This project demonstrates the creation of an interactive business intelligence dashboard using Microsoft Power BI as part of the Microsoft Azure Data Fundamentals (DP-900) learning path.
The objective was to import data, build relationships between tables, create interactive visualizations, and transform raw business data into meaningful insights for decision-making.
In addition to completing the Microsoft Learn lab, this repository documents the implementation process with screenshots, notes, and project documentation to showcase practical Power BI skills.
A company wants to analyze its sales performance using interactive dashboards that allow business users to:
- Monitor sales performance
- Analyze product trends
- Compare regional performance
- Visualize geographic sales distribution
- Explore data through interactive filtering
Power BI provides a centralized platform for transforming raw datasets into actionable business intelligence.
- Import business data into Power BI
- Build relationships between multiple tables
- Create interactive reports
- Design business dashboards
- Practice data visualization best practices
- Gain experience with Microsoft's Business Intelligence platform
- Microsoft Power BI Desktop
- Microsoft Azure Data Fundamentals (DP-900)
- Power Query
- Data Modeling
- Data Visualization
- Microsoft Learn
- Data Import
- Data Transformation
- Data Cleaning
- Data Modeling
- Relationship Creation
- Dashboard Design
- Interactive Reporting
- Business Intelligence
- Data Storytelling
Raw Business Data
│
▼
Power Query
│
▼
Data Cleaning
│
▼
Data Model & Relationships
│
▼
Power BI Dashboard
│
▼
Business Insights
The completed dashboard includes:
- Sales Overview
- Product Analysis
- Geographic Sales Map
- Interactive Filters
- Drill-down Visualizations
- KPI Reporting
Azure-PowerBI-Sales-Analytics/
│── README.md
│
├── Screenshots/
│ ├── 01_Data_Import.png
│ ├── 02_Data_Model.png
│ ├── 03_Visualizations.png
│ ├── 04_Map.png
│ └── 05_Final_Dashboard.png
│
├── Documentation/
│ └── Project_Notes.md
│
└── Assets/
Imported the provided sales datasets into Power BI Desktop to prepare the data for transformation and modeling.
Created relationships between multiple tables to establish an effective data model for reporting.
During this project I learned how Power BI transforms raw business data into interactive dashboards through:
- Importing datasets
- Creating relationships between tables
- Building interactive reports
- Designing business-friendly visualizations
- Presenting meaningful insights for decision makers
I also gained a better understanding of how Business Intelligence tools support organizations by enabling data-driven decision making.
Possible future enhancements include:
- Connect directly to Azure SQL Database
- Connect to Azure Blob Storage
- Automate data refresh
- Publish reports to Power BI Service
- Add advanced DAX calculations
- Build executive KPI dashboards
This project was completed using Microsoft's official DP-900 Azure Data Fundamentals learning materials and enhanced with additional documentation for portfolio purposes.
Okoye Hughes
Aspiring Azure Data Engineer | Python | SQL | Azure | Power BI | AI Data Engineering
GitHub: https://github.com/Ohughes-9312
If you found this project interesting or have feedback, feel free to connect with me on GitHub or LinkedIn.
I'm actively building my portfolio while pursuing a career in Azure Data Engineering and AI.