Power BI Syllabus with Time Duration

Week 1: Introduction to Power BI & Data Loading

• What is Power BI? (1 hour)

• Power BI Components & Architecture (1 hour)

• Installing and Setting Up Power BI Desktop (1 hour)

• Connecting to Different Data Sources (Excel, SQL, Web) (2 hours)

• Data Transformation using Power Query (2 hours)

• Understanding Data Types and Relationships (1 hour)

Week 2: Data Modeling & DAX Basics

• Introduction to Data Modeling (1 hour)

• Creating Relationships between Tables (1 hour)

• Introduction to DAX (Data Analysis Expressions) (2 hours)

• Basic DAX Functions (SUM, AVERAGE, COUNT, etc.) (2 hours)

• Creating Calculated Columns and Measures (2 hours)

• Using Variables in DAX (1 hour)

Week 3: Advanced DAX & Data Visualization

• Aggregation and Iterators (SUMX, AVERAGEX) (2 hours)

• Time Intelligence Functions (YTD, MTD, QTD) (2 hours)

• Filters and Context in DAX (2 hours)

• Introduction to Power BI Visuals (1 hour)

• Creating Bar, Line, Pie, and Table Visuals (2 hours)

• Conditional Formatting and Custom Visuals (2 hours)

Week 4: Advanced Visuals & Power BI Service

• Using Maps, TreeMaps, and Cards (2 hours)

• Creating Interactive Dashboards (2 hours)

• Introduction to Power BI Service (1 hour)

• Publishing Reports to Power BI Service (2 hours)

• Power BI Workspaces, Sharing, and Collaboration (2 hours)

• Refreshing Data and Scheduling (1 hour)

Week 5: Power BI Advanced Features & Security

• Row-Level Security (RLS) in Power BI (2 hours)

• Bookmarks and Drill-through (2 hours)

• Tooltips and Report Themes (1 hour)

• Using Parameters in Power BI (2 hours)

• Introduction to Power Automate & Power Apps (2 hours)

• Performance Optimization Techniques (1 hour)

Week 6: Power BI Integration & Real-World Project

• Connecting Power BI with SQL Server (2 hours)

• Using APIs with Power BI (1 hour)

• Creating Paginated Reports (2 hours)

• Real-World Power BI Project (6 hours)

•

Best Practices and Optimization (2 hours)