Microsoft Excel Power Pivot (Advanced)

Power Pivot is an add-in for Microsoft Excel 2013 that enables you to import millions of rows of data from multiple data sources.


1 day
All levels
0 lessons
0 quizzes
0 students

Course Info

Power Pivot is an add-in for Microsoft Excel 2013 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance. This hands-on course demonstrates how to take advantage of self-service business intelligence using Microsoft PowerPivot for Excel.

What Will I Learn From This Course?

Defining Measures for business performance.

  • Distinguishing the role of measures.
  • Translating key business concepts into measures

Implementing DAX functions in Power Pivot

  • Expressing information with measures
  • Exposing hidden information from data

Exploiting data analytics with aggregation

  • Quantifying information with DAX functions
  • Aggregating data from other tables

Performing date and time analysis

  • Grouping dates for time analysis
  • Comparing and categorizing time periods with time intelligence functions

Target Audience

Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.


Delegates should be proficient users of Excel and be familiar with the basics in creating Power Pivots, understand the concept of relationships in related tables.

At Course Completion:

Upon successful completion of this course, the delegate should be proficient with PowerPivot and have the necessary skills to implement PowerPivot applications, manipulate data and perform data analysis.

Recap on the Fundamentals of PowerPivot

This module explains how to bring your data into Excel whether it’s an external source, text files, Excel data and other sources. It also shows you how to build relationships between tables which is vital to data analysis.

  • Importing Data
  • Creating Linked Tables
  • Managing Relationships
  • Creating A Power Pivot


Recap on Data Analysis Expressions (DAX)

PowerPivot has its own syntax for defining calculation expressions. It is conceptually similar to an Excel expression, but it has specific functions that allow you to create more advanced calculation on data stored in multiple tables.

  • DAXS operators
  • DAXS context
  • Calculated Columns
  • Measures
  • Choosing between Calculated columns and Measures


Simple DAX Functions

  • SUMX


Row context and Filter context

  • Row context
  • Functions to aggregate expressions
  • Filter context
  • Relationships and Filter Context
  • Measures and Filter Context
Curriculum is empty

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications