SQLServerCentral.com / Strategies and Ideas / Data Warehousing / Design Steps for logical modeling of Dimensional DataMart / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 18:53:04 GMT20RE: Design Steps for logical modeling of Dimensional DataMarthttp://www.sqlservercentral.com/Forums/Topic1528842-363-1.aspxMy 2 cents-For Dimension: I will have conformation rules laid outFor Fact: I will list down all the transformation rules.Thu, 01 May 2014 07:55:14 GMTshashant.kumarRE: Design Steps for logical modeling of Dimensional DataMarthttp://www.sqlservercentral.com/Forums/Topic1528842-363-1.aspxMy 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.Thu, 09 Jan 2014 07:14:32 GMTdmbakerRE: Design Steps for logical modeling of Dimensional DataMarthttp://www.sqlservercentral.com/Forums/Topic1528842-363-1.aspxthe question was written with that having already been established.thanksThu, 09 Jan 2014 07:09:16 GMTps_vbdevRE: Design Steps for logical modeling of Dimensional DataMarthttp://www.sqlservercentral.com/Forums/Topic1528842-363-1.aspx[b]Step 0 - Talk to the business[/b]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.Thu, 09 Jan 2014 06:54:36 GMTdmbakerDesign Steps for logical modeling of Dimensional DataMarthttp://www.sqlservercentral.com/Forums/Topic1528842-363-1.aspxHibegin 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[b]Step 1 - Determine the dimensions[/b] create a business matrix that identifies the dimension and there relations with each other[b]Step 2 - Detarmine the measures[/b] set out the numeric values required for analysis[b]Step 3 - Determine the dimensions attributes[/b] identify elements that would be used to filter or group data for analysis[b]Step 4 - Create a Data map[/b] map out source and destination columns between the OLTP source and each dimension and facts table[b]Step 5 - Include a Date dimension [/b] almost every datamart has one this can be scriptedany advice welcome.thanksWed, 08 Jan 2014 04:44:59 GMTps_vbdev