Pizza-Shop-Sales-Analysis-SQL-Power-BI

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.

Key Features

• 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.

Built Using

• 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.

SQL Server SSIS Queries File Contains SQL Queries and results screenshots:

Pizza Sales SQL Queries.docx

Benefits

• 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.

Analysis provides insights to:

• Improve menu options
• Optimize ingredient stocking
• Target marketing and promotions

Comparing SQL SSIS vs Power Query helps determine:

• Which ETL technique is faster
• Which is easier to maintain
• Any limitations of each approach

Power BI Sales Analytics File :

Pizza Sales Analytics.pbix

Hope this helps! Let me know if you have any other questions.