Data Analyse with Excel Power Pivot

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

At the end of this training, you will have learned the following skills:

  • Use Power Query to transform external data
  • Use Power Pivot to set up a data model
  • Extend the data in Power Pivot via DAX
  • Analyze in Power Pivot via Measures
  • Create PivotTables from the Power Pivot data model

Contents

Introduction: Business Intelligence and Power BI

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

Collect & Transform

  • Import data into Power Pivot
  • Transform data through Power Query
  • Merge tables using Power Query

Setting up a data model in Power Pivot

  • Creating relationships between tables
  • Expanding tables (calculated columns)
  • Hide columns and tables
  • Custom sorting

Setting up measurements

  • Normal aggregating functions (SUM, COUNT, COUNTROWS, ETC.)
  • Using Aggregating Expressions (SUMX, AVERAGEX, MAXX...)
  • CALCULATE and various filter functions
  • Date calculation (SAMEPERIODLASTYEAR ...)

How to Create Dashboards in Excel

  • PivotTables
  • Building dashboards using Slicers

Target audience

Do you use Excel on a daily basis? Do you regularly create PivotTables and/or do you analyse fast quantities of data? Do you have to use VLOOKUP that often that you have build a love/hate relationship with this function? Then maybe it would be about time to get started with the Excel Power BI tools. These add-ons extend Excel with very powerful options allowing you to import, transform and analyse data.

Prerequisites

A decent knowledge of Excel is required to be able to benefit fully of this training. We will mainly work with PivotTables, so some knowledge of using this is really necessary.

Download PowerPivot_availability.pdf (only Dutch), please contact us if need more information

Duration

2 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
Analyzing your data and using pivottables
Creating powerful charts with Excel
Data Analyse with Excel Power Pivot
Getting started with Microsoft Excel
Introduction to Excel VBA
Making Dashboards in Excel
Using Complex Functions and Formulas
Working with macros in Excel