MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Pragmatic Self-Service BI with PowerPivot for Excel

Course Summary

This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You'll soon be assembling data from diverse sources into models that deliver business intelligence upon demand.

  • +

    Course Syllabus

    Introduction and Foreword
    - 6m 43s

    —Introduction and Installation 6m 43s
    PowerPivot Installation and Overview
    - 53m 0s

    —Introduction and Installation 2m 55s
    —Check for Installation 1m 25s
    —Demo: Verify Installation 0m 28s
    —Self-Service BI and PowerPivot 3m 52s
    —Managed Self-Service Business Intelligence 4m 0s
    —How PowerPivot Works 5m 5s
    —Demo: A Brief Overview of PowerPivot 2m 17s
    —Importing Text into PowerPivot 0m 22s
    —Demo: Import a Text File 3m 32s
    —Importing from Excel to PowerPivot 1m 19s
    —Demo: Import from Excel 2m 8s
    —Files Underlying PowerPivot 0m 44s
    —Demo: Examine Files Underlying PowerPivot 1m 21s
    —PowerPivot with SharePoint 4m 18s
    —PowerPivot Features and Limitations, and Relationships 4m 56s
    —Demo: Add a Relationship 2m 49s
    —Calculated Columns with DAX Examples 1m 10s
    —Demo: Add Calculated Columns 3m 35s
    —Mount PivotTable with a Measure 0m 57s
    —Demo: Create a Basic Dashboard with PowerPivot Data 4m 41s
    —Installation and Overview Summary 1m 6s
    Building the Basic PowerPivot Data Model
    - 24m 14s
    Working with the PowerPivot Model, and an Introduction to DAX
    - 49m 29s
    Build a Practical PowerPivot Application - Part 1
    - 30m 31s
    Build a Practical PowerPivot Application - Part 2
    - 42m 7s
    Practical PowerPivot Analysis and Reporting with PivotTables
    - 44m 51s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Cloud Computing , Data & Information Management and IT Compliance & Audit Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url