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.
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.
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.
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.
Time to complete