What I value most in BI tool

@kzzzr

I use Looker and totally satisfied with it.

Here's my list of features labeled with (H)igh, (M)edium and (L)ow priority.

I used this list to compare different solutions against what I currently use to see if I can benefit from switching to another tool.

You can use it as reference to populate BI tool comparison matrix (included).

(H) Pre-defined data modeling with LookML
Measures, Dimensions, Filters
Join patterns (facts - dimensions), aggregate awareness
(H) Development mode (zero affecting anybody else's work)
(H) Git workflow (develop, commit, submit PR, test, review, merge) + history of changes
(M) Data Quality: LookML validation + Content validation
(M) Wide variety of dialects supported. We might be possibly assessing Databricks, Snowflake, Clickhouse, Trino, Dremio, Spark
(M) LookML dashboards (dashboards as code)
(L) Liquid templating in LookML for more dynamic content (distinct currencies)
(L) Ability to sync with dbt (DWH) changes (via Spectacles)
(L) Actionable links (follow link and see customer/journey/chauffeur on the backend)

(H) Scheduling content delivery
(H) Share data (just copy link, includes state and filters)
(M) Content organization:
Shared and private folders
Curated 'Explores' exposed publicly
Curated Boards (number of dashboards and looks for specific teams)
(M) Looker functions and operators: custom fields, table calculations
(M) Easy pivot
(M) Merging results from different Explores — Combine data from multiple queries.
(L) Alerting feature (conditions met)
(L) Visualize table cells as color codes #FFFFFF (car color)
(L) Links to web (Users in CRM, Campaigns in Braze)

(M) Number of predefined reports: User Activity, Content Activity, Database Performance
(M) Querying metadata DB: content usage, users activity queries, etc.

## BI tool comparison matrix

-- | -- | -- | -- | -- | --

Report Page