Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

data.visualize!

Avatar for Lukas Fittl Lukas Fittl
November 14, 2013
Programming
250
4

 data.visualize!

Talk at vienna.rb on how we built https://pganalyze.com/ and other visualization products.

Avatar for Lukas Fittl

Lukas Fittl

November 14, 2013

More Decks by Lukas Fittl

See All by Lukas Fittl
How to Scale Postgres - Automation, Tuning & Sharding
Avatar for Lukas Fittl lfittl
0
710
What's Missing for Postgres Monitoring
Avatar for Lukas Fittl lfittl
0
320
A Map For Monitoring PostgreSQL
Avatar for Lukas Fittl lfittl
2
430
Monitoring Postgres at Scale
Avatar for Lukas Fittl lfittl
1
510
Monitoring PostgreSQL at Scale
Avatar for Lukas Fittl lfittl
4
310
Postgres Performance for App Developers
Avatar for Lukas Fittl lfittl
2
350
GraphQL ❤ PostgreSQL -- P.S. aka BeatQL
Avatar for Lukas Fittl lfittl
1
670
Hacking PostgreSQL to Gain SQL Parsing Superpowers
Avatar for Lukas Fittl lfittl
1
660
PostgreSQL at a Web Startup
Avatar for Lukas Fittl lfittl
3
660

Other Decks in Programming

See All in Programming
Atomic Design, Enforced: Scaling Mobile Design Systems (next.app devCon / droidCon Berlin 2026)
Avatar for Stelios Frantzeskakis steliosf
PRO
0
170
【加筆修正版】Laravel のアプリケーションをどこにデプロイするか #phpcon_ehime
Avatar for akase244 akase244
0
150
KiroのSpecで「五目並べ」を作ってみる
Avatar for Satoshi Kaneyasu satoshi256kbyte
1
370
ソニーのクラウド共通基盤の変遷と AI時代の開発スタイルに合わせた進化 / The Journey of Sony’s Common Cloud Platform and Its Evolution for AI-Native Development
Avatar for KenjiYoneyama kenjiyoneyama
0
250
AIに “答え“を書かせるのを やめてみた
Avatar for akari ___akari11
0
120
wkhtmltopdfの次どうするか問題2026
Avatar for Shinichi Maeshima willnet
2
1.9k
Simple Storage Service(S3) is not simple
Avatar for Yura Iwatsuka iwatsukayura
0
270
JAWS-UG 東京支部が始める、JAWS-UG支部コラボ / JAWS-UG lunchtime LT Collaboration
Avatar for y-ohgi y0hgi
0
250
プロダクトコードからライブラリの境界を見つける
Avatar for elmetal elmetal
PRO
0
110
速習iPhone Duo対応
Avatar for 野瀬田　裕樹 yuukiw00w
2
980
自サークルのIdPからログアウトできるようになるまで
Avatar for taiseiue taiseiue
1
130
HTML-in-Canvasで作る未来のWeb UI表現
Avatar for IKEDA Yasunobu clockmaker
4
4.8k

Featured

See All Featured
KATA
Avatar for Megan Lloyd mclloyd
PRO
35
16k
Ecommerce SEO: The Keys for Success Now & Beyond - #SERPConf2024
Avatar for Aleyda Solis aleyda
1
2.2k
Evolving SEO for Evolving Search Engines
Avatar for Ryan Jones ryanjones
0
320
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
287
14k
Measuring & Analyzing Core Web Vitals
Avatar for Philip Tellis bluesmoon
9
1k
The Curse of the Amulet
Avatar for Matthew Lei leimatthew05
3
15k
WCS-LA-2024
Avatar for Leonardo Collado-Torres lcolladotor
0
880
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
1
1.2k
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
301
52k
Redefining SEO in the New Era of Traffic Generation
Avatar for Szymon Słowik szymonslowik
1
470
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
350
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
5.3M

Transcript

  1. @LukasFittl data.visualize! # FIXME: Needs paradigm shiſt.

  2. Biz + UX + Dev @LukasFittl

  3. Recently: pganalyze.com usercycle.com

  4. Data Collection Data Storage Interface & Graphs

  5. Data Collection Data Storage Interface & Graphs

  6. Interface & Graphs

  7. Interface & Graphs

  8. Interface & Graphs !=

  9. Oh, its a button/label/slider/link! Interface & Graphs

  10. Forget fancy graphs, what are you displaying? Interface & Graphs

  11. Interface & Graphs

  12. Interface & Graphs

  13. Interface & Graphs

  14. Let The User Explore. Interface & Graphs

  15. Interface & Graphs

  16. Interface & Graphs

  17. Interface & Graphs

  18. Interface & Graphs d3.js —

  19. Interface & Graphs d3.js

  20. But, its complicated, kind of like vi(m). Interface & Graphs

  21. Interface & Graphs Rickshaw

  22. Interface & Graphs github.com/pganalyze/pgdatagraph

  23. Data Storage Interface & Graphs Data Collection

  24. Tracking Scripts Data Collection

  25. Data Collection Tracking Cron Jobs

  26. Its (usually) a JSON hash. Data Collection

  27. Data Collection

  28. Data Collection

  29. Historic data? Different queue! Data Collection

  30. Data Collection CreateEvent AssignCohorts PushToFrontend ApiController Data Storage Small &

    Fast Tasks.

  31. Data Collection Interface & Graphs Data Storage

  32. Data Storage Step 1: Store the Raw Data

  33. Data Storage Step 2: Add Caching Tables.

  34. Data Storage query_snapshots query_snapshot_hourlies

  35. Specialized Data Models Data Storage Event Signed Up Revenue Buckets

    ....

  36. @LukasFittl Thank you! pganalyze.com