This repository contains the code and data for analyzing pizza sales using SQL Server as the data store and Power BI for data visualization and analysis. Explore sales trends, customer preferences, and more to gain insights into pizza sales using this repository.
- SQL queries and SSIS packages to extract and transform data from SQL Server database.
- Power Query in Power BI to connect to SQL Server and load data.
- Compare results from SQL SSIS vs Power Query.
- Power BI reports and dashboards to visualize sales trends and customer insights.
- Insights into best selling pizzas, toppings, customer preferences and more.
- SQL Server - As the database to store sales data.
- SQL Server Integration Services (SSIS) - To extract and transform data.
- Power BI - Power Query to connect to SQL and Power BI reports for analysis.
- Compare ETL techniques using SQL SSIS vs Power Query.
- Understand performance and limitations of each approach.
- Gain insights into pizza sales trends, customer preferences and more.
- Optimize menu, ingredients and marketing based on analysis.
This dashboard in Power BI shows an overview of total sales, top pizzas sold and sales by Pizza type.
- Improve menu options
- Optimize ingredient stocking
- Target marketing and promotions
- Which ETL technique is faster
- Which is easier to maintain
- Any limitations of each approach
Pizza Sales Analytics.pbix
Hope this helps! Let me know if you have any other questions.