Design Datawarehouse from Northwind Database

View previous topic View next topic Go down

Design Datawarehouse from Northwind Database

Post  pmksasbi on Sun Jun 30, 2013 8:56 am

Hi ,

Can anyone of you help me in designing Data warehouse for Northwind database. Can you please share any documents based to design the database and how should i proceed further for Reports once the DIM and Fact Tables are filled.

Please guide me as i am learning

Thanks,

pmksasbi

Posts : 1
Join date : 2013-06-30

View user profile

Back to top Go down

Re: Design Datawarehouse from Northwind Database

Post  sachij3u on Mon Jul 22, 2013 1:06 pm

Here could be few starting points:
1) Collect the reporting requirements and what is the expectation from business users w.r.t Nothwest data mart in say coming 2-4 years timeframe.
2) Convert the reportign requirements into Fact Qualifier Matrix (FQM) which would act as a blue print for designing the Data mart\
3) Design the Data mart from FQM (Start with logical Data model)
4) LDM for data mart could be an interative exercise, So start talking on business on how they are going to see this data mart once implemented. Take feedback and make modification
5) Once your LDM is baselined, start with report design and ETL development.
avatar
sachij3u

Posts : 19
Join date : 2013-07-11
Age : 36
Location : Herndon, VA

View user profile

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