mrc's Cup of Joe Blog

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

Author name: Joe Stangarone

Joe Stangarone is a 40+ year veteran of the IT industry and president of mrc—the software company behind the award winning development platform, m-Power. Joe shares his leadership and technology insights through the Cup of Joe Blog, focusing primarily on ways businesses can save time, money, and increase productivity using technology.

2 ways a portal will help business (and how to make one)

By / , ,

Save TimeA customer portal (or customer extranet) is a secure area of your website designed for your customers. They can log in and perform a number of different tasks, such as pay their bill, view their information, purchase new products, ask a question, etc… If your business has customers (and I hope that it does), you should really have a portal set up. Why? I could rattle off a number of reasons, but here are the two biggest ways a portal/extranet will help your business: …

2 ways a portal will help business (and how to make one)Read More »

4 reasons why software purchases fail

By /

Save MoneyHave you ever been in a “blame” meeting? It’s one of those meetings called when numbers are down or after a project or purchase failed miserably. As you might guess, there’s a lot of finger pointing and blame spreading. Not only are these meetings painful, they are completely unproductive. Since everyone is too busy deflecting blame, no one learns from their mistakes.

I’d like to help you avoid these meetings. Obviously, I can’t write a definitive guide on how to avoid failure, as every business and situation is different. However, I can help you avoid failure in one area that applies to most companies: Software purchases. In my experience, software purchases usually fail for one of four reasons. I’d like to explain those reasons and then tell you how to avoid them. …

4 reasons why software purchases failRead More »

What is business intelligence?

By / , , ,

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

What is business intelligence?Read More »

The key to business dashboard integration

By / , ,

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.

…

The key to business dashboard integrationRead More »

The risks of application modernization

By /

Education You probably know the benefits of application modernization – more capabilities, decreased maintenance cost, increased integration with web services, etc… All in all, most companies stand to gain more than they lose from modernization.

If that’s the case, why isn’t every company rushing to modernize? Well, as with any big undertaking, there are risks, and these risks hold many back. However, most of these risks come from a lack of experience…a fear of the unknown. I’d like to go over 3 of the most common modernization fears and then explain how to avoid them:
…

The risks of application modernizationRead More »

Building and using Pivot Tables (explained via video)

By / , , ,

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

Building and using Pivot Tables (explained via video)Read More »

How to build a secure extranet in one day

By / ,

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

How to build a secure extranet in one dayRead More »

How to reduce the risks of modernization

By /

EducationWe recently published a couple of educational white papers which aim to reduce risk for companies beginning modernization projects.

The white papers address a common problem: While many companies recognize the need for modernization, few completely understand their options, the hidden risks, and the steps involved. An uninformed company heading into a new modernization project stands to risk significant sums of time and money. …

How to reduce the risks of modernizationRead More »

Five essential elements every Business Intelligence solution should include

By / , , ,

EducationBusiness intelligence is a confusing subject. Generally speaking, when a company realizes they need business intelligence (BI), they aren’t clear on everything a BI solution should include. Why not? BI isn’t the same across the board. As a result, comparing BI solutions is like comparing apples and oranges. Each solution contains different elements.

So, how do you know which elements to look for in a BI solution? I think a few elements are pretty standard, like simple ad-hoc reporting, the ability to use multiple databases, and exporting data to Excel and PDF. Besides these basic elements, I’ve put together a brief list of 5 essential elements that every good BI solution should include: …

Five essential elements every Business Intelligence solution should includeRead More »

Critical questions to ask before buying a report writer

By / ,

EducationReport writers are pretty easy to understand, aren’t they? If your company stores data in a database (as most companies do), you need reports. To create all these fancy reports, you need a report writer.

However, beyond the basic features like exporting to Excel and creating pretty graphs, you’ll find that report writers vary in capabilities. While they may all address the same problem (your need for data), each one offers different features. Figuring out what’s best for your company can be difficult if you’re unfamiliar with essential report-writing capabilities. …

Critical questions to ask before buying a report writerRead More »