all groups > sql server data warehouse > september 2003 >
You're in the

sql server data warehouse

group:

urgent: guidelines to do warehousing for MIS



urgent: guidelines to do warehousing for MIS jasmine
9/17/2003 1:33:42 AM
sql server data warehouse: hi there,

I am doing a college project on MIS(reporting system) with
datawarehouse concept for a retail shop . i am using
visual basic and sql server 2000. I use about 3 years
data and already input them in access and i had
sucessfully transform the data into sql server using DTS.I
am lost now and do not know what to do now. How to
transform it to star schema and after that it is consider
as a datawarehouse? how to design a simple datawarehouse
or data mart? what is my next step i should take. how to
retrieve any data from data warehousing to show in visual
basic as report? i saw an example in a book using forest &
tree to view the record but i cannot find the program. Do
u all have any idea how to get the program.Can i use
crystal report instead?

Re: urgent: guidelines to do warehousing for MIS Ray Higdon
9/17/2003 5:53:02 AM
Try this page to get started

http://intelligententerprise.com/ports/search_dw_fund.shtml


--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view]

AddThis Social Bookmark Button