Building Dataware house

  • Hello Everybody,

    I am having Sales SQL SERVER Database and now I want to build Data warehouse for this sales data.

    Can anybody please guide me how to do this or provide useful links ?

    Any help will be greatly appreciated....:-):-):-)

    Thanks in Advance...:-):-):-)

  • A recommended read is the Data Warehouse Toolkit from Ralph Kimball.

    Furthermore, you can take a look at http://www.sqlbi.com. They propose a methodology on how to implement your ETL/Data Warehouse with MS SQL Server.

    The first tool you need to familiarize yourself is MS SQL Server Integration Services, the ETL tool of Microsoft. This will populate your data warehouse.

    Good luck!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply