Data analysis with Power BI

Tailor-made training

Would you rather have a tailor-made training based on this course? Contact us and we will make it work.
Non-binding request
 
 

Description

After this two-day training, the participants should have the following skills:

  • Transforming external data via Power Query
  • setting up a data model via Power BI
  • Extending data in Power BI via DAX
  • Performing analyses in Power BI via Measures
  • Creating PivotTables based on the Power BI data model
  • Creating visual reports via Power BI Desktop
  • Publishing Power Bi Reports

Contents

Introduction: Business Intelligence and Power BI

  • What is Business Intelligence
  • What is the function of the different components of the Power BI package

Introduction

  • Start Power BI Desktop and signin Online
  • Use an existing report (consume)
  • Create a new report

Collecting and transforming

  • Importing data in Power BI
  • Transforming data via Power Query
  • Merging tables via Power Query

Setting up a data model in Power BI

  • Building relations between tables
  • Expanding tables (calculated columns)
  • Hide columns and tables
  • Adjusted sorting

Setting up measures

  • Normal aggregating functions (SUM, COUNT,COUNTROWS … )
  • Using aggregating expressions (SUMX, AVERAGEX, MAXX … )
  • CALCULATE and different filters functions
  • Date calculation (SAMEPERIODLASTYEAR …)

Visualize data

  • Add visuals and fields
  • Change filter interactions
  • Import visuals from the Marketplace

Formatting

  • Adjust visuals
  • Use page background wisely
  • Apply themes

Sharing Power BI analyses

  • Publishing analyses
  • Updating data
  • Creating dashboards online
  • Questionning your data via Q&A
  • Sharing reports

Target audience

Do you work daily with Excel? Do you often create PivotTables and/or do you analyse large amounts of data? Do you have to use VLOOKUP so many times that you love, but at the same time starting to hate this function? Then maybe it's time to enable the Power BI.

Prerequisites

A good knowledge of Excel

Duration

3 days
Tailor-made training
Each organization is unique in its identity, and no co-worker is the same. That's why we at Learnia offer our clients tailor-made courses as well.
Continue reading
Data analysis with Power BI