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

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

Avatar for Hazumi Ichijo Hazumi Ichijo
July 27, 2022
1.5k

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

Avatar for Hazumi Ichijo

Hazumi Ichijo

July 27, 2022
Tweet

More Decks by Hazumi Ichijo

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Λಋೖ Ͳ͏औΓ૊Ή͔ ྺ࢙ΛৼΓฦΓɺ৽͍͠΋ͷΛར༻͢Δ