Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

Hazumi Ichijo
July 27, 2022
840

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

Hazumi Ichijo

July 27, 2022
Tweet

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Ͱmail protected]Λ͚ͭΔͱ໰୊͕ू·ΔΑ͏ʹ  ෼ੳΛ෼ੳͰ͖ΔΑ͏ʹ͢Δ

    https://marketplace.looker.com/marketplace/detail/bigquery-information-schema Λར༻ Reacji Λར༻