Interactive Power BI dashboard to analyze AdventureWorks CRM sales data vs Excel Budget. Transforms raw data into daily-updated insights addressing "data exists but no clear visibility" business challenge.
- A clear overview of total sales
- Ability to track top customers
- Ability to track top products
- Comparison between actual sales and budget
- AdventureWorks CRM sales data (https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms)
- Excel file for budget data
Data was cleaned and prepared using SQL.
Clean Customer Dimension
Clean Date Dimension
Clean Product Dimension
Clean Fact internet sales
Sales Overview
Customer Details
Product Details
