Data Analytics Junkie

Analytics and AI on the Microsoft platform – Marcel Franke –


Data Warehouse

Data Warehouse reference architecture – Staging & Archive

In my last post I presented the Data Warehouse reference architecture that I use to explain design principles and ETL loading strategies for each layer. I will mainly focus on SSIS as ETL technology. So let’s first start with the... Continue Reading →

Data Warehouse reference architecture

As Thomas pointed out there seems to be a big gap on how to model a Data Warehouse. So I decided to write a little bit more about this topic and will add additionally some ETL loading pattern on top.... Continue Reading →

It’s so quite, what’s going on?

Currently there is nothing really happening on my blog. It’s not because I have no topics or no passion for writing it's a time problem. I have been on vacation and I have currently 2 major tasks which costs all... Continue Reading →

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 2008 R2 Analysis Services Operations Guide published

Today my good friend Thomas Kejser announced the public availability of the SQL Server 2008 R2 Analysis Services Operations Guide. I really can recommend this guide to everybody working with Analysis Services. It has more then 100 pages getting into... Continue Reading →

Project Barcelona – some more news

The product team published an introduction video to project Barcelona: It gives a good overview why we need a solutions that tracks dependencies within BI systems down to the source level and knows where our data comes from and... Continue Reading →

Analysis Services Roadmap

At the beginning of this week the Analysis Services product team announced the new product roadmap: As you can read in Chris Webb’s blog entry ( there was a lot of discussion in the BI Community in the past... Continue Reading →

SAP Integration – Part 1: Microsoft BI on top of SAP BW

The next series I decided to write about is SAP Integration with Microsoft BI. Why? Especially in the German speaking area  SAP is used very often in case of ERP (SAP ERP), CRM (SAP CRM) or Business Intelligence (SAP Business... Continue Reading →

Microsoft starts project Barcelona

This was very interesting news for me. Microsoft started a project for metadata management within the Business Intelligence area. We have seen already a first solution within SQL Server Denali in the form of data lineage analysis for SQL Server... Continue Reading →

Blog at

Up ↑