Power BI Efficient data analysis and reporting

The course focuses on built-in PowerPivot technology, which allows regular users to quickly analyze millions of rows from different databases simultaneously.
The course includes the DAX language, which allows you to create a very advanced analytical solution, far beyond the capabilities of classical contingency tables.
The course deals with sharing analyzes in the company and outside the company, on various devices, or other options that the Excel environment does not provide.
We will show you not only standard functionality, but also all the hidden possibilities that will take your reporting to the next level - well above what you thought it was possible so far. And all this in a tool from Microsoft that is free, fast and stable, and has no limits on data sources or their size.

The course is designed especially for Excel users who need to analyze large volumes of data, in cooperation with intuitive, as well as advanced and modern reporting.

Power BI basics and data visualization
Introduction to Power BI
Overview of Power BI and its benefits
Navigating the Power BI user interface
Data acquisition in Power BI
Connection to data sources (Excel, CSV, database, etc.)
Data transformation and cleaning with Power Query Editor
Creating relationships between tables
Creating visualizations

• Basics of visualizations: columns, graphs, tables, etc.
• Work with filters and interactive elements

Dashboards and reports

• Create and share dashboards
• Publishing reports and sharing with other users

Advanced techniques in Power BI for users
Advanced visualization
Hierarchies, mosaics, maps and other advanced visualizations
Creating custom visualization elements
Advanced work with data and DAX (Data Analysis Expressions)
Introduction to DAX and its use
Creating custom calculations and metrics

• Creation of a complex report with interactive elements
• Using DAX to create more complex calculations and analyses

Optimizing performance and sharing

• Optimizing the performance of reports and dashboards
• Sharing and collaboration in the Power BI service

Materials are in electronic form.