Data Analytics Junkie

Analytics and AI on the Microsoft platform – Marcel Franke –


SQL Server

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 →

Blog at

Up ↑