Course Overview
- Overview of the Power BI architecture
- Data connection concepts
- Overview of Power BI connectors
- Getting to know the connection types Import, Direct Query, and Live Query
- Cleaning, transforming, and loading data in Power BI
- Overview of the Power Query Editor
- Transformation options in the Power Query Editor
- Introduction to the formula language M
- Data connection and transformation with Python
- Data profiling
- Designing a data model
- Introduction to Data Modeling 3NF vs. Star Schema
- Creating relationships between tables
- Defining keys, hierarchies, and time dimensions
- Configuring tables and column properties
- Model extensions with DAX
- Introduction to DAX
- Using DAX for model extension and KPI calculation
- Creating derived columns, measures, and tables with DAX
- Introduction to the DAX language (including Related, Calculate, etc.)
- Creating reports and dashboards
- Getting to know the standard visuals
- Data restriction with filters, slicers, cascading
- Cross-report navigation with buttons and bookmarks
- Controlling the interaction of visuals
- AI-Features in Power BI
- Natural Language Query (NLQ) in Power BI
- Anomaly detection
- Identification of key influencers
- Decomposition tree analysis
- Creating mobile reports for smartphones and tablets
- Creating paginated reports
- Deployment of reports and dashboards
- Deployment on SSRS for Power BI and in the cloud
- Administration of reports
- Setup of automated data updates
- Setting up row-level security
Who should attend
Database developer, data analyst, business analyst, Excel power user
Prerequisites
Basic knowledge of SQL, basic knowledge of data modeling
Course Objectives
Basic knowledge of SQL, basic knowledge of data modeling
Course Content
- Overview of the Power BI architecture
- Data connection concepts
- Overview of Power BI connectors
- Getting to know the connection types Import, Direct Query, and Live Query
- Cleaning, transforming, and loading data in Power BI
- Overview of the Power Query Editor
- Transformation options in the Power Query Editor
- Introduction to the formula language M
- Data connection and transformation with Python
- Data profiling
- Designing a data model
- Introduction to Data Modeling 3NF vs. Star Schema
- Creating relationships between tables
- Defining keys, hierarchies, and time dimensions
- Configuring tables and column properties
- Model extensions with DAX
- Introduction to DAX
- Using DAX for model extension and KPI calculation
- Creating derived columns, measures, and tables with DAX
- Introduction to the DAX language (including Related, Calculate, etc.)
- Creating reports and dashboards
- Getting to know the standard visuals
- Data restriction with filters, slicers, cascading
- Cross-report navigation with buttons and bookmarks
- Controlling the interaction of visuals
- AI-Features in Power BI
- Natural Language Query (NLQ) in Power BI
- Anomaly detection
- Identification of key influencers
- Decomposition tree analysis
- Creating mobile reports for smartphones and tablets
- Creating paginated reports
- Deployment of reports and dashboards
- Deployment on SSRS for Power BI and in the cloud
- Administration of reports
- Setup of automated data updates
- Setting up row-level security