Katie and Emil "10 Steps" guide to building a data warehouse

View previous topic View next topic Go down

Katie and Emil "10 Steps" guide to building a data warehouse

Post  itcouple on Mon Sep 24, 2012 4:17 pm

Hi

We decided to share our "10 steps" to building a data warehouse which is based on our experience only. I wonder if anyone has similar steps or may maybe different ones?

Below is link

Katie and Emil 10 Steps guide

Take care
Emil

itcouple

Posts : 45
Join date : 2010-10-13

View user profile

Back to top Go down

Example

Post  frankee787 on Mon Nov 26, 2012 3:52 am

It would be great if you could explain more on how you have made the transition from STEP3 to STEP4 , probably with an example.

Regards,
Franklin

frankee787

Posts : 6
Join date : 2012-11-26

View user profile

Back to top Go down

10 steps

Post  itcouple on Mon Nov 26, 2012 12:08 pm

Hi Franklin,

Not sure if I will answer the questions precisely so I will try to just provide more details for step 3 and 4.

Step 3. We have completed (subject to change) Kimball Bus Matrix where business decided which business process / Activity to target first. So if there are 5 only 1 should be chosen.

Step 4. Get data and import it as fact/dimensional models (some ad-hoc manipulation may be needed). For PoC I don't care about surrogate keys etc (I use business keys) and just focus on model that can be used with Excel. If SharePoint is used (or Excel 2013) then Power View can be used to do some quick analysis.

Hope that makes it clearer... if you have more questions let me know, I'll be happy to share my thoughts.

Regards
Emil

itcouple

Posts : 45
Join date : 2010-10-13

View user profile

Back to top Go down

Re: Katie and Emil "10 Steps" guide to building a data warehouse

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum