Course Power BI Professional
The Power BI Professional course is intended for all Excel users who want to learn to obtain data from different sources. You will learn to connect to them, design and create reports. You can transform, shape or model data. DAX functions are also part of the course.
Minimum input knowledge
Experience working in Excel at the level of a slightly advanced user
Course dates Power BI Professional
Daily courses (5 days): 09:00 - 15:00
Course price: 805.00 / 990.15 EUR
without VAT / incl. VAT
This course can be completed free of charge within the support program for UoZ job seekers.
If you are interested in attending the course free of charge, you can find more information at the following link:
Training syllabus Power BI Professional
Getting Data from Different Sources
- From Excel, from text files, from the web, from a folder, from PDF
Editing Data in the PowerQuery Editor
- Using the first row as headers
- Replacing values
- Changing the type of values in a column, using local settings
- Splitting a column
- Standard mathematical operations
- Adding a conditional column and a column from examples
- Removing duplicates
Creating a Data Model
- Multiple tables in the data model
- Relationships between tables, cardinality
- Filter direction
- Date table
- Hierarchy
DAX Language
- Creating a measure
- Adding a column to a table
- Operations and functions of the DAX language
Data Visualization
- Different visuals - card, table, matrix, charts, map
- Formatting visuals
- Using themes, creating a custom theme
- Sorting data in charts
- Creating a custom tooltip
- Creating a details page
Filters
- At visual level, page level and report level
- Editing interactions between individual visuals
Calculations in the Data Model
- new column in a table - calculated field summary calculations for the whole table - measures
Functions Using Relationships Between Tables
- Related RelatedTable
Group of X Functions
Measures, Calculation Context, Filters and Anti-Filters in the DAX Language
Calculate Function
Active and Inactive Relationships in the Data Model and Their Impact on Calculations
Cross Filters
Time Intelligence Functions, Date Table
Functions Whose Result Is a Table
Output knowledge
A graduate of this course package will gain knowledge for using the functions of the Power BI tool and the DAX language at an advanced level.
Recommended courses after completing Power BI Professional
Show all courses from category Excel courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Power BI Professional
This course has no published reviews yet.
You can add a review after completing the course.