「データ分析」の解像度を上げたい / wanna-understand-data-analysis

by Yuya Matsumura

Slide 1

Slide 1 text

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

©2020 Wantedly, Inc. • ৽ઃͷʮσʔλ෼ੳʯνʔϜʹϏδωενʔϜ͔Βͷ SQL ࡞੒ґཔ͕ࡴ౸͠ ͯຊདྷߦ͍͍ͨʮσʔλ෼ੳʯ͕ߦ͑ͳ͍ɻ • ʮઌ݄ͷചΓ্͛͸͍͘Β͔ʁʯͱฉ͔ΕͯʮʓʓສԁͰ͢ɻʯͱճ౴ͨ͠ ΒɼʮͰɼ݁ہͦΕͬͯͲ͏ͳͷ…ʁʯͱϚωʔδϟʹݴΘΕͯ͠·ͬͨɻ • Kaggle ͰιϩۜΛ֫ಘ͍ͯͨͨ͠Ίे෼ͳʮσʔλ෼ੳʯͷྗ͕͋Δͱ൑ அͯ͠ʮσʔλ෼ੳʯνʔϜͷΠϯλʔϯʹݺΜֶͩੜ͕͍·͍ͪ׆༂Ͱ͖ ͳ͔ͬͨɻ ͍ۤܦݧͨͪʢϑΟΫγϣϯʣ

Slide 6

Slide 6 text

Slide 7

Slide 7 text

Slide 8

Slide 8 text

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

Slide 15

Slide 15 text

©2020 Wantedly, Inc. ʮࠓظͷ໨ඪ͸Ϣʔβͷܧଓ཰Λ্͛Δ͜ͱʯ ʮϢʔβͷܧଓ཰ͱ click ͸ڧ͍ਖ਼ͷ૬ؔΛ࣋ͭʯ ʮաڈʹΦϑϥΠϯධՁʹ͓͍ͯ MAP ͕105%ʹͳͬͨϥ ϯΩϯάʹΑͬͯclick ਺͕110%ʹͳͬͨ͜ͱ͕͋Δʯ ʰA or Bʱͱ͍͏໰͍ʹରͯ͠ղΛग़͢ͷʹඞཁͳཁૉ ࣄ࣮ = ਺ࣈ ൑அج४ ʮΦϑϥΠϯධՁʹ͓͍ͯ click Λਖ਼ղͱͨ͠ MAP ͕ 110% ʹͳͬͨʯ ʰA or Bʱͱ͍͏໰͍ ʮ͜ͷ༧ଌϞσϧͰ࡞ΒΕΔϥϯΩϯά͸ ࠓΑΓྑ͍ʁʯ ղ ʮYesʯ

Slide 16

Slide 16 text

Slide 17

Slide 17 text

©2020 Wantedly, Inc. 1.ʰA or Bʱͱ͍͏໰͍ • ͜Ε͕ͳ͍ͱͦ΋ͦ΋ʮσʔλ෼ੳʯͰ͖ͳ͍ɻ • Ϗδωε՝୊Λ෼ੳ՝୊ʹམͱ͠ࠐΉ຋༁ऀͱ͔ݴΘΕΔ΍ͭʁϏδωεྗɻ • ந৅తͳʢࡶͳʣ໰͍Λ͜͜·ͰϒϨΠΫμ΢ϯͯ͠ઃܭ͢Δඞཁ͕͋Δ͜ͱ΋ɻ ຊ౰ʹ஌Γ͍ͨ͜ͱΛਪ͠ྔΔೳྗ͕ඞཁɻ • ex.ʮઌ݄ͷച্͸͍͘Βʁʯ-> ʮച্͸৳ͼ͍ͯΔͱݴ͑Δͷ͔ʁʯ • ΋ͪΖΜɼͦ΋ͦ΋σʔλΛूܭͯ͠ʮࣄ࣮ʹ਺ࣈʯΛग़͚ͩ͢Ͱ͍͍৔߹΋ɻ • ex. ϏδωενʔϜ͔ΒͷSQL࡞੒ґཔʢͷҰ෦ʣ

Slide 1

Slide 1 text

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

Slide 8

Slide 8 text

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

Slide 15

Slide 15 text

Slide 16

Slide 16 text

Slide 17

Slide 17 text

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

Slide 24

Slide 24 text

Slide 25

Slide 25 text