Browse by Tags

• Data Warehousing
• Design Tips
• ETL
• Microsoft
• SQL Server
• SSAS

• Modelling & Loading a Slowly Changing Many-to-Many Relationship

  I haven’t blogged for a while, mostly because I have been busy. Today I am on a train to London , so I thought what better thing could I do to fill the time than to blog about something I have been meaning to blog about for a while: Modelling Slowly changing... Posted Feb 18 2010, 01:56 PM by JakeSmillie with | with no comments Filed under: ETL, Data Warehousing, Kimball, SSAS, Design Tips

• Creating Slowly Changing Hierarchies in SSAS 2005

  In a Data Warehouse, you’ll typically get at least one slowly changing hierarchy. You’ll probably also have other slowly changing attributes on the same dimension that are not in the hierarchy, causing many changes. Setting up this scenario in SSAS 2005... Posted Jul 03 2009, 11:27 AM by JakeSmillie with | with no comments Filed under: Microsoft, Data Warehousing, Kimball, SQL Server, SSAS

• Kimball Microsoft Data Warehouse: What they don’t tell you! Part 4 – Dealing with Failed Lookups & Early Arriving Facts – Alternative Approach

  Welcome to my 4th and final post of my 4 part series of the Kimball Microsoft Data Warehouse toolkit. I hope you have found it interesting so far. If you have missed any posts, below is the outline of my series:   Part 1 – SCD Dates - (What dates... Posted Oct 28 2008, 03:26 PM by JakeSmillie with | with no comments Filed under: Microsoft, Data Warehousing, Kimball, SQL Server

• Kimball Microsoft Data Warehouse: What they don't tell you! Part 3 – A Composite Type Change (Type-1 & Type-2)

  This is the third part of my 4 part blog series that is aimed to give the world more insight on some of the Kimball Group concepts and, sometimes difference in opinions. Below is the outline of the series.   Part 1  - SCD Dates - (What dates... Posted Oct 27 2008, 11:46 AM by JakeSmillie with | with no comments Filed under: Microsoft, Data Warehousing, Kimball, SQL Server

• Kimball Microsoft Data Warehouse: What they don't tell you! Part 2 – Type-1 Changes & Historical Data

  This is the second part of my 4 part blog that is aimed to give the world more insight on some of the Kimball Group concepts and, sometimes difference in opinions. In my first blog I talked about my difference in opinion to Kimball Group on handling Type... Posted Oct 24 2008, 03:29 PM by JakeSmillie with | with no comments Filed under: Microsoft, Data Warehousing, Kimball, SQL Server

• Kimball Microsoft Data Warehouse: What they don't tell you! Part 1 - SCD Dates

  I was recently lucky enough to attend the Kimball University "Microsoft Data Warehouse in Depth" course, which I thoroughly recommend to anyone looking at the Microsoft toolkit for their Data Warehouse solution. It is well structured, well thought... Posted Oct 24 2008, 11:36 AM by JakeSmillie with | with no comments Filed under: Microsoft, Data Warehousing, Kimball, SQL Server