Introducing DAX Workshop

Dublin, IE

Sorry, this course is closed.

Leave your email if you want to be notified when a new edition of Introducing DAX Workshop will be available in Ireland.

 By pressing the Notify button you are agree to our Privacy Policy.

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
    • CALCULATE
    • 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.

Topics

Prerequisites

Location

Location to be announced
Dublin, IE
View on Google Maps

Looking for another city?

We bring our courses to you all over the world. Here are the current scheduled classroom events.
Please note that each course is taught exclusively by SQLBI trainers (no external trainers are involved).
Early Bird
Discount
Bundle
Discount
Video
Discount
 Seattle, WA, US Feb 6-8
Seattle
 Atlanta, GA, US Feb 11-13
Atlanta
 Amsterdam, NL Feb 19-21
Amsterdam
 London, UK Mar 13-15
London
 Vancouver, BC, CA Mar 13-15
Vancouver
 Chicago, IL, US Mar 25-27
Chicago
 Amsterdam, NL Apr 9-11
Amsterdam
 Amsterdam, NL May 8-10
Amsterdam
 Cincinnati, OH, US May 21-23
Cincinnati
 Helsinki, FI May 21-23
Helsinki
 Aarhus, DK Jun 18-20
Aarhus
 Brisbane, QLD, AU Jul 17-19
Brisbane
 Melbourne, VIC, AU Jul 23-25
Melbourne
 Sydney, NSW, AU Jul 30-Aug 1
Sydney
 Melbourne, VIC, AU Aug 6-8
Melbourne
 Perth, WA, AU Aug 14-16
Perth
Other locations On-Site On-Site On-Site On-Site On-Site