Power Pivot, Part 5 of 5: Intelligence and Optimizing

with expert Doug Ortiz

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.


Intermediate | 1h 4m | September 03, 2014

Power PivotSQL BIOfficeBusiness IntelligenceExcelSharePoint

Course Outline


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.




Explore Our Blogs, Courses and Webinars