Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Analytics Engineeringチームの目標管理
Search
nagai shinya
November 16, 2023
36
17k
Analytics Engineeringチームの目標管理
発表した場所:
https://timeedev.connpass.com/event/299088/
発表者:
https://twitter.com/__hiza__
nagai shinya
November 16, 2023
Tweet
Share
More Decks by nagai shinya
See All by nagai shinya
1日50万件貯まるクエリのログを活かして、SQLの生成に挑戦している話
__hiza__
7
1.3k
データ整備の優先順位付けに役立つテクニック
__hiza__
5
2.3k
データマネジメントがちょっと楽になるBigQuery監査ログの使い方
__hiza__
0
4.2k
レガシー化したdata pipelineの廃止
__hiza__
0
810
メルカリにおける分析環境整備の取り組み
__hiza__
7
7.1k
LookerのDashboardをより柔軟に作る
__hiza__
0
1.4k
Featured
See All Featured
Raft: Consensus for Rubyists
vanstee
132
6.3k
A designer walks into a library…
pauljervisheath
200
23k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
501
140k
Faster Mobile Websites
deanohume
299
30k
What the flash - Photography Introduction
edds
64
11k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
187
16k
Six Lessons from altMBA
skipperchong
21
3k
The Power of CSS Pseudo Elements
geoffreycrofte
60
5k
Why Our Code Smells
bkeepers
PRO
331
56k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
352
28k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
116
18k
Ruby is Unlike a Banana
tanoku
96
10k
Transcript
1 Analytics EngineeringνʔϜͷ ඪཧ 2023/11/16 Nagai Shinya (@_ _hiza_ _)
2 • Α͘ߦ͍ͬͯΔඪཧ ◦ νʔϜ͕࡞ͬͨπʔϧͷར༻ਓ (KPI) ◦ ࣮ࡍʹͬͨਓʹͱཱ͍ͬͯͬͯͦ͏͔? (ώΞϦϯά) •
എܠʹ͋Δߟ͑ํ ◦ ʮຊͷՌଌΕͳ͍ʯ ◦ ͰͲ͏͢Δ͔? ຊͷςʔϚ Analytics EngineeringνʔϜͷඪཧࣄྫ
3 ϝϧΧϦ BI productνʔϜ ͍ΘΏΔAnalytics Engineeringʹׂ͍ۙΛͬͨνʔϜ • ओཁͳϓϩδΣΫτ ◦ ABςετͷࣗಈԽ
◦ BIπʔϧ(Looker)ͷ։ൃͱల։ ◦ σʔλϞσϦϯά ◦ BigQueryͷίετݮͱσʔλύΠϓϥΠϯͷҠߦ • νʔϜߏ ◦ Ϛωʔδϟʔ1໊ɺϝϯόʔ7໊
4 Lookerͷ։ൃɺల։ ϓϩδΣΫτͱͦͷඪઃఆͷࣄྫ
5 ϓϩδΣΫτͷࣄྫ : Lookerͷ։ൃɺల։ ඪ : SQL͕ॻ͚ͳͯ͘σʔλੳ͕Ͱ͖ΔΑ͏ʹ͢Δ • ՝ :
SQLൈ͖Ͱσʔλ͕ੳͰ͖ͳ͔ͬͨ ◦ PdM͔ΒΞφϦετʹରͯ͠୯७ͳूܭͷґཔ͕ଟ͔ͬͨɻ ◦ ϦʔυλΠϜ͕͘ͳΔɻ ◦ ΞφϦετ͕ίΞͳੳʹऔΓΉ͕࣌ؒݮΔɻ • ղܾࡦ ◦ LookerΛల։ͯ͠PdM͕ηϧϑαʔϏεͰੳͰ͖ΔΑ͏ʹ͢Δɻ
6 ϓϩδΣΫτͷࣄྫ : Lookerͷ։ൃɺల։ Lookerͷར༻ऀΛKPIʹઃఆ LookerͷWAU(Weekly Active User)͕ओཁͳKPI ඞཁʹԠͯ͡ •
ར༻νʔϜͷੳ • ར༻ظؒɺճͷੳ
7 ώΞϦϯάʹΑΓूܭ ͷूܭ͕LookerͰର Ԡग़དྷ͍ͯͨɻ ͔ͳΓޮԽʹܨ͕ͬͯͦ ͏ɻ ϓϩδΣΫτͷࣄྫ : Lookerͷ։ൃɺల։ ಛఆͷPJͰൃੜͨ͠ੳχʔζͷԿׂ͕LookerͰରԠͰ͖͔ͨ?
8 ϓϩδΣΫτͷࣄྫ : Lookerͷ։ൃɺల։ • ϞχλϦϯάͱํमਖ਼ ◦ KPIώϦϯά݁Ռ͕ѱԽˠࠓ͍ͬͯΔࢪࡦʹԿ͔͕͋Δɻ ◦ ํੑΛݟ͢ɻ
• ධՁͱใࠂ ◦ PJશମͱͯ͠ྑ͍݁Ռ͕ग़ͨͷ͔? ▪ νʔϜͷৼΓฦΓɻ ▪ ܦӦʹର͢Δઆ໌ɻ ඪΛͲ͏׆͔͍ͯ͠Δͷ͔?
9 ඪઃఆͷҙਤ LookerϓϩδΣΫτͷࣄྫΛ௨ͯ͡
10 • ձ͕࣮ࣾݱ͍ͨ͜͠ͱԿ͔? ◦ ͓٬༷Ձͷ্ɺऩӹΞοϓ ◦ ͯ͢ձࣾͷ֎Ͱ͔͠ಘΒΕͳ͍ɻ ◦ ʮՌ৫ͷ֎෦ʹ͔͋͠Γ͑ͳ͍ʯϐʔλʔɾυϥοΧʔ •
νʔϜ͕ࢦ͖͢ͷ ◦ ձࣾͷ֎ʹ·ͰΠϯύΫτΛग़͢͜ͱɻ ◦ ඪઃఆɺ͜ͷʮՌʯʹ͔͍ͬͯΔͷ͔ଌΔπʔϧͰ͋Δ͖ ग़ൃͱͯ͠େࣄʹ͍ͯ͠Δߟ͑ํ ʮՌձࣾͷ֎ʹ͋Δʯ
11 ඪઃఆͷ͍͠ϙΠϯτ ຊͷʮՌʯఆྔతʹଌΕͳ͍ ࢲୡ͕࣮ݱ͍ͨ͜͠ͱ PdM͕ࣗੳͰ͖ΔΑ͏ʹͳ ͬͨ͜ͱͰɺސ٬Ձऩӹ͕ ͲΕ͘Β͍Ξοϓͨ͠ͷ͔? ͦͷҼՌΛ٬؍త͔ͭఆྔతʹ ଌΕΔͷ͕ཧɻ →
ݶΓͳ͘ࠔɻ PdM͕ࣗ ੳͰ͖Δ ސ٬Ձ ্ ऩӹΞοϓ ࣾΛվળͨ͠! ͦͷޮՌ͕ٴͯ͠ ࠷ऴతʹࣾ֎ͰͷՌʹ!
12 ࢪࡦʹඞཁͳ ใΛPdM͕ ͙͢௫ΊΔ ଌΕͳ͍ຊͷՌʹͲ͏ͨ͠Β͚ۙͮΔ͔? ᶃ Ռʹ͍ͨΔετʔϦʔΛඳ্͍ͨͰɺͦͷ్தͷΛࣈͰଌΔ(KPI) ސ٬Ձ ্ ऩӹΞοϓ
ΑΓ ࣭ͷߴ͍վળ ͕ग़ͤΔ ͓٬༷ͷ ཧղ͕ਂ·Δ PdM͕ࣗ ੳͰ͖Δ ΞφϦετ͕ ߴͳੳʹ ूதͰ͖Δ “Ռ” Ռʹ͍ͨΔετʔϦʔ ͜Ε͘Β͍ͩͬͨΒଌΕΔ = Lookerར༻ऀΛKPIʹ ͜͜ΛଌΔͷࠔ ͜Ε͚ͩͩͱɺར༻ͷྔ ͔࣭͔ͬͯΒͳ͍ɻ
13 ࢪࡦʹඞཁͳ ใΛPdM͕ ͙͢௫ΊΔ ଌΕͳ͍ຊͷՌʹͲ͏ͨ͠Β͚ۙͮΔ͔? ᶄ ࣈͰදݱ͖͠Εͳ͍෦ΛώΞϦϯάͰิ͏ ސ٬Ձ ্ ऩӹΞοϓ
ΑΓ ࣭ͷߴ͍վળ ͕ग़ͤΔ ͓٬༷ͷ ཧղ͕ਂ·Δ PdM͕ࣗ ੳͰ͖Δ ΞφϦετ͕ ߴͳੳʹ ूதͰ͖Δ “Ռ” Ռʹ͍ͨΔετʔϦʔ ͜Ε͘Β͍ͩͬͨΒଌΕΔ = Lookerར༻ऀΛKPIʹ ͜͜ΛଌΔͷࠔ ͍ͬͯΔ͚ͩͰͳ͘ʮʹཱ͍ͬͯΔ͔?ʯΛώΞϦϯάɻ ΠϝʔδతʹάϨʔͷൣғ
14 ඪઃఆͷҙਤ : ·ͱΊ ᶃ Ռʹ͍ͨΔετʔϦʔͷཧ ᶄ ଌΕΔͱ͜Ζ·ͰKPIͰ ᶅ ͦͷઌώΞϦϯάͰ
15 ࢲ͕ߟ͑ΔඪઃఆͷΞϯνύλʔϯ • ٬؍తʹଌΕΔՌ͚ͩΛٻΊΔͱͲ͏ͳΔ͔? ◦ ଌఆ͍͢͠ʮίετݮʯʹߦ͖ண͖͕ͪɻ ◦ ͕͔ͩͦ͜ΒʮຊۀͷՌΛՃͤ͞ΔऔΓΈʯ͕ੜ·Εͳ͍ ▪ ʮຊۀͷՌʯଟͷ৬ೳΛԣஅͯ͠࡞ΔͷɻՌͷߩݙ͕٬؍తʹΓ͚ΒΕ
ͳ͍ɻ • ώΞϦϯάʹዞҙੑ͕ͱͳ͏ ◦ ʮʹཱ͔ͬͨ?ʯओ؍తͳใʹΑΔධՁͰ͋Γɺᐆດɻ ◦ ͚ͩͲͦΕͰ͍͍ɻ٬؍ใͰͯ͢அͰ͖ΔͳΒਓؒͷϚωʔδϟʔඞཁͳ͍ɻ [Ξϯνύλʔϯ] ٬؍తʹଌΕΔՌΛٻΊͨ݁Ռɺίετݮʹߦ͖ண͘
16 • Α͘ߦ͍ͬͯΔඪཧ ◦ νʔϜ͕࡞ͬͨπʔϧͷར༻ਓ (KPI) ◦ ࣮ࡍʹͬͨਓʹͱཱ͍ͬͯͬͯͦ͏͔? (ώΞϦϯά) •
എܠʹ͋Δߟ͑ํ ◦ ʮຊͷՌଌΕͳ͍ʯ ◦ ͰͲ͏͢Δ͔? ◦ → Ռʹ͍ͨΔετʔϦʔΛߟ͑ɺࣈͰଌΕΔॴଌΓɺଌΕͳ ͍ॴώΞϦϯά͠ɺ࠷ޙਓ͕ՌΛஅ͢Δɻ ·ͱΊ
17 @_ _hiza_ _ https://twitter.com/__hiza__ ͜ͷςʔϚʹ͍ͭͯΧδϡΞϧʹ͍ͨ͠ํ͕ډͨΒ ͓ؾܰʹDM͍ͩ͘͞ɻ