Choosing a BI and Analytics Tool: 8 Steps from Requirements to Evaluation
Some tips for when your team is looking at the best way to analyze data.
Join the DZone community and get the full member experience.Join For Free
for a long time, business intelligence (bi) was the specialized domain belonging to your company’s statistics expert. however, in the last few years, we’ve seen an exponential growth in bi tools for the enterprise, meaning that in theory, anyone can gain real-time, actionable insights. whether you’re a sales person, a cio or a cattle farmer , the use of real-time data is changing how all kinds of industries work.
there’s been a lot of hype around bi and there are now a bewildering number of bi tools on the market. choosing the right one will mean your colleagues can become more productive, work smarter and avoid waste. choosing the wrong one will mean your colleagues are more confused than ever, which could result in them failing to adopt the tool and losing you time and money. so, how do you choose the right bi tool for your company?
it’s all about strategy
coming to a decision about which is the right tool for you will be much easier if you develop a strategy to narrow down the list of options and discover the best solution for you.
1. be clear about your requirements
when you invest in any new enterprise productivity software, it’s essential to have a clear idea of your requirements. this involves a series of sub-steps:
a. build a list of needs
your ‘needs’ list should be fairly short and specific and outline your most pressing requirements. perhaps you need something that’s mobile ready? something that can be embedded in your external website? or something that can draw in data from x,y or z data source?
b. build a list of wants
the ‘wants’ list can be as long as you like. perhaps you want a tool that can be white-labelled to fit your corporate brand, for instance. perhaps you’d like the graphs and charts to be interactive.
c. work out your budget
this of course depends on the number of users per month. you need to have a good understanding of who in your organization will be using the bi tool and how many licenses you’ll need.
d. work out who in your business will be using the tool
this will tell you the context in which they’re going to need it. some companies will want a desktop bi tool, others need something that’s mobile and cloud based. at this stage, you need to speak to end users and find out their most pressing wants and needs from bi in their day-to-day work.
e. work out what you plan to use the tool for
do your sales people need bi on the road? will store employees be helping customers interact with data on-screen? having a clear idea of use cases will narrow down which kinds of tools are appropriate. bear in mind that sometimes more ‘limited’ but less expensive tools will do everything you need – you don’t need the complexity of photoshop if your users can get their work done in ms paint (and vice versa). the same goes for bi.
2. narrow down your options
armed with your requirements list, you should now be able to cut down a lot of bi tools out there. some won’t correspond with your needs; some will be over budget; a lot will meet your basic needs but none of your wants; some will be purely desktop focused, only configured with a limited number of data sources not relevant to you. narrow down your list to four or five contenders and then begin a deeper comparison.
3. how to choose from your finalists?
once you have your top contenders, now is the time to really begin comparing their strengths and weaknesses. so which kinds of things should you look out for?
- are they ‘future focused’? you might have found a great provider. however, if it’s not clear what their plan is going forward, that should raise an eyebrow. a roadmap or a clear indication of where the company are planning to take their platform should be what you’re looking for. do they currently only provide a desktop tool? will this be expanded to include mobile any time soon? are they planning to increase connections with more data sources in the near future?
- do they have a large user base? simply put, the wider the user base, the more likely you’ll find support and advice online.
- is documentation, support and guidance available and up to date? are there forums where you can ask questions from an active community?
4. evaluate features
go back to your list of needs and wants. how does the product feature list compare with your needs and wants? what’s missing and what additional benefits does it offer?
5. try a free download
most providers will offer some kind of free download where you can test the product, explore how it works and see if it’s the right tool for you. this should help concretize your final decision.
Published at DZone with permission of Josh Anderson, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.