This project involves creating a Power BI dashboard using data from a MySQL database. The dashboard provides insights into revenue, sales quantity by markets, revenue trends, top customers, and top products.
Import the provided SQL file into the MySQL database to initialize the data.
Execute the queries included in the repository to normalize and prepare the data for analysis. These queries ensure the data is clean and ready for use in Power BI.
Establish a connection between the MySQL database and Power BI. This allows Power BI to access and visualize the data directly.
Utilize Power BI tools to create various visualizations, such as bar charts, line charts, and tables, to represent the data insights effectively.
Run additional queries to verify the accuracy of the visualizations in Power BI, ensuring that the results match the expected outcomes.
The Power BI dashboard includes the following key insights:
Revenue by Markets: A bar chart displaying revenue generated in different markets. Sales Quantity by Markets: A bar chart showing the sales quantity in various markets. Revenue Trend: A line chart depicting the revenue trend over time. Top 5 Customers: A bar chart listing the top 5 customers by revenue. Top 5 Products: A bar chart showing the top 5 products by revenue.
This dashboard provides a comprehensive view of the business performance, allowing stakeholders to make informed decisions based on the visualized data.
Please note this project was originally re-created from (codebasics.io) i have utilised the supplied materials and re-created it in order learn the tools and demonstrate my skills.