This project focuses on analyzing pizza sales data using Power BI and SQL queries to extract key insights and create informative reports. The project includes a set of SQL queries for calculating various Key Performance Indicators (KPIs) and the use of Power BI for data visualization.
-
SQL Queries for KPIs: SQL queries are used to calculate essential KPIs related to pizza sales, such as total revenue, average order value, and more.
-
Power BI Reports: The project includes Power BI reports that visualize the analyzed data, making it easy to understand and draw insights from.
- Total Revenue
- Average Order Value
- Total Pizza Sold
- Total Order
- Average Pizza per Order
- Daily Total Order
- Monthly Total Order
- Pizza Category Sales
- Pizza Size Sales
- Top 5 Pizzas by Revenue
- Bottom 5 Pizzas by Revenue
- Top 5 Pizzas by Quantity
- Top 5 Pizzas by Number of Orders
To get started with this project, you'll need access to a SQL database containing pizza sales data. You can run the provided SQL queries to calculate KPIs, and then use Power BI to create visual reports based on the extracted data.
- Clone this repository to your local machine.
- Execute the SQL queries on your pizza sales database to gather the necessary data.
- Open the Power BI project and load the data for creating interactive reports.
- Customize and extend the Power BI reports based on your specific needs and insights.
- SQL
- Power BI
- Data visualization libraries
If you would like to contribute to this project, please feel free to submit pull requests.
This project is licensed under the [License Name] - see the LICENSE.md file for details.

