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 reporting

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

Five essential elements every Business Intelligence solution should include

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

Critical questions to ask before buying a report writer

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