mrc's Cup of Joe Blog

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

Education

6 must-have features of good reporting software

EducationI believe we’re seeing a shift in IT responsibilities. As more and more computer-savvy employees enter the workforce, many of the traditional IT-specific tasks are being handled by the end user. For example, simple tasks like plugging in a monitor or keyboard are easily handled by most end users.

The same is true for business software. Certain task, which used to require highly technical software, can now be handled directly by the users (with the right software). For example, reporting used to be an IT task. The only reporting option for end users went through the IT department. Now, many of the enterprise reporting options are simple enough for end users. If an end user needs a report, they can either build their own, or access a pre-built web-based report that pulls data from the database in real-time.

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.

8 things to look for in a BI tool

EducationBy now, you probably understand the concept of business intelligence. It helps you keep a pulse on your business and make decisions based on factual data. It helps you spot trends (both negative and positive) and adjust your business plan accordingly.

But, the difficult question with BI is this: What should I look for? What makes a good BI solution? If you’ve ever looked for BI software, you quickly learned just how many options exist. How do you know which one is best for your company?

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: …

6 essential elements of a good reporting solution

EducationHave you ever purchased business software, only to realize later that it didn’t quite meet every requirement? Maybe you overlooked a requirement, or maybe you assumed certain capabilities were standard, but they weren’t.

If you’re looking around at reporting tools, I want to help you avoid that mistake. The first (and most important) piece of advice is this: Never assume. Don’t just assume that every tool is created equal, or has similar features. Some tools may look impressive, but completely leave out some “basic” features.

So, what do you look for in a reporting tool? Obviously, the requirements vary by company, but I believe that certain elements are essential in a good reporting tool. What are they? We’ve put together a handy list of 6 essential elements you should look for in any good reporting solution. I hope you find it useful!

What is business intelligence?

EducationJust the other day, someone asked me this question: “What is business intelligence?” It got me thinking…I frequently write about business intelligence (BI) and why it’s important, but I’ve never really defined the term. In this post, I’d like to take a step back and give you the what, why, who, where, when, and how of business intelligence. Sound good? Okay, let’s get started…

What is business intelligence?
Most companies collect and store data covering all areas of their business. This data sits in a database and is really pretty useless in this format. What do I mean by that? If you looked at data in a database, it wouldn’t make any sense and would most definitely overwhelm you. This is where business intelligence comes into play. Business intelligence is the process of taking that (overwhelming) data in your database and presenting it in an understandable, accessible, and useful fashion. …

The key to business dashboard integration

EducationI’ve recently noticed more and more companies asking this question: “Can you integrate this dashboard with Sharepoint?” While it seems like a basic question, it highlights an underlying trend. I’ve noticed a shift in the business dashboard landscape. Business dashboards are no longer good enough. The question is not, “Do you have a dashboard?” Now, the question is, “Where can you integrate/access your dashboard?”

What do I mean? I’ve noticed that more and more companies want dashboards that:

  • Integrate with other business software (like Sharepoint).
  • Are accessible from any web browser.
  • Are accessible from a smartphone.
  • Integrate with other web services.

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

How to build a secure extranet in one day

EducationAn extranet is an extremely useful resource for many companies. For those unfamiliar with the term, it is a computer network that allows controlled access from outside the company. For example, here are a few ways extranets are used:

1. Extranets can be set up for customers to log in and view important data.
2. Extranets can be set up for employees to log in outside the office. For example, your sales force could log in to the extranet and view their sales numbers.
3. Extranets can be set up for distributors to log in and view orders, purchase more products, and view new products. . …