mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

Month: August 2011

Pivot table comparison: Excel v. Google v. Web-based

EducationPivot 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.

A dirty little secret about screen-scraping

Save MoneySuppose you’re buying a new computer. You find a great-looking computer at a local store, bring it home, boot it up, and…it’s extremely slow. You open up the case only to discover that all of the internal parts are at least 10 years old. You storm back to the store demanding your money back because they sold you an old computer. Their response: “Of course it’s new, look at the new, beautiful case we put it in.”

Of course, that’s a ridiculous story. No self-respecting computer store would sell you a “new” computer that’s actually old on the inside. Why then, do some companies try to sell “modernization services” which do little more than put a flashy new case on old parts?

Why users don’t use Business Intelligence

ProductivityOne of the biggest problems facing companies using business intelligence software is this: Most users don’t use it. This problem has been discussed in great detail, with the general consensus being that users typically don’t use BI software because it’s too difficult. Makes sense, right?

While I believe that problem does play a role in adoption rates, I recently read an old Gartner BI study that touches on another possible reason. Many BI tools require that the user stop operating in their traditional workspace and move to another environment to view information.