Pizza Sales Analytics Dashboard using MS Excel
Bharat Sahu
Data Visualizer
Automation Engineer
Data Analyst
Excel VBA
Microsoft Excel
SQL
Overview:
Created a sophisticated Pizza Sale Analytics Dashboard using MS Excel, designed to resemble a web interface similar to Power BI. The dashboard includes various key performance indicators (KPIs) and metrics such as:
• Total Revenue
• Average Daily Order
• Sum of Sales
• Pizza Category Performance
• Revenue by Category
• Total Quantity by Time
• Total Quantity by Pizza Size
• Number of Orders
• Sum of Sales
• Category of Pizza
• Sum of Quantity by Days
• Revenue by Pizza Size
• Sum of Quantity by Month
Business Problem:
The primary business problem is to provide a comprehensive and visually appealing dashboard that allows stakeholders to monitor and analyze pizza sales performance effectively. The goal is to enable data-driven decision-making by presenting key metrics and trends in an easily understandable format.
Solution:
1. Data Collection and Preparation:
Gather sales data, including order details, pizza categories, sizes, quantities, and revenue.
Clean and preprocess the data to ensure accuracy and consistency.
2. Dashboard Design:
Use Excel to create a visually appealing dashboard that mimics a web interface.
Design interactive elements such as slicers, charts, and tables to display the metrics.
3. Metrics Calculation:
Calculate the total revenue, average daily order, and sum of sales.
Analyze pizza category performance and revenue by category.
Determine total quantity sold by time, pizza size, and days.
Track the number of orders and sum of sales by category and month.
4. Dashboard Design:
Create a new Excel workbook and design the layout of the dashboard.
Use Excel features such as PivotTables, PivotCharts, and slicers to create interactive elements.
Format the dashboard to resemble a web interface, using colors, fonts, and styles similar to a web based interface like PowerBI
