POWPIV

Faster analysis with PowerPivot

Advanced level, statement-focused training
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 primary target audience for this course includes business analysts, logistics analysts, controllers, and report creators. We also welcome anyone who feels they’ve exhausted Excel’s traditional capabilities and are looking for a stable solution for data analysis. During the training, participants will learn how to import large volumes of data from multiple sources into Excel, connect them, and analyze them effectively using PivotTables—without VLOOKUP or macros!

Description

The course aims to introduce the student to the use of Microsoft PowerPivot. 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 and 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

Completion or knowledge of Excel Advanced course.