Microsoft Power BI Designer Now supports DAX Calculated Measures
Just a quick update, I was busy working on a Power BI presentation and thought let me just download the Microsoft Power BI Designer and see if it has been updated. And to my great surprise it has. It appears as though it was updated on 21 April 2015. I then went and installed the downloaded version of Microsoft Power…
Power Pivot and DAX in Power BI
Introduction: Something got me thinking the other day when I used the Google Analytics Connector and saw what looked like to me was a Power Pivot Model, as well as an image. I know in the current Power BI Designer as well as when you import an Excel file into Power BI on the web front end, you do not get to see these…
The future for me
I was reading through the email from The Databse Weekly and I saw an article from Paul Randal with regards to Paul being your mentor. This really got me thinking and where is my future within Business Intelligence (BI). I really love what I do. I get great satisfaction and enjoyment when I can tell people a story about their…
Relocating to Australia – BI Job opportunities in Queensland
I thought I would let you guys know that I am about to relocate to Australia from South Africa. I have had an amazing time in South Africa, and learnt a whole lot whilst working at my past employer. So this is a plug at anyone who has any lead or potential BI work in Queensland, Australia. I would really…
Win Free Ecopy of new book on SSAS
Readers would be pleased to know that I have teamed up with Packt Publishing to organize a Giveaway of the Expert Cube Development with SSAS Multidimensional Models And two lucky winners stand a chance to win ecopy of their new book. Keep reading to find out how you can be one of the Lucky Winners. Overview: …
DAX – Comparing a specific Product Average against the average of ALL products
I had a situation when one of my fellow workers wanted to create a report where they wanted to compare one product’s sales and how it was doing when compared to the average of ALL the product sales. In our example below we want to extract from the AdventureWorksDW2012 Analysis Services Database You can get a copy of…
SSAS (SQL Server Analysis Services) Tabular – Error when Processing – OLE DB or ODBC error: Server: The operation was cancelled by the user ..
The above error is caused when processing an SSAS Tabular database. NOTE:This only applies to when using MDX and an SSAS OLAP Cube to get your data into SSAS Tabular. NOTE 2:The reason that I use MDX and the SSAS OLAP Cube to get data in is for 2 reasons. · The first is that as we know it…
SSRS–Creating reports using Custom MDX or DAX to query SQL Server Analysis Services (SSAS) Cube both OLAP and Tabular (Not using the Wizard)
By default in SSRS you can query an SSAS Cube, but this is by using the drag and drop functionality. The issue with this is that it has quite a few limitations. One of the biggest limitations that I found is that you cannot use your own Custom MDX to create your data set. NOTE: You can use the same…