Data Analytics Junkie

Analytics and AI on the Microsoft platform – Marcel Franke –



A Data Warehouse in 4 steps

Yesterday someone asked me how do I typically build a Data Warehouse? I think a very good question and I have a good answer: “I need 4 steps”. Only 4 steps? Hmm…so let’s have a look. Step1: Dimensional Modeling First... Continue Reading →

SQL Server Parallel Data Warehouse

I’m currently on a PDW training and I’d like to share some of the concepts when building a Data Warehouse on PDW. For those who are not familiar with PDW this is Microsoft's first step into the MPP architecture. SQL... Continue Reading →

Data Warehouse Architecture

When I think of a data warehouse architecture I have this typical picture in mind: Data in or Staging Area On the lefthand side there are a bunch of source files or source systems which are staged in the "Data... Continue Reading →

Blog at

Up ↑