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 8, 2014 4:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 1:56 AM
Points: 79, Visits: 466
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 9, 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: 2 days ago @ 7:44 AM
Points: 522, Visits: 2,879
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 9, 2014 7:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 1:56 AM
Points: 79, Visits: 466
the question was written with that having already been established.

thanks
Post #1529330
Posted Thursday, January 9, 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: 2 days ago @ 7:44 AM
Points: 522, Visits: 2,879
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
Posted Thursday, May 1, 2014 7:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 8:01 AM
Points: 3, Visits: 94
My 2 cents-
For Dimension: I will have conformation rules laid out
For Fact: I will list down all the transformation rules.
Post #1566721
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse