Optimizing & Analyzing DAX Query Plans



DAX is super-fast, you can use it to query billions of rows in less than one second. End of marketing, now let’s go back to the real world. If your query is not performing as advertised, it is time to dive into the details of optimizations, which means catching the query plan with the profiler, understanding what is happening under the cover and rephrase your query, or re-shape your model so to obtain better performance. In this live demo session, Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues. In the meantime, there will be chances to dive into some of the internals of the xVelocity query engine to grab a better understanding of the optimization techniques in DAX.



Enclose code in comments with <PRE></PRE> to preserve indentation.