rollercoaster43 (8/8/2014)
Hi All,We have a very busy OLTP setup here.You can consider this as an Enterprise which has being doing Business across the globe for various clients.
Now, with respect to forecasting and taking Business decisions, we currently DO NOT HAVE A Datawarehouse.
We are planning to set up a warehouse for all the data which can be used for various reporting and forecasting purpose using SSIS/SSAS/SSRS
Can someone please send across some links or other materials that could be help to design the warehouse and go ahead with the other operations?
Any help in this regards would be greatly appreciated!!
Thanks a lot!!
We have a very busy OLTP setup here
...what is your definition of busy?
details of volume of data you wish to analyse may help
Now, with respect to forecasting and taking Business decisions, we currently DO NOT HAVE A Datawarehouse.
.....why do you think you need a datawarehouse...what benefits do you expect to see ?
which can be used for various reporting and forecasting purpose
...are these predefined are you just fishing for ideas?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day