Microsoft & .NET Training / PowerPivot Training
MCC 55108 - Discovering the Power of Excel 2010, 2013, and 2016 PowerPivot Data Analytic Expressions (DAX)
This Microsoft Community Course 55108, Discovering the Power of Excel 2010, 2013, or 2016 PowerPivot Data Analytic Expressions (DAX) training, teaches attendees PowerPivot Data Analytic Expressions (DAX) fundamentals, functions, and evaluation contexts, as well as advanced functionality.
Location and Pricing
Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.
PowerPivot DAX Training Objectives
All students will:
PowerPivot DAX Training Outline
Exploring Data Models
Differences Between Excel 2010 & 2013
PowerPivot for Excel Add-In
PowerPivot Data Model
VLOOKUP vs Relationships
Introduction to DAX
Introduction to DAX
Exploring Data Types
Using DAX Functions
Understanding Evaluation Contexts
The CALCULATE Function
Single Table Evaluation Context
Multiple Table Evaluation Context
Working with Dates
Working with Calendars
Using Multiple Calendars
Utilizing Advanced DAX Functionality
Simplifying Your Life with DAX Studio
Walkthrough a Basic Pattern
All attendees must have substantial prior experience using Excel. Prior experience writing SQL queries would be a helpful foundation but is not required.
Students receive comprehensive courseware and a copy of Microsoft's The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills).
Software needed for each student PC:
Installation of Excel 2010, 2013, or 2016 with the latest service packs and lab files that we provide, as well as Windows 7, 8, 8.1, 10, or later.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.