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 →
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 →
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 →
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 →
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 →
The product team published an introduction video to project Barcelona: http://blogs.msdn.com/b/project_barcelona_team_blog/archive/2011/05/25/introduction-to-project-barcelona-presentation.aspx 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 →
At the beginning of this week the Analysis Services product team announced the new product roadmap: http://blogs.msdn.com/b/powerpivot/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx As you can read in Chris Webb’s blog entry (http://cwebbbi.wordpress.com/2011/05/17/good-news-on-the-future-of-analysis-services/) there was a lot of discussion in the BI Community in the past... Continue Reading →
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 →
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 →