17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

Chris Webb

Chris Webb is an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is 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", and blogs at http://cwebbbi.wordpress.com/ 
http://cwebbbi.wordpress.com/ http://feeds.feedburner.com/wordpress/Cpjz
Chris Webb has submitted a session for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

An in-depth session on advanced Power Query functionality and the M language

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

Microsoft Tabular Modeling Cookbook 12 Apr 2014
I stopped writing book reviews on my blog a long time ago because, frankly, I knew most of the authors of the books I featured so it was hard to be impartial. That doesn’t mean I can’t plug my friends’ books in a totally biased way, though, in the same way that I plug my […]

Free Video On Subselects In MDX 07 Apr 2014
Yet more videos have been added to my online MDX training course including a new, free video on subselects in MDX that you can see here: https://projectbotticelli.com/knowledge/what-is-a-subselect-mdx-video-tutorial?pk_campaign=tt2014cwb   If you’d like to subscribe to my MDX course then you ...

CREATE SESSION CUBE and disk usage 01 Apr 2014
You learn all kinds of interesting things on the forums! Recently I saw this post from Nils Rottgardt about a problem with the CREATE SESSION CUBE statement and SSAS Multidimensional: ...

Working with Web Services in Power Query 26 Mar 2014
One of many cool things about Power Query is the way that it allows you to retrieve data from web services and load it into Excel. While this is a subject that lots of people (including me) have already blogged about, the Web.Contents() function – which is the M function that you’ll need to use ...

Pretty Patterns With Power Query And Power Map 20 Mar 2014
Here’s something with no practical use whatsoever. Today, after I finished writing the first draft of the chapter on M of my upcoming Power Query book, I got thinking about how Power View and Power Map get all the attention because of all the eye-catching demos you can create with them. And then I ...