Power BI Syllabus

Course Structure of Power BI

Module 1 : Introduction To Power BI

Week 1: Overview of Power BI
What is Power BI?
Power BI Content (Power BI Desktop, Power BI Service, Power BI Mobile)
Using Power BI data and apps

Module 2: Getting started with Power BI 

Week 2: Installing and setting up Power BI
Installing Power BI Desktop
Overview of the Power BI interface
Understanding the Power BI ecosystem
Week 3: Setting up a connection to a data source
Import data from Excel, CSV, and text
Connect to a database (SQL Server, Access)
Connect to online services (SharePoint, Azure, Web API)

Module 5: Creating reports and dashboards

. Week 1: Design Article Guide
Layout and design
Creating multi-page reports
Adding text boxes, images, and charts
Week 9: Creating dashboards in Power BI
Activities publish data to Power BI Services
Pining visuals to dashboards
Sharing and collaborating on dashboards

Module 3: Data transformation and modeling

Week 4: Using Power Query for data transformation
Introduction to the Power Query Editor
Data cleansing (delete duplication, filtering rows)
Combining and appending queries
Week 5: Patterns
Understanding many-to-many, many-to-many relationships (Part 1)
Designing calculation columns and measures
Introduction to DAX (data analysis table)

Module 4: Data visualization

Week 6: Creating visualizations
Overview of visualization types (bars, lines, pies, charts)
Adding and formatting visuals
Using slices and filters for interactivity
Week 7: The exciting visual process
Designing your visualization
Using tips and best practices
Data visualization best practices

Module 6: Advanced Power BI features

Week 10: Accessing advanced DAX operations
High Definitions in DAX
Using Time Intelligence Actions
Developing Advanced Analytics
Week 11: Power BI and Data Recovery
Setting Up Scheduled Refresh
Understanding Data Gateway
Handling data update errors

Module 7: Power BI Administration and Management

Week 12: Power BI Administration
Power BI Administration Portal Overview
Manage Workspaces and Permissions
Monitor Usage Metrics and Performance
Week 13: Data Management Data and Security
Row-Level Security (RLS)
Data Sensitivity Tags
Data Governance Best Practices