Description
The Power BI course Effective data analysis and reporting will show you how to use interactive data analysis and reporting in the Power BI tool in all aspects.
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.
Target
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.Contents
Power BI basics and data visualizationIntroduction 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 usersAdvanced 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
Study Materials
Materials are in electronic form.Followups
Power BI - advanced visualization and analysis using the DAX language
