4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


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 http://cwebbbi.wordpress.com/ 
http://cwebbbi.wordpress.com/ 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

Blog posts RSS

Handling Added Or Missing Columns In Power Query 26 Feb 2015
A recent conversation in the comments of this blog post brought up the subject of how to handle columns that have either been removed from or added to a data source in Power Query. Anyone who has worked with csv files knows that they have a nasty habit of changing format even when they aren’t ...

Optimising SSAS Many-To-Many Relationships By Adding Redundant Dimensions 21 Feb 2015
The most elegant way of modelling your SSAS cube doesn’t always give you the best query performance. Here’s a trick I used recently to improve the performance of a many-to-many relationship going through a large fact dimension and large intermediate measure group… Consider the following cube, built ...

I’m speaking at the PASS BA Conference 15 Feb 2015
I haven’t been shy about stating my support for the PASS BA conference and the associated efforts by PASS to reach out beyond its traditional audience to analysts and other power users (see here for example). I won’t bore you with my opinions again, except to say that at the third attempt I think ...

More Power BI Licensing Details 09 Feb 2015
At the end of last week I came across an interesting link on Twitter (thanks Devin) with more details on how the ‘new’ Power BI will be licensed, and how existing Power BI subscribers will move to the new experience, that I thought was worth highlighting. Here it is: ...

Expression.Evaluate() In Power Query/M 06 Feb 2015
A year ago I wrote a post on loading the M code for a Power Query query from a text file using the Expression.Evaluate() function, but I admit that at the time I didn’t understand how it worked properly. I’ve now had a chance to look at this function in more detail and thought it […]