Business Intelligence on ROLAP

Hi all,

I am inquiring whether I can have some business Intelligence on Relational DBMS in SQL 2005 as projecting the number of patients within a health care basing on the available data.

Please help me out.

Regards,

Ronnie

Hi:

I think what are really looking at is using Data Mining in SQL 2005 - to do predictive analysis. There are several algorithms that would allow you to do this including Microsoft Time Series.

Thanks.

Suranjan

|||

Can I enable data mining on SQL SERVER 2005 database.

Please you can post me some information on this?

Thanx

Ronald

|||

Hi Ronald:

The Data Mining functionality comes as part of the SQL 2005 bundle (specifically in Analysis Services) and you need to create Mining Models using the BI Dev Studio.

You can start with Books Online. There are books in the market as well on the subject.

It would be good to get a clearer overall picture of what you are trying - size, scope, location etc - and then I could help you out further.

Thanks.

Suranjan

|||

I have one mining structure using Microsoft Decision Tress that I have created basing on the tutorial of Adventure Works DW.

How can be able to incorporate this mining structure with ASP.NET 2.0 so as my project can be intelligenct or so that my GUI that users use there are to project or get meaningful information through the data in the database basing on my mining model.

Thanx

|||

Moving to Data Mining forum.

|||

Please help me out. What does Moving to data Mining Forum mean? I thought that this is were I am.

Ronald