The grocery store wants to make the most of their recent upswing in sales. Over the last few months, they’ve been getting so many customers and don’t know what to do with themselves! much data as possible was extracted so we could familiarize ourselves with their current operations and come up with a strategy plan.
Below are the tasks
- Ascertain amount generated from each product
- Busiest hour
- Find customers that generates the least income
- Find employee that spent the least days working at the grocery store
- Ascertain income realize from sales
- Find the day of the week which the grocery store makes the most sales
- What is the Average daily sales?
- What is the best Selling products?
- Find the top 5 Loyalty customers
- Which customer patronize products that generates the highest income?
- Find the product that generates the least income and by much