Lightweight data exploration in Excel

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
As I found on Digg this morning:

We often are given a chunk of data in Excel that we need to explore. Of course, the first tool you should pull out of your toolbox in cases like this is the trusty PivotTable (it slices, it dices!). But at times we have to dig a little deeper into the toolbox and pull out the in-cell bar chart.

The write-up (and screenshots) are here:
http://juiceanalytics.com/weblog/?p=236
 
Richard, a couple more thoughts on Filemaker:

It's quite a different interface, so databases produced in FM have a very different look and feel.

The learning curve isn't as steep to get going.

You can create PDF attachments from any report and email them straight out of FileMaker. No hassles with Outlook getting narky.

I haven't had the chance to give it a go, but the reported file capacity in version 8 and higher is about 4 terabytes. Compare that to 2 gigabytes for Access, and that's a pretty serious difference.

As for connectivity, FM uses ODBC and JDBC, but not ADO, which is MS-only. In a Microsoft environment I found that to be a bit of a disadvantage.

Some things that Access does out of the box -- events, exporting data to files whose name you change on the fly -- don't ship natively in FM, but you can get them as plug-ins and they work very well.

If you're looking to Web-enable a database, I reckon FM is better. You can do it natively using a special version of FM Server, and a very high proportion of your page layout and scripting translates directly to the browser. Again, later versions are better.

If you are hosting a workgroup database and don't want or need to go all the way to the big guys, FM Server lets you simultaneously handle 255 connections. Access doesn't do that -- at least not that I've seen. It also works over Citrix.

Can't think of anything else at the moment, but that might be food for thought.

Denis
 
Upvote 0

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,225,322
Messages
6,184,275
Members
453,225
Latest member
adelphiaUK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top