Pivot tables are great tools for spotting hidden details and trends in a sea of data. One pivot table lets you quickly examine nearly any aspect of your data. Also, unlike static reports, the user determines what parts of the data to analyze.
The big question with pivot tables is this: Which pivot table option is best for my company? Right now, there are three main pivot table options: Google Docs, MS Excel, and database-driven web pivot tables. How do they compare? We’ve put together a handy one-page guide which explains the differences between each pivot table option. I hope you find it useful.
One aspect of Excel that wasn’t pointed out is that a MS Excel picot table doesn not “Have” to access data in a Excel spreadsheet. A MS Excel Pivot table can be built using a ODBC, SQLNET or other database connectivity interface to a Access, MySQL, Oracle or SQL Server database server that has millions of rows.. In this scenario, Excel is acting as a pivot table client to a database server..
Thxtnx for the analisys! Its simple one, but good for users like me. I’d prefer web pivot tables, do you know some to try?