BCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
CategoriesPower BI LookerTableauGoogle Data StudioCognos AnalyticsSAP AnalyticsOracle AnalyticsAmazon QuickSightSpotfireSisenseDOMOThoughtSpotQlik SenseAlteryxSupersetMetabaseMicroStrategy AnalyticsPentahoBirstPresetSisuKnowiGrowGoodDataZoho AnalyticsMode
2
CompanyMicrosoftGoogleSalesforceGoogleIBMSAPOracleAmazonTIBCOSisenseDOMOThoughtSpotQlikAlteryxApacheMetabaseMicroStrategyHitachiInforPresetSisuKnowi
3
Release year2015201320032016200520152012*2016199620042011*2012*201319972017?1989?2004*20212019
4
Price per creator (pm)Pro: $9.99, Premium: $20est. $5,000+ for 12 licenses$70$0$10-40$36$40.00$18.00$125 + $9,000-50,000 for licensing*$160*$83*N/A*$30.00?open source but $20 hosted by Preset?$600/user or $300,000/CPU core*?$49.00$20.00
5
Price per viewer (pm)$9.99~$15 per user after the $5,000pm fee*$15$0$10-40$36$40.00$5.00$25$160*$83*N/A*$30.00???N/A*?$49.00$20.00
6
On-prem cost (per month)$4995*$5,000+ for 12 licensessame costn/a$15-70 per user??????$6,250*annual $25,000 +10%*??????n/aPlease contribute to orange-colored cells by leaving a comment and I will integrate it. Thank you in advance for helping make this analysis more objective and detailed. The link to this spreadsheet and the dashboard will always stay public.
7
Deployment ModelCloud (poor on-prem)*On-prem or Cloud*On-prem or CloudCloudOn-prem or CloudOn-prem or CloudOn-prem or CloudCloudOn-prem or CloudOn-prem or CloudCloudOn-prem or CloudOn-prem or Cloud?On-prem or cloud?On-prem or Cloud?CloudCloudOn-prem or Cloud
8
Development EnvironmentDesktopBrowserDesktopBrowserBrowser or DesktopBrowser*Browser*BrowserBrowser or DesktopBrowser or DesktopBrowser*ImplementationBrowserDesktopBrowser?Desktop?Desktop*BrowserBrowser or Desktop
9
OS AgnosticWindows only✓✓✓✓✓✓✓Windows: Full featured on Windows/ Mac: Limited, via web browser✓✓✓✓?✓?✓?✓✓✓
10
Cloud AgnosticAzure lock-in for hosting and some features✓✓n/a✓*✓*✓*✓*✓✓✓✓✓?✓?✓?✓✓
11
Database Agnostic✓ConnectorConnector✘ConnectorConnector✓Connector✓ConnectorConnector✓✓?✓?Connector?✓✓✓✓Dashboard: https://datastudio.google.com/reporting/03b3aed8-42e1-4423-bea9-e37b8e4e0f86
12
Preferred Data ModelStar-schemaStar-schema*FlatStar-schema/ SnowflakeStar-schema/ Snowflake/ OLAPStar-schema/ Snowflake*Star-schema/ Snowflake*Star-schema/ Snowflake*Star-schema/ SnowflakeStar-schemaStar-schemaStar-schema*Snowflake/ Star-schema???Star-schema/ Snowflake*??Star-schema*
13
Full-Featured Free Version✓✘Separate tool✓Free trialFree trialFree trialFree trialFree trialFree trialFree trial✘✘?✓?✓?✘✓Free trial
14
Share with anyone on the Internet✓*✓Separate tool✓✓✘*✓*✘*✓✓✘*✘*✘???✘*?✘*✓
15
R and Python SupportOnly in the personal version✓✓✘✓R*✓✘✓✓✓R✓???✓*?✘
16
Open-source Custom Visuals✓✓✓*✓✓✘*✓✓✓✓✓✘✓?✓?✓?✘*✓✓
17
Dynamic Cross-Filtering✓✓✓✓✓✓*✓✓✓✓✓✘✓???✘?✘*✓
18
Search Analytics with NLP✓✘✓✘✓✓✓✓✓✓*✓*✓✓???✓?✘*✓
19
Data Modelling Tools✓✓Separate tool✘✓✓✓✓✓✓✓*✓✓???✓*?✓✓✓✓
20
Data Preparation Tools✓✓*Separate toolSeparate tool✓✓✓✓✓✓✓✓✓???✓*?✓✓
21
Data prep/modeling coding requirement (No-code, Low, Medium, High)?????????????????????
22
Max data size for data prep?????????????????????
23
Mobile App✓✓✓✓✓✓✓✓✓✓✓✓✓???✓?✓✘✘
24
Embed Analytics✓✓✓✓✓✓✓✓✓✓✓✓✓???✓?✓✓
25
Simultaneous Development by Multiple Parties✘✘*✘*✓✘???✘??????????✓✓
26
Built-in Row Level Security✓✓✓✓✓✓✓✓✓✓✓✓✓???✓?✓✓✓
27
Security Protocols/Certs Support?????????????????????✓
28
User-friendliness (developer)HighHighHigh; after slightly higher learning curveHighHigh*???High; after slightly higher learning curve?High????????HighHighHigh
29
Dashboards appealHighHighHighHigh????High?High???????LowHighHigh
30
Other comment (i.e. why did you choose to use over PBI/Tableau, things to have in mind)1) Part of MS Power Platform but very buggy; 2) MS Azure; 3) developing custom visualisations is unpleasant; 4) slicers and filters don't interact; 5) advanced ML featuresPromising; browser-based ensures consistent experience for everyoneLess integrated as a single solution; more advanced mapping capabilities; Tableau has VizQL and Hyper technology that optimizes visualizations and working with large data in-memory; Strong position in regards to Salesforce CRM.Great for quick, simple reports or sharing something with the public. However - very limited, slower, less connection sources compared to more advanced tools.Better governance, full automation for delivering reports by email, fast and efficient semantic layerhigh cost, inflexible, challenging migration"We use it in conjunction with Tableau, PBI. Mostly because we already use Oracle. I like that it is browser based as it reduces installation issues.
Governance is quite good; semantic layer is one of the most robust I’ve seen - you can even have ad-hoc users creating their own semantic layers."		Low cost; scalable, so it can support thousands of users without additional infrastructure management or capacity planning"Integrated Data Wrangling interface, fully interactive Python/R through in-built engine, realtime updates (1 sec refresh), Custom App building, Highly responsive custom visualizations" - NeilPotentially promising; leader in embedded analyticsPotentially promisingRecognized as speech specialist (for natural language queries); doesn't offer the full functionality to replace other BI solutions and only complements them; Implementation is hard, requiring IT skills and effort, planning in advance.????high cost??Fully hosted version of superset with added security and features you would expect from an enterprise BI tool. Easy and free to get started with most sql databases as well as some easy connections to sources like google sheets. No vendor lock in as customers to move to superset.Helps business users take common metrics and automatically generate multiple analysis without needing to building dashboards from scratch.Includes native integrations to data stores (Mongo, Snowflake, Redshift, Google sheets, and more), no need for intermediary tools to pull in and transform data. Tons of security and governance capabilities, ability to define custom roles and permissions, allows for business users to ask questions and get a response in real time (against your dataset real time), easy to clone all assets, embedding capabilities, reports / alerting capabilities, and intuitive to get up and running. Attractive UI and ability to use in tandem with other BI / reporting tools or on its own. Slack integration is also useful.
31
1111910129139121211913108
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100