Contact us:
+48 22 379 02 00
info@cloudteam.pl
Live Chat
PL
EN
MS-55108
Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)
AUDIENCE
Information Workers
LEVEL

Introductory (100) – preliminary course, overview

Intermediate (200) – the course extends the knowledge from the level 100 with specific issues

Advanced (300) – the course extends the knowledge from the level 300 with specific issues

Expert (400) – the training course involves an expert level of knowledge and experience and provides an in-depth analysis of the issue

Intermediate
LENGTH
2 days
TRAINING METHOD
vILT
PRICE

2600

ABOUT THIS COURSE
COURSE DETAILS
PREREQUISITES
ABOUT THIS COURSE

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

AUDIENCE PROFILE

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.

COURSE DETAILS

Module 1: Course Overview

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing
  • Lab: Course Overview

Module 2: Exploring Data Modeling

  • Differences Between Excel 2010 & 2013
  • PowerPivot for Excel Add-In
  • PowerPivot Data Model
  • VLOOKUP vs Relationships
  • Relationships
  • Lab: Exploring Data Modeling

Module 3: Introduction to DAX

  • Introduction to DAX
  • Explaining Syntax
  • Exploring Data Types
  • Utilizing Operators
  • Understanding Values
  • Handling Errors
  • Lab: Introduction to DAX

Module 4: Using DAX Functions

  • Mathematical Functions
  • Statistical Functions
  • Logical Functions
  • Information Functions
  • Text Functions
  • Conversion Functions
  • Aggregation Functions
  • Relational Functions
  • Lab: Using DAX Functions

Module 5: Understanding Evaluation Contexts

  • The CALCULATE Function
  • Filter Functions
  • Single Table Evaluation Context
  • Multiple Table Evaluation Context
  • Lab: Understanding Evaluation Contexts

Module 6: Working with Dates

  • Date Functions
  • Working with Calendars
  • Using Multiple Calendars
  • Lab: Working with Dates

Module 7: Utilizing Advanced DAX Functionality

  • Many-to-Many Relationships
  • Banding
  • Evaluate
  • Simplifying Your Life with DAX Studio
  • Lab: Utilizing Advanced DAX Functionality

Module 8: Examining Patterns

  • Walkthrough a Basic Pattern
  • Lab: Examining Patterns
Detailed Agenda
PREREQUISITES

Before attending this course, students must have:

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

2600

Included in price:

  • Authorized instructor
  • Labs
  • Certificate of completion
  • Materials associated with the training – read more

All quoted prices are net prices. All prices are subject to VAT at 23%.

SCHEDULE

Are you looking for another date? Contact us

We do not have a scheduled date for this training.
Contact us to find out when we can start it.

CHOOSE THE MOST CONVENIENT TRAINING COURSE METHOD

ILT

Do you prefer traditional instructor-led
training courses in a classroom?

See our training classrooms!

vILT

Do you prefer virtual instructor-led
training method?

See how our remote training courses look like!

PROMOTIONS

In CloudTeam you can enrich any training course with a bonus of your choice!

Learn more

CLOUDTEAM HAS BEEN YOUR RELIABLE IT TRAINING PARTNER FOR 16 YEARS

Menu
Bitnami