Slide 1

Slide 1 text

EXPLORATORY 1

Slide 2

Slide 2 text

2 εϐʔΧʔ നށ ܟొ Customer Succes EXPLORATORY ུྺ େֶࡏֶதʹϑʔυϩεΛݮΒͨ͢ΊʹɺֶੜஂମΛ্ཱͪ͛୅දΛ ຿ΊΔɻͦͷޙɺϏδωεΛ஌ΔͨΊʹԽֶϝʔΧʔͷσϡϙϯͱ ϑʔυςοΫܥελʔτΞοϓͰӦۀͱϚʔέςΟϯάΛܦݧɻ ΞϓϦͷ੒௕ͷͨΊʹ͸σʔλαΠΤϯε͕ඞཁͩͱײ͡ɺΞϓϦʹ ಛԽͨ͠Ϣʔβʔͷߦಈ෼ੳπʔϧΛ։ൃ͢ΔاۀʹͯɺΞϓϦۀք ͷKPI෼ੳͳͲΛ୲౰͢Δɻ ݱࡏ͸Exploratory, Inc. ͰΧελϚʔαΫηεΛ୲౰͢Δ๣Βɺσʔ λͷՄࢹԽͱ୳ࡧతσʔλ෼ੳΛઐ໳ͱͯ͠σʔλαΠΤϯεͷීٴ ʹऔΓ૊Ήɻ @ShirotoTakato

Slide 3

Slide 3 text

3 • ࣭͝໰͸zoomͷνϟοτʹ͝౤ߘ͍ͩ͘͞ɻ • ηϛφʔͷײ૝΍໾ʹཱͭ৘ใΛTwitterͰϋογϡλάΛ ͚ͭͯπΠʔτΛ͓ئ͍͠·͢ɻ #Exploratoryηϛφʔ Exploratory Hour

Slide 4

Slide 4 text

Exploratory Hour

Slide 5

Slide 5 text

ࠓिͷ࣭໰ • ܽଛ஋Λಛఆͷ஋ͰຒΊ͍ͨ • ৚݅ʹج͍ͮͯܽଛ஋ΛຒΊ͍ͨ 5

Slide 6

Slide 6 text

ࠓिͷ࣭໰ • ܽଛ஋Λಛఆͷ஋ͰຒΊ͍ͨ • ৚݅ʹج͍ͮͯܽଛ஋ΛຒΊ͍ͨ 6

Slide 7

Slide 7 text

7 ஫จͷ༏ઌ౓(Order_Priority)ͷྻ͕͋Δɻ

Slide 8

Slide 8 text

8 ஫จͷ༏ઌ౓ʹܽଛ஋ؚ͕·Ε͍ͯΔɻ

Slide 9

Slide 9 text

9 ಛผͳࣄ৘͕ͳ͍ݶΓɺ஫จͷ༏ઌ౓͸ച্ͷେ͖͞Ͱܾ·͍ͬͯΔɻ Sales Order Priority 100Ҏ্ High 10Ҏ্ Middle 10ΑΓԼ Low

Slide 10

Slide 10 text

10 ஫จͷ༏ઌ౓(Order_Priority)ʹ͸͍͔ͭ͘ͷܽଛ஋͕͋Δɻ Customer_ID Sales Order_Priority A101 220 High A102 120 A103 50 Middle A104 20 A105 8 Low A106 6

Slide 11

Slide 11 text

11 ஫จͷ༏ઌ౓͕ܽଛ஋ͷ৔߹ɺSalesΛ΋ͱʹܽଛ஋ΛຒΊ͍ͨɻ Customer_ID Sales Order_Priority A101 220 High A102 120 A103 50 Middle A104 20 A105 8 Low A106 6 Customer_ID Sales Order_Priority A101 220 High A102 120 High A103 50 Middle A104 20 Middle A105 8 Low A106 6 Low

Slide 12

Slide 12 text

12 ྻϔομϝχϡʔͷܽଛ஋Λૢ࡞͔Βɺܽଛ஋Λಛఆͷ஋ʹஔ͖׵͑ΔΛબ୒ ͢Δɻ

Slide 13

Slide 13 text

13 ྫ͑͹ɺܽଛ஋ΛຒΊΔ஋ʹ”High”Λೖྗͨ͠ͱ͢Δɻ

Slide 14

Slide 14 text

14 ͢Δͱશͯͷܽଛ஋͕ʮHighʯʹஔ͖׵Θͬͯ͠·͏ɻ͜ͷํ๏Ͱ͸৚݅ʹج ͍ͮͯܽଛ஋Λஔ͖׵͑Δ͜ͱ͕Ͱ͖ͳ͍ɻ

Slide 15

Slide 15 text

15 ྻϔομϝχϡʔ͔Β஋Λஔ͖׵͑ΔΛબͼɺ৚݅ΛࢦఆΛબ୒͢Δɻ

Slide 16

Slide 16 text

16 ৚݅Λઃఆͯ͠ஔ׵Λ࢖͏ͱ͜ͷ໰୊ΛղܾͰ͖Δʂʂ

Slide 17

Slide 17 text

17 ࠓճͷ৔߹ͷ৚݅͸Ͳ͏ͨ͠ΒΑ͍͔ʁ

Slide 18

Slide 18 text

18 ࠓճͷ৔߹͸2ͭͷ৚͕݅ඞཁʹͳΔɻ ஫จͷ༏ઌ౓͕ܽଛ஋ɹ͔ͭɹച্͕100Ҏ্ ྫ

Slide 19

Slide 19 text

19 ஫จͷ༏ઌ౓͕ܽଛ஋ɹ͔ͭɹച্͕100Ҏ্ ྫ Sales >= 100

Slide 20

Slide 20 text

