Excel BI Academy

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

[qode_accordion][qode_accordion_tab title=”Description of training” title_tag=”h4″]

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.

[/qode_accordion_tab][qode_accordion_tab title=”Aim of the training” title_tag=”h4″]

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.

[/qode_accordion_tab][qode_accordion_tab title=”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
[/qode_accordion_tab][qode_accordion_tab title=”Exercises:”]

All of our trainings are based on practical exercises combined with theoretical information. All participants will receive an exercise book which includes description of methods practiced during the classes.

[/qode_accordion_tab][qode_accordion_tab title=”Training form:”]

The training takes place online or on-site in the ordering company’s office or any place chosen by it. A coordinator from the ordering company chooses a group of participants not larger than 15 people. The participants should have Power BI installed. The training lasts 2 or 3 days (each day lasting 7 hours).

[/qode_accordion_tab][qode_accordion_tab title=”Price:”]

3400 EUR for a 2-day training
5100 EUR for a 3-day training (recommended)
+ optionally 149 EUR per person for 4in1 POWER courses bundle at Excel BI Academy (22 hours of videos)

It is a good practice to organize first a 3-day Power BI Basics training and then after a while a 3-day Power BI Advanced training – Data modelling, DAX, Power BI tips & tricks.

[/qode_accordion_tab][qode_accordion_tab title=”Number of participants”]

Maximum number of participants is 15 persons, the price is independent of the number of participants.

[/qode_accordion_tab][/qode_accordion]

Training agenda

[qode_accordion][qode_accordion_tab title=”Quick Start in Power BI”]
  1. Loading data
  2. Your first chart
  3. Hierarchy and conditional formatting
  4. Matrix, table & measures
  5. Q&A
  6. Line charts
  7. Interactions, slicers & filters
  8. Publishing the report to Power BI Online
[/qode_accordion_tab][qode_accordion_tab title=”Prepare the data with Power Query”]
  1. Report from A to Z
  2. Append & getting the files from folder
  3. Merge queries vs VLOOKUP
  4. Add new columns & transform columns
  5. Group data
  6. Unpivot
[/qode_accordion_tab][qode_accordion_tab title=”Design a data model with DAX measures”]
  1. Loading the source data
  2. Designing the table with calendar
  3. Creating a data model
  4. Checking the data model
  5. Creating calculations using DAX
[/qode_accordion_tab][/qode_accordion]

Training in numbers

[qode_elements_holder number_of_columns=”three_columns”][qode_elements_holder_item vertical_alignment=”top” horizontal_alignment=”center” advanced_animations=”no”][counter type=”random” box=”no” position=”center” separator=”yes” digit=”3″ font_size=”70″ text=”day training full of exercises”][/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”top” horizontal_alignment=”center” advanced_animations=”no”][counter type=”zero” box=”no” position=”center” separator=”yes” digit=”50″ font_size=”70″ text=”exercises to do by Participants”][/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”top” horizontal_alignment=”center” advanced_animations=”no”][counter type=”zero” box=”no” position=”center” separator=”yes” digit=”200″ font_size=”70″ text=”pages of training handout + optionally 22 h videos”][/qode_elements_holder_item][/qode_elements_holder]
[qode_accordion][qode_accordion_tab title=”Profile of a participant:”]

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.

[/qode_accordion_tab][qode_accordion_tab title=”After the training the participants:”]
  • Will save many hours of work creating refreshable queries to reference databases, files and folders using Query.
  • Will create reports based on several sources which process large amount of data very quickly.
  • Will design dashboards using Power BI and share them to other users.
[/qode_accordion_tab][qode_accordion_tab title=”Benefits for the organisation”]
  • Automated process of refreshing of reports that provides an analyst with more time for drawing conclusions.
  • Access to reports using internet browser and mobile applications.
  • Management of access to data, linking the access with Active Directory, broad possibilities of cooperation between employees.
[/qode_accordion_tab][/qode_accordion]

We have been the trusted partner of:

[qode_carousel carousel=”live-trainings” number_of_visible_items=””]
[qode_elements_holder background_color=”#ffffff” number_of_columns=”one_column” custom_class=”DTeam”][qode_elements_holder_item horizontal_alignment=”center” advanced_animations=”no” item_padding=”10%”]
Bartosz Czapiewski SR_150x150
Bartosz Czapiewski
TRAINER

An expert in the area of BI and data visualisation with +10 years of experience as an analyst, report designer, consultant and trainer. He prepared reports for the largest companies. Enthusiast of Excel (with Power Query and Power Pivot), Power BI, data visualisation and dashboards.

[/qode_elements_holder_item][/qode_elements_holder]
[qode_elements_holder background_color=”#ffffff” number_of_columns=”one_column” custom_class=”DTeam”][qode_elements_holder_item horizontal_alignment=”left” advanced_animations=”no” item_padding=”10%”]
Do you have any questions?

Contact me:

[icons size=” custom_size=’14px’ icon=’fa-phone’ type=” position=’left’ border=’no’ border_color=” icon_color=” background_color=” margin=” icon_animation=” icon_animation_delay=” link=” target=’_self’]  +48 500 196 861

[icons size=” custom_size=’14px’ icon=’fa-envelope’ type=” position=’left’ border=” border_color=” icon_color=” background_color=” margin=” icon_animation=” icon_animation_delay=” link=’mailto:bartosz@excelbiacademy.com’ target=’_blank’]  Mail

[/qode_elements_holder_item][/qode_elements_holder]