Power Pivot, Part 2 of 5: Basic Concepts

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.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

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.

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.

Video Runtime

69 Minutes

Time to complete

192 Minutes

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)