Advanced Power BI Training
Level
AdvancedDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedAdvanced Power BI Training
The training is intended for people who process and analyze large volumes of data. It covers preparing data with PowerQuery and using it for visualization in Microsoft Power BI. The course includes the use of the DAX library as well as storytelling with data.
What You Will Learn
- Gain advanced skills in processing and analyzing large datasets using Power Query and Power BI, including DAX
- Learn advanced Power Query techniques: M language, query parameterization, custom functions, and working with SQL as a data source
- Master using Python in Power BI: setup, scripts for data retrieval, and visualizations
- Explore advanced Power BI features: report security with RLS (Row-Level Security), AI-driven visualizations, variables in measures, and DirectQuery for models
- Work with additional tools such as DAX Studio and Tabular Editor, plus advanced report publishing (embedding on websites, URL parameters)
- Use Power Automate to streamline workflows with Power BI for more efficient data management and presentation
Who is this training for?
Analysts, marketers, and all those working with data-
People involved in processing and analyzing large datasets
Training Program
-
Advanced Techniques in Power Query
- Introduction to M language and the Advanced Editor
- Preparing data using advanced M functions
- Query parameterization
- Creating custom functions
-
Working with SQL Databases as a Data Source
- Import and DirectQuery connection modes
- Loading data from SQL databases
- Query folding – concept and practical usage
- Writing and parameterizing SQL queries
- Best practices for working with SQL data sources
-
DirectQuery Optimization Techniques
- Performance considerations for DirectQuery models
- Optimizing queries and data models
-
Python in Power BI
- Setting up Python for Power BI Desktop
- Limitations of Python in Power BI
- Using Python scripts to retrieve data (Python connector)
- Building Python-based visualizations
-
Advanced Power BI Features
- Report security with Row-Level Security (RLS)
- AI-powered visualizations
- Using DirectQuery in data models
- Using variables in DAX measures
- Additional tools: DAX Studio and Tabular Editor
-
Advanced Report Publishing
- Embedding reports on websites
- Using URL parameters
-
Power Automate with Power BI
- Automating workflows using Power Automate and Power BI
