Power BI Dashboard using AdventureWorks Database

Overview

This project is a Power BI dashboard created using the AdventureWorks Database. The dashboard provides insights into various aspects of the business through dynamic visualizations and data analysis.

Features

• Extracted data from Microsoft SQL Server Database Using DirectQuery Conductivity Mode.
• Transformed data using dimensional modeling to achieve a star schema
• Created a DAX table containing all essential measures
• Developed multiple visualizations representing key business insights:
  • Bar Charts
  • Pie Charts
  • Donut Charts
  • Clustered Bar Charts
  • Line Charts
  • Slicers
• Implemented features for enhanced user experience:
  • Drill Down
  • Drill Through
  • Tooltip pages
  • Bookmarks

Implementation