How did your restaurant perform over the past few years during Christmas dinner?

Since Christmas Day fell on a Friday last year, we will include Saturday to run an analysis.

By setting the dinner time period from 18:00 to 00:00, and choosing only dine-in customers, all the subsequent data analysis will be automatically tabulated and analyzed for this particular period.

Should you promote Couple Sets or Family Sets?

Groups of two are making up 70% of your business over the Christmas period, which is twice as much as usual. Since most groups of two are couples, you should put up posters to promote couple sets during Christmas!

Discount or a free gift: which one attracts more couples?

Using Intelligent Date Filter, under “Advanced Options”, select 2 people under “Number of People”, and run a customer analysis.

According to the report, the "Wear red to get half price on red wine" promotion was 3 times more popular than the "Kiss to get a free dessert" promotion – so go with the first promotion this year!

Which is better: cake or ice cream as the dessert for the Christmas Couple Set?

At Christmas the “two-person” customer group ordered cake with their meal 3 times more than at any other time of the year, so choosing cake instead of ice cream for the “Couple Set” dessert is a better choice.

How were the lunch sales during the school holidays compared to the rest of the year?

Select the school holiday period (June) last year, choose lunch time, and run the analysis. Remember to exclude groups that were over 6 people because those were probably customers celebrating Father's Day, which falls in June.

Iced green tea sales have gone up, so which dish should we pair with it to make a new set?

During the school holidays, the sale of tofu dishes were 30% higher than usual and they also sold more than any other dish. Matching a tofu dish with iced green tea to make a special holiday set would be a good idea.

To ice or not to ice, that is the question

You can see from your analysis that 6 out of 10 customers did not want ice with their cold brew coffee, but there were a few customers who asked for ice. It would still be better to ask the customer for their ice preference before serving the drink.

Should we stop student lunch discounts, which may be driving away office workers who pay higher prices?

Student discounted sales at lunchtime increased by 100% during the school holidays.

You should remove the student discount during the school holidays so that you would not incentivise the student crowd. More seats will be created for office workers who have higher spending power and pay the full price for their meals in order to increase your revenue.

Can I analyze the sales during Chinese New Year specifically?

Last year’s Chinese New Year Eve was February the 7th. Let’s choose February 6th to the 14th and run the analysis.

Should I get extra staff until the third or the sixth day of Chinese New Year?

The number of customers dropped by 50% after the third day of New Year, so additional staff will not be needed after that!

Is it better to just do takeaways on Chinese New Year Eve?

Last year on Chinese New Year Eve, 80% of your restaurant's business was takeaways. Thus, it is advisable that you focus on takeaways this year.

How many BBQ whole chickens should you prepare for the first and second day of Chinese New Year, and how many should be for takeaways?

Last year, you sold 200 BBQ whole chickens on those two days, with half of them being takeaways. Thus, this year you can prepare around 230 whole chickens, half for eating in and half for taking away.

Can I choose to only see data for Fridays?

Select the time period 17:00 to 22:00, click dine-in and then choose all the Fridays you want to analyze.

Should you change tables of four to tables of two on Friday nights?

60% of your customers on Friday nights are a “two-person” group. On other days, they only account for 40%.

Thus, on Friday, you should separate the tables of four to two-person tables. When a group of four comes in, you can simply join up the tables for them.

Want to speed up your service by simplifying your menu? Which dishes should you remove and which should you keep?

The order rate for two dishes, Fish & Chips and Pork Chop is over 30%, so they should stay on the menu as main dishes.

Does getting more kitchen staff help dishes reach your customers faster?

Since hiring more kitchen staff, the waiting time after placing an order has been reduced from 15 minutes to 10 minutes and customers are staying 4 minutes less in the restaurant. Fantastic!

Are certain months destined to have poor sales?

Dinner sales seems to be declining and you suspect this is because it’s the Seventh Month and people tend to stay in at night. To find out if this is an annual trend, select the duration of the Seventh Month according to the lunar calendar and compare it to the previous year’s.

Your revenue has fallen by $16,000. Do you have fewer customers or are they just spending less?

Your customer count has actually gone up by 5% but they are spending 30% less per visit. The drop in average spending per customer has a huge effect on your business! ”

Is your sales revenue being eaten away by discounts?

Although your discounts added up to $20,000, this was in fact only 3% higher than last quarter, so discounts are not the reason for your reduction in sales revenue.

Your sales revenue has dropped by $20,000. Is that because sales of cold dishes and cold drinks have fallen due to the cooler weather?

Your cold dish sales dropped by $40,000, while your hot soup sales have gone up $20,000 to help cushion the drop in revenue. Hence, you should work on a way to promote more soup!