This project involves the creation of a PowerBI sales report using the "awesome chocolates" dataset obtained from here. The dataset consists of information related to sales, products, geography, and salespeople, stored in a MySQL database. The objective is to analyze overall sales data, based on product and generate insightful dashboards to facilitate decision-making for the chocolate business.
The project requires the following components:
- Access to the "awesome chocolates" dataset here.
- MySQL tools for managing and querying the dataset.
- PowerBI for creating interactive dashboards and visualizations.
- Knowledge of DAX (Data Analysis Expressions) for creating calculated measures.
- SQL querying skills to extract specific data from the dataset.
- Understanding of parameters and data loading techniques in PowerBI.
The project consists of the following files:
- Sales Report.pbix: PowerBI file containing the sales report dashboard and visualizations.
- awesome-chocolates-data: The MySQL database containing four tables: Geo, People, Products, and Sales.
To run the project files:
- Download the "awesome chocolates" dataset from here.
- Import the dataset into a MySQL database.
- Open PowerBI and load the "Sales Report.pbix" file.
- Modify the SQL query in PowerBI to filter sales data based on a specific product code.
- Ensure that the MySQL server is running on localhost:3306.
- Update the parameters in PowerBI to reflect the desired product code.
- Refresh the data in PowerBI to see the updated dashboard product-wise.
- With these steps completed, the PowerBI sales report should be ready to use, providing insights into chocolate sales based on the specified product code.