This project was executed using sample data. The sample business request for this project highlighted the need for an improved reporting system. The focus was on analyzing: sales of products, customer sales, and sales trends over time. Key requests for this project were the ability to filter data by product and customer as each salesperson works on different products. Additionally, the integration of the 2021 budget data for performance comparison was necessary, with an emphasis on a two-year sales data retrospective. 1. User Stories Development: User stories were crafted to guide the data cleaning and dashboard design, ensuring real-world applicability and utility.
2. Data Cleaning with SQL: The AdventureWorks databases were cleansed and prepped using SQL, ensuring high data quality for analysis.
3. Budget Data Integration: The 2021 budget data was incorporated from an Excel spreadsheet to compare actual sales with budgeted targets.
4. Data Visualization with Power BI: Data visualizations were then developed in Power BI, resulting in 3 dashboards:
• Sales Overview: A comparative analysis of product sales vs budget, Sales by Product Category, Top 10 Customers and Products, and Sales by Customer location
• Customer Details: A matrix of client sales filtered by top buying clients, Sales by Customer location, and Sales trends by month
• Product Details: A matrix of product sales filtered by top-selling product items, Sales by Customer location, and Sales trends by month
• Microsoft Power BI
• Microsoft Excel The final deliverable was a set of interactive Power BI dashboards that offer a comprehensive view of the company's internet sales. Key features include:
• Dynamic filters for Customer location, Product Category, Product Sub-category, and Product Name
• Customizable views for Year and Month aiding in historical analysis
• Visual representations of sales trends and comparisons with integrated budget figures
• Microsoft AdventureWorks Sample Databases: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
• SQL and Power BI Learning Resources: https://www.youtube.com/@iamaliahmad