Learn your way! Get started

Power Pivot, Part 1 of 5: Data Models

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/14/2014
Level Intermediate
Runtime 0h 59m
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 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.

Prerequisites

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

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



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)