mrc's Cup of Joe Blog

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

6 common misconceptions of self-service BI

EducationSummary: Despite it’s growing popularity, many myths still surround self-service BI. These myths can lead to implementations that aren’t as successful as they could be, or flat-out fail. Learn about the common myths/misconceptions that businesses have about self-service BI, and why they’re false.


photo credit: Negativespace via pixabay cc
photo credit: Negativespace via pixabay cc

Self-service Business Intelligence (BI) is one of the fastest growing trends in the business world. Industry analysts like Forrester and Gartner agree: Self-service BI is exploding, and shows no signs of slowing down.

Why the rapid growth? Self-service BI offers businesses a tempting benefit: It promises to give business users direct access to data and reporting capabilities. It promises to remove the reporting burden from the IT department, and bring data access directly to the decision makers.

Who doesn’t want that?

But, there’s a problem: Self-service BI efforts often go wrong. The business enters the project with high expectations, only to face disappointment.

Why? Many businesses don’t have a realistic view of self-service BI. They believe some common myths that still surround the topic. These myths can lead to implementations that don’t meet expectations, or flat-out fail.

Today, let’s dispel these myths. Here are a few of the most common misconceptions surrounding self-service BI:

1. If we build it, they will come

photo credit: fancycrave1 via pixabay cc
photo credit: fancycrave1 via pixabay cc

In a perfect world, end users will flock to the self-service BI tool and immediately begin running their own queries and generating reports. Unfortunately, we don’t live in a perfect world.

If you give your users a self-service BI tool, will all of them dive into their data and pull out meaningful insights? No. Let’s take a look at two key problems that get in the way of this goal.

First, few users actually understand the data. As explained below, users cannot gain insight unless they understand how the data was collected, how it’s integrated, and what the various data elements mean.

“One of the most dangerous myths about self-service BI is the “Field of Dreams” approach to analytics (i.e., “build it and they will come!”),” says Douglas Briggs, Director, Business Intelligence at Washington University in St. Louis. “It’s deeply tempting to hope that simply by making data available and training business users on reporting tools, they will then dive into the ocean of data and emerge with valuable insights that lead to meaningful improvements in processes and products. While business users *can* do this, it’s only possible when they understand how the data has been made available to them: how it was collected, how it’s been integrated with other data, and what the various data elements mean (beyond merely their labels — what sources they originate from and how they’ve been transformed before they arrive in the analytics environment). This keeps user from combining data in ways that it wasn’t meant to be, leading to conclusions that are nonsensical or (worse yet) reasonable-seeming and yet erroneous! Organizations that deploy self-service BI effectively often make an expert in the data available so that business users can validate their analyses and insights and develop over time their own savvy with the data they need to create real insights.”

The second reason: Not every user wants to create their own queries and dive into their data. Some users want their reports, and little else. Ideally, they want their reports created by someone else. They’re just not interested in exploring the data.

Does this mean that self-service BI is a waste? Not at all. Many users will jump at this opportunity. They want to explore their data. They want to run queries. They will become the report creators. Just understand that not every user cares about data exploration.

2. Self-service BI eliminates the need for IT

The goal of self-service BI: Put data in the user’s hands and reduce the burden on the IT department. But, many make the assumption that it shifts 100% of the BI process to the users.

Is that accurate? Not at all. In reality, you’ll still need the IT department for some tasks.

For instance, self-service BI will only produce great results if you have clean, well-modeled data. Is that a job for end users? No! You still need your BI team or IT department to set up the data.

Also, not every report or query will be straightforward. Sure, self-service BI will eliminate a large portion of the reporting requests. But, you’ll still need the IT department for the more complex applications.

“Self-service BI does remove much of the reporting burden from the IT department,” says Rick Hurckes, Services Director at mrc. “But, it doesn’t eliminate IT from the equation–and that’s a good thing. The IT department must control the data and the user access. They’re responsible for keeping the data clean, and ensuring that users can only access data they’re authorized to see. The self-service BI tool only acts as a doorway for users to access the IT-controlled data.”

3. A good self-service BI tool will lead to a successful project

photo credit: geralt via pixabay cc
photo credit: geralt via pixabay cc

This is a big misconception that we see over and over again. Many organizations assume that they’ll find a BI tool that will fix all of their data and reporting problems. When the project fails, they blame it on a bad tool.

In fact, many even buy multiple tools when they discover that the first one didn’t fix their problems. After a while, they’re stuck with multiple tools–none of which helped them.

Why not? BI failures rarely stem from the tool itself.

In reality, BI success depends more on the data quality, data control, and business processes than anything else. Those are the foundational elements. It’s like building a house. If you build a house on top of a weak foundation, the quality of the house itself doesn’t matter. The weak foundation will eventually destroy the house.

Business Intelligence is the same way. If you struggle with your foundational elements, no BI tool will be successful. A great tool applied to bad data/processes will not succeed.

4. The tool should be “plug and play”

Some organizations assume a BI tool should “just work” out of the box. They treat it like a simple piece of software–just install it and go. In reality, this is nowhere near accurate. Self-service BI requires a great deal of planning and preparation before it’s ever deployed.

photo credit: geralt via pixabay cc
photo credit: geralt via pixabay cc

“The biggest misconception I see is companies assuming BI platforms being plug-and-play,” says Ryan O’Donnell, Director of Marketing at Avalara TrustFile. “Assuming integration will be quick and easy is a flawed approach. Companies need to dig in and read the docs to understand how to set up their BI platforms correctly from the start. Failure to do so results in wasted time as engineers have to go back in and make changes / updates after release.”

The big problem with the plug-and-play myth: It ignores the importance of clean data. Data that hasn’t been scrubbed, or even set up properly, will destroy a BI project. Users won’t be able to create the reports they need, or (even worse) will create inaccurate reports.

In my experience, the most successful self-service BI projects aren’t accidents. They’re the result of proper planning and data organization before the tool is ever deployed.

5. Users will understand how to use it

The rise of mobile apps has created unrealistic expectations with business software. Some users expect they can just pick up a tool and start using it. They expect that all software should be self-explanatory.

“Every individual within an organization may not be at the same competency level to first understand the platform, and second to go about creating a compelling data story or answer critical business questions about revenue, gaps, performance, product offerings, deals and more,” explains Anees Merchant, Senior Vice President – Digital, for Blueocean Market Intelligence. “To be successful, business stakeholders need to be coached throughout the development plan and adoption process.”

In reality, a good self-service BI tool isn’t something your users can just pick up and start using. While many expect them to provide “app-like” simplicity, self-service BI is infinitely more complex than most mobile apps, and provides far more capabilities. It requires proper training–both in the tool, and the business data.

6. All self-service BI tools are essentially the same

This may seem obvious, but I’ve actually heard this one a few times from different IT leaders. They believe that any self-service BI tool they purchase will provide the same features.

In a way, they’re half right. Yes, all BI tools will let you create basic reports and dashboards. But, after you get past the basics, you’ll find some significant differences.

For instance…

Does it offer mobile capabilities?

How well does it integrate with your current systems?

Does it let users upload spreadsheets, and export to Excel?

What security features does it offer?

Many of these “extra” features get ignored, but can make or break a project. I know of a company who had to cancel a big BI project because the tool they were using didn’t offer multi-tenant security. They went into the project assuming it was included, and discovered that fact halfway through.

The truth is, self-service BI tools will provide similar reporting options. But after that, they differ greatly.

Summary

While this list could certainly go on, the points listed above are some of the common myths surrounding self-service BI. What do you think? Would you add anything to the list? If so, please feel free to share in the comments.