Power BI

1. Introduction to Power BI

What is Power BI
Business Intelligence (BI) concepts
Power BI ecosystem
Power BI Desktop vs Power BI Service vs Mobile
Power BI licensing (Free, Pro, Premium)
Course project overview

2. Installing and Setting Up Power BI

Installing Power BI Desktop
Power BI interface overview
Navigating the workspace
Saving and publishing reports
Power BI file types (.pbix, .pbit)

3. Data Sources

Connecting to Excel
Connecting to CSV files
Connecting to SQL Server
Connecting to Access databases
Connecting to SharePoint
Connecting to Web APIs
Import vs DirectQuery vs Live Connection

4. Power Query Editor

Introduction to Power Query
Query Editor interface
Loading data
Removing columns
Renaming columns
Changing data types
Filtering rows
Sorting data
Splitting and merging columns
Replacing values
Removing duplicates

5. Data Cleaning and Transformation

Handling missing values
Removing errors
Appending queries
Merging queries
Pivoting data
Unpivoting data
Grouping data
Creating custom columns
Conditional columns
Index columns

6. Data Modeling

Understanding data models
Relationships
One-to-One relationships
One-to-Many relationships
Many-to-Many relationships
Active vs Inactive relationships
Cross-filter direction
Star Schema
Snowflake Schema

7. DAX Fundamentals

Introduction to DAX
Calculated Columns
Calculated Tables
Measures
DAX syntax
Operators
Variables (VAR)
Comments in DAX

8. Basic DAX Functions

SUM()
AVERAGE()
COUNT()
COUNTROWS()
DISTINCT()
MAX()
MIN()
IF()
SWITCH()
DIVIDE()

9. Advanced DAX Functions

CALCULATE()
FILTER()
ALL()
ALLEXCEPT()
RELATED()
RELATEDTABLE()
LOOKUPVALUE()
SELECTEDVALUE()
VALUES()
HASONEVALUE()

10. Time Intelligence

Calendar tables
DATEADD()
TOTALYTD()
TOTALQTD()
TOTALMTD()
SAMEPERIODLASTYEAR()
DATESYTD()
Running totals
Year-over-Year analysis
Month-over-Month analysis

11. Data Visualization

Bar charts
Column charts
Line charts
Pie charts
Donut charts
Area charts
Scatter charts
Maps
Treemaps
Waterfall charts
Funnel charts
Gauge charts
KPIs

12. Tables and Matrix Visuals

Creating tables
Matrix visual
Conditional formatting
Data bars
Icons
Heat maps
Drill-down features

13. Slicers and Filters

Report filters
Page filters
Visual filters
Slicers
Sync slicers
Hierarchical slicers
Search slicers

14. Formatting Reports

Themes
Colors
Fonts
Titles
Backgrounds
Custom formatting
Responsive layouts
Bookmarks

15. Interactive Dashboards

Drill-through pages
Tooltips
Bookmarks
Buttons
Navigation menus
Page navigation
Selection pane

16. Advanced Visualizations

Custom visuals
Importing visuals from AppSource
Decomposition Tree
Key Influencers
Smart Narrative
Q&A Visual

17. Row-Level Security (RLS)

Introduction to security
Creating roles
Dynamic security
Testing security roles
Publishing secure reports

18. Power BI Service

Publishing reports
Creating dashboards
Workspaces
Sharing reports
Managing permissions
Subscriptions
Collaboration features

19. Refreshing Data

Manual refresh
Scheduled refresh
Gateway installation
On-premises data gateway
Incremental refresh

20. Performance Optimization

Optimizing data models
Reducing model size
Optimizing DAX calculations
Performance Analyzer
Best practices for large datasets

21. AI Features in Power BI

Quick Insights
Forecasting
Anomaly Detection
Key Influencers
Smart Narrative
Natural Language Q&A

22. Power BI Mobile

Mobile layouts
Viewing reports on mobile devices
Optimizing dashboards for mobile

23. Power BI Administration

Workspace management
Dataset management
User permissions
Data governance
Deployment pipelines (overview)

24. Power BI with Excel

Importing Excel models
Using Analyze in Excel
Exporting data
Connecting Excel to Power BI datasets

25. Introduction to Power BI APIs

REST API overview
Embedding reports
Power BI Embedded basics
Automation concepts

26. Power BI Best Practices

Dashboard design principles
Data storytelling
Color theory for dashboards
Accessibility (A11y)
Naming conventions
Documentation

27. Real Business Dashboards

Sales Dashboard
HR Dashboard
Finance Dashboard
Inventory Dashboard
Marketing Dashboard
Executive KPI Dashboard

28. Mini Projects

Student Performance Dashboard
Hospital Dashboard
Retail Sales Dashboard
Call Center Dashboard
Employee Attendance Dashboard
Website Analytics Dashboard

29. Final Project

Students will build a complete business intelligence solution that includes:

Data import from multiple sources
Data cleaning with Power Query
Star schema data model
Relationships and calculated measures
Advanced DAX calculations
Interactive dashboards
Drill-through reports
Time intelligence analysis
Row-Level Security (RLS)
Publishing to Power BI Service
Dashboard sharing and scheduled data refresh
Professional, executive-ready business reports