Power BI Multi-Source Integration &
Dashboard Project
Project Title
Enterprise Business Intelligence Dashboard using Multiple Data Sources in Power BI
Project Objective
Students will connect Power BI with multiple real-world data sources, integrate and
transform data using Power Query, create relationships and data models, and build an
interactive business dashboard for decision-making.
This project is designed to simulate a real Business Intelligence (BI) and Data Analytics
consulting project.
Learning Outcomes
After completing this project, students will be able to:
• Connect Power BI with different data sources
• Import structured and semi-structured data
• Perform ETL using Power Query
• Create relationships between tables
• Build data models
• Create KPIs and DAX measures
• Design professional dashboards
• Generate business insights
Requirement
Each student/group must connect at least 4 different data sources in ONE Power BI report.
Students may use any combination from the following sources:
Recommended Data Sources
File Sources
• Excel Workbook
• CSV/Text Files
• JSON/XML
• PDF Tables
Database Sources
• SQL Server
• MySQL
• PostgreSQL
• Google BigQuery
• Snowflake
• Azure SQL Database
Online/Web Sources
• Web Data
• SharePoint List
• Google Analytics
• Salesforce Reports
• GitHub Data
• OData Feed
Programming Sources
• Python Script
• R Script
Cloud/Big Data Sources
• Azure Blob Storage
• Azure Data Lake
• Dataverse
• Hadoop/HDFS
• Spark
Suggested Business Domains
Students may choose ONE domain:
Domain Example
Retail Sales & Inventory Dashboard
Banking Loan & Customer Analytics
Healthcare Patient & Hospital Dashboard
E-commerce Orders & Customer Behavior
Domain Example
HR Analytics Employee Performance Dashboard
Education Student Performance Dashboard
Supply Chain Logistics & Delivery Dashboard
Marketing Campaign & Customer Analytics
Minimum Project Requirements
1. Data Collection
Students must collect/import data from:
• Minimum 4 different sources
• Minimum 3 related tables
• At least 5,000 rows combined
2. Data Transformation (Power Query)
Students must:
• Clean missing values
• Remove duplicates
• Split/merge columns
• Create calculated columns
• Change data types
• Append or merge queries
3. Data Modeling
Students must:
• Create relationships
• Design star/snowflake schema
• Create date table
• Build calculated measures using DAX
4. Dashboard Requirements
Dashboard must include:
KPIs
• Total Sales
• Profit
• Growth %
• Customer Count
• Orders
Visualizations
• Bar Chart
• Line Chart
• Pie/Donut Chart
• Map Visualization
• KPI Cards
• Matrix/Table
• Slicers/Filters
Advanced Features
• Drill-through
• Tooltips
• Bookmarks
• Conditional Formatting
• Dynamic Titles
Advanced Bonus Tasks
Students can earn bonus marks by implementing:
• AI Visuals
• Forecasting
• Python/R Visuals
• Sentiment Analysis
• Real-time Dashboard
• Incremental Refresh
• Row Level Security (RLS)
Example Project Scenario
Retail Analytics Dashboard
Data Sources
Source Data
Excel Product Data
SQL Server Sales Transactions
Web Currency Exchange Rates
CSV Customer Information
Python Script Forecasting Results
Dashboard Features
• Monthly Sales Trend
• Regional Performance
• Top Products
• Customer Segmentation
• Sales Forecast
• Profitability Analysis
Deliverables
Students must submit:
1. Power BI (.pbix) File
2. Dataset Files
3. Project Report (3–5 pages)
4. Screenshots of Data Sources
5. Dashboard Presentation (5 minutes)
Project Report Structure
Include:
• Introduction
• Business Problem
• Data Sources Used
• Data Cleaning Process
• Data Model
• Dashboard Explanation
• Key Insights
• Conclusion
Suggested Real Public Datasets
Students may use:
• Kaggle
• [Link]
• Google Dataset Search
• GitHub Datasets
• World Bank Data
• Yahoo Finance
• UCI Machine Learning Repository
Important Instructions
• Use professional dashboard design
• Avoid overcrowded visuals
• Use proper color themes
• All charts must be labeled
• Dashboard should support filtering and interaction
• Students must explain business insights, not only visuals