How nayankumar746/pizza-sales-analysis works
This repository documents a 2015 pizza-sales analysis: sales data is checked and analyzed with SQL, then presented in an interactive Power BI dashboard for decisions about demand, staffing, and menu performance. The README identifies the dataset, SQL documentation, and dashboard, and describes their relationship; no source excerpts were available to verify implementation details beyond that documentation.
Main entry points: pizza_dasboard.pbix Two-Page Dashboard · Pizza_Sales_SQL_Qurries.doc KPI and Trend Queries · pizza_sales_excel_file.xlsx 2015 Sales Dataset
Components 5
Sales Data
- 2015 Sales Dataset
pizza_sales_excel_file.xlsx
SQL Analysis
- KPI and Trend Queries
Pizza_Sales_SQL_Qurries.doc
Interactive Reporting
- Two-Page Dashboard
pizza_dasboard.pbix
Other components
- Restaurant Owner
- Business Decisions
Connections 4
- 2015 Sales Dataset → KPI and Trend Queries: analyzes
- KPI and Trend Queries → Two-Page Dashboard: provides KPIs
- Restaurant Owner → Two-Page Dashboard: explores
- Two-Page Dashboard → Business Decisions: informs