Related Topics: SYS-CON MEDIA


The 10-Point Checklist for Choosing the Right Analytics Tool

Choosing the Right Business Intelligence tool

Picking a business intelligence (BI) tool is hard. According to Scott Brinker and his Marketing technology Landscape there are over two hundred BI and data visualization solutions. This is a lot of choices to review before you can make a decision. In this overview, we are putting six tools through a 10-point checklist for choosing the BI solution: Tableau, Looker, Mode Analytics, Chartio, Qlikview and Power BI. The goal of the checklist is to establish a vetted consideration set.

The 10-Point Checklist For BI Tools

When it come to make a choice, for any decision you need to have consistent set of criteria. For BI tools this means using a set of objective benchmarks to narrow down the hundreds of options to a few that are worthy of a demo. This simple, easy to use 10 point checklist, can help frame your tools assessment endeavors:

1. Target Audience Is this BI tool built for engineers or business users? Will we be happy with using this every day? Make sure you are aligning your use cases to the intended users internally. If the tool is not something people will enjoy using, it is a certainty it won’t be used at all.

2. Features What is the tool great at? What areas of focus and emphasis do they have? How quickly can I be productive? What is my time-to-value? Also, what does the product roadmap look like? Does it mesh with my strategic vision for the work I need to get done? Does the tool include must-have features like supported data sources, filters, data visualizations, etc. that are easy to understand? For example, the BI analytics tool may stand out for its stunning visualizations like Tableau, its simple and easy-to-follow interface like Chartio, its great collaboration capabilities like Mode, or its data exploration capabilities like Looker. For features that are lacking, decide if you and your team can live without them. Ask yourself whether they nice to have or are critical to the mission.

3. Technology On the technology side, you should look at what databases the BI analytics tool supports. Can it connect to your cloud data warehouse like Amazon Redshift, Amazon Athena, or Google BigQuery? Can it connect to on-premise systems? Do users interact via browser (cloud only) or is this a desktop app, server software? All of the above? Which operating systems the BI tool supports? Is it Windows? Mac? Linux? What are the hardware requirements needed to run? Does the technology align with your current or future state environments?

4. Collaboration How can people working together create and update outputs visualizations, models, and calculations? Does the tool help with knowledge and resource sharing? Can code snippets, templates or reports be packaged for use across a broader team?

5. Education What kind of training and learning material is available? Some business intelligence and analytics tools are intuitive, some have short learning curves, but some will require deeper training. Make sure to define how much time you are ready to invest in learning. Are there videos or self-paced online classes? Does it provide free training or specific paid courses? Does it fit with the learning style of your company?

6. Community Does it have robust online communities, forums, enthusiast blogs, passionate evangelist users, local meetups, or user groups? Is the community driven by the company or are users are forming an organic community? Both? You want to make sure that you can get answers and learn from experts when you hit a roadblock.

7. Customers Customer reviews serve as proof points on what the tool is claiming to deliver. Look at who is using it: Coca-Cola? Apple? Starbucks? Big companies? Mostly small companies? Is it teams or individuals? Both? Would they purchase again? Don’t hesitate to reach out to a customer referenced by the company to validate their experiences.

8. Support The provider of the tool knows best how to overcome issues. Find out how support is provided. Is it paid? Free? Contact online, call, chat? Does the support model work for your company?

9. Partners Are there consultants, freelancers or people that can be hired or provide value-added services around the product? If yes, how robust is that partner ecosystem? If the tool is complex, you may consider third-party support to make kickstart your data analytics efforts.

10. Cost How is the product priced? Does it fit budgets? What trade-offs are you willing to accept at different price points? Do they offer discounts at scale? For long-term commitments? Knowing how BI tool is priced can help set up budgets accordingly. Are you a growing company? Is your analytics team growing? Consider possible changes in your team.

6 Business Intelligence Tools Reviewed

For reference, we put the following six tools thru this checklist. These reviews are meant to be starting points to exploring options, not definitive answers, to determine what tools work best:

1. Tableau

2. Power BI

3. Mode Analytics

4. Chartio

5. Qlikview

6. Looker

Data That Fuels BI Tools

An often overlooked aspect of BI efforts is the data. Sounds obvious, but it is anything but obvious. As a general rule data should never be locked away in a source system, analytics tool or data management platform. If it is locked away, then data is NOT a first class organizational asset. Unfortunately, when data is spread across different systems it is anything but that. All of the “dark data” represents a treasure trove of consumer insight that should be available and ready to be used by your team. You need to make sure “pipelines” exist to ensure the adequate flow of data to your tool(s).

What is data pipeline?

A pipeline solves the logistics of moving a resource from a place of low value to a place of high value. For example, pipelines move water from reservoirs (low value location) to homes (high value location). In the context of BI tools, a data pipeline solves the logistics between data sources (systems where data resides) and data consumers (those who need access to data) for processing, visualizations, transformations, routing, reporting or creating statistical models.

As you seek to implement BI solutions, don’t overlook the fact the data needed to fuel those tools may require further consideration. With the data pipelines in place you can mobilize data to your BI software.

Making a choice

