Business Analytics Course details

Course Objective

To enable learners use PowerPivot features to overcome shortcomings of microsoft excel in handling big data.

Learning Outcomes

The learner shall be able to create, manage and manipulate data models by using PowerPivot tool available in MS Excel 2010/2013

Course Description

Download Brochure

Concepts such as data models and relationships between various tables are explained in detail. We also explore the new world of opportunities that PowerPivot brings by introducing the concept of DAX measures


The Promise of Power Pivot
  • Introduction to LDA
  • LDA Assumptions
  • Case Study on LDA
  • Interpreting the Results
Controlling the way you view your pivot data
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Why Wouldn't I Build Every Future Pivot Table in Power Pivot?
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Getting Your Data into Power Pivot
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Creating and Managing Relationships
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Building Pivot Tables
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Cool Tricks Native to Pivot Tables
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Cool Tricks New with Power Pivot
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Using DAX for Aggregate Functions
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Using DAX for Date Magic
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Named Sets, Get Pivot Data, and Cube Formulas
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results
Final Formatting: Making the Report Not Look Like Excel
  • Introduction to PCA
  • Difference between PCA & EFA
  • PCA in SAS
  • Interpreting the Results

Want to explore detailed syllabus? Click Here

Course Extract

  Level Intermediate
    Methodology Online / Offline / Self Learning
    Duration 7 hrs
    Price ₹ 5999 – Offline
₹ 4199 - Online
₹ 2399 - Self Learning
  Pre-requisites None
  Batch size 10-15 students
  Classes On weekend / Sunday
  Certificate Yes
  Placement Assistance Yes

We're ready to listen...

* Indicates a required field

Complete the form below or call us on 784 008 4266.

What services are
you interested in?