In-Depth data analysis with Power BI Desktop

Power BI allows you to create engaging reports and share them with other users, who, with this information, can define decision-making strategies.

However, in some cases, the default visuals do not allow you to provide all the answers.

In this course, we will discuss how to create relationships between tables, create your own measures to perform more complex calculations using the DAX (Data Analysis Expressions) language, and analyze data.

You will discover some tips to solve a number of basic data analysis and calculation problems.

We will also discuss the in-depth analysis of visuals as well as the management of interactions between them.

All our training, especially on the advanced uses of Power BI, is conducted by our expert trainers. For a request to finance your training by an OPCO, come and discover all our eligible training courses on the "Personalized training" page.

Session theme: Microsoft Power BI

Target Audience: PowerBi users who want to analyze complex data sources

Startup Level: Intermediate

Prerequisite: Master independently the basic uses of Internet browsing and the uses of your computer. A very good knowledge of data tables is essential.

Means and Methods:

• The session is carried out remotely with a virtual classroom tool
• Live interaction with a trainer enabling participants to ask questions
• Videos can complete the course

Objectives: At the end of this course you will be able to structure the analysis of complex data sources to make complete reports

Skills:

• Manage relationships between tables with Power BI Desktop
• Analyze data with metrics

Course Outline:

• Build a report with multiple tables
• Create a calculated column
• Use metrics to refine your calculations (introduction to DAX)
• Explore visuals

Context Elements:

Microsoft Power BI Desktop helps you analyze your data across your enterprise and work as a team using Microsoft One Drive and share your data.
When you use Power BI, some visuals or data may not be visible. This is when you need to use other more advanced features that allow you to analyze your data in more depth.