Learn your way! Get started

Power Pivot, Part 2: Basic Concepts

with expert Doug Ortiz

Watch trailer

Power Pivot, Part 2: Basic Concepts Trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date Release date 7/21/2014
Level Level Intermediate
Runtime Runtime 1h 9m
Platform Platform Major browsers on Windows Major browsers on Windows Major browsers on Mac OSX Major browsers on Mac OSX Mobile Devices Mobile Devices
Closed captioning Closed captioning Included
Transcript Transcript Included
eBooks / courseware eBooks / courseware Included
Hands-on labs Hands-on labs N/A
Sample code Sample code Included
Exams Exams Included

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

In this course we'll start looking at the visual differences between Power Pivot 2010 and 2013.Then move into creating our first Power Pivot Workbook and Pivot Table. Next we will look at how to format Pivot Tables, explain the differences between Calculated Fields and Columns and then how to hide and refresh our data. Then we will look at basics such as: filtering, exploring, relationships, perspectives, slicers and drill through.


This course assumes that the users have an understanding of Microsoft Excel and how databases function. The user should have already viewed the Power Pivot: Data Models course before viewing this course.

Meet the expert

Doug Ortiz Doug Ortiz is an independent consultant whose skillset encompasses multiple platforms including .NET, SharePoint, Office, SQL Server and Business Intelligence. Doug has a master’s degree in relational databases and over 20 years of experience in IT, over half of which have been within .NET and SharePoint. His roles both in and outside of SharePoint have ranged from architecture, implementation, administration, disaster recovery, migrations, development, and automation of information systems.

Course outline

Basic Concepts

Creating a PowerPivot (10:32)
  • Introduction (00:16)
  • Visual Differences (00:53)
  • Power Pivot Ribbon Tabs (00:17)
  • Home Ribbon Tab (00:27)
  • Design Ribbon Tab (00:15)
  • Advanced Ribbon Tab (00:28)
  • Creating our first Workbook (00:23)
  • Creating a Data Connection (00:25)
  • Demo: Creating a Workbook (01:35)
  • Creating a Table (00:35)
  • Demo: Creating a Table (04:37)
  • Summary (00:15)
Formatting (25:29)
  • Introduction (00:23)
  • Formatting (01:06)
  • Demo: Formatting (04:23)
  • Demo: Formatting (cont.) (02:03)
  • Calculated Fields (02:29)
  • Demo: Calculated Fields (01:56)
  • Calculated Columns (01:42)
  • Demo: Calculated Column (03:49)
  • Hiding and Refreshing Data (00:47)
  • Demo: Power Pivot Hide Data (02:29)
  • Demo: Power Pivot Refresh Data (04:04)
  • Summary (00:12)
DataSet (33:44)
  • Introduction (00:15)
  • Filters (01:45)
  • Filters (Cont) (00:55)
  • Demo: Filters (02:39)
  • Quick Explore (00:54)
  • Demo: Quick Explore (01:47)
  • Relationships (01:17)
  • Demo: Relationships (03:51)
  • Perspectives (00:30)
  • Demo: Perspectives (03:35)
  • Slicers (02:29)
  • Demo: Slicers (03:30)
  • Demo: Slicers – Timelines (05:30)
  • Drill Through (01:01)
  • Demo: Drill Through (03:23)
  • Summary (00:14)