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

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

Transcript

1. ©2021 Wantedly, Inc.
   ϓϩμΫτνʔϜͱͲ͏
   ڠۀ͠෼ੳ؀ڥΛվળ͢Δ͔
   8BOUFEMZͰͷվળࣄྫ
   

   View Slide

2. ©2021 Wantedly, Inc.
   ࣗݾ঺հ
   )B[VNJ*DIJKP
   5XJUUFS!IB[VNJSS
   (JU)VC!SFSPTU
   ॴଐਪનνʔϜ!8BOUFEMZ
   ৬छόοΫΤϯυ.-0QTΤϯδχΞ
   

   View Slide

3. ©2021 Wantedly, Inc.
   ΞδΣϯμ
   ෼ੳΛऔΓר͘എܠ
   ໰୊ͱͦͷࠜݯ͸ͳʹ͔
   Ͳ͏औΓ૊Ή͔
   ·ͱΊ
   5JQT
   

   View Slide

4. ©2021 Wantedly, Inc.
   ෼ੳΛऔΓר͘എܠ
   ໰୊ͱͦͷࠜݯ͸ͳʹ͔
   Ͳ͏औΓ૊Ή͔
   ·ͱΊ
   5JQT
   

   View Slide

5. ©2021 Wantedly, Inc.
   ෼ੳΛऔΓר͘എܠ
   ϓϩμΫτνʔϜ
   ʢ࣮૷ɾσʔλઃܭɾࢪࡦ࣮ࢪɾ෼ੳʣ
   ʜ
   #JH2VFSZ
   ਪનνʔϜ
   

   View Slide

6. ©2021 Wantedly, Inc.
   ෼ੳΛऔΓר͘എܠ
   https://docs.wantedly.dev/fields/data/data-infra
   

   View Slide

7. ©2021 Wantedly, Inc.
   ෼ੳΛऔΓר͘എܠ
   ໰୊ͱͦͷࠜݯ͸ͳʹ͔
   ۩ମతʹऔΓ૊Μͩ໰୊
   ·ͱΊ
   5JQT
   

   View Slide

8. ©2021 Wantedly, Inc.
   ໰୊ϓϩμΫτ։ൃ͕ਐΉʹͭΕ෼ੳͷޮ཰͕ѱ͘ͳ͍ͬͯΔ
   ࠜݯੲ͸ϓϩμΫτ։ൃͱ෼ੳ͕ಉҰਓ෺͕ͩͬͨɺ࣌ؒɾਓؒతʹผਓ͕୲͏έʔε͕૿Ճ
   ʮσʔλͷ஌͕ࣝ஝ੵ͞Εͳ͍ʯ͕ղܾ͞ΕΔ΂͖ࣄ৅
   ໰୊ͱͦͷࠜݯ͸ͳʹ͔
   ϓϩμΫτνʔϜ
   ʢ࣮૷ɾσʔλઃܭɾࢪࡦ࣮ࢪɾ෼ੳʣ
   ʜ
   #JH2VFSZ
   ਪનνʔϜ
   

   View Slide

9. ©2021 Wantedly, Inc.
   ෼ੳΛऔΓר͘എܠ
   ໰୊ͱͦͷࠜݯ͸ͳʹ͔
   Ͳ͏औΓ૊Ή͔
   ·ͱΊ
   5JQT
   

   View Slide

10. ©2021 Wantedly, Inc.
    Ͳ͏औΓ૊Ή͔
    ࣋ଓՄೳͳܗͰղܾ͢Δ
    🙅୭͔ʹແཧͤ͞Δɾ࢓ࣄΛ૿΍͢
    🙆উखʹղܾ͞ΕΔɾࠓޙ໰୊ʹͳΒͳ͍
    ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
    ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ
    

    View Slide

11. ©2021 Wantedly, Inc.
    Ͳ͏औΓ૊Ή͔
    ՝୊ςʔϒϧɾΧϥϜͷઆ໌͕ແ͍
    ࣮૷্ͷ՝୊
    3%#্ͷςʔϒϧͷઆ໌͕ແ͍ʢྫQSFGFSFODFT ʣ
    ޠኮͷରԠ෇͚͕ͮ͠Β͍ʢྫస৬ҙཉͷΧϥϜ໊͸ʁʣ
    ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
    

    View Slide

12. ©2021 Wantedly, Inc.
    Ͳ͏औΓ૊Ή͔
    ՝୊ςʔϒϧɾΧϥϜͷઆ໌͕ແ͍
    ࣮૷্ͷ՝୊
    3%#্ͷςʔϒϧͷઆ໌͕ແ͍ʢྫQSFGFSFODFT ʣ
    ޠኮͷରԠ෇͚͕ͮ͠Β͍ʢྫస৬ҙཉͷΧϥϜ໊͸ʁʣ
    આ໌Λಉظ͢Δ࢓૊Έ͑͋͞Ε͹ɺ
    ࣮૷ͷ՝୊͕ղܾ͞ΕΔͱɺ෼ੳͷ՝୊͕ղܾ͞ΕΔ
    ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
    

    View Slide

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ʹهೖ͞ΕΔΑ͏ʹ
    

    View Slide

14. ©2021 Wantedly, Inc.
    ՝୊σʔλΛՃ޻͢ΔϨΠϠʔͰ͍͍΋ͷ͕ͳ͍
    ೥࣮ςʔϒϧͷ࡞੒͕ఆظతʹߦ͑ΔγεςϜ͕ಋೖ
    ʢBOBMZUJDTʣ
    ೥7JFXΛ(JU)VC؅ཧͰ͖Δπʔϧ͕ಋೖ͞ΕΔʢCRWʣ
    Ͳ͏औΓ૊Ή͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ
    https://docs.wantedly.dev/fields/data/data-infra
    

    View Slide

15. ©2021 Wantedly, Inc.
    ྺ࢙Λ·ͱΊΔ͜ͱʹΑΔؾ͖ͮ
    ͦΕͧΕͷπʔϧͰͷ໰୊
    BOBMZUJDTґଘؔ܎͕؅ཧͮ͠Β͍
    CRWΫΤϦ଎౓
    ϝϯςφϯείετ͕ߴ͍
    7JFXϥΠΫʹॻ͚Δ͜ͱʹ͸Ձ஋͕͋Δ
    7JFXϥΠΫʹ࣮ςʔϒϧɾґଘΛѻ͑ΔECUΛಋೖ
    Ͳ͏औΓ૊Ή͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ
    

    View Slide

16. ©2021 Wantedly, Inc.
    Ͳ͏औΓ૊Ή͔
    https://docs.wantedly.dev/fields/data/data-infra
    

    View Slide

17. ©2021 Wantedly, Inc.
    ·ͱΊ
    8BOUFEMZʹ͓͍ͯ͸
    ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
    ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛಋೖ͢Δ
    ͕ޮՌΛൃشͨ͠ɻ
    

    View Slide

18. ©2021 Wantedly, Inc.
    5JQT
    طଘπʔϧͷࣾ಺޲͚଎शձΛ࠶౓ߦ͏
    4MBDLͰEBUB@QSPCMFNΛ͚ͭΔͱ໰୊͕ू·ΔΑ͏ʹ
    ෼ੳΛ෼ੳͰ͖ΔΑ͏ʹ͢Δ
    https://marketplace.looker.com/marketplace/detail/bigquery-information-schema Λར༻
    Reacji Λར༻
    

    View Slide