mrc's Cup of Joe Blog

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

Web Pivot Tables

5 canned reports that take the reporting burden off of IT

analyticsIf end-user reporting is a burden on your IT department, you’re certainly not alone. The question is…how can you reduce the amount of time your IT department spends creating end-user reports?

One way to fix the problem: Create canned reports with run-time options for end users. This lets your users quickly access the data they need, while reducing the time your IT department spends creating reports.

Here’s how it works: Your IT department creates the initial reports with run-time filters for the users. The users can select which data to display, or filter their data however they wish when they run the report. With the right run-time filters, users can use a single report in many different ways.

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.

Pivot tables in Google Docs: How do they compare?

EducationA couple of weeks ago, Google announced some big news: Google Docs now has pivot tables! I know what you’re thinking: How is this different than other pivot table options, such as those found in Excel? Are they right for business? I’d like to help you answer these questions.

First, how does this differ from other pivot table options? Before we answer that question, we must first answer this question: What are the other options? Before Google pivot tables came around, there were 2 main approaches to pivot tables: Excel pivot tables and database-driven web pivot tables (like those created with m-Power). With Google’s foray into pivot tables, we now have 3 legitimate pivot table options. So, which one is best for your business? The best way to answer that question is to take a look at how each option compares in 5 key areas: …

Create business reports in under 5 minutes

Save TimeSome people request them from the IT department. Others lock themselves in their offices for a day or two and go crazy with spreadsheets. Others delegate the task. Whatever the method, everyone has a process for creating business reports.

But, what if your process wastes time? What if the hours you spend running reports or analyzing data are unnecessary?

Here’s a good test: Does it take longer than 5 minutes? If so, you’re wasting time. Within a matter of seconds, you should be able to see any piece of data you wish to see. For example, applications like this interactive report or this web pivot table report give you a high level view of data, but let you “slice-and-dice” it however you want. …

Building and using Pivot Tables (explained via video)

EducationPivot tables are great analytical tools—they sum up large amounts of data and let you view it in just about any way possible. More importantly, they help you quickly analyze business information, discover trends, and make better and more informed decisions.

Pivot tables are typically found in spreadsheet software, such as Excel. Spreadsheet-based pivot tables are great as single-user tools, but you run into problems if you want to distribute, share, or let multiple users alter or view one spreadsheet. Also, if security or data accuracy are necessities, spreadsheet-based pivot tables aren’t ideal. …