Chris Webb is an independent consultant specialising in Analysis Services, MDX, Power BI, Power Pivot and Power Query. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model",
"Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase". He blogs at http://blog.crossjoin.co.uk
This session will show you how to build aggregations in Analysis Services 2008 that are useful for the queries you're actually running
Learn how the Analysis Services cache works, and how you can pre-load it with data to ensure optimal query performance.
Learn to tune Analysis Services 2008 query performance
This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it
Learn about the most frequently made Analysis Services design mistakes, the problems they cause, and how to fix them or not make them in the first place
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
This session explains what the BI Semantic Model in SQL Server Denali is, how it is related to Analysis Services, and provides a brief introduction to the new Tabular model.
This session will cover advanced security topics in the Analysis Services Multidimensional model.
This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View.
An in-depth session on advanced Power Query functionality and the M language
A fun session showing some amazing things you can do with Power BI
See how to use Power Query to build a detail-level reporting solution
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
After SandDance was announced at the Microsoft Data Insights Summit a few weeks ago I had a quick play with it, thought to myself that it looked like it it would provide a few more cool data visualisation options, and then almost forgot about it. More recently I spent some time looking at SandDance ...
As you probably know, charts (and lots of other visualisations) in Power BI have titles that can be set to any piece of static text. You can do this by selecting the chart, going to the Format tab in the Visualizations pane, then changing the properties in the Title section as shown below (full ...
Last week one of the attendees on my SSAS cube design and performance tuning course in London told me that he had been prevented from running a Profiler trace on his SSAS Multidimensional instance by a DBA because “he should be using Extended Events”. He wasn’t too pleased, and I can understand ...
In Part 1 of this series I introduced the different types of non empty filtering that occur in Analysis Services Multidimensional and in Part 2 I showed how you can use monitor this activity using Profiler. In this, the final part of the series, I’m going to show some examples of how you can use ...
Some time ago I wrote the following post on how to work out how long your M query takes to execute in Power Query: http://blog.crossjoin.co.uk/2014/11/17/timing-power-query-queries/ While it’s still relevant for Power Query and now of course Power BI (and it also illustrates some interesting facts ...