January 8, 2014 at 4:45 am
Hi
begin to understand the process off building a Data warehouse off of an OLTP database. So thought I would put down the steps involved (as I understand them) for clarity and to make sure im covering all base's. please amend where appropriate as I will use this as guide as I venture deeper into BI
Step 1 - Determine the dimensions
create a business matrix that identifies the dimension and there relations with each other
Step 2 - Detarmine the measures
set out the numeric values required for analysis
Step 3 - Determine the dimensions attributes
identify elements that would be used to filter or group data for analysis
Step 4 - Create a Data map
map out source and destination columns between the OLTP source and each dimension and facts table
Step 5 - Include a Date dimension
almost every datamart has one this can be scripted
any advice welcome.
thanks
January 9, 2014 at 6:54 am
Step 0 - Talk to the business
Are you sure you need a data warehouse at all? Discuss needs with your users and make sure you understand the business. If you don't really need a data warehouse, don't build one.
January 9, 2014 at 7:09 am
the question was written with that having already been established.
thanks
January 9, 2014 at 7:14 am
My apologies, it wasn't clear in your initial post that that this was the case and it's someting that seems to be often forgotten. I'm certainly glad to hear it though, and if you already have a good understanding of the needs of your users and business then you're already well ahead of the game.
May 1, 2014 at 7:55 am
My 2 cents-
For Dimension: I will have conformation rules laid out
For Fact: I will list down all the transformation rules.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply