good day all,
I have scoured the net looking for some material on datawarehousing, OLAP, cubes. Can anyone out there help me out. Its really important.

Hi thanks a lot for your post, The major issue is that I am still a novice in the field of Datawarehousing, I currently work for a company that is in the process of implementing a datawarehouse,, currently I would say what we have at the moment is a datastore which is a far cry from what a standard datawarehouse is. I have scoured the net but i can only get vague material. Anything ranging from basic OLAP tutorials to advanced will be OK with me. I intend making a career from this field, as I have noticed a gap just yearning to be filled up.
Thank you.

Being able to get trends to enable better business descisions, also forcasting future trends are major reasons why any business will want to move to a datawarehouse. I do not think outsourcing will be an option in this case. i always thought getting a good tool will only be efficient and effective when you have an optimised datawarehouse. the current scenerio is one that will not allow for smart mining. Thanks for the earlier post. Too many data stores which have to be joined as when neccesary is required to produce inteligent reports.

Thanks for this posting, however, i know there is so much to know about OLAP.

By the way, does anybody the address and phone number of Expert Edge or anybody working for the coy?

Thanks,
nwoye

badguy:

good day all,
I have scoured the net looking for some material on datawarehousing, OLAP, cubes. Can anyone out there help me out. Its really important.

Creating a datawarehouse aware database is very easy . All you need to do is to create a Fact table which has a foreign key to all the tables you are trying to get data for. You can then add a time column to this table so that u can capture data based on time. If you are using oracle u can use a variety of analytical functions available to create cubes .

Hope this helps

nwoye:

Thanks for this posting, however, i know there is so much to know about OLAP.

By the way, does anybody the address and phone number of Expert Edge or anybody working for the coy?

Thanks,
nwoye

Expertedge is located at Ligali Ayorinde street Victoria Island very close to Mobil Producing Nigeria. It is the last house on the street very close to the beach

Sbucareer definitely said, I designed a system that receives roughly 14,400 entries per user per day (and they are forecasting a usage of around 300 users at the end of the year). These sort of databases require time and extensive maintenance - you want to avoid going from programmer/database designer to database maintainer (which is what is happening to me :s)

p.s. Sbu I'm still waiting on that e-mail with the docs from you oh and I'm now in London.

I'll send you an e-mail or perhaps call you.

Above given information is really helpful especially for newbies who wants to retrieve the multidimensional data from sql 2005.I would also recommend a book on OLAP and believe me its pretty informative.The book is available on Amazon & you can buy an e-book directly from the publisher by writing [email]OLAPWorldPress@gmail.com[/email].

We have appreciated the Warehousing services of star distribution system. This company is not only depending on common Warehousing facilities, carriers or transportations services, pool distribution, LTL also included with its services. Their warehouse is more than modern and well organized to others. They can assurance our products will get in and out without delay.
Miami Warehousing