20 ஫จͷ༏ઌ౓͕ܽଛ஋ɹ͔ͭɹച্͕100Ҏ্ ྫ ??

Slide 21

Slide 21 text

21 ஫จͷ༏ઌ౓͕ܽଛ஋ɹ͔ͭɹച্͕100Ҏ্ ྫ is.na(Order_Priority)

Slide 22

Slide 22 text

22 ஫จͷ༏ઌ౓͕ܽଛ஋ɹ͔ͭɹച্͕100Ҏ্ ྫ is.na(Order_Priority) & Sales >= 100

Slide 23

Slide 23 text

23 Լهͷ৚݅ࣜΛ࢖͏͜ͱͰɺ৚݅ʹج͍ͮͯܽଛ஋ΛຒΊΔ͜ͱ͕Ͱ͖Δɻ ஫จͷ༏ઌ౓͕ܽଛ஋ɹ͔ͭɹച্͕100Ҏ্ ྫ is.na(Order_Priority) & Sales >= 100

Slide 24

Slide 24 text

24 ྻϔομϝχϡʔ͔Β஋Λஔ͖׵͑ΔΛબͼɺ৚݅ΛࢦఆΛબ୒͢Δɻ

Slide 25

Slide 25 text

25 ৚݅Λઃఆͯ͠ஔ׵ͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 26

Slide 26 text

26 ৚݅ΛΫϦοΫͯ͠ΧελϜΛબ୒͢Δɻ

Slide 27

Slide 27 text

27 ܽଛ஋͔ͭച্͕100Ҏ্ͱ͍͏৚݅ࣜΛೖྗ͢Δɻ

Slide 28

Slide 28 text

28 ৚݅ʹܽଛ஋͔ͭച্͕100Ҏ্ͷ৚͕݅௥Ճ͞Εͨɻ

Slide 29

Slide 29 text

29 ৽͍͠஋ʹ”High”ͱೖྗ͢Δɻ

Slide 30

Slide 30 text

30 ܽଛ஋͔ͭച্͕100Ҏ্ͷ࣌ʹ”High”ͷ஋Λฦ͢৚͕݅ઃఆ͞Εͨɻ

Slide 31

Slide 31 text

31 ϓϥεϘλϯΛΫϦοΫͯ͠৽͍͠৚݅Λ࡞੒͢Δɻ

Slide 32

Slide 32 text

32 ܽଛ஋͔ͭച্͕10Ҏ্ͱ͍͏৚݅ࣜΛೖྗ͢Δɻ

Slide 33

Slide 33 text

33 ৚݅ʹܽଛ஋͔ͭച্͕100Ҏ্ͷ৚͕݅௥Ճ͞Εͨɻ

Slide 34

Slide 34 text

34 ৽͍͠஋ʹ”Middle”ͱೖྗ͢Δɻ

Slide 35

Slide 35 text

35 ܽଛ஋͔ͭച্͕10Ҏ্ͷ࣌ʹ”Middle”ͷ஋Λฦ͢৚͕݅ઃఆ͞Εͨɻ

Slide 36

Slide 36 text

36 ϓϥεϘλϯΛΫϦοΫͯ͠৽͍͠৚݅Λ࡞੒͢Δɻ

Slide 37

Slide 37 text

37 ܽଛ஋͔ͭച্͕10ΑΓԼͱ͍͏৚݅ࣜΛೖྗ͢Δɻ

Slide 38

Slide 38 text

38 ৚݅ʹܽଛ஋͔ͭച্͕10ΑΓԼͷ৚͕݅௥Ճ͞Εͨɻ

Slide 39

Slide 39 text

39 ৽͍͠஋ʹ”Low”ͱೖྗ͢Δɻ

Slide 40

Slide 40 text

40 ܽଛ஋͔ͭച্͕10ΑΓԼͷ࣌ʹ”Low”ͷ஋Λฦ͢৚͕݅ઃఆ͞Εͨɻ

Slide 41

Slide 41 text

41 ઃఆͨ͠৚݅Ҏ֎(ܽଛ஋Ͱͳ͍)৔߹͸ɺݱࡏͷྻͷ஋Λฦ͍ͨ͠ɻ

Slide 42

Slide 42 text

42 ৽͍͠஋ʹྻ໊ͷOrder_PriorityΛೖྗ͢Δɻ

Slide 43

Slide 43 text

43 શͯͷ৚݅ͱ৽͍͠஋Λࢦఆ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 44

Slide 44 text

44 ৽͘͠ྻΛ࡞੒ʹνΣοΫΛͯ͠೚ҙͷྻ໊Λೖྗ͢Δɻ

Slide 45

Slide 45 text

45 ܽଛ஋Λ৚݅ʹج͍ͮͯຒΊΔ͜ͱ͕Ͱ͖ͨɻ

Slide 46

Slide 46 text

46 αϚϦɾϏϡʔͰΈͯ΋ܽଛ஋͕ͳ͍͜ͱ͕֬ೝͰ͖Δɻ

Slide 47

Slide 47 text

σʔλϥϯάϦϯάɾτϨʔχϯά 12݄։࠵ʂ EXPLORATORY

Slide 48

Slide 48 text

12݄ΦϯϥΠϯ։࠵ʂ ฏ೔൛: 12݄17೔(໦), 18೔(ۚ)

Slide 49

Slide 49 text

No content

Slide 50

Slide 50 text

No content

Slide 51

Slide 51 text

12݄ΦϯϥΠϯ։࠵ʂ ฏ೔൛: 12݄1೔(Ր), 2೔(ਫ), 3೔(໦)

Slide 52

Slide 52 text

No content

Slide 53

Slide 53 text

Q & A

Slide 54

Slide 54 text

Contact Email [email protected] Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory Hour https://bit.ly/30odd9q

Slide 55

Slide 55 text

EXPLORATORY