Exploratory Hour #98 - バーとラインを組み合わせたチャートを作りたい

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

• ಉ͡จষͷதͰ࢖ΘΕΔ୯ޠͷ૊Έ߹ΘͤΛʮάϧʔϓ͝ͱʯʹू ܭ͍ͨ͠ • όʔͱϥΠϯΛ૊Έ߹ΘͤͨνϟʔτΛ࡞Γ͍ͨ ࠓिͷ࣭໰

Slide 6

Slide 6 text

• ಉ͡จষͷதͰ࢖ΘΕΔ୯ޠͷ૊Έ߹ΘͤΛʮάϧʔϓ͝ͱʯʹू ܭ͍ͨ͠ • όʔͱϥΠϯΛ૊Έ߹ΘͤͨνϟʔτΛ࡞Γ͍ͨ ࠓिͷ࣭໰

Slide 7

Slide 7 text

7 ച্σʔλ

Slide 8

Slide 8 text

8 ҰͭͷνϟʔτͷதͰɺόʔͱϥΠϯΛҰॹʹՄࢹԽ͍ͨ͠

Slide 9

Slide 9 text

9 ͦͷ݄ͷ͓͚Δച্ ച্ͷྦྷੵ߹ܭ

Slide 10

Slide 10 text

10 • λΠϓʹόʔΛબ୒͢Δɻ • X࣠ʹ஫จ೔Λબͼɺूܭ୯ҐʹؙΊॲཧͷ݄ Λબ୒͢Δɻ • Y࣠ʹച্Λબͼɺूܭؔ਺ʹ߹ܭ஋ʢSUMʣ Λબ୒͢Δɻ

Slide 11

Slide 11 text

11 Y࣠ʹ৽ͨʹʮച্ʯΛ௥Ճ͠ɺूܭؔ਺ʹ͸߹ܭ஋ʢSUMʣΛબ୒͢Δɻ

Slide 12

Slide 12 text

12 Y࣠ͷ2ͭ໨ͷ஋ͷϝχϡʔ͔ΒʮϚʔΧʔʯΛબ୒͢Δɻ

Slide 13

Slide 13 text

13 ϚʔΧʔͷλΠϓʹʮϥΠϯʯΛબ୒͢Δɻ

Slide 14

Slide 14 text

14 2ͭ໨ͷY࣠ͷച্͕ϥΠϯͰՄࢹԽ͞Εͨɻ

Slide 15

Slide 15 text

15 2ͭ໨ͷY࣠ͷϝχϡʔ͔ΒΫΠοΫදܭࢉͷʮྦྷੵ߹ܭ஋ʯΛબ୒͢Δɻ

Slide 16

Slide 16 text

16 ച্ͷྦྷੵ߹ܭ஋ΛՄࢹԽ͢Δ͜ͱ͕Ͱ͖ͨɻ͔͠͠ɺY࣠ͷϨϯδ͕ҟͳͬ ͍ͯΔͷͰɺόʔͷಈ͖͕ಡΈऔΓͮΒ͍ɻ

Slide 17

Slide 17 text

17 ྦྷੵ߹ܭ஋ͷY࣠ͷϝχϡʔ͔ΒY1/Y2࣠ͷࢦఆΛબ୒͢Δɻ

Slide 18

Slide 18 text

18 Y2࣠ʹׂΓ౰ͯΔʹνΣοΫΛ͢Δɻ

Slide 19

Slide 19 text

19 ݄ຖͷച্ΛόʔͰɺച্ͷྦྷੵ߹ܭ஋ΛϥΠϯͰՄࢹԽ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 20

Slide 20 text

࣍ճηϛφʔ

Slide 21

Slide 21 text

EXPLORATORY ΦϯϥΠϯɾηϛφʔ #41 ͳͥExcelϢʔβʔ͸ ExploratoryΛ࢖͏΂͖ͳͷ͔

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

No content

Slide 27

Slide 27 text

• ϏδωεͰ࢖͑Δࢥߟྗͷҭ੒ σʔλαΠΤϯεͷεΩϧशಘ͚ͩͰͳ͘ɺσʔλΛ࢖ͬͨΑΓΑ͍ҙࢥܾఆΛߦ͏ͨ Ίʹඞཁͳ౷ܭతɾ֬཰తࢥߟྗ΋शಘͰ͖Δɻ • ݱ৔Ͱ࢖͑ΔεΩϧͷशಘ ڭࣨͷத͚ͩͰ௨༻͢Δཧ࿦ΑΓ΋ɺ࣮ࡍͷϏδωεͷݱ৔Ͱͷ໰୊Λղܾ͢ΔͨΊʹ ࢖͑ΔεΩϧͷशಘʹॏ৺Λ͓͍ͨτϨʔχϯάɻ • ϓϩάϥϛϯάͳ͠ RݴޠͷUIͰ͋ΔExploratoryΛ෼ੳπʔϧͱͯ͠࢖༻͢ΔͨΊɺࢥߟྗͱσʔλαΠΤϯ εͷख๏ͷशಘʹ100ˋूதͰ͖Δɻ ಛ௃

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

No content

Slide 31

Slide 31 text

Q & A

Slide 32

Slide 32 text

Contact Email takato@exploratory.io Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory Hour https://bit.ly/30odd9q

Slide 33

Slide 33 text

EXPLORATORY