Chris_Webb.jpg

Chris Webb

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
http://blog.crossjoin.co.uk http://feeds.feedburner.com/wordpress/Cpjz

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.

Blog posts RSS

Data-Driven Power BI Desktop Parameters Using List Queries 30 Aug 2016
The July 2016 update for Power BI Desktop included the ability to make parameters data-driven, by giving the option to bind the Suggested Values (previously called the Allowed Values) property of a parameter to the output of a query that returns a list. However that’s pretty much all the ...

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI 23 Aug 2016
One slightly frustrating feature of Power BI is that some of the cool stuff you can do in M code for loading data, and which works in Power BI Desktop (and in Power Query), causes errors when you try to refresh your dataset after it has been published to PowerBI.com. I recently learned some ...

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code 16 Aug 2016
The Web.Contents() function in M is the key to getting data from web pages and web services, and has a number of useful – but badly documented – options that make it easier to construct urls for your web service calls. Consider the following url: ...

Handling 404–Not Found Errors With Web.Contents() In Power Query And Power BI 09 Aug 2016
One strange feature of the Web.Contents() function in Power Query and Power BI is that it doesn’t respond in a consistent way to the standard error handling techniques used in M. I don’t know if this is a bug or a feature, but it’s certainly something I’ve run into a few times so I thought […]

Another Way To Check Query Folding In Power BI/Power Query M Code 02 Aug 2016
Following on from my last post on checking whether query folding is taking place in a Power BI/Power Query query, I’ve just stumbled on another way of doing this – by looking at metadata. I blogged about M metadata and Power Query some time ago (you might want to read the post to get some […]