Microsoft Excel – Power Pivot Course

overview

Power Pivot is a data modelling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel.

Apply Today

Instructor Led Learning

Duration: 1 Day
Location: Cape Town & Johannesburg
Registration Open Now!

Video Learning

Duration:1 Day
Registration Open Now!

What you will learn

  • Lesson 1 :Getting Started with PowerPivot
  • Lesson 2 : Manipulating PowerPivot Data
  • Lesson 3 :Creating PowerPivot Reports
  • Lesson 4 :Using DAX Functions in PowerPivot
  • Lesson 5 : Distributing PowerPivot Data

Basic computer skills

Computers made easy course

Excel 2010 – Part 1

Excel 2010 – Part 2

Excel 2010 – Part 3

Location for instructor led courses are Cape Town and Johannesburg. We also offer onsite training country wide. T’s and Cs apply. Contact us for more information.

FULL COURSE OUTLINE

Lesson 1: Getting Started with PowerPivot

  • The Need for Power Pivot
  • Acquiring Power Pivot and Power Query
  • The BI Process Overview
  • A Sneak Peek at Your Future

Lesson 2:Pivot Table Skill Review

  • Creating Basic (non-Power) Pivot Tables
  • PivotTable Formatting
  • PivotTable Filtering Tools & Techniques

Lesson 3:Getting Data for Power Pivot

  • Facts vs Dimensions
  • Getting Data from Databases
  • Managing Power Queries
  • Getting Data from Excel Tables
  • Getting Data from Excel Ranges

Lesson 4:Data Modelling Techniques

  • Creating a Power PivotTable
  • Key Concepts for Relating Data
  • Linking Tables with One-To-Many Joins – Practice
  • Solving Many-To-Many Joins with Composite Keys – Theory
  • Solving Many-To-Many Joins with Composite Keys – Practice
  • Solving Many-To-Many Joins with Bridge Tables – Theory
  • Solving Many-To-Many Joins with Bridge Tables – Practice
  • Creating Dynamic Calendars – Theory
  • Creating Dynamic Calendars – Application
  • Sorting Data Model Fields

Lesson 5:Building Measures with DAX (Power Pivot’s Formula Language)

  • Basic Measures – Theory
  • Basic Measures – Application
  • Understanding Measure Calculation
  • Performing Math with Compound Measures
  • The CALCULATE() Function – Theory
  • The CALCULATE() Function – Application
  • The ALL() Function – Theory
  • The ALL() Function – Application
  • Time Intelligence Measures

Lesson 6:Performance Considerations

  • The Case for Current
  • Performance and Stability: Design Best Practices

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.

Contact Us