• This course is available for in-company training and at our premises
Data Analysis Expressions(DAX)&Advanced Excel Functions

DAX (Data Analysis Expressions) is a language that helps you create formulas that link various data tables from the data that already exists in your Data Model. DAX formulas enable you to perform data modeling, data analysis, and use the results for reporting and decision making.

This course is a guide with simple step by step instructions to walk you through creating DAX in Excel, quickly and efficiently.

Each module in this training will be for a maximum of two (2) hours of vigorous practical sessions that will happen every weekend. A total of four (4) modules (8 hours in the month) shall ensure professionals are proficient in utilizing the advanced tools and features of MS Excel to generate DAX.

Learn how to build DAX functions in PowerPivot with Excel

Get a Quote

Data Analysis Expressions(DAX)&Advanced Excel Functions

Download Brochure

Click here to download Data Analysis Expressions(DAX)&Advanced Excel Functions
Register to attend Data Analysis Expressions(DAX)&Advanced Excel Functions
Register

Data Analysis Expressions(DAX)&Advanced Excel Functions

Download Brochure

Click here to download Data Analysis Expressions(DAX)&Advanced Excel Functions
Register to attend Data Analysis Expressions(DAX)&Advanced Excel Functions
Ask a Question

Data Analysis Expressions(DAX)&Advanced Excel Functions

Ask a Quick Question

Fill in your question and details below and we’ll get right back to you

Why Choose This Course?

By the end of this productivity package, professionals will be able to:

  • Import data into the Power Pivot Data Model using Excel
  • Build Relationships between Data Tables
  • Create DAX Expressions including: SUMX(), RELATED(), RELATEDTABLE(), COUNT(), DISTINCTCOUNT(), MONTH(), DATE(), CALCULATE(), ALL()
  • Build custom DAX Expressions to drop into any pivot
  • Create a Date Table (Calendar) in Excel and Relate to the Data Model for Time Intelligence analysis.

Next Start Dates

Weekend 9 am to 1 pm
Weekdays Evening 2 days 6pm-8pm

Ask a Question

Data Analysis Expressions(DAX)&Advanced Excel Functions

Ask a Quick Question

Fill in your question and details below and we’ll get right back to you
Request Quote

Data Analysis Expressions(DAX)&Advanced Excel Functions

Download Brochure

Click here to download Data Analysis Expressions(DAX)&Advanced Excel Functions
Register to attend Data Analysis Expressions(DAX)&Advanced Excel Functions

By the end of this productivity package, professionals will be able to:

  • Import data into the Power Pivot Data Model using Excel
  • Build Relationships between Data Tables
  • Create DAX Expressions including: SUMX(), RELATED(), RELATEDTABLE(), COUNT(), DISTINCTCOUNT(), MONTH(), DATE(), CALCULATE(), ALL()
  • Build custom DAX Expressions to drop into any pivot
  • Create a Date Table (Calendar) in Excel and Relate to the Data Model for Time Intelligence analysis.
  • Row & Filter Context
  • Multiple Data Tables
  • Create Calculated Columns
Download Brochure

Data Analysis Expressions(DAX)&Advanced Excel Functions

Download Brochure

Click here to download Data Analysis Expressions(DAX)&Advanced Excel Functions
Register to attend Data Analysis Expressions(DAX)&Advanced Excel Functions
Ask a Question

Data Analysis Expressions(DAX)&Advanced Excel Functions

Ask a Quick Question

Fill in your question and details below and we’ll get right back to you

Download a Free Course Brochure

Download Brochure

Data Analysis Expressions(DAX)&Advanced Excel Functions

Download Brochure

Click here to download Data Analysis Expressions(DAX)&Advanced Excel Functions
Register to attend Data Analysis Expressions(DAX)&Advanced Excel Functions