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
64
38k
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
Analytics Engineeringチームを立ち上げて学んだこと
__hiza__
4
1.8k
1日50万件貯まるクエリのログを活かして、SQLの生成に挑戦している話
__hiza__
7
1.7k
データ整備の優先順位付けに役立つテクニック
__hiza__
5
2.9k
データマネジメントがちょっと楽になるBigQuery監査ログの使い方
__hiza__
0
5.2k
レガシー化したdata pipelineの廃止
__hiza__
0
990
メルカリにおける分析環境整備の取り組み
__hiza__
8
7.7k
LookerのDashboardをより柔軟に作る
__hiza__
0
1.5k
Featured
See All Featured
Done Done
chrislema
182
16k
Agile that works and the tools we love
rasmusluckow
328
21k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
129
19k
Building Applications with DynamoDB
mza
93
6.2k
The Cult of Friendly URLs
andyhume
78
6.2k
The Straight Up "How To Draw Better" Workshop
denniskardys
232
140k
Git: the NoSQL Database
bkeepers
PRO
427
64k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
21
2.5k
Optimising Largest Contentful Paint
csswizardry
34
3.1k
Thoughts on Productivity
jonyablonski
69
4.5k
GraphQLの誤解/rethinking-graphql
sonatard
68
10k
BBQ
matthewcrist
87
9.5k
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͍ͩ͘͞ɻ