Pizza Sales Analysis with Power BI and SQL

Project Overview

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.

Key Features

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

SQL Queries for KPIs

• 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

Getting Started

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.

Usage

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

Technologies Used

• SQL
• Power BI
• Data visualization libraries

Contributing

If you would like to contribute to this project, please feel free to submit pull requests.

License

This project is licensed under the [License Name] - see the LICENSE.md file for details.