mrc's Cup of Joe Blog

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

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 »

6 reasons why IT projects fail

By / ,

Save MoneyA successful IT project is one that is delivered on time, at or under budget, and working as originally planned. According to the Standish group, only 32% of IT projects are considered successful. Believe it or not, that’s an improvement over years past.

Why are most IT projects unsuccessful? I found a nice article entitled “Why IT projects fail” which lists 6 of the most important reasons for failure. I couldn’t agree more with the first point: Lack of user involvement. If your project will be used at all by end users, they must be involved early on. After all, a new system or application that end users can’t (or don’t want to) use is a waste of money. …

6 reasons why IT projects failRead More »

Keys to a successful BI implementation

By / ,

Save MoneyBusiness intelligence (BI) can provide incredible advantages when implemented correctly, such as agility, better decision-making, and even increased profitability. BI is not without risks, however.

How can you implement a BI solution with the greatest chance for success? Let’s take a look at our options. In the past, there were really only two: Build it yourself or buy a pre-packaged solution. …

Keys to a successful BI implementationRead More »

Where is the best place to outsource?

By / ,

Save MoneySomeone in one of my LinkedIn groups asked this question: “Where is the best place to outsource?” Now, he was from an outsourcing company and was only trying to raise awareness for his company, but the responses made me smile.

Most responses mirrored my advice: Avoid outsourcing if at all possible and keep it in house. I understand…many companies outsource because they feel it’s their only option. They can’t afford to keep the work in-house and outsourcing makes perfect financial sense on paper. …

Where is the best place to outsource?Read More »

How much does free really cost?

By / ,

Save MoneyThe web is changing perceptions about what should be free. Companies are giving away software for seemingly nothing. Some of it actually looks like good, quality software. But…is it really free? What does “free” actually cost? Answer: A lot more than you might think. Let me explain.

While “free” products may not cost money upfront, you typically end up paying in one of these three forms: …

How much does free really cost?Read More »

Keep your skills current and stay productive

By / ,

ProductivityAre you struggling to keep up with tech trends? Are you finding a declining demand for your aging skills? I understand the dilemma. How do you pick up a new skill or programming language and remain productive at the same time?

This story on ITJungle.com is inspiration for all those struggling to keep up with the ever-changing tech trends.

Basically, it showcases an RPG programmer with some ingenuity. He designs Java-based web app and recently created an iPhone application for his company. The best part: He doesn’t even know Java, yet is a very productive Java developer. Want to learn how? Check out the article for the whole story.