Show all

Power BI - advanced visualization and analysis using the DAX language

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.
Level
Designed for participants with basic knowledge and experience
intermediate
Course length
2 days
Language
 cz  eu
Course code
PU24010030
Power BI
Category:
Do you want this tailor-made course to your company? Contact us

Courses with lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
27. - 28. 3. 2025
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: PU24010030-0004
Price without VAT
14 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: PU24010030-0001
Price without VAT
14 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: PU24010030-0002
Price without VAT
14 000 Kč

Course description

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.

Required knowledge

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

Course content

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

Materials are in electronic form.

Objectives

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

Do you want this tailor-made course for your company?

Contact us

News with the course

Náhledový obrázek novinky
Microsoft 10. 6. 2024
10 reasons to use Power BI for data analysis

Microsoft Power BI is a powerful platform for data analysis and visualization. You can easily connect all the company's data sources to it, no matter where they are or in any format. In a user-friendly environment, it creates interactive visualizations that bring data to life and facilitate the recognition of trends and insights.

Náhledový obrázek novinky
Microsoft 17. 5. 2024
Overview of Microsoft Azure certifications

We took a closer look at Microsoft Azure certifications, also known as AZ. Microsoft's certification map is extensive and at first glance it may not be easy to understand it. That's why we're here to help you with that.

Náhledový obrázek novinky
Microsoft 21. 12. 2023
The Microsoft systems are interconnected and form an integrated platform

It's important for administrators to understand the interconnectedness and the strength of the entire platform. A conversation with lecturer Matyáš Koc, a certified Microsoft solutions trainer.

Previous courses

Do you want this tailor-made course for your company?

Contact us

News with the course

Náhledový obrázek novinky
Microsoft 10. 6. 2024
10 reasons to use Power BI for data analysis

Microsoft Power BI is a powerful platform for data analysis and visualization. You can easily connect all the company's data sources to it, no matter where they are or in any format. In a user-friendly environment, it creates interactive visualizations that bring data to life and facilitate the recognition of trends and insights.

Náhledový obrázek novinky
Microsoft 17. 5. 2024
Overview of Microsoft Azure certifications

We took a closer look at Microsoft Azure certifications, also known as AZ. Microsoft's certification map is extensive and at first glance it may not be easy to understand it. That's why we're here to help you with that.

Náhledový obrázek novinky
Microsoft 21. 12. 2023
The Microsoft systems are interconnected and form an integrated platform

It's important for administrators to understand the interconnectedness and the strength of the entire platform. A conversation with lecturer Matyáš Koc, a certified Microsoft solutions trainer.

Why with us