Course Power BI - 1
The Power BI - 1 course is intended for everyone who wants 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.
Minimum input knowledge
knowledge at the level of Excel 1, Excel 2.
Course dates Power BI - 1
Daily courses (3 days): 09:00 - 15:00
Evening courses (4 days): 16:30 - 19:00
Weekend courses (3 days): 09:00 - 15:00
Course price: 450.00 / 553.50 EUR
without VAT / incl. VAT
Training syllabus Power BI - 1
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
Discussion
Recommended courses after completing Power BI - 1
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 - 1
Average rating