3 Days Advanced DAX Workshop

This three-day workshop is an advanced course on DAX and Tabular Patterns, based on DAX expressions. DAX is the native language of both PowerPivot for Excel and SSAS Tabular model in Microsoft SQL Server Analysis Services 2012.

Who should attend?

The training is aimed at Advanced PowerPivot users and Analysis Services developers that want to master the DAX language and improve their skills in performance optimization. The course includes hands-on lab sessions assisted by our teachers, including exercises for creating queries, solving business problems and locating performance bottlenecks in DAX.

Course Outline:

  • DAX Introduction
  • Advanced Time Intelligence in DAX
  • Evaluation Contexts Recap
    • Filter and Row Context
  • Data Modeling in Tabular
    • DAX Patterns
    • Leveraging Calculated Columns
  • Evaluation Contexts and Relationships
  • Moving Business Logic from ETL to Tabular Model
  • Querying Tabular
  • Analyzing DAX Execution Plan
  • The Vertipaq Engine
  • Optimizations and Monitoring
  • Memory Configuration
  • Advanced DAX
    • Understanding Cross filters
    • Internal Materialization

Dates: Jun 4th,5th & 6th

Venue: Hilton Hotel

Cost: €1,800 (Early Bird until May 21st 2014 €1,620)

For further information contact: events@prodata.ie or call 01 2933883

Register Now


  • Alberto Ferrari

    Alberto Ferrari

    Alberto is a Business Intelligence consultant. His main interests reside in two areas: a methodological approach to the BI development lifecycle, and performance tuning of ETL and SQL code.

    His activities are related to designing and implementing solutions based on Integration Services and Analysis Services for the financial, manufacturing, and statistical areas. He is also a book author and a speaker in international conferences such as PASS Summit, SQLRally and SQLBits. Alberto is certified as an SSAS Maestro. His bio can be found here.
Register Now

Related Events


  • Prodata SQL Centre of Excellence
  • SQL BI

Other Information