{"id":9092,"date":"2015-05-05T10:30:16","date_gmt":"2015-05-05T15:30:16","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=9092"},"modified":"2023-03-13T16:06:38","modified_gmt":"2023-03-13T21:06:38","slug":"the-bi-roadmap-part-iii-how-to-choose-bi-software","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2015\/05\/the-bi-roadmap-part-iii-how-to-choose-bi-software\/","title":{"rendered":"The BI Roadmap (Part III): How to choose BI software"},"content":{"rendered":"

\"Education\"Summary: Despite the growing need for analytics, most BI projects still fail. Why? In the first two parts of our BI Roadmap Series, we learned a few reasons why BI projects fail, and a few steps you can take to limit your risk. In this article, you’ll take the next step–exploring the key features and capabilities you need in BI software. <\/em>
\n<\/span>
\n<\/a><\/p>\n

\"photo
photo credit: PublicDomainPictures<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

In the first part of our BI roadmap<\/span><\/a>, we started with the important questions. These are questions you must ask before looking for a BI solution. If ignored, your BI project will likely fail.<\/p>\n

In the second part of our BI roadmap<\/span><\/a>, we explored a few steps that you can\u2019t ignore. Those who rush through these initial steps place their entire project at risk.<\/p>\n

Today, let\u2019s explore the next phase: Choosing BI software. Now, bear in mind that the first two parts are critical. If you ignore the initial questions and steps, even the best BI software won\u2019t save your project.<\/p>\n

Assuming you\u2019ve addressed the issues outlined in the first two parts, let\u2019s move into the software. What should you look for? How can you avoid software that either doesn\u2019t fit your needs, or lacks essential features?<\/p>\n

Today, we\u2019ll answer those questions. But first, let\u2019s examine two steps you should take to prepare for BI software:<\/p>\n

1. Understand your capabilities<\/b>
\nEvery business is different. Your team and capabilities may vary greatly from similar companies in your industry.<\/p>\n

This is where many companies make a mistake. They find the popular BI tool of the day, and assume it\u2019s right for their company. Sure, maybe one BI tool works for the business down the street, but that doesn\u2019t mean it fits your company\u2019s unique strengths and needs.<\/p>\n

\u201cBe sure you know what your capabilities are both in terms of staff expertise and infrastructure,\u201d says Douglas Briggs<\/span><\/a>, Director, Business Intelligence at Washington University in St. Louis. \u201cUltimately your staff will have to live with the technology choices and business process changes that your BI solution entails, so make sure that you build what your staff can sustain and develop into an increasingly effective and mature component of your IT portfolio.\u201d<\/p><\/blockquote>\n

2. Talk to others<\/b>
\nWhile every business does have different needs, you can still learn from the experiences of others. Other companies have gone through the BI software selection process. Seek out unbiased opinions from them.<\/p>\n

What if you don\u2019t have contacts with BI experience? Check out forums, social networks, and LinkedIn Groups. You\u2019ll find a wealth of information from real companies using BI software.<\/p>\n

\u201cMost companies (especially those with young or growing BI practices) should seek out their colleagues at other companies and ask about the real truth beyond the vendor hype,\u201d explains Briggs. \u201cAsk for wins they achieved and pain they suffered through. Everyone will have a different set of pros and cons for their particular vendor and package choices. Determine whether they apply to you, and if so, how you can mitigate them or how to approach vendors with your specific concerns in mind.\u201d<\/p><\/blockquote>\n

While these steps may seem basic, they better prepare your business for a successful BI implementation. Now, let\u2019s move on to the next part: software.<\/p>\n

What to look for in the software?<\/h3>\n

So, what should you look for in BI software? Every BI product will provide some basic features, like simple reports, dashboards, and visualizations. Most will even provide mobile features these days. Besides the standard features, what should you look for in Business Intelligence software? Here are a few questions to ask about any BI software:<\/p>\n

1. How does data get into the system?<\/h3>\n
\"photo
photo credit: PublicDomainPictures<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

In most businesses, data comes from multiple systems and applications. How will you consistently collect and transform all of that data into a usable format for the BI software?<\/p>\n

Some BI software comes with Extend, Transform, and Load (ETL) tools built in. These ETL tools let you extract data from multiple source systems, transform it into a single format, and load that data into a target database.<\/p>\n

Now, this isn\u2019t always a standard feature. Some BI tools offer it as a costly add-on, while others don\u2019t offer the feature–meaning you\u2019ll need to integrate multiple tools.<\/p>\n

\u201cThe advice I would give to businesses looking for BI software is not to focus solely on the front-end \/ GUI,\u201d says Adam Bowers, Marketing Communications Manager at Urjanet<\/span><\/a>. \u201cBusinesses also need a plan for how they will gather and input data into the BI software. Without good data coming into the system, the tool becomes useless. Businesses should make sure they either have the internal resources to collect and input the data, or can find a good external partner who will automate the data collection and delivery process into their BI software.\u201d<\/p><\/blockquote>\n

2. How does data get out of the system?<\/h3>\n

On the opposite end of the spectrum, how can you get raw data out of the system? While the BI software should provide the analytical tools you need, you still need the flexibility to move data into spreadsheets (or other formats) if need be.<\/p>\n

\u201cCan the solution export all data for further analysis (using APIs or as .csv files)?\u201d says Heinrich Hartmann, Chief Data Scientist at Circonus<\/span><\/a>. \u201cThe UI will never be perfect for every situation. Sometimes you have to dig deeper and then you need the raw data.\u201d<\/p><\/blockquote>\n

3. Does it allow for self-service BI?<\/h3>\n

In the past, the IT department controlled reporting and BI capabilities within the organization. These days, that\u2019s changing. We\u2019re seeing the rise of self-service solutions that let end users create their own BI and reporting applications. This is the direction Business Intelligence is heading today, and is an essential aspect of modern BI software.<\/p>\n

\u201cThe biggest piece of advice I can offer is to consider newer self-service BI solutions from smaller firms,\u201d says Drew Settles, Product Analyst at TechnologyAdvice.com<\/span><\/a>. \u201cThe larger, traditional enterprise vendors, while “safe”, are usually far more powerful and expensive tools than are needed by most businesses. With these newer tools, while usually requiring at least *some *input and custom development to integrate into your existing IT infrastructure, once the connectors have been built, individual users can handle their own reporting and analysis, saving considerable time and resources when compared to traditional BI. The democratization of IT is leading to the democratization of BI, and as a result, everyone can make decisions based on data analysis, and create a data-driven company culture.\u201d<\/p><\/blockquote>\n

4. Is it really \u201ceasy to use\u201d?<\/h3>\n

Ease-of-use is a term that\u2019s lost most of its meaning due to overuse. Most vendors claim \u201cease-of-use\u201d, but is that really true? No.<\/p>\n

Here are a few areas to examine: Does the software require any coding? Does it require that you learn a proprietary language? How quickly can you get up and running? How quickly can you generate BI applications once you\u2019re up and running?<\/p>\n

Why is this so important? With the rise of SaaS solutions, end users have options. If the BI software confuses end users, they won\u2019t use it. They\u2019ll revert back to Excel, or any number of readily available SaaS options.<\/p>\n

\u201cConsumer applications have reinvented simplicity,\u201d says Edwin Miller, CEO of 9Lenses<\/span><\/a>. \u201cToday\u2019s workers expect the same from their business systems. Lucky for us, software providers have been forced to adjust and have created business applications with the ease-of-use employees expect. When considering business intelligence software simplicity is the key because complex apps simply don\u2019t get used. And your business intelligence system is practically useless if users don\u2019t adopt it.\u201d<\/p><\/blockquote>\n

5. Does it include Operational Reporting?<\/h3>\n

Operational reporting is designed to support the detailed day-to-day activities of the organization. Often scheduled to run nightly and delivered via email, operational reports give business leaders the details they need to run the business.<\/p>\n

The problem: Not every BI solution offers operational reporting capabilities as an out-of-the-box feature. This forces you to purchase and integrate multiple tools, or purchase additional modules\u2014raising the total cost of ownership of your solution.<\/p>\n

\u201cKey areas to focus attention on are “standard” operational reporting and “ad-hoc” reporting,\u201d explains Briggs. \u201cMost users will expect to be able to select fields\/data elements they need for a report and click a button that gets the data they need.\u201d<\/p><\/blockquote>\n

6. Does it include Online Analytical Processing (OLAP) or “slice-and-dice” reporting?<\/h3>\n

\u201cUsers are familiar with Excel pivot tables and will expect to explore data in this format,\u201d explains Briggs. \u201cIt’s critical to be able to dive into the data and investigate relationships by navigating its “dimensions”.\u201d<\/p><\/blockquote>\n

Why is this so important? First, as Briggs mentions above, it delivers data in a familiar format. Pivot tables are widely used. This lets users analyze their data using methods they already understand–a key element in driving BI user adoption.<\/p>\n

Second, it simplifies reporting. Rather than creating multiple reports for different views of your data, a pivot table lets users examine nearly any data aspect from a single application.<\/p>\n

7. What user\/data security features are included?<\/h3>\n
\"photo
photo credit: archer10 (Dennis)<\/a> via photopin<\/a> cc<\/a><\/figcaption><\/figure>\n

This is where you\u2019ll find disparity between products. A BI software\u2019s security features dictate the level of control you have over data and user access. While some features come standard, you\u2019ll be surprised to see how many lack certain security elements.<\/p>\n

For instance, most will give you application-level and multi-tenant security. These features let you control applications and the data displayed within each application on a per-user (or user role) basis.<\/p>\n

But, other features like single sign-on, flexible authentication options, user privilege parameters, and user-specific data sources might not exist in every software. Examine the security aspects carefully, and choose which areas are most important to you.<\/p>\n

\u201cDon’t overlook security,\u201d says Tyler Wassell, Software Development Manager at mrc<\/span><\/a>. \u201cThat\u2019s my advice for businesses looking at BI software. Data and user security features are often overlooked, but I\u2019d argue that they are one of the most important aspects. I\u2019ve seen companies abandon their BI implementations once they realized it lacked a specific security feature.\u201d<\/p><\/blockquote>\n

8. What is the TCO?<\/h3>\n

With BI software, the initial purchase price is often deceptively low, while the Total Cost of Ownership (TCO) can be surprisingly high.<\/p>\n

Look beyond the initial purchase price. What are the costs for implementation, training, and maintenance?<\/p>\n

How do they handle license fees? Some charge per seat. Others charge per database license and provide unlimited user seats.<\/p>\n

What\u2019s the upgrade policy? Will the software become outdated in a few years? Will you have to purchase the next version when it comes out, or is that part of the maintenance plan? Is the software regularly enhanced, or does it slowly fall out of date?<\/p>\n

Also, does the licensing include both external and internal reporting? For instance, what happens if you want to make reports available to your customers via a portal? While these features are included in some packages, others don\u2019t allow this without an additional license or module. Still others will charge you a distribution fee.<\/p>\n

As you can see, pricing isn\u2019t usually cut-and-dried. Look beyond any \u201cper-seat\u201d pricing, and into the actual, long-term cost.<\/p>\n

9. How portable is the software\/applications?<\/h3>\n

Most analysts and researchers agree on one point: Cloud computing is the future. BI on the cloud promises near 100% uptime and scalability while avoiding the effort\/expense of in-house hardware.<\/p>\n

Before you purchase BI software, understand two important points:<\/p>\n