Geek Answers Handbook

MS Access + OLAP

I have a lot of data in MS Access, and I need tools for analysis. Can you offer any data mining and analysis (OLAP) tools?

+4
source share
6 answers

In your data volumes, the complexity of the relationship you want to explore depends on:

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

(2) Connections with large volumes and with a high degree of complexity - consider calibrating on an SQL server and use older data cubes (OLAP), stored procedures, etc.

+2
source

Access support (and other non-SQL Server data sources) will be included in the upcoming release of SQL Server 2008 R2 (this release focuses on self-service BI). You can follow the progress of the project at http://blogs.msdn.com/gemini .

+2
source

I believe that it is best to import your data into SQL Server using SQL Server Integration Services - should be pretty simple and painless.

In SQL Server, you have Analysis Services that provides you with all of these features for OLAP analysis.

I do not think that directly for MS Access is wrong.

Mark

+1
source

If there is not too much data, import it into Excel and use the private table function.

If there is too much for this, then SQL Server is the way to go.

+1
source

A possible solution would be Excel 2010 using the new Power Pivot Add-on. It really depends on the type of analysis.

Federico

+1
source

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

0
source

More articles:


All Articles