18/04/2016 7:08:31 AM
In this talk we will look at how you can get started with writing your own queries against cubes. We will start from a basis of SQL queries and compare and contrast equivalent DAX and MDX queries. Being able to write your own queries is an important skill to know for the following reasons:
• It makes it a lot easier to identify issues with your data,
• It can provide a much faster way to test and develop measures,
• It's an extremely effective way of doing performance tuning
• It can extended your reporting capability by providing a means of extracting data that is difficult or impossible to do with GUI tools.
As in the Matrix movie I'm inviting you to take the red pill and come with me on a journey. At the end of our session you should have an understanding of the basic concepts of querying cubes and how to get started writing your own queries.
THIS MONTH'S SPEAKER:
Darren Gosbell has 15 years of practical experience implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Darren has been awarded as a Microsoft MVP SQL Server since 2006 in recognition of his contribution to the community specially in the areas of Analysis Services and MDX. Darren is a contributor to a number of open source projects including BIDS Helper, DAX Studio and ASStoredProcedures.
Venue: Microsoft Melbourne Office (Level 5, Building 4, Freshwater Place, Southbank, Melbourne) |
Duration 5:30PM pizzas & drinks and sharing ideas 6:00PM start 7:30PM finish (ish!) |
On: Tuesday, 19 April 2016