This is a dynamic Coffee Sales - MS-Excel Dashboard. The goal was to transform, clean, and analyze data to extract valuable insights using powerful Excel tools like Power Query, Power Pivot and create Visualizations.
- Data collection, cleaning, and preparation
- Analyse monthly, quaterly, and daily sales patterns with Power PivotTables.
- Develop compelling reports and visualization
- Create an Interactive dashboard
The dataset can be found on Mo Chen 's YouTube Channel.
Power Query - Utilized Power Query to import, transform, and clean raw sales data (handling NULL values, remove duplicates, etc...)
Power Pivot -
Employed Power Pivot for advanced data modeling and analysis.
Using Filtering, Sorting and Excel Functions- Vlookup, IF.
Use Data Analysis Expressions (DAX) to create calculated KPI(s) measures.
Visualizations - Created interactive Pivot charts and graphs to visualize sales data and trends.
📊 Sales Performance Trends:
- ➡️ June: Makes maximum coffee sales
- ➡️ August: Lowest Sum of Sales & Profit
📈 Product Performance Analysis:
- ➡️ Product Size: 2.5 kg - Highest sales (53%)
- ➡️ Q4 2021: Highest Sold Quantity (321)
👫 Top/Bottom Products by Sales:
- ➡️ A-L-2.5: Top product (5.67% of sales)
- ➡️ R-M-0.2: Bottom product (0.39% of sales)
🌍 Top Country by Sales:
- ➡️ United States Tops Highest Sum of Sales (79%) & Profits (78%).
Thank you for your interest and time. Feel free to modify and give your valuable suggestions!!!.
Connect with me on https://www.linkedin.com/in/rohit-dusane