Vijay SankaranDirector, Application Development| Ford Motor CompanyAnn Arbor, Mi, United States
Everyone is always looking for new and improved BI tools. Share your experiences on which tools you think are useful, which ones suck, and common problems you've had using tools... Saving Changes...
yes wood.As you said conventional RDBMSs are not reluctant to Dataw arehousing or Mining. But NCR's Teradata seems to be a good choice.Any idea? Saving Changes...
Michael WoodProject Manager / Business Analyst / Business Process Improvement Guru| Independent ContractorGig Harbor, Wa, United States
Teradata was designed with data mining in mind. I do not know of another product that is designed to handle tonnage like Teradata. Saving Changes...
Most tools have to rely on RDBMS storage. Some provide for increased performance through a variety of tricks. A product that stands-out as a kind of fully transparant database-plugin is HyperRoll (cfr www.hyperroll.com). It provides for dramatic improvements. The example of 151 hours is also one that looks like being potentially dramatically shortened without having to go through major maintenance-tuning type of work. Saving Changes...
I have used SQL Server with Analysis servers successfully for small and medium-sized warehouses. If you have dozens of GB you need to consider Oracle. I am not familiar with ProClarity but I was just introduced to dynaSight InSight (from arcplan) which can generate MDX queries. They are very strong with the Executive Dashboard concept in a browser, and the best graphs and geographical maps I've seen. I have seen low-end (low-cost) solutions using Excel pivot tables, but they can't deliver what Cognos, arcplan or MicroStrategy can deliver. -DL Saving Changes...
I have used SQL Server with Analysis servers successfully for small and medium-sized warehouses. If you have dozens of GB you need to consider Oracle. I am not familiar with ProClarity but I was just introduced to dynaSight InSight (from arcplan) which can generate MDX queries. They are very strong with the Executive Dashboard concept in a browser, and the best graphs and geographical maps I've seen. I have seen low-end (low-cost) solutions using Excel pivot tables, but they can't deliver what Cognos, arcplan or MicroStrategy can deliver. -DL Saving Changes...
