SYS-CON MEDIA Authors: Pat Romanski, Liz McMillan, Yeshim Deniz, Elizabeth White, Courtney Abud

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
In 2014, Amazon announced a new form of compute called Lambda. We didn't know it at the time, but this represented a fundamental shift in what we expect from cloud computing. Now, all of the major cloud computing vendors want to take part in this disruptive technology. In his session at 20th Cloud Expo, John Jelinek IV, a web developer at Linux Academy, will discuss why major players like AWS, Microsoft Azure, IBM Bluemix, and Google Cloud Platform are all trying to sidestep VMs and containers...
Using serverless computing has a number of obvious benefits over traditional application infrastructure - you pay only for what you use, scale up or down immediately to match supply with demand, and avoid operating any server infrastructure at all. However, implementing maintainable and scalable applications using serverless computing services like AWS Lambda poses a number of challenges. The absence of long-lived, user-managed servers means that states cannot be maintained by the service. Lo...
With the new Kubernetes offering, ClearDATA solves one of the largest challenges in healthcare IT around time-to-deployment. Using ClearDATA's Automated Safeguards for Kubernetes, healthcare organizations have access to the container orchestration to dynamically deploy new containers on demand, monitor the health of each container for threats and seamlessly roll back faulty application updates to a previous version, avoid system-wide downtime and ensure secure continuous access to patient data.
Isomorphic Software is the global leader in high-end, web-based business applications. We develop, market, and support the SmartClient & Smart GWT HTML5/Ajax platform, combining the productivity and performance of traditional desktop software with the simplicity and reach of the open web. With staff in 10 timezones, Isomorphic provides a global network of services related to our technology, with offerings ranging from turnkey application development to SLA-backed enterprise support. Leadin...
With the rise of Docker, Kubernetes, and other container technologies, the growth of microservices has skyrocketed among dev teams looking to innovate on a faster release cycle. This has enabled teams to finally realize their DevOps goals to ship and iterate quickly in a continuous delivery model. Why containers are growing in popularity is no surprise — they’re extremely easy to spin up or down, but come with an unforeseen issue. However, without the right foresight, DevOps and IT teams may lo...
Platform9, the open-source-as-a-service company making cloud infrastructure easy, today announced the general availability of its Managed Kubernetes service, the industry's first infrastructure-agnostic, SaaS-managed offering. Unlike legacy software distribution models, Managed Kubernetes is deployed and managed entirely as a SaaS solution, across on-premises and public cloud infrastructure. The company also introduced Fission, a new, open source, serverless framework built on Kubernetes. These ...
Emil Sayegh is an early pioneer of cloud computing and is recognized as one of the industry's true veterans. A cloud visionary, he is credited with launching and leading the cloud computing and hosting businesses for HP, Rackspace, and Codero. Emil built the Rackspace cloud business while serving as the company's GM of the Cloud Computing Division. Earlier at Rackspace he served as VP of the Product Group and launched the company's private cloud and hosted exchange services. He later moved o...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
Kubernetes is a new and revolutionary open-sourced system for managing containers across multiple hosts in a cluster. Ansible is a simple IT automation tool for just about any requirement for reproducible environments. In his session at @DevOpsSummit at 18th Cloud Expo, Patrick Galbraith, a principal engineer at HPE, will discuss how to build a fully functional Kubernetes cluster on a number of virtual machines or bare-metal hosts. Also included will be a brief demonstration of running a Galer...
DevOps is under attack because developers don’t want to mess with infrastructure. They will happily own their code into production, but want to use platforms instead of raw automation. That’s changing the landscape that we understand as DevOps with both architecture concepts (CloudNative) and process redefinition (SRE). Rob Hirschfeld’s recent work in Kubernetes operations has led to the conclusion that containers and related platforms have changed the way we should be thinking about DevOps and...
Cloud-Native thinking and Serverless Computing are now the norm in financial services, manufacturing, telco, healthcare, transportation, energy, media, entertainment, retail and other consumer industries, as well as the public sector. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long development cycles that pro...
Docker is sweeping across startups and enterprises alike, changing the way we build and ship applications. It's the most prominent and widely known software container platform, and it's particularly useful for eliminating common challenges when collaborating on code (like the "it works on my machine" phenomenon that most devs know all too well). With Docker, you can run and manage apps side-by-side - in isolated containers - resulting in better compute density. It's something that many developer...
Technology has changed tremendously in the last 20 years. From onion architectures to APIs to microservices to cloud and containers, the technology artifacts shipped by teams has changed. And that's not all - roles have changed too. Functional silos have been replaced by cross-functional teams, the skill sets people need to have has been redefined and the tools and approaches for how software is developed and delivered has transformed. When we move from highly defined rigid roles and systems to ...
In a recent survey, Sumo Logic surveyed 1,500 customers who employ cloud services such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP). According to the survey, a quarter of the respondents have already deployed Docker containers and nearly as many (23 percent) are employing the AWS Lambda serverless computing framework. It's clear: serverless is here to stay. The adoption does come with some needed changes, within both application development and operations. Th...
xMatters helps enterprises prevent, manage and resolve IT incidents. xMatters industry-leading Service Availability platform prevents IT issues from becoming big business problems. Large enterprises, small workgroups, and innovative DevOps teams rely on its proactive issue resolution service to maintain operational visibility and control in today's highly-fragmented IT environment. xMatters provides toolchain integrations to hundreds of IT management, security and DevOps tools. xMatters is the ...