Hello
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)?
+1
A:
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.
heferav
2009-10-18 10:54:57
It's not "upgrading" to SQL Server, but "upsizing."
David-W-Fenton
2009-10-19 00:37:21
David - upgrade changed to upsize
heferav
2009-10-19 07:11:49
Midle complexity. I have to calculate several numbers, and after that analyse accoding dozen criterias. It is really easy to calculate those numbers in the Access, but analysis according criterias it is pain.
apribojimas
2009-10-22 08:40:16
Please edit your question to include a few of the analysis criteria and explain why you are finding it "a pain" to do in ms-access
heferav
2009-10-22 10:17:04
'Upsizing' is just a marketing term. 'Upgrading' seems correct to me because SQL Server is a more capable SQL product.
onedaywhen
2009-10-22 10:36:43
+1
A:
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
marc_s
2009-10-18 10:56:09
+2
A:
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.
Ron Pihlgren
2009-10-18 18:21:23
+1
A:
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.
Shiraz Bhaiji
2009-10-18 18:33:14
More then 700,000 records. It is not for excel :(. I don't have licenses for SQL Server, so looking for other solutions
apribojimas
2009-10-22 08:41:59
Shiraz Bhaiji
2009-10-22 14:15:11