MS Access + OLAP

I have lot of data in MS Access, and for开发者_运维技巧 analysis I need tools. Might you suggest any tools for data mining and analysis (OLAP)?

Support for Access (and other various non-SQL Server data sources) will be included in the upcoming SQL Server 2008 R2 release (this release is focusing on self-service BI). You can follow how the project is progressing at http://blogs.msdn.com/gemini.

It depends on your data volumes the the complexity of the relationships that you want to investigate:

(1) Moderate volumes with low complexity relationships - use queries, pivot's graphs and reports in ms-access.

(2) High volume and or high complexity relationships - consider up sizing to SQL server and using the more grown-up data cubes (OLAP), stored procedures etc.

A possible solution can be Excel 2010 using the new Power Pivot Add-on. It really depend on the type of analisys needed.

Federico

I guess your best bet would be to import your data into SQL Server using SQL Server Integration Services - should be pretty straightforward and painless.

Once in SQL Server, you have the Analysis Services at your disposal which give you all these capabilities for OLAP analysis.

I don't think there's much for MS Access directly.

Marc

If it is not too much data, import it into Excel and use the privot table functionality.

If it is too much for that then SQL Server is the way to go.

An alternative OLAP solution is to use icCube to connect directly to your MS Access file.