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

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

Hazumi Ichijo
July 27, 2022
1.2k

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

Hazumi Ichijo

July 27, 2022
Tweet

Transcript

  1. ©2021 Wantedly, Inc. Ͳ͏औΓ૊Ή͔ ՝୊ςʔϒϧɾΧϥϜͷઆ໌͕ແ͍ ࣮૷্ͷ՝୊  3%#্ͷςʔϒϧͷઆ໌͕ແ͍ʢྫQSFGFSFODFT ʣ 

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

    ޠኮͷରԠ෇͚͕ͮ͠Β͍ʢྫస৬ҙཉͷΧϥϜ໊͸ʁʣ આ໌Λಉظ͢Δ࢓૊Έ͑͋͞Ε͹ɺ ࣮૷ͷ՝୊͕ղܾ͞ΕΔͱɺ෼ੳͷ՝୊͕ղܾ͞ΕΔ ෼ੳͷ՝୊Λ࣮૷্ͷ໰୊ʹ͢Δ
  3. ©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ʹهೖ͞ΕΔΑ͏ʹ
  4. ©2021 Wantedly, Inc. ྺ࢙Λ·ͱΊΔ͜ͱʹΑΔؾ͖ͮ  ͦΕͧΕͷπʔϧͰͷ໰୊  BOBMZUJDTґଘؔ܎͕؅ཧͮ͠Β͍  CRWΫΤϦ଎౓

     ϝϯςφϯείετ͕ߴ͍  7JFXϥΠΫʹॻ͚Δ͜ͱʹ͸Ձ஋͕͋Δ 7JFXϥΠΫʹ࣮ςʔϒϧɾґଘΛѻ͑ΔECUΛಋೖ Ͳ͏औΓ૊Ή͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