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
Quem deve participar
Database developer, data analyst, business analyst, Excel power user
Pré- requisitos
Basic knowledge of SQL, basic knowledge of data modeling
Objetivos do Curso
Basic knowledge of SQL, basic knowledge of data modeling
Conteúdo do curso
- 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