Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
プロダクトチームとどう 協業し分析環境を改善するか
Search
Sponsored
·
Your Podcast. Everywhere. Effortlessly.
Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
→
Hazumi Ichijo
July 27, 2022
1.7k
2
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
プロダクトチームとどう 協業し分析環境を改善するか
https://datatech-jp.connpass.com/event/252062/
Hazumi Ichijo
July 27, 2022
Transcript
18 slides
©2021 Wantedly, Inc. ϓϩμΫτνʔϜͱͲ͏ ڠۀ͠ੳڥΛվળ͢Δ͔ 8BOUFEMZͰͷվળࣄྫ
©2021 Wantedly, Inc. ࣗݾհ )B[VNJ*DIJKP 5XJUUFS!IB[VNJSS (JU)VC!SFSPTU ॴଐਪનνʔϜ!8BOUFEMZ ৬छόοΫΤϯυ.-0QTΤϯδχΞ
©2021 Wantedly, Inc. ΞδΣϯμ ੳΛऔΓר͘എܠ ͱͦͷࠜݯͳʹ͔ Ͳ͏औΓΉ͔
·ͱΊ 5JQT
©2021 Wantedly, Inc. ੳΛऔΓר͘എܠ ͱͦͷࠜݯͳʹ͔ Ͳ͏औΓΉ͔
·ͱΊ 5JQT
©2021 Wantedly, Inc. ੳΛऔΓר͘എܠ ϓϩμΫτνʔϜ ʢ࣮ɾσʔλઃܭɾࢪࡦ࣮ࢪɾੳʣ ʜ #JH2VFSZ ਪનνʔϜ
©2021 Wantedly, Inc. ੳΛऔΓר͘എܠ https://docs.wantedly.dev/fields/data/data-infra
©2021 Wantedly, Inc. ੳΛऔΓר͘എܠ ͱͦͷࠜݯͳʹ͔ ۩ମతʹऔΓΜͩ
·ͱΊ 5JQT
©2021 Wantedly, Inc. ϓϩμΫτ։ൃ͕ਐΉʹͭΕੳͷޮ͕ѱ͘ͳ͍ͬͯΔ ࠜݯੲϓϩμΫτ։ൃͱੳ͕ಉҰਓ͕ͩͬͨɺ࣌ؒɾਓؒతʹผਓ͕୲͏έʔε͕૿Ճ ʮσʔλͷ͕ࣝੵ͞Εͳ͍ʯ͕ղܾ͞ΕΔ͖ࣄ ͱͦͷࠜݯͳʹ͔ ϓϩμΫτνʔϜ ʢ࣮ɾσʔλઃܭɾࢪࡦ࣮ࢪɾੳʣ ʜ
#JH2VFSZ ਪનνʔϜ
©2021 Wantedly, Inc. ੳΛऔΓר͘എܠ ͱͦͷࠜݯͳʹ͔ Ͳ͏औΓΉ͔
·ͱΊ 5JQT
©2021 Wantedly, Inc. Ͳ͏औΓΉ͔ ࣋ଓՄೳͳܗͰղܾ͢Δ 🙅୭͔ʹແཧͤ͞ΔɾࣄΛ૿͢ 🙆উखʹղܾ͞ΕΔɾࠓޙʹͳΒͳ͍ ੳͷ՝Λ্࣮ͷʹ͢Δ
ྺ࢙ΛৼΓฦΓɺ৽͍͠ͷΛར༻͢Δ
©2021 Wantedly, Inc. Ͳ͏औΓΉ͔ ՝ςʔϒϧɾΧϥϜͷઆ໌͕ແ͍ ্࣮ͷ՝ 3%#্ͷςʔϒϧͷઆ໌͕ແ͍ʢྫQSFGFSFODFT ʣ
ޠኮͷରԠ͚͕ͮ͠Β͍ʢྫస৬ҙཉͷΧϥϜ໊ʁʣ ੳͷ՝Λ্࣮ͷʹ͢Δ
©2021 Wantedly, Inc. Ͳ͏औΓΉ͔ ՝ςʔϒϧɾΧϥϜͷઆ໌͕ແ͍ ্࣮ͷ՝ 3%#্ͷςʔϒϧͷઆ໌͕ແ͍ʢྫQSFGFSFODFT ʣ
ޠኮͷରԠ͚͕ͮ͠Β͍ʢྫస৬ҙཉͷΧϥϜ໊ʁʣ આ໌Λಉظ͢ΔΈ͑͋͞Εɺ ࣮ͷ՝͕ղܾ͞ΕΔͱɺੳͷ՝͕ղܾ͞ΕΔ ੳͷ՝Λ্࣮ͷʹ͢Δ
©2021 Wantedly, Inc. Ͳ͏औΓΉ͔ ੳͷ՝Λ্࣮ͷʹ͢Δ # == Table Explanatio n
# # preferences Ϣʔβʔͷઃఆ߲ # # Ϣʔβʔ͝ͱͷ໌ࣔతͳઃఆ߲Λද͢ͷɻuserςʔϒϧͱ1:1ରԠ͢Δɻ # Ϣʔβʔ͝ͱͷ҉తͳઃఆ߲ʢྫ: VisitϢʔβʔɾPeopleϢʔβʔͳͲʣuser_detailsςʔϒϧʹॻ͖ࠐΉɻ # # === Column s # # i d # user_id ࣋ͪओͷϢʔβ I D # career_change_willingness_cd స৬ҙཉ(0: ͳ͠, 1: ͦͦ͜͜, 2: ΊͬͪΌ͋Δ ) # # === Deprecated Column s # # email_status ϝʔϧͷड͚औΓઃఆɻemaiL_preferencesςʔϒϧʹઃఆΛҠಈ આ໌ͷهड़ͷΠϝʔδɻ͜ΕΛύʔε͠BigQueryͷDescriptionʹهೖ͞ΕΔΑ͏ʹ
©2021 Wantedly, Inc. ՝σʔλΛՃ͢ΔϨΠϠʔͰ͍͍ͷ͕ͳ͍ ࣮ςʔϒϧͷ࡞͕ఆظతʹߦ͑ΔγεςϜ͕ಋೖ ʢBOBMZUJDTʣ 7JFXΛ(JU)VCཧͰ͖Δπʔϧ͕ಋೖ͞ΕΔʢCRWʣ Ͳ͏औΓΉ͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠ͷΛར༻͢Δ https://docs.wantedly.dev/fields/data/data-infra
©2021 Wantedly, Inc. ྺ࢙Λ·ͱΊΔ͜ͱʹΑΔؾ͖ͮ ͦΕͧΕͷπʔϧͰͷ BOBMZUJDTґଘ͕ؔཧͮ͠Β͍ CRWΫΤϦ
ϝϯςφϯείετ͕ߴ͍ 7JFXϥΠΫʹॻ͚Δ͜ͱʹՁ͕͋Δ 7JFXϥΠΫʹ࣮ςʔϒϧɾґଘΛѻ͑ΔECUΛಋೖ Ͳ͏औΓΉ͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠ͷΛར༻͢Δ
©2021 Wantedly, Inc. Ͳ͏औΓΉ͔ https://docs.wantedly.dev/fields/data/data-infra
©2021 Wantedly, Inc. ·ͱΊ 8BOUFEMZʹ͓͍ͯ ੳͷ՝Λ্࣮ͷʹ͢Δ ྺ࢙ΛৼΓฦΓɺ৽͍͠ͷΛಋೖ͢Δ ͕ޮՌΛൃشͨ͠ɻ
©2021 Wantedly, Inc. 5JQT طଘπʔϧͷ͚ࣾशձΛ࠶ߦ͏ 4MBDLͰEBUB@QSPCMFNΛ͚ͭΔͱ͕ू·ΔΑ͏ʹ ੳΛੳͰ͖ΔΑ͏ʹ͢Δ
https://marketplace.looker.com/marketplace/detail/bigquery-information-schema Λར༻ Reacji Λར༻
More Decks by Hazumi Ichijo
See All by Hazumi Ichijo
RailsとRidgepoleの マイグレを120倍早くする
hazumirr
0
490
CIを整備してメンテナンスを生成AIに任せる
hazumirr
0
1.5k
病院の情報フローを理解して、 予約〜会計の見え方が変わった話
hazumirr
1
2k
Rubyのコード削除したい時 僕がやること
hazumirr
0
310
テーブル駆動テストと状態
hazumirr
5
2.3k
オンラインテストしようと思った その日に開始できる環境を目指して
hazumirr
0
1.2k
推薦によるプロダクト改善とマイクロサービスが噛み合った話
hazumirr
2
4.9k
ChatGPTで僕が知っていることまとめ
hazumirr
3
3.2k
bqv速習会
hazumirr
6
7.3k
Featured
See All Featured
Getting science done with accelerated Python computing platforms
jacobtomlinson
2
580
Agile that works and the tools we love
rasmusluckow
331
22k
SEO Brein meetup: CTRL+C is not how to scale international SEO
lindahogenes
2
3k
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
chikuwait
0
970
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
31
10k
Large-scale JavaScript Application Architecture
addyosmani
516
110k
Digital Projects Gone Horribly Wrong (And the UX Pros Who Still Save the Day) - Dean Schuster
uxyall
2
4k
What the history of the web can teach us about the future of AI
inesmontani
PRO
3
830
Exploring anti-patterns in Rails
aemeredith
4
580
What Being in a Rock Band Can Teach Us About Real World SEO
427marketing
0
1.1k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
9
1.7k
Imperfection Machines: The Place of Print at Facebook
scottboms
270
14k