Learn your way! Get started

Power Pivot, Part 2 of 5: Basic Concepts

with expert Doug Ortiz


Watch trailer


Course at a glance

Included in these subscriptions:

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

Release date 7/21/2014
Level Intermediate
Runtime 1h 9m
Closed captioning Included
Transcript Included
eBooks / courseware Included
Hands-on labs N/A
Sample code Included
Exams Included


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.

Prerequisites

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.

Learning Paths

This course is part of the following LearnNowOnline SuccessPaths™:
SharePoint 2013 Business User

Meet the expert

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)