BI tools landscape

Generation 1: It is the central guardian. • BI tools are code —> Need SQL to run queries. • Everyone depends on the IT team to run queries • The IT provides a static report which can take days to product The features by which this era is defined • Query in: SQL, python, …. • Static reports The issue with this era This era is problematic because the data team is a HUGE bottleneck. Generation 2: The birth of self-service A more agile approach replaced the first one: an approach that fostered self-service capabilities. • New BI tools eliminate the tech stack. Focus: provide data discovery and visualization tools to business users. • Now business users can access the data and play with it. The can now conduct ad hoc analysis of multiple data sources. • Data visualization allows for modern BI to be as much an art as a science. The key performance indicators become more accessible to employees, their bosses, and their companies as a whole. As a result, IT-centric BI vendors quickly started to build these data discovery and visualization capabilities into their product portfolios. • There is still a dependence on the data team for data preparation and modeling • Reporting/KPI’s focused. Generation 3: Business users empowered. —> Augmented analytics. • promises to reduce the dependence of business users on the data team. • Today, many well-known BI platforms have built-in capabilities to automate data preparation and detect some correlations and anomalies in large data sets. Some platforms are capable of analysis and even insight generation and action plan generation, but there is still a considerable amount of hype to muddy the waters. • Business users don’t require IT assistance to define data models • Data preparation and analysis aided by artificial intelligence • Ease-of-use greatly increased by AI automation • Data correlation and insights automatically generated to drive decision-making Feature definitions: Business focus/ Analyst focus: Tools for analysts’ code are needed to create and generate reports but business users can refresh them. You need to be a SQL pro to truly get value out of the tool. When we put both: business teams across the organization with a data analytics team to support/ No code interface: With a drag-and-drop interface to create powerful, in-depth analyses or simple dashboards + the user can connect, query and visualize your data without writing code. Data exploration: Explore the underlying query of every chart without breaking the actual dashboard. Allow non tech user to answer more complex questions. Dashboard builder:build a dashboards that suits our needs: your brand color, etc… Drill down: Click on a chart to have access to the underlying data of which records are at play to describe your metric. Metric layer:
NameWebsiteGeneration Optimized forUser focusDeployment supportData modeling No-code interfacePricing Query using DW integrations FeaturesNumber of native connectors
Mode
Generation 2 - Self-service
SMB'smid-market
Analysts
Cloud
free trialFreemium
SQLPythonR
VisualizationPython & R notebooksSQL editorExplorationsCalculated fieldsdrilldowns
Tableau
Generation 2 - Self-service
Enterprise
Business users
On-premCloud
Contact Onlyfree trial
VisualizationData AnalysisData Preparation
Qlik view
Generation 2 - Self-service
mid-marketEnterprise
AnalystsBusiness users
Cloud
free trialContact Only
SQL
discoverycollaborationinteractive dashboardsData Preparation
Power BI
Generation 2 - Self-service
Enterprise
Analysts
On-premCloud
FreemiumContact Only
DAX
Azure SQL
Visualization
Domo
Generation 2 - Self-service
Enterprise
AnalystsBusiness users
Cloud
free trialContact Only
SQL
Self-serviceData SharingEmbedded analyticsData apps
Whaly
Generation 3 - user empowerment
SMB'smid-market
Business usersAnalysts
Cloud
SQL
SnowflakeBigQueryRedshift
Dashboard builderData explorationDrill downVisualizationData SharingEmbedded analytics
150
Alteryx
Generation 2 - Self-service
Enterprise
Analysts
Looker
Generation 2 - Self-service
mid-marketEnterprise
AnalystsBusiness users
CloudOn-prem
Contact Only
LookML
Embedded analyticsVisualizationVersion control
Metabase
Generation 2 - Self-service
mid-marketEnterprise
Business users
CloudOpen-source
Freemium
SQLNo-code
Amazon AthenaRedshiftBigQueryClickhouseCube.jsdruidExasolFireboltMongoDBGoogle analyticsOraclePostgreSQL
SQL editorSelf-service
Sigma
Generation 2 - Self-service
mid-marketEnterprise
Business users
Cloud
free trial
SQLNo-code
SnowflakeBigQueryRedshift
Automatic SQL translationSpreadsheet interfaceEmbedded analytics
Y42
Generation 3 - user empowerment
Enterprisemid-market
Business usersAnalysts
Cloud
N/A
No-codeSQL
Data PreparationVisualizationData SharingWorkflow AutomationData Integration
100
Gaphext
Generation 3 - user empowerment
mid-marketEnterpriseSMB's
Business users
On-premCloud
FreemiumContact Only
Text querySQL
ML models creationCreate no-code data modelsData explorationData Preparation
Acho
Generation 3 - user empowerment
mid-marketEnterprise
Business users
free trialContact Only
Data warehousingData SharingVisualizationData ModelingWorkflow AutomationData EngineeringBusiness IntelligenceData extractionData workflow automation
Astrato
Generation 2 - Self-service
mid-marketEnterprise
Analysts
Cloud
Usage based
Snowflake
VisualizationIntegrated writebackLive query
Superset
Generation 1 - traditional BI
mid-market
Analysts
Open-source
Freemium
No-codeSQL
SnowflakeBigQueryRedshiftClickhouseDremio25 +
Data explorationVisualization
GoodData
Generation 2 - Self-service
mid-marketEnterprise
Business usersAnalysts
Cloud
Freemium
VisualizationApplication integrationIngestionData IntegrationData PreparationData transformationMetrics management
Lightdash
Generation 2 - Self-service
mid-marketSMB's
Data EngineersAnalysts
Open-source
Freemium
SQLNo-code
Self-serviceDbt poweredData Sharing
Redash
Generation 1 - traditional BI
mid-marketEnterprise
Analysts
On-premCloud
free trial
SQL
SQL editor
Adverity.com
Generation 3 - user empowerment
Enterprisemid-market
Business usersMarketing Analytics
free trialContact Only
Augmented Analytics
Preset
Generation 1 - traditional BI
mid-market
Analysts
Cloud
Contact Only
SQL
VisualizationData explorationSQL IDEEmbedded analytics
Amazon Quick Sight
Generation 1 - traditional BI
mid-marketEnterprise
Cloud
Pay per Session
Embedded analytics
Mprove
Generation 2 - Self-service
mid-marketEnterprise
AnalystsBusiness users
Open-source
free trialContact Only
SQL
Self-serviceVersion control
ToucanToco
Generation 3 - user empowerment
mid-marketEnterprise
Business users
Cloud
free trialContact Only
GlossaryRow permissions
Sisense
Generation 3 - user empowerment
mid-marketEnterprise
Analysts
On-premCloud
free trial
SQL
Snowflake
VisualizationData Preparation
Holistics.io
Generation 2 - Self-service
mid-marketEnterprise
Business usersData Engineers
Cloud
free trial
No-code
BigQueryDataBricks
VisualizationData IntegrationData warehousing
AnswerRocket
Generation 3 - user empowerment
Enterprisemid-market
Business usersAnalystsData Engineers
Cloud
Contact Only
Create no-code data modelsVisualizationData Integration
Data Pine
Generation 2 - Self-service
mid-marketEnterprise
AnalystsMarketing Analytics
Cloud
free trialContact Only
Data PreparationData SharingDashboard builderVisualizationMetrics management
Atscale
Generation 3 - user empowerment
mid-marketEnterprise
Analysts
Cloud
Contact Only
Redshift
Data Movement
Baremetrics
Generation 2 - Self-service
mid-marketEnterpriseSMB's
AnalystsBusiness users
Cloud
Contact OnlyUsage based
Tellery
Generation 2 - Self-service
mid-market
Analysts
Open-source
free trial
SQL
Data IntegrationMetrics managementDashboard builderPerformance analysis
Startree
Generation 2 - Self-service
mid-market
Business users
Open-source
Contact Only
No-code
Data AggregationOperational analytics
Statsbot
Generation 3 - user empowerment
mid-marketEnterprise
Analysts
Open-source
FreemiumContact Only
SQL
Cube.js
Data AnalysisSelf-serviceData Preparation
Polyture
Generation 3 - user empowerment
mid-marketEnterprise
Business usersAnalysts
Open-source
FreemiumContact Only
No-codeSQL
SnowflakeShopifyMySQL
VisualizationData SharingData warehousingDashboard builderCreate your own data pipeline
Bipp
Generation 2 - Self-service
mid-marketEnterprise
AnalystsBusiness users
Open-source
Contact Only
No-codeSQL
SnowflakeClickhouse
VisualizationCreate no-code data modelsDashboard builder
Veezoo
Generation 3 - user empowerment
mid-marketEnterpriseSMB's
Business users
On-premCloud
free trialContact OnlyFreemium
Text querySQL-based language
SnowflakeBigQuery
VisualizationData PreparationDashboard builderVersion control
Trevor
Generation 2 - Self-service
mid-market
Open-source
free trialContact Only
SnowflakeBigQuery
VisualizationDrill downDashboard builderSQL IDE
Zepl
Generation 3 - user empowerment
mid-marketEnterpriseSMB's
Data Engineers
Open-source
free trialContact Only
Data warehousingML models creationVisualizationData exploration
Varada
Generation 2 - Self-service
mid-marketEnterprise
AnalystsData Engineers
On-prem
Contact Only
SQL
DataBricks
Incorta
Generation 2 - Self-service
mid-marketEnterprise
Analysts
Open-source
free trial
MySQLRedshiftOracle
Metric insights
Generation 1 - traditional BI
Enterprise
Open-source
Contact Only
Cluvio
Generation 1 - traditional BI
mid-marketEnterprise
Data Engineers
Open-source
Contact OnlyFreemium
SQLR
SnowflakeBigQueryRedshiftOracleMySQL
Dashboard builderData Preparation
Microsoft analytics
mid-marketEnterprise
Open-source
N/A
Macheye
mid-marketSMB's
Business usersMarketing AnalyticsAnalysts
Open-source
Freemium
No-code
SnowflakeDremioMySQL
VisualizationEmbedded analytics
Scuba
Generation 3 - user empowerment
mid-marketEnterprise
Business users
Open-source
FreemiumContact Only
No-code
Data PreparationVisualizationWorkflow AutomationDashboard builderCreate no-code data modelsAugmented analytics
Endor
Generation 3 - user empowerment
mid-marketEnterprise
Business users
Open-source
Contact Only
No-code
Data PreparationVisualization
Explo
Generation 2 - Self-service
SMB's
Marketing AnalyticsBusiness usersAnalysts
On-premOpen-source
N/A
SnowflakeBigQueryRedshiftMySQLClickhouse
Data PreparationVisualizationDashboard builder
Einblick
Generation 2 - Self-service
mid-marketSMB's
AnalystsBusiness users
Open-source
free trial
PythonNo-code
SnowflakeMySQLOracle
VisualizationData SharingML models creation
DataHero
mid-marketEnterprise
Business users
Open-source
free trial
VisualizationDashboard builderEmbedded analytics
Targit
Generation 1 - traditional BI
Enterprise
Business users
Open-source
Contact Only
Visualization
Verb data
Generation 3 - user empowerment
mid-marketEnterpriseSMB's
Business users
Open-source
free trial
No-code
MySQL
VisualizationDashboard builderCreate no-code data modelsData Modeling
Splashback
mid-marketSMB's
Open-source
free trial
Data Sharing
Glean
Generation 2 - Self-service
mid-marketSMB's
Cloud
Undisclosed
No-code
RedshiftSnowflake
VisualizationDashboard builder