This Pizza Sales Analysis Project featuring a dynamic Power BI dashboard that breathes life into the realm of pizza sales data. Our interactive dashboard empowers users to explore, gain insights, and drive data-driven decisions based on essential performance metrics. Fueling this analysis is the formidable combination of Power Query and DAX Query, meticulously dissecting the data to craft precise measures and captivating visualizations.
- SQL Server Management Studio
- SQL
- Power BI
- Power Query
- Dax Query
- Imported raw sales data into SQL server using import task option in SSMS and Sql to analyze the data in SSMS
- Imported data from SQL server into Power BI for creating dashboard
- Used Power Query editor to clean and transform the data
- Apply all necessary cleaning steps, such as removing duplicates, renaming columns, and changing data types
- Load and Apply the cleaned data into Power BI
- Design the dashboard layout
- Created a measures to aggregate and display the data using Dax functions
- Use Visulizations for charts and slicers for filter dashboard
- Now, Add Title Pizza Sales Dashboard
- Add Pizza category and order date as Slicer and add some informative KPI
- Add Card chart, Area chart, Donut chart, Bar chart, Map etc
- Add buttons to create an another page with Visuals for Best/Worst Pizza
This is an interactive Power BI Dashboard , you can interact with this dashboard from https://www.novypro.com/project/pizza-sales-report-power-bi-3
Pizza Sales Overview REPORT
![image](https://private-user-images.githubusercontent.com/135998004/281140311-27c9f9df-46f7-4ea2-8a99-1f434ffc7f49.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ0NDUzOTEsIm5iZiI6MTcyNDQ0NTA5MSwicGF0aCI6Ii8xMzU5OTgwMDQvMjgxMTQwMzExLTI3YzlmOWRmLTQ2ZjctNGVhMi04YTk5LTFmNDM0ZmZjN2Y0OS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyM1QyMDMxMzFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00MzdjYjhiNjdlMGI0NGQ0NmNmZmJlNTBiZTc5ODJmYTM5ZjlkOTY3Mjg3NjZmMmE3YTMzYTFkZjEyZGRiY2I4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.VR1uNDyaqT6QMdw_ozSE7H1XaXlrs7CmqP5K4AxOt7g)
Pizza Sales Overview REPORT based on Best/Worst Sellers
![image](https://private-user-images.githubusercontent.com/135998004/281140781-619376f6-9fde-46f9-bee8-884b55d122e3.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ0NDUzOTEsIm5iZiI6MTcyNDQ0NTA5MSwicGF0aCI6Ii8xMzU5OTgwMDQvMjgxMTQwNzgxLTYxOTM3NmY2LTlmZGUtNDZmOS1iZWU4LTg4NGI1NWQxMjJlMy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODIzJTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyM1QyMDMxMzFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00N2Q1NGVhM2NmY2RjZmNkZDVkZjkzZDkyODgwNTMxNWUwZjg3YTVmM2M3NGI0ODhlZjEwOGM3MjY4MDRlYmM4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.jLS8MOppO7zqNcKL0U_dr-VIPOLq5D_kBRWnbQ5qeCw)
The Pizza Sales Report dashboards offer a user-friendly interface to provide a comprehensive view of our pizza sales data. They encompass various key insights, including daily and monthly sales trends, sales breakdown by pizza category, distribution of sales by pizza size, identification of top-selling pizzas based on various metrics, and identification of least-selling pizzas based on multiple criteria. These views empower us to make informed, data-driven decisions, optimizing our pizza sales and business performance for sustained success.