Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Design Steps for logical modeling of Dimensional DataMart Expand / Collapse
Author
Message
Posted Wednesday, January 08, 2014 4:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 2:33 AM
Points: 47, Visits: 314
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
Post #1528842
Posted Thursday, January 09, 2014 6:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:01 AM
Points: 519, Visits: 2,735
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.



Post #1529326
Posted Thursday, January 09, 2014 7:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 2:33 AM
Points: 47, Visits: 314
the question was written with that having already been established.

thanks
Post #1529330
Posted Thursday, January 09, 2014 7:14 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:01 AM
Points: 519, Visits: 2,735
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.


Post #1529331
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse