Microsoft Power BI - Beginner Course
Course code:
Microsoft Power BI - Beginner Course - Dates and application
First training day: 22 April 2026, Further training days: 23.
Please submit your application and we will try our best to provide a seat for you!
First training day: 17 June 2026, Further training days: 18.
First training day: 3 September 2026, Further training days: 4.
First training day: 10 December 2026, Further training days: 11.
Applying for closed-group training
Application without a date
The aim of the course is to introduce students to the Power BI tool, which enables them to quickly and efficiently analyse large amounts of data, even from different data sources, and present it to decision makers in a way that makes it easy to extract useful information for decision making. All this on their own, without the support of IT professionals.
Our Power BI course is designed for controllers, analysts, BI developers, finance and economics professionals, managers and decision makers, as well as project managers. It is recommended for all professionals working with Excel and databases, those who have to manage large amounts of data, create statements and reports, often from tables of an entire company database. Suitable for producing effective and engaging reports and executive decision preparation materials.
Advanced knowledge of Microsoft Excel is required. Basic knowledge of Pivot tables, database management and SQL language is an advantage.
After completing our course, participants will be able to work independently, using their own tools (Excel, Power BI Desktop, browser); they will be able to build and maintain database-driven business applications - mini BI systems - that can even support decisions.
Course outline:
1. INTRODUCTION TO THE POWER BI TOOLKIT
1.1. Definitions
1.1.1 Definition of BI
1.1.2 What is ETL (Extract, Transform, Load)?
1.1.3 Basic concepts of database and data model (OLTP vs OLAP)
1.2. The concept of self-service Business Intelligence
1.2.1 Why has it developed?
1.2.2 The changes in the way IT and Business work together
1.2.3 What enables a system to truly support decision-making
1.3 Introduction to Excel Power BI Addins and Power BI Desktop
1.3.1 Prerequisites for using Power BI
1.3.2 Excel Power BI versus Power BI Desktop versus PowerBI.com
1.3.3 The differences between the different Excel versions
2. OBTAINING DATA (POWERQUERY)
2.1 Data sources (Extract)
2.1.1 Obtaining data from a database
2.1.2 Obtaining data from a file system
2.1.3 Obtaining data from the internet
2.1.4 Obtaining data from other data sources (Salesforce, R, Google Analytics, etc.)
2.2 Transformations (Transform)
2.2.1 Transforming data
2.2.2 Data Cleansing Tasks
2.2.3 Merging data from different data sources
2.2.4 Creating Dimensions and Data Tables
2.3 Introduction to the M language
2.3.1 Creating basic data transformations and calculated columns using the M language
2.3.2 Programmed data acquisition
2.3.3. Creating a calendar table using the M language
2.4 Loading data into the model (Load)
2.5 Data updates
3. CREATING DATA MODELS (POWERPIVOT)
3.1 Creating and modifying table relationships
3.2 Introduction to the DAX language
3.2.1 Creating simple calculated columns and calculated fields (measures)
3.2.2 Calculating functions
3.2.3 Time-based analyses (Time Intelligence)
3.3. Designing and developing reports presented to users
3.3.1 What will make the analysis useful
3.3.2 Setting up table and field types
3.3.3 Creating hierarchies
3.3.4 Creating KPIs
3.3.5. Using pivot tables to access the data model
4. DATA VIZUALISATION (POWERVIEW)
4.1 Using a Canvas (Excel - PowerView)
4.1.1 Basic visualisation elements and settings
4.1.2 Time-based graphical visualisation
4.1.3 Displaying images in the report
4.2 Story telling in space (Excel PowerMap)
4.3 Power BI Desktop visualisation capabilities
4.3.1 Using the visualisation interface
4.3.2 Setup and formatting options
4.3.3 Using custom visualisations
5. SHARING ANALYSES
5.1 Things to do when sharing
5.2 Interfaces
5.2.1 Excel
5.2.2 SharePoint
5.2.3 PowerBI.com
5.2.4 Other possibilities
Trainers
Do you have any questions about the training?
I really liked the structure of the training, the style of the instructor. I really liked the subject-matter of the whole two days.
Mónika Bogenfürst
Mercedes-Benz Hungária Kft.