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
41
18k
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.4k
データ整備の優先順位付けに役立つテクニック
__hiza__
5
2.4k
データマネジメントがちょっと楽になるBigQuery監査ログの使い方
__hiza__
0
4.3k
レガシー化したdata pipelineの廃止
__hiza__
0
830
メルカリにおける分析環境整備の取り組み
__hiza__
7
7.1k
LookerのDashboardをより柔軟に作る
__hiza__
0
1.4k
Featured
See All Featured
Robots, Beer and Maslow
schacon
PRO
155
8k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
155
14k
The Mythical Team-Month
searls
217
42k
For a Future-Friendly Web
brad_frost
172
9k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
245
20k
A Modern Web Designer's Workflow
chriscoyier
689
190k
Git: the NoSQL Database
bkeepers
PRO
423
63k
Producing Creativity
orderedlist
PRO
338
39k
Rails Girls Zürich Keynote
gr2m
91
13k
Embracing the Ebb and Flow
colly
80
4.2k
Code Review Best Practice
trishagee
56
15k
The Pragmatic Product Professional
lauravandoore
26
5.9k
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͍ͩ͘͞ɻ