Summary
Row
Chart A
322,967Row
Branch Performance
Sales by Product Line
Sales Performance
Row
Chart
116,292Chart
97,219Chart
109,456Row
Monthly Performance
Weekly Performance
Customer Experience
Row
Average Customer Rating
Row
Demographics
Summary of Customer Experience
Shopping Behavior
Row
Daily Performance
Hourly Performance
Row
Chart C
$ 326Chart D
$ 324Chart E
$ 319Final Takeaways
Row
Sales Activity and Shopping Behavior
- Branch B earned the most revenue but each branch generated approximately 33-34% of total sales.
- The best selling products were “Food and beverages”, “Sports and travel” was a close second.
- Sales were highest in January, despite sales being the lowest during the first week of January.
- Sales momentum dipped slightly during mid-February.
- Most sales were made during 7pm (19) and the least amount of sales occurred during the hours between 4-5pm (16-17) and an hour from closing (20).
Row
Demographics
- The average customer experience rating was below 7, which might be concerning. The company recieved no ratings below a 4.
- Most of the customers in quarter 3 were either female members or non-member males.
- Most orders were made on a Saturday or a Tuesday. Monday generally has the lowest frequency of orders.
- Method of payment has very little influence on the customers transaction amount, as the average transaction amount for each payment type are consistent within $7.
Column
The customer who made the most orders can be categorized by the following demographics:
Customer Gender Product Day Orders
141 Member Female Sports and travel Tuesday 16The customer who generated the most sales can by categorized by the following demographics:
Customer Gender Product Day Sales
129 Member Female Food and beverages Tuesday 6985