📚 Power BI – Course Content

1. Introduction to Business Intelligence & Power BI

• What is Business Intelligence (BI)
• Power BI ecosystem overview
• Power BI Desktop, Service & Mobile
• Installing and navigating Power BI Desktop

2. Data Sources & Data Connection

• Connecting to Excel, CSV, Text files
• Connecting to databases (SQL – intro level)
• Import vs Direct Query mode
• Data refresh concepts

3. Data Transformation with Power Query

• Power Query Editor overview
• Cleaning and transforming data
• Removing duplicates & errors
• Split, merge, replace & conditional columns
• Data type handling

4. Data Modeling

• Relationships between tables
• Cardinality & filter direction
• Star schema basics
• Creating calculated columns

5. DAX (Data Analysis Expressions)

• DAX fundamentals
• Measures vs calculated columns
• Common DAX functions (SUM, COUNT, CALCULATE, IF)
• Time intelligence basics
• Business logic using DAX

6. Data Visualization & Reports

• Charts, tables & matrix visuals
• Cards, KPIs & gauges
• Filters, slicers & drill-through
• Custom visuals
• Formatting & design best practices

7. Interactive Dashboards

• Creating multi-page reports
• Dashboard design principles
• Tooltips & bookmarks
• User interaction & navigation

8. Power BI Service (Cloud)

• Publishing reports to Power BI Service
• Creating dashboards in service
• Sharing reports & workspaces
• Scheduled data refresh

9. Power BI Security & Performance

• Row-level security (RLS) basics
• Optimizing reports for performance
• Data refresh & access control

10. Excel & Power BI Integration

• Importing Excel data models
• Using Power Pivot concepts
• Comparing Excel vs Power BI reporting

11. Real-Time Business Use Cases

• Sales performance dashboard
• Finance & profit analysis
• HR analytics dashboard
• Operations & inventory reporting

12. Live Projects & Practical Work

• End-to-end Power BI project
• Data cleaning to dashboard creation
• Real-world datasets & case studies
• Portfolio-ready dashboards