UEL-3

Building a data model using PowerPivot

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
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 business analysts, logistics analysts, controllers, and managers responsible for creating reports. We also welcome anyone who feels they’ve exhausted Excel’s traditional capabilities and is looking for a reliable solution for data analysis. During the course, participants will learn how to import large amounts of data from multiple sources into Excel, combine them, and analyze them efficiently using pivot tables, all without using VLOOKUP or macros!

Description

The aim of the module is to introduce the student to the use of Microsoft PowerPivot. By using PowerPivot as a "self-service BI" solution, Excel is able to manage up to 100 million records (rows) and analyse them faster with data available in one or more spreadsheets. By the end of the program, the user will have learned the basics of managing PowerPivot and how to build a data model to effectively analyze data using Excel on their own.

Outline

  • Data loading with PowerQuery from various sources
    (other workbook, current workbook, website)
  • Cleaning, transforming, preparing data in PowerQuery
  • PowerPivot introduction
  • Excel Pivot table vs. PowerPivot, multi-table queries
  • Plotting data, displaying tables, relationships in PowerPivot
  • Basic calculations and functions with PowerPivot (DAX intro)
  • Data analysis and reporting options
  • Dashboard creation basics
Outline (PDF)

Prerequisites

Advanced knowledge and experience of Excel is required to successfully complete the training.