Not all tools are perfect for all users, teams or companies. Once you have narrowed down your consideration set to a few candidates, then experiment with each before committing (i.e, purchasing) licenses or long term contracts. Most vendors offer free trials, so take advantage of those! Use a familiar datasets to explore how asking questions of your data works within the software. Try out different visualizations, reports, dashboards to asses your comfort level with the user interface. Validate your assessment from the checklist to meet (or exceed!) expectations. Lastly, make sure you have an “evangelist” or “advocate” internally, someone who is passionate about the solution and adoption within the company. If you don’t have a person or team who is passionate about the solution you will find your BI software is just as productive as a gym membership 4 weeks after the New Years resolution that prompted it.

More Stories By Thomas Spicer

Thomas Spicer is a Founder and CEO at Openbridge, a data delivery platform. With 20+ years of client delivery and management experience for teams like Digitas, Cramer, Studiocom, VML/WPP across all aspects of both digital and traditional marketing, he is now successfully helping teams and enterprises to solve challenges of collecting and managing data across multiple channels and deliver value faster.

Latest Stories
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
SYS-CON Events announced today that Silicon India has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Published in Silicon Valley, Silicon India magazine is the premiere platform for CIOs to discuss their innovative enterprise solutions and allows IT vendors to learn about new solutions that can help grow their business.
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
In this presentation, you will learn first hand what works and what doesn't while architecting and deploying OpenStack. Some of the topics will include:- best practices for creating repeatable deployments of OpenStack- multi-site considerations- how to customize OpenStack to integrate with your existing systems and security best practices.
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. CrowdReviews.com is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buye...
You want to start your DevOps journey but where do you begin? Do you say DevOps loudly 5 times while looking in the mirror and it suddenly appears? Do you hire someone? Do you upskill your existing team? Here are some tips to help support your DevOps transformation. Conor Delanbanque has been involved with building & scaling teams in the DevOps space globally. He is the Head of DevOps Practice at MThree Consulting, a global technology consultancy. Conor founded the Future of DevOps Thought Leade...
Everyone wants the rainbow - reduced IT costs, scalability, continuity, flexibility, manageability, and innovation. But in order to get to that collaboration rainbow, you need the cloud! In this presentation, we'll cover three areas: First - the rainbow of benefits from cloud collaboration. There are many different reasons why more and more companies and institutions are moving to the cloud. Benefits include: cost savings (reducing on-prem infrastructure, reducing data center foot print, redu...
Jo Peterson is VP of Cloud Services for Clarify360, a boutique sourcing and benchmarking consultancy focused on transforming technology into business advantage. Clarify360 provides custom, end-to-end solutions from a portfolio of more than 170 suppliers globally. As an engineer, Jo sources net new technology footprints, and is an expert at optimizing and benchmarking existing environments focusing on Cloud Enablement and Optimization. She and her team work with clients on Cloud Discovery, Cloud ...
Founded in 2000, Chetu Inc. is a global provider of customized software development solutions and IT staff augmentation services for software technology providers. By providing clients with unparalleled niche technology expertise and industry experience, Chetu has become the premiere long-term, back-end software development partner for start-ups, SMBs, and Fortune 500 companies. Chetu is headquartered in Plantation, Florida, with thirteen offices throughout the U.S. and abroad.
SYS-CON Events announced today that DatacenterDynamics has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY. DatacenterDynamics is a brand of DCD Group, a global B2B media and publishing company that develops products to help senior professionals in the world's most ICT dependent organizations make risk-based infrastructure and capacity decisions.
The technologies behind big data and cloud computing are converging quickly, offering businesses new capabilities for fast, easy, wide-ranging access to data. However, to capitalize on the cost-efficiencies and time-to-value opportunities of analytics in the cloud, big data and cloud technologies must be integrated and managed properly. Pythian's Director of Big Data and Data Science, Danil Zburivsky will explore: The main technology components and best practices being deployed to take advantage...
DXWorldEXPO LLC announced today that All in Mobile, a mobile app development company from Poland, will exhibit at the 22nd International CloudEXPO | DXWorldEXPO. All In Mobile is a mobile app development company from Poland. Since 2014, they maintain passion for developing mobile applications for enterprises and startups worldwide.
Nicolas Fierro is CEO of MIMIR Blockchain Solutions. He is a programmer, technologist, and operations dev who has worked with Ethereum and blockchain since 2014. His knowledge in blockchain dates to when he performed dev ops services to the Ethereum Foundation as one the privileged few developers to work with the original core team in Switzerland.
Most DevOps journeys involve several phases of maturity. Research shows that the inflection point where organizations begin to see maximum value is when they implement tight integration deploying their code to their infrastructure. Success at this level is the last barrier to at-will deployment. Storage, for instance, is more capable than where we read and write data. In his session at @DevOpsSummit at 20th Cloud Expo, Josh Atwell, a Developer Advocate for NetApp, will discuss the role and value...
Andi Mann, Chief Technology Advocate at Splunk, is an accomplished digital business executive with extensive global expertise as a strategist, technologist, innovator, marketer, and communicator. For over 30 years across five continents, he has built success with Fortune 500 corporations, vendors, governments, and as a leading research analyst and consultant.