Chris Webb

Chris Webb is an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. 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

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

Blog posts RSS

Are You Going To PASS Summit 2015? I Need Your Help! 11 Oct 2015
This year at the PASS Summit I’m delivering a rather ambitious and risky session. Here’s the abstract: Analyzing Audience Reaction to the PASS Summit Keynote If you’ve been to PASS Summit before, you know that social media channels such as Twitter go wild during the keynote speeches. Many ...

Drillthrough On Multiselect Now Works In Excel 2016 And SSAS 2016 05 Oct 2015
One unadvertised – but still very welcome – feature of Excel 2016 is that it is now possible to do a drillthrough in a PivotTable when there is a multiselect on a filter or a slicer. It only works if you are using SSAS 2016 on the server, or if you’re querying the Excel Data […]

Tables.GetRelationships() Function In Power BI M 28 Sep 2015
There’s a new M function in the latest release of Power BI Desktop that I spotted: Tables.GetRelationships(). Here’s the help page for it: Basically, what it does is return all the relationships between all of the tables in a data source such as SQL Server. The documentation is a bit cryptic but I ...

Calculated Tables In Power BI 23 Sep 2015
There are loads of great new features in today’s release of Power BI Desktop, but for me the most important by far is the introduction of calculated tables. Miguel Llopis gives a good introduction to what they are in the post announcing the release, but I thought it was worth going into a bit more ...

Upcoming User Group, Conference And Teaching Dates In Scandinavia, UK and USA 17 Sep 2015
I’m going to be doing a lot of speaking at various events over the next few months, and so I thought I would let you know about where I’ll be in case you want to attend. Scandinavia Next week I’m doing a mini-tour of four Scandinavian user groups in a week: Oslo, 17:15 Monday September […]