Learn your way! Get started

Power Pivot, Part 5: Intelligence and Optimizing

with expert Doug Ortiz


Watch trailer

Power Pivot, Part 5: Intelligence and Optimizing 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 9/3/2014
Level Level Intermediate
Runtime Runtime 1h 4m
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 cover using Time Intelligence with Power Pivot. Then we’ll show you how to upgrade from Power Pivot 2010 to Power Pivot 2013. Then we’ll optimizations you can apply to workbooks and formulas. Next we’ll cover Cube Functions, while not part of DAX, we can look how we can leverage it to our advantage.

Prerequisites

This course assumes that the users have an understanding of Microsoft Excel and how databases function. You should have viewed the Power Pivot: Data Models, Power Pivot: Basic Concepts, Power Pivot: Dashboards and Power View and Power Pivot: DAX, Formulas, Functions courses before viewing this course.

Learning Paths

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

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



Intelligence and Optimizing

TimeIntelligence (28:15)
  • Introduction (00:30)
  • What is Time Intelligence? (00:19)
  • Prerequisites (00:57)
  • Getting a Calendar Table (01:28)
  • Time Intelligence Functions (00:57)
  • Demo: Simple Calendar Table (05:30)
  • Demo: TI Functions (04:13)
  • Demo: TIF - YTD, PREV (04:35)
  • Demo: TIf - MIN/MAX (04:10)
  • Demo: TIF - DATESINPERIOD (05:02)
  • Summary (00:28)
Upgrading (05:22)
  • Introduction (00:17)
  • Upgrading from PowerPivot 2010 (01:00)
  • Steps (00:56)
  • Demo: Upgrading 2010 Workbook (02:52)
  • Summary (00:15)
Add-Ins (05:53)
  • Introduction (00:29)
  • Workbook Size Optimizer Add-In (00:35)
  • Demo: Add-Ins Content (00:24)
  • Demo: Installing Optimizer (00:55)
  • Demo: Optimizing Workbook (03:05)
  • Summary (00:24)
FormulaOptimizations (05:30)
  • Introduction (00:20)
  • Optimizing PowerPivot Formulas (02:54)
  • Identifying Possible Culprits (01:17)
  • Summary (00:57)
CubeFunctions (16:12)
  • Introduction (00:50)
  • What are Cube Functions? (01:04)
  • Cube Functions (00:21)
  • Demo: Cube Functions (03:17)
  • Demo: CF – CUBEMEMBER, VALUE (05:17)
  • Demo: CF - CUBERANKEDMEMBER (04:31)
  • Summary (00:50)
WhereToGo (02:57)
  • Introduction (00:24)
  • What We Have Learned (00:55)
  • What Next? (01:16)
  • Summary (00:20)