This repository contains a comprehensive Power BI dashboard project built using the Adventure Works dataset. It showcases real-world business intelligence (BI) skills in data extraction, transformation, modelling, DAX calculation, and dashboard design.
You’ve just been hired as a Business Intelligence Analyst by AdventureWorks, a global manufacturing company that produces cycling equipment and accessories.
The management team needed a solution to:
- Track KPIs like sales, revenue, profit, and returns
- Compare regional and product-level performance
- Identify high-value customers
- Visualise temporal trends in customer behaviour and product sales
- Extracted and cleaned raw
.csvdata using Power Query - Applied profiling tools to handle missing values and validate data quality
- Appended multiple years of sales data
- Built lookup tables for categories, subcategories, and customers
- Built a star schema with fact and dimension tables
- Established relationships using primary and foreign keys
- Created a calendar table and implemented hierarchies (Year > Month > Day)
- Optimised cardinality and filter direction
- Developed key measures:
- Total Sales, Total Returns, Return Rate, Profit, Revenue per Customer, etc.
- Used
CALCULATE(),FILTER(),SUMX(),DATESYTD()and more for time intelligence and filtering logic - Created calculated columns for SKU types and customer segmentation
- Designed interactive dashboards with:
- KPIs and card visuals
- Time-series line charts with drill-down
- Donut and bar charts for demographic and sales analysis
- Tooltips, slicers, and dynamic filters
- Field parameters for toggling between key metrics
- Dynamic filtering using slicers
- Smart bookmarks and drill-through navigation
- Return rate calculation with conditional formatting
- Custom tooltips and field parameters
- Regional and category-wise return analysis
- Mobile-optimised layout (Power BI app)
- Power BI Desktop
- DAX
- Power Query (M Language)
- GitHub for version control and collaboration
