Detailed Course Outline
Overview of Power BI Architecture
- Data connection concepts
- Overview of Power BI connectors
- Introduction to connection types: Import, Direct Query, and Live Query
Data Cleaning, Transformation, and Loading in Power BI
- Overview of the Power Query Editor
- Transformation options in the Power Query Editor
- Introduction to M formula language
- Data connection and transformation with Python
- Data profiling
Designing a Data Model
- Introduction to data modeling: 3NF vs. Star Schema
- Creating relationships between tables
- Setting keys, hierarchies, and time dimensions
- Configuring table and column properties
Extending the Model with DAX
- Introduction to DAX
- Using DAX for model extension and KPI calculations
- Creating calculated columns, measures, and tables with DAX
- Introduction to DAX functions (e.g., Related, Calculate…)
Creating Reports and Dashboards
- Exploring standard visuals
- Data filtering with filters, slicers, and cascading
- Cross-report navigation with buttons and bookmarks
- Controlling the interaction between visuals
AI Features in Power BI
- Natural Language Query (NLQ) in Power BI
- Anomaly detection
- Identifying key influencers
- Decomposition tree analysis
Report Deployment and Administration
- Creating mobile reports for smartphones and tablets
- Creating paginated reports
- Deploying reports and dashboards
- Deployment on SSRS for Power BI and to the cloud
- Report administration
- Setting up automated data refresh
- Configuring Row Level Security