Power BI - advanced visualization and analysis using the DAX language (EN)

Description

Learn many useful techniques and tools to help you effectively analyze and visualize data. You will have the opportunity to explore a wide range of functions, including working with DAX functions, manipulating data and creating complex reports.

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.

Goals

• 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.

Contents

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

• 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.)

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

• 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

• 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

Prerequisites

Study Materials