Power BI – prepare data, create data model, design dashboard

BI, that is Business Intelligence, means providing to proper people the proper information in proper time and in a proper form, and this information should help with making proper business decisions. This is a popular definition of this term. So what is Power BI? It is a set of tools that allow using Business Intelligence in practice. An analyst, who is able to use Power BI, will be very valuable for his company – he will be able to focus on key indicators finding and accurately identifying chances and risks. Aim of the training is to prepare for using Power BI efficiently – the participant will be able to prepare data, design a data model with calculations (KPIs) as well as publish reports and dashboards.

3400 EUR (2 days),

5100 EUR (3 days)

Duration

2 or 3 days

Mode

offline/online

Language

Polish or English

Max group

15 participants

Participants will learn:

How to install and prepare themselves to work with Power BI Desktop
How to prepare data for analysis using Power Query
How to create a data model using and how to design measures (KPIs) in DAX
How to create charts and dashboards in Power BI
How to publish the reports to Power BI Online
How to visualise data using Power BI so it is clear and readable for recipients

For whom?

All persons interested in creating reports using Power BI Desktop – a Microsoft tool for reporting and analysing of data that as one of the very few tools can be used free of charge.

Data analysts

Training program

Loading data
Your first chart
Hierarchy and conditional formatting
Matrix, table & measures
Q&A
Line charts
Interactions, slicers & filters
Publishing the report to Power BI Online

Report from A to Z
Append & getting the files from folder
Merge queries vs VLOOKUP
Add new columns & transform columns
Group data
Unpivot

Loading the source data
Designing the table with calendar
Creating a data model
Checking the data model
Creating calculations using DAX

Quick Start in Power BI

Loading data
Your first chart
Hierarchy and conditional formatting
Matrix, table & measures
Q&A
Line charts
Interactions, slicers & filters
Publishing the report to Power BI Online

Prepare the data with Power Query

Report from A to Z
Append & getting the files from folder
Merge queries vs VLOOKUP
Add new columns & transform columns
Group data
Unpivot

Design a data model with DAX measures

Loading the source data
Designing the table with calendar
Creating a data model
Checking the data model
Creating calculations using DAX

Who will train you?

Our Training Team is versatile and constantly evolving in the ever changing world of tech. We encourage you to Get to know our Trainers in a dedicated section of our website and to explore further at Meet Our Team.

We aim for high flexibility and providing you with the up-to-date knowledge and relevant skills, hence trainers can be assigned to a particular course dynamically. Selection criteria may involve factors like preferred dates, trainer’s latest achievements in a given field or your personal view of their competence and experience. Did we mention the Get to know our Trainers section?

Power BI – prepare data, create data model, design dashboard

the right choice?

Is Power BI – prepare data, create data model, design dashboard the right choice?

Misaligned training isn’t just frustrating – it’s a waste of time. Fill in the form below and ensure we can deliver exactly what your skill set requires. We’ll get back to you within a day, offering our best value for your time.

Dive deeper with these related topics

Excel course

#Microsoft #Beginner #Data analysts

4in1 Power courses bundle

#Microsoft #Beginner #Data analysts

Excel BI for Analysts

#Microsoft #Beginner #Data analysts

Intro to AI for enterprise

#Beginner #Everyone

UiPath Developers Foundation

#UiPath #Beginner #RPA Developers

UiPath Developers Advanced

#UiPath #Advanced #RPA Developers

RPA for Business Analysts

#Intermediate #Business Analysts #Project Managers #Automation Managers

MS Power Automate Flows + Desktop

#Microsoft #Beginner #Power Automate Developers

MS Power Apps Training

#Microsoft #Beginner #Power Automate Developers

Excel course

#Microsoft #Beginner #Data analysts

4in1 Power courses bundle

#Microsoft #Beginner #Data analysts

Excel BI for Analysts

#Microsoft #Beginner #Data analysts