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

Tuesday,

July

12

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 Ferrari started working with SQL Server in 2000 and immediately focused his interest on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology. Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities. Alberto is a well-known speaker at many international conferences, like PASS Summit, SQLBits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses. Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

PASSChapterLogo.jpg

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids