So it has been a while since the GA release of PowerBI.com and Power BI Desktop Edition (for those that remember ProClarity and Panorama Desktop tools this choice of name still makes me giggle!) and I thought it about time I put the modelling capabilities of Power BI Desktop to the test. I am a..
The objective of any data warehouse should include:
- Identification of all possible data assets
- Select the assets that have actionable content and are accessible
- Model the assets into a high performance data model
- Expose the data assets most effective for decision making
Under the SQL Server 2012 licencing terms running a data warehouse on the BI edition of SQL Server did not make sense if your source databases were licensed per core.
Let me introduce you to an interesting story that was part of the foreword of the Mike Cohn book “Succeeding with Agile: Software Development with Scrum”. In the story, trappers would stop off at the Hudson Bay store to get all their supplies before setting off into the wilderness and make their..
Everyone is talking about Big Data. What it is, how important it is and why it should be part of your strategy or roadmap. But what does it really mean? I can only talk from my experiences with various customers and what it means for them. For some it means large volumes of difficult to use data:..
I am often asked to recommend good books to help with training or as references around different areas of the MS BI stack. This blog is a list of books I have found most useful, I will look to add to this as I find new ones.