Microsoft Excel - Power Pivot Course Overview

Enroll for our 2-day Microsoft Excel - Power Pivot from Koenig Solutions. In this course you will learn how to perform powerhouse data analysis and modeling to make intelligent business decisions through Microsoft PowerPivot. Microsoft PowerPivot is an add on for Excel that provides Business Intelligence functionality & reporting within the familiar environment of Excel.

The course is designed for Excel 2016, 2019 and Microsoft 365 (Office 365), so you can choose the version that works best for you.

Target Audience:

The training is Intended for data analysts, financial analysts, business analysts, managers, and anyone who wants to harness Excel's business intelligence capabilities.

Learning Objectives:

After completing this course, you will be able to:

  • How to get data and transform it into useful tables.
  • How to build a proper dimensional model in Excel, by linking multiple tables together in order to solve common real-world problems.
  • Write your own custom calculations for pivot tables using DAX (Data Analysis Expressions), Power Pivot’s formula language.
  • How to build amazing reports.

 

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Getting started with PowerPivot
  • Start Excel & launch the PowerPivot window
  • Navigating the PowerPivot window
  • Exploring the PowerPivot tab and field list in Excel
  • Data sources and types supported in PowerPivot workbooks
  • Importing data (from pre-prepared file)
  • Add Data by using Excel Linked Tables
  • Using Power Query
  • Working with Tables and Columns
  • Filtering and Sorting Data
  • Creating Relationships Between Tables
  • Creating and Working with calculations
  • Creating, deleting a table
  • Rename a Table or Column
  • Set the Data Type of a Column
  • Hide or Freeze Columns
  • Undo or Redo an Action
  • Sorting and filtering data in a table
  • Understanding Relationships
  • Create a Relationship Between Two Tables
  • View and Edit Relationships
  • Delete Relationships
  • Troubleshoot Relationships
  • Overview of Data Analysis Expressions (DAX) language
  • Building Formulas for Calculated Columns and Measures
  • Understanding the Use of Relationships and Lookups in Formulas
  • Understanding Aggregations in Formulas
  • Filtering Data in Formulas
  • Recalculating Formulas
  • Create a PivotTable or PivotChart Report
  • Create a Reporting Services Report with PowerPivot Data
  • Create a Measure in a PivotTable or PivotChart
  • Create and Change the Field Layout in a PivotTable or PivotChart Report
  • Delete a PivotTable or PivotChart Report
  • Filter Data using Slicers
  • Work with Relationships in PivotTables
  • Change the Display Language
  • Retail sales KPI case study
  • Sales per hour, average
  • Conversion rates
  • Wage to sales ratio
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training
30 - 31 May 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 07 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too fast, we can offer Comfort Track for 32 hours

Course Prerequisites
  •  A  good knowledge of Excel, including a working knowledge of PivotTables and an understanding of nested functions.

 

Request More Information

Add Name and Email Address of participant (If different from you)