Introducing DAX
Dublin, IE

This one-day seminar is an introductive course about the DAX language. DAX is the native language of Power Pivot for Excel, Power BI Designer and SSAS Tabular models in Microsoft SQL Server Analysis Services 2012/2014. The training is aimed at users of Power Pivot for Excel, Power BI Designer and at Analysis Services developers that want to start using the DAX language.

The goal of the course is to provide the basic notion of DAX syntax and common functions used in most of the solutions.

Prerequisite: Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Designer, or Analysis Services Tabular modeling. A prerequisite of the course can be the participation to the SSAS Tabular Workshop in Dublin the days before, or PowerPivot Workshop, or having an equivalent real-world experience.

Topics covered:

  • DAX Basics
  • Table Functions
  • Evaluation Contexts
    • Filter and Row Context
    • Evaluation Contexts and Relationships
  • Time Intelligence Calculations
  • Statistical Functions
  • Common DAX Patterns

The course does not include hands-on labs: however, you can bring your own notebook to test solutions shown during the seminar and you will receive all the examples used in the seminar.

The course is an intensive and interactive format. Each attendee can bring his/her laptop, but it is not required. There will be "group exercises" driven by the trainers using the wall projector.

Course time

Exact time schedule will be communicated by mail before the course

Course location

Location to be announced
Dublin, IE
» Get directions

Special Bundle Offer

Don't miss another great course in a convenient time frame! Register to both courses and obtain a special bundle price:
SSAS Tabular Workshop
Jun 16-17, 2015 - Dublin, IE

Learn the new Tabular modeling in Microsoft SQL Server Analysis Services 2016 directly from SSAS Maestros.