Using Bonobo, Airflow and Grafana to Visualize Your Business

Explore building a business dashboard using Bonobo ETL, Airflow, and Grafana in this hands-on EuroPython 2018 talk. Learn to create data pipelines, implement ETL processes, and visualize business metrics without prior knowledge of these tools. Dive into topics such as data services, technical metrics, planning metrics, and business frameworks using real SaaS software data. Discover how to write code for object count readers, normalize data, create graph instances, and connect to various data sources including Google Analytics and Prometheus. Gain insights into Airflow architecture, cron jobs, and system environments. By the end of this 45-minute session, acquire the skills to develop a similar system for monitoring and improving business metrics over time.

Syllabus

Intro
Romains background
Goals
Bonobo
Private beta
World service
Data services
Grafana dashboards
Technical metrics
Metrics
Planning metrics
Business frameworks
Data pipelines
About Bonobo
Writing the code
Object Count Reader
Normalize
Write to matrix
Create graph instance
Filter metrics
Database connection
Linear status
Connecting to Google Analytics
Prometheus
Reducer
Graph execution
Algorithm
Graphing
What is graphing
Interface to configure graph
QoS
Number of spiders
Time to get a new picture
Public dashboards
Database Joins
Conversion Rate
Timeline Injection
cron jobs
what is a flow
Airflow architecture
GHG objects
Dikes
Connections
System Environment
Documentation
Timeboxed experiments
Canvases
Text
Assembly line
Books
Feedback
Flow vs Bonobo