Metrics and the
modern data experience
Benn Stancil
Mode
December 8, 2021
Metrics and the
modern data experience
Benn Stancil
Mode
December 8, 2021
2121
1989 – 2011
The age of
Big BI
Fast & Cheap
Database
Slow & pricey
Database
Revenue
$1,731,805
▲ 24.2%
Business Intelligence
Slow & pricey
Database
Data model
Business Intelligence
Slow & pricey
Database
Metrics
Data model
f(x)
Business Intelligence
Slow & pricey
Database
Metrics
Data model
f(x)
Business Intelligence
Slow & pricey
Database
Metrics
Data model
f(x)
Can only use precomputed data and metrics
Business Intelligence
Slow & pricey
Database
Metrics
Data model
f(x)
Hard to answer questions on unmodeled data
Business Intelligence
Slow & pricey
Database
Metrics
Data model
f(x)
A consistent and reliable view of the business
Data scientist!!!
Revenue
$1,731,805
▲ 24.2%
Revenue
$1,731,805
▲ 24.2%
Business Intelligence
Slow & pricey
Database
Metrics
Data model
f(x)
Slow & pricey
Database
Fast & cheap
Database
Business Intelligence
Fast & cheap
Database
Metrics
Data model
f(x)
Business Intelligence
Fast & cheap
Database
Metrics
Data model
f(x)
Analytics
Business Intelligence
Fast & cheap
Database
Metrics
Data model
f(x)
Analytics
Operations
Business Intelligence
Fast & cheap
Database
Metrics
Data model
f(x)
Analytics
AI + ML
Operations
Data model
Business intelligence
Fast & cheap
Database
Metrics
f(x)
Analytics
AI + ML
Operations
Data model
Business intelligence
Fast & cheap
Database
Metrics
f(x)
Analytics
AI + ML
Operations
1990 – 2011
The age of
Big BI
2012 – 2021
The age of the
Modern Data Stack
Very powerful and flexible!
Data model
Business intelligence
Fast & cheap
Database
Metrics
f(x)
Analytics
AI + ML
Operations
The Analytics Engineering Advantage
14
Impact
Time
Post-analytics engineering
Pre-analytics engineering
Data model
Business intelligence
Fast & cheap
Database
Metrics
f(x)
Analytics
AI + ML
Operations
f(x)
f(x)
f(x)
Metrics are now all over the place
Thing it does is means the last mile of data tooling can focus on experiences.
We don’t have to worry about underlying infrastructure and making it all match (quote from Ali, Sisu reference, etc)
Trace
Trace
BI
Data model
Fast & cheap
Database
Analytics
AI + ML
Operations
Metrics
f(x)
BI
Data model
Fast & cheap
Database
Analytics
AI + ML
Operations
Metrics
f(x)
Discovery
BI
Data model
Fast & cheap
Database
Analytics
AI + ML
Operations
Metrics
f(x)
Discovery
Monitoring
1989 – 2011
The age of
Big BI
2012 – 2021
The age of the
Modern Data Stack
1989 – 2011
The age of
Big BI
2012 – 2021
The age of the
Modern Data Stack
2022 – ...
The age of the
Modern Data Experience
BI
Data model
Fast & cheap
Database
Analytics
AI + ML
Operations
Metrics
f(x)
Discovery
Monitoring
BI
Data model
Fast & cheap
Database
Analytics
AI + ML
Operations
Metrics
f(x)
Discovery
Monitoring
How do we interact with metrics?
...in different tools...
...and across different tools?
1
1
2
How do we interact with metrics...
...in different tools?
...and across different tools?
BI
Data model
Fast & cheap
Database
Analytics
AI + ML
Operations
Metrics
f(x)
Discovery
Monitoring
BI
Analytics
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Metrics
f(x)
Dashboards
Data apps
How do we interact with metrics...
...in different tools...
1
2
How do we interact with metrics...
...in different tools...
...and across different tools?
1
2
3
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Metrics
f(x)
Dashboards
Data apps
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Metrics
f(x)
Dashboards
Data apps
Why are signups down?!?
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Metrics
f(x)
Dashboards
Data apps
Data apps
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Metrics
f(x)
Dashboards
Metrics
Data apps
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Dashboards
Metrics
Data apps
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Dashboards
Me:
Also me:
Metrics
Data apps
Visual analysis
Data model
Fast & cheap
Database
R + Python notebooks
SQL-based analysis
Dashboards
Trace
mode.com/coalesce
Questions?
benn.substack.com
@bennstancil
© Mode Analytics, Inc. 2020 | mode.com