Course 55108-B: Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)

This course is intended to expose you to PowerPivot Data Analytic Expressions (DAX) concepts such as the Data Model and evaluation context, DAX functions, operators, and constants. This release adds a module on the Data Model, an introduction to patterns, and has lab versions for both Excel 2010 and 2013.

Job role: Developer

Skills gained

  • This course is intended for Power Users, Business Intelligence Developers, and IT Professionals that will be involved with the development of Excel PowerPivot queries and tabular modeling.

Prerequisites

Before attending this course, students must have:

  • Experience with Excel and Microsoft SQL query writing is helpful.

Course outline

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

Lab : Course Overview

After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

Module 2: Exploring Data Modeling

In this module, we will explore the differences between versions of Excel, examine how to activate the PowerPivot for Excel Add-in, e...