ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
ToolPublic Demo URLFree?Open Source?I can execute a query without having to write a line of codeData Source SupportI can upload and analyze a CSVI can analyze JSON from a URLI can quickly turn SQL into a visualizationAble to join data from multiple underlying database tables, either at query time or behind the scenesCan I query data without a login?Can I publish a query / dashboard publicly?Supports basic visualizations (table, bar, pie, etc.)Supports visualizations of map dataSupports filtering by field nameSupports autocompletion of possible values when filteringSupports grouping measures by arbitrary groups of dimensionsSupports more advanced calculations based on SQL, or client-side, that enable users to apply functions like averages, or row offsets, etc.Formatting is "smart" (formats automatically based on the data type, or enables decorating values with dollar signs, decimal places, etc.)Provides tooltips / descriptions that help users understand what a given field name meansCan I export the results of a query to CSV, or an Excel doc?Can I share a query with someone else in under 10 seconds (e.g. via URL)?Can I abstract measures in some user / developer configuration with ease?Can I abstract dimenions in some user / developer configuration with ease?Can I use measures and dimensions that I've abstracted in other measure / dimension definitions?Can I rename table names to give the user a more human-friendly table description?Can I rename field / column names to give the user a more human-friendly description?Can I manipulate data in a pivot table (rows by columns)?Configuration stored in version control?Changes can be tested before being pushed to users in production
2
LookerNoNoYesMany databases, primarily relationalNoNoNot through the SQL Editor. Have to write LookML to surface new measures / dimensions and use the pivot table to visualizeYesYesNoYesYesYesYes (runs SELECT DISTINCT on field at runtime - not as fast as Metabase)YesYesYesYesYesYesYesYesYesYesYesYesYesYes
3
MetabaseYesYesYesMany large-scale relational databases, Mongo, Druid and othersNoNoNoYes, but limitedNo. Login required to query, but public access being discussedNoYesYesYesYes (static list of distinct field values presented immediately)YesNoNo. Formatting appears to be relatively smart, but no way to edit default formattingYesYes (very quick export of CSV only)YesYes, limited - able to create measures, which enable you to abstract a calculation as the result of a filter and calculation (COUNT, SUM, etc.), but not to execute arbitrary SQLNoNoYesYesNo (I can break out data by rows only)NoNo
4
Superset (formerly Caravel)YesYesYesRelational databases supported through SQLAlchemy connections, and DruidNoNoYesNoNoNoYesYesYesNoYesNoNoYes (maybe?). Field in admin config allows for description, but I don't see it appear anywhereYes (one-click CSV export)YesYesYesNoNoYesYesNoNo
5
Re:dash
http://demo.redash.io/
YesYesNoPlugs into relational databases and more (e.g. Graphite, InfluxDB, Mongo)No, but will support Google SpreadsheetsYesYesYesMaybe, need to testMaybe, if open auth supportedYesYesYes, through SQLNoYes, through SQLYes, through SQLLimited (numbers appear with commas, dates appear as dates)NoYesYesNoNoNoNoNoYes, through SQL (technically) or through a Pivot Table visualization typeNot exposed to the userNo
6
Amazon QuickSightOnly during trial period / for AWS free tierNoYesAmazon S3, Salesforce, other relational DBsYesNoNoYesNoNoYesNoYesPre-populates list of values from which you can choose (no free-form text box)Ability to group by more than 2 dimensions limitedCalculated fields must be developed when creating a data source, where a number of SQL-like functions can be appliedYesNoNoI can share, but not quickly via URLYes, limited ability to create calculated measuresYesYesYesYesYesNoNo
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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