Learn your way! Get started

Power Pivot, Part 1: Data Models

with expert Doug Ortiz

Watch trailer

Power Pivot, Part 1: Data Models 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/14/2014
Level Level Intermediate
Runtime Runtime 0h 59m
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 the course will be introduced to Power Pivot 2013, what it is, what is new to Power Pivot 2013 and its place in Business Intelligence arena. Leading us into what is a Pivot Table, configuring and enabling Power Pivot 2013 and finalizing with platforms that support Power Pivot. Then we will take a look at Data Models and how they fit within Power Pivot 2013.We’ll then see types of Data Models and how they relate to Data Connections and how SQL Query Designer can be used as a Data Modeling Tool. Then we will look at importing data from other Data Connections and combining them together within a Power Pivot Workbook.


This course assumes that the users have an understanding of Microsoft Excel and how databases function.

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

Data Models

Introduction (12:38)
  • Introduction (00:29)
  • Introduction (01:47)
  • What is Power Pivot? (02:07)
  • New to Power Pivot 2013 (01:22)
  • Power Pivot 2013 Place in BI (01:39)
  • What is PivotTable? (01:12)
  • Configuration (01:34)
  • Enabling Power Pivot 2013 (00:43)
  • Demo: Enabling in Excel 2013 (01:32)
  • Summary (00:08)
Data Models (21:03)
  • Introduction (00:23)
  • Data Models (02:03)
  • Physical Data Models (00:28)
  • Physical Models Example (00:58)
  • Logical Data Models (00:24)
  • Logical Data Models Example (01:09)
  • Understanding Data Connections (00:55)
  • SQL Query Designer (01:47)
  • Demo: T-SQL & Power Pivot (03:44)
  • SQL Server (01:57)
  • Demo: SQL Server & Power Pivot (03:15)
  • Access (01:23)
  • Demo: Access & Power Pivot (02:08)
  • Summary (00:23)
Data Models Continued (26:06)
  • Introduction (00:12)
  • Excel Workbooks (00:59)
  • Demo: Excel & Power Pivot (03:14)
  • Text Files (00:47)
  • Demo: CSV Files & Power Pivot (03:22)
  • Data Feeds (01:16)
  • Demo: OData & Power Pivot (03:28)
  • SharePoint (01:08)
  • Demo: SharePoint & Power Pivot (03:30)
  • Analysis Services (00:52)
  • Demo: Analysis & Pivot (03:01)
  • Combining Data Connections (01:21)
  • Demo: Combining Data Sources (02:29)
  • Summary (00:21)