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

Power Query, Power BI And The “Allow Data Preview To Download In The Background” Option 05 Dec 2016
Recently I was asked by a customer to do some tuning on an Excel workbook with a lot of Power Query queries in it. Although all of the data used in the queries was coming from tables in the workbook itself and the data volumes were small, there were fifty Power Query queries and clicking […]

Sharing Power Query Queries With Azure Data Catalog 29 Nov 2016
About a week ago, without any warning, a much-awaited new feature lit up in Azure Data Catalog: the ability to share Power Query queries between workbooks and users. In fact it’s not really a new feature but the reappearance of something that was present in the original version of Power BI for ...

Converting Lists Of Numbers To Text Ranges In Power Query 24 Nov 2016
In a comment on my post on Creating Sequences of Integers And Characters In Power BI/Power Query Lists a reader, Paul G, asked me the following question: can you reverse this? e.g i have a list (1,2,3,5,7,8,9,12,13,14,15) can i convert this to (1-3, 5 ,7-9,12-15) This got me thinking… I was sure it ...

Referenced Queries And Caching In Power BI And Power Query 20 Nov 2016
Last week, Maxim Zelensky (whose blog is well worth checking out) tweeted about a very interesting answer he had received to a question he posted on the Power Query MSDN forum, on the subject of caching and referenced queries in Power Query. You can read the thread here: ...

Calling Microsoft Flow From Power Query And Power BI 13 Nov 2016
Since last week’s blog post caused quite a lot of interest, here’s something similar: did you know you can trigger a Flow in Microsoft Flow and get a response from it back using Power Query/Power BI? To start off, I suggest you read this post by Irina Gorbach which shows how a Flow can be […]