Microsoft PowerPivot

Have Queries? Ask us +91 72592 22234

Course Overview

The Microsoft PowerPivot training course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.

Course Content

Course Overview

  • Lessons
    • Introduction
    • Course Materials
    • Facilities
    • Prerequisites
    • What We'll Be Discussing
  • Lab : Course Overview


  • Lessons
    • Best Things That PowerPivot Brings to Excel
    • What Will PowerPivot Do for the Analyst?
    • Introduction to PivotTables (Optional)
    • PowerPivot Versions
    • New 2013 PowerPivot Features
    • VLOOKUP Not Required (Use Relationships)
    • Architectural Changes in Excel 2013
    • PowerPivot and Excel 2013
    • PowerPivot and SharePoint
    • Enterprise Business Intelligence and PowerPivot
    • Importing Data
    • Data Models
    • Relationships
    • Simple PivotTable Reports
    • Calculated Columns and Calculated Fields
    • Refreshing Data
    • Calculations
    • SharePoint Sharing
  • Lab : PowerPivot
    • Pivot Tables (Optional)
    • PowerPivot User Interface
    • Importing Data
    • Importing Large Datasets
    • Importing Data with a Query
    • Creating Relationships
    • Creating a Cascading Relationship
    • Creating a Relationship Between Tables From Different Sources
    • Hiding Columns, Change Data Type, Sorting, and Filtering
    • Calculated Column and Calculated Field
    • Add a Calculated Field From the PivotTable
    • Filter Context Using One Table
    • Row Context and Dynamic Selection
    • FILTER Function
    • CALCULATE Function
    • Build a Date Table
    • Relate a Table to an Excel Calendar Table
    • Time Intelligence
    • Perspectives
    • Hierarchies
    • KPIs

Power View

  • Lessons
    • Report Design Principles
    • New 2013 Power View Features
    • Microsoft Power View User Interface
    • Tables
    • Charts
    • BI Semantic Models
    • Saving and Sharing
  • Lab : Power View
    • Power View

SharePoint 2013 Business Intelligence Center

  • Lessons
    • Quick Architecture
    • New 2013 SharePoint Central Administration
    • New 2013 Business Intelligence Center
    • Permissions and Roles
    • Included Document Library and List Apps
    • Create Custom Apps (Libraries) for Visualizations or Workbooks
  • Lab : SharePoint 2013 Business Intelligence Center
    • Central Administration Tour and Web Application Creation
    • Introduction to the Business Intelligence Center
    • Permissions and Sharing
    • SharePoint 2013 Business Intelligence Center Create Apps

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234