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
55
31k
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.3k
1日50万件貯まるクエリのログを活かして、SQLの生成に挑戦している話
__hiza__
7
1.6k
データ整備の優先順位付けに役立つテクニック
__hiza__
5
2.7k
データマネジメントがちょっと楽になるBigQuery監査ログの使い方
__hiza__
0
4.7k
レガシー化したdata pipelineの廃止
__hiza__
0
930
メルカリにおける分析環境整備の取り組み
__hiza__
8
7.5k
LookerのDashboardをより柔軟に作る
__hiza__
0
1.5k
Featured
See All Featured
What's in a price? How to price your products and services
michaelherold
242
11k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
34
1.7k
Building Adaptive Systems
keathley
36
2.1k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
28
1.6k
Infographics Made Easy
chrislema
239
18k
Creatively Recalculating Your Daily Design Routine
revolveconf
215
12k
Building Your Own Lightsaber
phodgson
101
6k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
29
2.6k
How GitHub Uses GitHub to Build GitHub
holman
472
290k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
34
1.9k
Fireside Chat
paigeccino
31
2.9k
Speed Design
sergeychernyshev
19
410
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͍ͩ͘͞ɻ