This capstone project offers an end-to-end, real-world data analysis experience within the Retail & Food Industry domain, focusing on Pizza Sales. It integrates popular analytics tools like Power BI, SQL, Python, Excel, and Tableau to help you build analytical thinking, data storytelling, and business intelligence skills using sales transaction data.
Data Extraction & Cleaning:
Use SQL and Python to extract, clean, and prepare raw pizza sales data for analysis.
Exploratory Data Analysis (EDA):
Perform in-depth sales trend analysis, identify top-selling pizzas, busiest hours, and customer preferences using Python and Excel.
Data Modeling:
Design data models and create calculated fields and KPIs such as Total Revenue, Average Order Value, Sales by Category, and Orders by Size.
Interactive Dashboards:
Build engaging and dynamic dashboards in Power BI, Excel, and Tableau to visualize key performance indicators, sales insights, and profitability trends.
Business Insights:
Derive meaningful insights on sales performance, menu optimization, and customer behavior, enabling better decision-making for restaurant growth and marketing strategies.
No video explanation is available for this project.
✅ Dashboard Files – Power BI (.pbix), Tableau (.twbx), Excel File
✅ SQL – Query Document (import raw data into MS SQL Server and execute queries)
✅ Python – Jupyter Notebook (.ipynb)
✅ Raw Data – CSV & Excel files
✅ Background Images and visuals used in dashboards
✅ Problem Statements Document
Only 25% of the amount is refundable.
Email: [email protected]
WhatsApp: +91 9579005495