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 on a specific date with a live lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
2. - 3. 10. 2024
Language
Place
Praha
Form
classroom
?
The course with an instructor in classroom.
Code of the course: PU24010030-0003
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 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.

Náhledový obrázek novinky
Microsoft 21. 7. 2021
Learn the basics of Microsoft Azure

Azure offers an ever-expanding set of cloud services that can help companies meet business challenges. It offers the freedom to build, manage, and deploy applications on a massive global network using an organization’s favorite tools and frameworks. This opens up many opportunities for IT professionals, depending on their talents and interests.

Náhledový obrázek novinky
Microsoft 11. 5. 2021
10 reasons to earn a Microsoft Certification

There is a high demand for Microsoft experts, and globally recognized Microsoft certifications are used to validate and validate the required knowledge. What else do you get if you decide to become a certified IT professional?

Previous courses

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

Contact us

News with the course

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.

Náhledový obrázek novinky
Microsoft 21. 7. 2021
Learn the basics of Microsoft Azure

Azure offers an ever-expanding set of cloud services that can help companies meet business challenges. It offers the freedom to build, manage, and deploy applications on a massive global network using an organization’s favorite tools and frameworks. This opens up many opportunities for IT professionals, depending on their talents and interests.

Náhledový obrázek novinky
Microsoft 11. 5. 2021
10 reasons to earn a Microsoft Certification

There is a high demand for Microsoft experts, and globally recognized Microsoft certifications are used to validate and validate the required knowledge. What else do you get if you decide to become a certified IT professional?

Why with us