Power BI - advanced visualization and analysis using the DAX language

Deep yourself in the world of data visualization and effective analysis with this powerful tool. We have a wide range of topics on the program, from the basic principles of working with visual elements to advanced techniques of working with DAX functions and data manipulation. You can look forward to an interactive environment, hands-on exercises and a deeper understanding of the possibilities that Power BI offers for your analytical needs.

Participants should have knowledge at the level of a beginner's course.

Data visualization in Power BI

• Working with buttons and tabs
• Conditional filtering by the return value of another function
• Dynamic tables, labels

DAX functions in relation to the data model

• Functions for changing the calculation context (CALCULATE, CALCULATETABLE)
• Activating and deactivating the filter during the calculation
• Functions for working with objects (VALUES, DISTINCT)
• Transferring data from other tables (RELATED, RELATEDTABLE, LOOKUPVALUE, CROSSJOIN, etc.)

Time Intelligence feature

• Setting your own time table
• Basic functions for working with time
• Concurrent time periods (comparison between years, quarters, months, etc.)
• Cumulative and sliding calculations

Working with custom tables

• Creating a table using DAX
• Adding new columns, adding new columns from other data model tables
• Joining data from multiple tables using the DAX language
• Advanced techniques for working with DAX

Data segmentation

• Computing over virtual tables
• Identifying slow calculations and replacing them with faster alternatives
• The use of iterators for advanced calculations and limiting the number of calculated measures or columns

Materials are in electronic form.

• Using conditional filtering and DAX functions.
• Analysis of time trends and use of Time Intelligence functions.
• Advanced techniques of working with DAX for data segmentation and joining tables.
• Solving performance issues and optimizing calculations.
• Gain practical skills for effective data analysis and visualization in Power BI.

What is Time Intelligence in Power BI?
Time Intelligence is a set of DAX functions that let you analyze data over time — for example, comparing results between periods, calculating cumulative totals, or tracking how metrics evolve across days, months, quarters, and years. It relies on a dedicated calendar/date table linked to the rest of the data in the model.

What is the CALCULATE function used for in DAX?
CALCULATE is one of the most important functions in DAX — it lets you change the calculation context, meaning you can apply, modify, or remove filters that affect a given calculation. With it, you can calculate things like "revenue for a selected region only" or "revenue regardless of the currently applied date filter," without changing the structure of the report.

How do I compare data year-over-year (YoY) in Power BI?
Year-over-year comparisons in Power BI are handled using Time Intelligence functions combined with CALCULATE — typically a function like SAMEPERIODLASTYEAR, which returns the value for the same period in the previous year, is used and then compared against the current value. This requires a properly configured calendar table in the data model.

How can I speed up slow calculations in Power BI?
The main techniques include identifying inefficient DAX formulas and replacing them with faster alternatives, limiting the number of unnecessarily complex calculated columns and measures, working with virtual tables instead of physically storing data, and using iterators for more efficient aggregations. These optimization techniques are exactly what's covered in the course.