Welcome to the Indy BI PASS User Group

Indy BI User Group usually meets the first Tuesday of every month. Please check out our new Meetup group we created to track our event attendance at http://www.meetup.com/IndyBI_UG/.  Events will be posted there as well as here with any changes or added details updated at http://www.meetup.com/IndyBI_UG/.

Next Meeting




Toolkit for DAX Optimization

  • In-Person @ 8900 Keystone Crossing Indianapolis, Indiana, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

Welcome to our First Indy BI PASS User Group meeting with Alberto Ferrari!!!

Featured Presentation:

Toolkit for DAX Optimization

Alberto Ferrari, Consultant Sqlbi

How do you optimize a DAX expression? This session will introduce you to the useful tools to measure performance, gathering data to find the bottlenecks and helping you in writing new optimized versions of DAX. Starting from SQL Profiler, you will learn which events are relevant for DAX, and how to collect them in different environments (Analysis Services, Power Pivot, Power BI). We will show DAX Studio, which simplify and speed-up the data collection process, and makes it easy to find bottlenecks in storage engine and formula engine. VertiPaq Analyzer and other small tools will be also used to collect other useful information. The goal of the session is to provide you a methodology to analyze performance of your DAX measures, to find the bottleneck and to identify the main reason of a performance issue.

About Alberto:
Alberto is a Business Intelligence consultant. His main activities are in the delivery of DAX, and SSAS Tabular workshops all around the world, consulting on large and complex data warehouses, to provide assessments and validation of project analysis or to perform specific problem-solving activities. Alberto author several books about DAX and SSAS and he is a speaker at international conferences like Teched, PASS Summit, SQLRally, and SQLBits.




Back to Top