PBI-K

Power BI beginner

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates

Training price

99 000 Ft
+ VAT/person
Please choose the date and form of participation!
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Trainer recommendation

Gémes Brigitta

Gémes Brigitta trainer

The target audience for this training is primarily data analysts and reporting professionals, but we welcome anyone who wants to replace their old Excel-based reports (Pivot tables) and PowerPoint-embedded charts with a new, versatile analytical tool for modern, interactive dashboards. During the course, participants will learn how to import large amounts of data from multiple sources into Power BI, explore available data cleaning options, build data models to link and analyze the data, and finally, present it through engaging, interactive visualizations.

Description

The aim of the training is to introduce the unrivalled data processing and visualisation capabilities of Power BI to participants who have not worked with the tool before. The training will cover topics such as data collection and management, data model building and data visualization.

Suggested For

The course is recommended for employees with traditional Excel-based reporting skills.

Outline

What is Power BI?

  • Power BI in headlines
  • The Power BI family and Power BI Desktop
  • User interface (Report, Data and Model views)

Importing data

  • Different sources and ways of importing data (Import and DirectQuery)

Data cleaning

  • Benefits of Power Query
  • Most common data cleansing tasks
  • Operations in the Query Editor [Query Editor]

Data Modeling

  • Creating, editing, characteristics of relationships (Many to One, One to One)
  • Data Analysis Expressions (DAX) introduction
  • Creating Calculated Elements (Calculated Column, Calculated Table, Measure)

Data model optimisation

  • Data types and data categories
  • Sorting methods
  • Defining a hierarchy

Data visualisation basics

  • Inserting visualisation, changing type, formatting
  • Analytical tools
Outline (PDF)

Prerequisites

To successfully complete the training, you need to have an advanced level of Excel (especially data analysis and reporting) and some experience. Completion of our Preparing to use Power BI course will increase the effectiveness of your participation in the course.