プロダクトチームとどう 協業し分析環境を改善するか

https://datatech-jp.connpass.com/event/252062/

Transcript

1. ©2021 Wantedly, Inc. ϓϩμΫτνʔϜͱͲ͏
   ڠۀ͠෼ੳ؀ڥΛվળ͢Δ͔ 8BOUFEMZͰͷվળࣄྫ
2. ©2021 Wantedly, Inc. ࣗݾ঺հ )B[VNJ
   *DIJKP
   5XJUUFS
   !IB[VNJSS
   (JU)VC
   !SFSPTU
   ॴଐ
   ਪનνʔϜ!8BOUFEMZ
   
   ৬छ
   όοΫΤϯυ.-0QT
   ΤϯδχΞ
3. ©2021 Wantedly, Inc. ΞδΣϯμ  ෼ੳΛऔΓר͘എܠ
    ໰୊ͱͦͷࠜݯ͸ͳʹ͔
    Ͳ͏औΓ૊Ή͔
    ·ͱΊ
    5JQT
4. ©2021 Wantedly, Inc.  ෼ੳΛऔΓר͘എܠ
    ໰୊ͱͦͷࠜݯ͸ͳʹ͔
    Ͳ͏औΓ૊Ή͔
    ·ͱΊ
    5JQT
5. ©2021 Wantedly, Inc. ෼ੳΛऔΓר͘എܠ ϓϩμΫτνʔϜ
   
   
   ʢ࣮૷ɾσʔλઃܭɾࢪࡦ࣮ࢪɾ෼ੳʣ ʜ #JH2VFSZ ਪનνʔϜ
6. ©2021 Wantedly, Inc. ෼ੳΛऔΓר͘എܠ https://docs.wantedly.dev/fields/data/data-infra
7. ©2021 Wantedly, Inc.  ෼ੳΛऔΓר͘എܠ
    ໰୊ͱͦͷࠜݯ͸ͳʹ͔
    ۩ମతʹऔΓ૊Μͩ໰୊
    ·ͱΊ
    5JQT
8. ©2021 Wantedly, Inc. ໰୊
   ϓϩμΫτ։ൃ͕ਐΉʹͭΕ෼ੳͷޮ཰͕ѱ͘ͳ͍ͬͯΔ
   ࠜݯ
   ੲ͸ϓϩμΫτ։ൃͱ෼ੳ͕ಉҰਓ෺͕ͩͬͨɺ࣌ؒɾਓؒతʹผਓ͕୲͏έʔε͕૿Ճ
   
   ʮσʔλͷ஌͕ࣝ஝ੵ͞Εͳ͍ʯ͕ղܾ͞ΕΔ΂͖ࣄ৅ ໰୊ͱͦͷࠜݯ͸ͳʹ͔ ϓϩμΫτνʔϜ
   
   
   ʢ࣮૷ɾσʔλઃܭɾࢪࡦ࣮ࢪɾ෼ੳʣ ʜ #JH2VFSZ ਪનνʔϜ
9. ©2021 Wantedly, Inc.  ෼ੳΛऔΓר͘എܠ
    ໰୊ͱͦͷࠜݯ͸ͳʹ͔
    Ͳ͏औΓ૊Ή͔
    ·ͱΊ
    5JQT
10. ©2021 Wantedly, Inc. Ͳ͏औΓ૊Ή͔ ࣋ଓՄೳͳܗͰղܾ͢Δ
    🙅
    ୭͔ʹແཧͤ͞Δɾ࢓ࣄΛ૿΍͢
    🙆
    উखʹղܾ͞ΕΔɾࠓޙ໰୊ʹͳΒͳ͍  ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
     ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ
11. ©2021 Wantedly, Inc. Ͳ͏औΓ૊Ή͔ ՝୊
    ςʔϒϧɾΧϥϜͷઆ໌͕ແ͍
    ࣮૷্ͷ՝୊  3%#্ͷςʔϒϧͷઆ໌͕ແ͍ʢྫ
    QSFGFSFODFT
    ʣ
     ޠኮͷରԠ෇͚͕ͮ͠Β͍ʢྫ
    స৬ҙཉͷΧϥϜ໊͸ʁʣ ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
12. ©2021 Wantedly, Inc. Ͳ͏औΓ૊Ή͔ ՝୊
    ςʔϒϧɾΧϥϜͷઆ໌͕ແ͍
    ࣮૷্ͷ՝୊  3%#্ͷςʔϒϧͷઆ໌͕ແ͍ʢྫ
    QSFGFSFODFT
    ʣ
     ޠኮͷରԠ෇͚͕ͮ͠Β͍ʢྫ
    స৬ҙཉͷΧϥϜ໊͸ʁʣ
    આ໌Λಉظ͢Δ࢓૊Έ͑͋͞Ε͹ɺ
    ࣮૷ͷ՝୊͕ղܾ͞ΕΔͱɺ෼ੳͷ՝୊͕ղܾ͞ΕΔ ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
13. ©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ʹهೖ͞ΕΔΑ͏ʹ
14. ©2021 Wantedly, Inc. ՝୊
    σʔλΛՃ޻͢ΔϨΠϠʔͰ͍͍΋ͷ͕ͳ͍
    ೥
    ࣮ςʔϒϧͷ࡞੒͕ఆظతʹߦ͑ΔγεςϜ͕ಋೖ ʢBOBMZUJDTʣ
    ೥
    7JFXΛ(JU)VC؅ཧͰ͖Δπʔϧ͕ಋೖ͞ΕΔʢCRWʣ Ͳ͏औΓ૊Ή͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ https://docs.wantedly.dev/fields/data/data-infra
15. ©2021 Wantedly, Inc. ྺ࢙Λ·ͱΊΔ͜ͱʹΑΔؾ͖ͮ
     ͦΕͧΕͷπʔϧͰͷ໰୊
     BOBMZUJDT
    ґଘؔ܎͕؅ཧͮ͠Β͍
     CRW
    
    
    
    
    
    
    
    
    ΫΤϦ଎౓
     ϝϯςφϯείετ͕ߴ͍
     7JFXϥΠΫʹॻ͚Δ͜ͱʹ͸Ձ஋͕͋Δ 
    7JFXϥΠΫʹ࣮ςʔϒϧɾґଘΛѻ͑ΔECUΛಋೖ Ͳ͏औΓ૊Ή͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ
16. ©2021 Wantedly, Inc. Ͳ͏औΓ૊Ή͔ https://docs.wantedly.dev/fields/data/data-infra
17. ©2021 Wantedly, Inc. ·ͱΊ 8BOUFEMZʹ͓͍ͯ͸
     ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
     ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛಋೖ͢Δ
    ͕ޮՌΛൃشͨ͠ɻ
18. ©2021 Wantedly, Inc. 5JQT 
    طଘπʔϧͷࣾ಺޲͚଎शձΛ࠶౓ߦ͏
     4MBDLͰ
    EBUB@QSPCMFN
    Λ͚ͭΔͱ໰୊͕ू·ΔΑ͏ʹ
     ෼ੳΛ෼ੳͰ͖ΔΑ͏ʹ͢Δ
    https://marketplace.looker.com/marketplace/detail/bigquery-information-schema Λར༻ Reacji Λར༻