Coffee_Shop_Sales_Analysis

Excel Report

• Source of Dataset: Maven Analytics
  

• tools used:
  Data cleaning: Excel PowerQuery
  Data visualization: Excel
  

• Creating an exploratory dashboard to help obtain the following information:
  

1. How sales vary by each months, days and hours
   
2. Determine peak times for sales
   
3. Best selling products in terms of quantity and revenue
   
4. Determine hourly & daily footfall
   
5. How sales vary by product category and type
   
6. Customers Preferences in coffee size