4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Chris_Webb.jpg

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
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

Viewing Error Messages For All Rows In Power Query 22 Dec 2014
One of the great features of Power Query is the way you can view any rows that contain error values when you load data. However, even if you can see the rows that have errors you can’t see the error messages easily – without writing a little bit of M code, which I’ll show you […]

Thoughts On The New Power BI 19 Dec 2014
There’s been a lot of Power BI-related news in the last few days. I think it’s enough to say that there is a new Power BI in town, a very different (and much better) story from what we’ve had up to now. Sadly the preview is only available in the US at the moment. I’m […]

Bing Pulse 16 Dec 2014
A recent post on the Bing blog alerted me to a Microsoft service called Bing Pulse that I hadn’t heard about before. It’s a way of collecting and analysing audience feedback in real time during events like TV programmes, sporting events and speeches; the videos at ...

Reading The Power Query Trace File–With Power Query 11 Dec 2014
In the September 2014 update of Power Query a new piece of functionality was added: the ability to turn on tracing. There’s no documentation about what the trace files actually contain anywhere (it’s clearly intended to be used only by Microsoft to help them diagnose problems) but I couldn’t help ...

Power Query And Function Parameters Of Type List 05 Dec 2014
Here’s something interesting that I just discovered about how Power Query deals with function parameters of type list… Imagine you have the following table in an Excel worksheet, and a Power Query query called MyTable that loads all of the data from it: Now, create the following function in a new ...