Which Business Intelligence (BI) Tools Are Right For Your Business?

best business intelligence (BI) tools review list in 2020 by agiletech
business intelligence software tableau, power bi, google data studio, IBM cognos by agiletech

Top Business Intelligence Tools — Review & Pricing

Tableau

Microsoft Power BI

  1. Free version — comes with basic reporting features and a 1GB data limit per user.
  2. Pro version — gives you all Power BI features, including real-time dashboard updates, more customization options for visuals, and access management controls for security.

Google Data Studio

IBM Cognos

  • Uploading data to cloud sources
  • Joining data from multiple sources
  • Sharing content with users
  • Ability to create dashboards with new or old content
  • Ability to create data stories using web pages, images, text, and other media
  • Data discovering using artificial intelligence
  • Advanced pattern detection

Why Use Business Intelligence Tools?

Connecting to data

Tableau

  • 75+ built-in connectors
  • Option to extend connectors with ‘web data connector’
  • Supports most file types (CSV, JSON, Excel, etc.)
  • Connects to most databases (Microsoft, Amazon, Snowflake, SAP, Spark, Google, etc.)
  • Connects directly to some services (Google Analytics, Dropbox, Marketo, Salesforce)

Power BI

  • Visual interactions are the killer feature
  • Ability to create custom visuals (even low code in Microsoft Visio) or download community visuals
  • Not as many customization features as Tableau but reaching feature parity with each release
  • Simple and effective approach to creating visuals

Google Data Studio

  • Makes it easy to create something that looks pleasing without much effort
  • Recently opened up the ability to create community visuals (community is very small right now)
  • Very limited customization
  • A very simple approach, but a little too simple

IBM Cognos

  • Visualization tools are not simple enough for average users to understand albeit being appealing itself
  • Insights in visualization are strongly enhanced
  • Enables responsive options and customizable actions
  • Engages the audience through scenes and stories with definable animations

Sharing Data

Tableau

  • Other than static files, sharing requires purchasing accounts for viewers at $12 per user per month
  • The online portal is dated and can be slow to refresh data
  • White-labeling is limited without embedding
  • Embedding is available but requires developers to make fully functional

Power BI

  • Limited export of static files
  • Power BI files can be shared, but end-user needs Power BI Desktop to view
  • Sharing online requires purchasing viewers (if outside your organization) @ $10 per user per month (no minimums required)
  • Same issues as Tableau with the online portal, white-labeling, and embedding

Google Data Studio

  • Built around easy sharing, but does require a Google account
  • The online portal is fresh and easy for users that are accustomed to other Google products (e.g. Google Drive)
  • Sharing is always free with no limits
  • PDF/printing is limited

IBM Cognos

  • Enables sharing via email or Slack
  • Embedding is available
  • Dashboards and be exported under PDF format
  • User can create URLs that open or run content objects, such as reports, dashboards, stories, and data module

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
AgileTech Vietnam

AgileTech Vietnam

A quality outsourcing/offshoring company in Website/Mobile Apps, Blockchain services, AI - big data services. Visit our website: https://agiletech.vn