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
Chris Webb has submitted 3 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

A fun session showing some amazing things you can do with Power BI
Learn how to use natural language querying with Power BI Q&A
See how to use Power Query to build a detail-level reporting solution

Previous Sessions

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

Blog posts RSS

PASS Summit And Other Speaking And Training Dates 29 Oct 2014
This is just a quick post to advertise some upcoming speaking and training dates… PASS Summit I’ll be at the PASS Summit in Seattle next week, and if you see me around be sure to say hello! I’ll be presenting a deep dive session on MDX scoped assignments at 9:45am on Friday November 7th, and ...

BI Survey 14 Results 26 Oct 2014
Once again, the nice people at BARC have sent me a copy of the results of the latest BI Survey and allowed me to blog about some of their findings (obviously if you want to read them all, buy the survey!). Here are a couple of things that caught my eye: When respondents were asked […]

Sentiment Analysis In Excel With Azure Machine Learning And Power Query 19 Oct 2014
You may have seen Joseph Sirosh’s blog post last week about the ability to publish Azure Machine Learning models to the Azure Marketplace, and that MS have published a number of APIs there already. There’s a new Excel add-in that can be used with these APIs but I noticed that at least one of them, ...

MDX Solve Order, SCOPE_ISOLATION and the Aggregate() function 14 Oct 2014
Solve order in MDX is a mess. Back in the good old days of Analysis Services 2000 it was a difficult concept but at least comprehensible; unfortunately when Analysis Services 2005 was released a well-intentioned attempt at making it easier to work with in fact ended up making things much, much ...

Thoughts On Office Sway And BI 09 Oct 2014
When I first saw the announcement about Office Sway last week, I thought – well, you can probably guess what I thought. Does it have any potential for BI? After all, the Sway team are clearly targeting business users (as well as hipster designers and schoolchildren): look at the Northwest Aquarium ...