4 Key Criteria for Selecting a Business Intelligence Solution
Once a media company has decided to get started with business intelligence (BI), they must choose a vendor. There are many vendors that offer solutions in this space, but for most, SaaS (software-as-a-service) tools like Domo, Tableau, Grow, iDashboards, Birst, Qlik, Looker, and Microsoft Power BI offer great functionality without the need for lengthy and costly integration into a publisher’s existing systems.
In the process of selecting a vendor, publishers need to achieve a balance across multiple criteria rather than looking at just a single factor (e.g. cost). Below is a list of criteria that are key for publishers in choosing a BI solution. Each is presented with a Decision Weight (DW) that indicates its impact on the final selection – this is where participation from multiple departments is needed to determine the best solution.
1. Functionality (DW of 40)
To evaluate a BI solution's functionality, consider the following components.
- Connector Availability: Does the BI solution easily integrate with key third-party data and databases through pre-built connectors across all Marketing/HR/Sales/Finance business functions (e.g. Amazon Redshift, Amazon S3, Dropbox, Salesforce, Google Analytics, Google Ads, Facebook Ads, Netsuite, Flurry, Jira, Mailchimp, Microsoft Excel)?
- API Connectivity: Does the BI solution easily integrate with any application program interface (API)?
- Data Limitations: Does the BI solution import and store all the data that it has been connected to on its platform? This would mean that any data cleaning, combining, and transforming would happen on the platform. If this is the case, what are the limits of that storage (in terms of gigabytes or rows of data)? Alternatively, does the BI solution create a “live” connection to the data hosted by the publisher, or its service providers, when displaying a dashboard or card/graph? This would mean that only simple data cleaning, combining, and transforming could be performed by the platform.
- Data Manipulation: Does the BI solution offer a visual tool, usable by a business/marketing analyst, to support cleaning, combining, and transforming the publisher’s data? Does the BI solution support SQL and R for developers?
Dashboard and Cards/Graphs
The mechanics around building and using dashboards and cards/graphs, including:
- User Experience (UX): What is the technical level (e.g. coding skills) needed to build cards/graphs and dashboards? Does the building and editing of every card/graph need the participation of a developer?
- Filtering and User-Defined Cohorts: Is there dashboard-level filtering? Are these user-defined cohorts persistent as users click onto cards/graphs?
- White Labeling: Can the dashboard and/or individual cards/graphs be customized to show the publisher’s logo and branding or embedded into the publisher’s site? Can the publisher add custom messaging?
- Mobile: Does the vendor offer mobile access that allows card/graph or dashboard creation and editing?
- Digital Signage: Does the vendor offer a digital signage solution to show reformatted dashboards on public space displays?
User-defined alerts can be triggered and sent (e.g. email, text) based on important changes or thresholds crossed at either the dataset level or the card/graph level.
The BI system provides access to either detailed reports or raw data on how users are interacting with built dashboards and cards/graphs.
- User Authentication: Support for single sign-on (SSO)
- Access rights: Can the publisher define roles within the BI solution to grant users specific rights to access and/or edit selected datasets, cards/graphs, and dashboards? Does the BI solution support row-level security within a dataset?
2. Technology and Infrastructure (DW of 25)
SaaS vs On-Prem
Is the BI solution offered as SaaS, as a locally installed software (on-prem), or a hybrid combination of the two?
Data backup and redundancy plan, frequency (hourly, daily), and onsite/offsite setup.
Regular updates in functionality (e.g. data connectors, card/graph types, dashboard design), and underlying technology (e.g. dataset size limitations, redesign speed).
Handling of publisher’s data, including:
- Theft/Copying Countermeasures
- Competing Client Data Separation
- Employee Monitoring (e.g. cameras, PC logs, supervision)
- Premises Security: 24-hour guard, alarm, and personnel entrusted with keys.
3. Service and Support (DW of 15)
Proper communication and timely response, including:
- Contact Methods (e.g. phone, IM, online system, email)
- Location: Is there a US client support team?
- Hours: Overlap with publisher working hours and ability to extend them for deadlines.
- Service Level Agreements (SLA): Does vendor offer an agreement that guarantees strict delivery terms, including penalties?
Program to train publisher in vendor’s systems, procedures, tools and best practices.
Does vendor offer help in further tailoring its solution beyond the standard package offered?
4. Vendor Reliability (DW of 20)
Age of the business, management experience, and existing/past clients (their type, depth and length of relationship, frequency of repeat business, and opinion of the vendor’s products and services).
Vendor’s proactive vision and strategy to expand functional coverage, upgrade technology and infrastructure, serve clients more efficiently, and improve market position.
Life expectancy of the vendor. This includes:
- Financial Backing: How is the company financed?
- Employees: How many employees are currently employed?
- Financial Results: Is the vendor profitable or showing a solid trend towards profitability?
- Market Share: Vendor’s share of the relevant market.
- Dependence: How much of vendor’s total business is from specific client?
Pricing and Proof of Concept
It is particularly important that an extensive proof of concept (PoC) be conducted with the selected solution (or the shortlisted solutions, if possible) to ascertain whether the various departments involved are satisfied with the solution’s actual functionality in a real environment.
A publisher should only look at pricing after evaluating and selecting a shortlist of possible BI vendors according to the four criteria groups above. Though various pricing models exist in the BI space that depend on whether the solution is SaaS or on-prem, the publisher should focus primarily on comparing:
- Per user costs over three years (including support and maintenance)
- Training costs
- Proof of concept (PoC) costs
- Any consulting and third-party integration/implementation costs
While the long-term success of a BI solution is heavily dependent on how important data and the intelligence deriving from it is to an organization, selecting the wrong vendor can hamper even the best laid plan.