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
70
43k
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
2.1k
1日50万件貯まるクエリのログを活かして、SQLの生成に挑戦している話
__hiza__
7
2k
データ整備の優先順位付けに役立つテクニック
__hiza__
5
3.2k
データマネジメントがちょっと楽になるBigQuery監査ログの使い方
__hiza__
0
5.6k
レガシー化したdata pipelineの廃止
__hiza__
0
1k
メルカリにおける分析環境整備の取り組み
__hiza__
8
8k
LookerのDashboardをより柔軟に作る
__hiza__
0
1.6k
Featured
See All Featured
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
31
2.2k
A better future with KSS
kneath
239
17k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
60k
Fashionably flexible responsive web design (full day workshop)
malarkey
407
66k
Learning to Love Humans: Emotional Interface Design
aarron
273
40k
YesSQL, Process and Tooling at Scale
rocio
173
14k
Being A Developer After 40
akosma
90
590k
Scaling GitHub
holman
462
140k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
7
810
What’s in a name? Adding method to the madness
productmarketing
PRO
23
3.6k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.4k
Optimising Largest Contentful Paint
csswizardry
37
3.4k
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͍ͩ͘͞ɻ