PBI-A

New Preparing to use Power BI

Microsoft Power BI Courses Level One
Form of participation
Form of training
Length of training
  • 2 day (2×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates

Training price

from 
138 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 anyone who has previously done data cleaning manually or with macros may also benefit. This course may also be useful for those who have not worked with database management applications and would like to understand the logic of data modeling within the familiar Excel environment. Participants will learn how to import large amounts of data from multiple sources into Excel using the Power Query add-on, then combine and analyze the data efficiently using the PowerPivot add-on and pivot tables.

Description

The course aims to introduce participants to the data analysis tools of Microsoft Excel. During the course, participants will learn how to import large amounts of data (millions of rows or records) from multiple sources into Excel using Power Query, link and build a data model using Power Pivot, and then analyse and update it efficiently using DAX functions and a statement (Pivot table).

The knowledge acquired during the training is suitable to prepare participants who have not previously worked with report generation but will need dynamic visualisation of data and information in the future to use Power BI.

Outline

Microsoft Excel business analytics tools

  • The role of Tables, Power Query and Power Pivot in business analysis

Creating a table

  • Table creation criteria, table insertion, properties

Scanning data

  • Importing data from a web page, folder, file using Power Query

Data cleaning

  • Most common data cleaning tasks using Power Query
  • Operations in the Query Editor [Query Editor]
  • Updating Queries

Data Modeling

  • Creating relationships using Power Pivot
  • Data Analysis Expressions (DAX) introduction
  • Creating Calculated Column and Measure

Optimizing the data model

  • Number formats
  • Sorting
  • Hierarchy [Hierarchy] definition

Creating a Statement and Statement Diagram

  • Inserting a statement [Pivot Table] from multiple tables
  • Insert a Pivot Chart from multiple tables
Outline (PDF)

Prerequisites

To successfully complete the course, it is recommended that you have a minimum of intermediate level Excel skills.