fbpx
Course length:
Training language:
16 lessons
English
Course fee:

153 500 HUF + VAT (cca. 400 EUR + VAT)


Course dates and application

First training day: 15 July 2024, Further training days: 16.

on working days (09.00 - 16.30)
Application deadline:
5 July 2024
Training language:
English
Course fee:

153 500 HUF + VAT (cca. 400 EUR + VAT)

Applying for closed-group training

If you and your colleagues are attending a closed group training course and you have a training date code, you can apply here.

Application without a date

If none of the dates is right for you, but you are interested in the course, please submit your application without a date. When we announce a new date you will be notified.

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 

 

 

Qualified mentors of the training


Do you have any questions about the training?



You may also be interested in these courses and e-learning packages

You may find the courses below interesting


Microsoft Power Platform (Power Apps, Power Automate) Course
(MFEPOWERPL)

Length:
16 lessons
Price:

209 500 HUF + VAT (cca. 550 EUR + VAT)

Training dates:
Aug 15
Nov 07