MSBIBlog.comMicrosoft BI / Data Platform development and training.

  • Home
  • Who we are
  • Join us! (A brief history)

Dimensional Modeling

Do you need a data platform?

  • 14-01-2020
  • /
  • Azure Azure Data Lake Big Data Dimensional Modeling Enterprise BI Power BI Uncategorized
  • /
  • No Comments

4 years ago I was a speaker for an event called "Power BI for municipalities". The first speaker showed some of the reports they had been making at their organization. The audience was very involved and enthusiastic. They simply loved it. The main feeling going through everyone's mind was "I want to start with Power
Continue reading...

Dimensional modeling in 2018

  • 18-09-2018
  • /
  • Dimensional Modeling Uncategorized
  • /
  • 7 Comments

It is quite common to update your skills in a product, Power BI for example. It is not so common to re-validate concepts or theory very often. For example "Joins are performance heavy", or "Data warehouses need surrogate keys". Usually these things don't change very often. Still it is important to update your view on
Continue reading...

Data Warehouse Automation Thoughts

  • 20-07-2017
  • /
  • Data Vault Data Warehouse Automation Dimensional Modeling Enterprise BI
  • /
  • 2 Comments

I've been looking into DWA for a few months now, and might give it a try sooner or later. Here's some thoughts about it:
Continue reading...

Should you call it a junk dimension?

  • 21-08-2015
  • /
  • Dimensional Modeling
  • /
  • 2 Comments

Datamarts, cubes, tabular models...they all present a dimensional model to the end user that is intuitive. At least, that should be the case. So no abbrevations in the dimensional model. Business users tend to prefer to see the data in the same way they speak about it. So a product is a product, not a
Continue reading...

Recent Activity

  • Posts
  • Comments
  • Tags
  • Data quality is everything 12-06-2020
  • Store streaming data to Azure Synapse Pool (Part 3) 03-06-2020
  • Self Service BI is here to stay 11-05-2020
  • Store streaming data to a data lake in Azure 20-03-2020
  • Streaming Twitter data to Power BI with Azure 17-02-2020
  • Brandon Chen
    Great tutorial. This is the first Azure tutorial I...
  • John Helmuth
    Lars, Thanks for the demonstration of accessing...
  • Kareem Rasheed babatunde
    Hi, my cluster couldnt install the libraries. what...
  • Jesse Gorter
    Hi Zeffry, I hope soon! :)
  • Zeffry
    Hi Jesse, when will be the part 4?
AzurePower BIAzure MLMachine LearningSSASSQL DatabaseData WarehousingSQL DatawarehouseETLSSISAzure Stream AnalyticsPythonscikit-learnRCortana IngelligenceContinuous Integrationcontinuous builddata lakeTabular Modelanalysis services connector

MS BI Blog on Twitter

Tweets door @MSBIBlog
Copyright 2022 MSBIBlog · Theme design by Bluthemes · www.bluthemes.com