データドリブンな意思決定を支えるredash活用事例/ Data driven and redash

by Shoichiro Nagai(shnagai)

Slide 1

Slide 1 text

$POOFIJUP*ODӬҪউҰ࿠ ϚϚͷҰาΛࢧ͑Δ σʔλυϦϒϯͳҙࢥܾఆΛࢧ͑Δ 3FEBTI׆༻ࣄྫ

Slide 2

Slide 2 text

ࣗݾ঺հ ӬҪউҰ࿠ ίωώτגࣜձࣾΤϯδχΞ  Πϯϑϥɾ΢ΣϒΦϖϨʔγϣϯ 5XJUUFS!TIOBHBJ    2JJUBIUUQTRJJUBDPNOBHBJT  ϒϩάIUUQLPCJUPTBOIBUFOBCMPHDPN ௚ۙͷ৬ྺɿ Ұٳ.comɹ 7೥ ίωώτ ࡢ೥5݄ʹjoin

Slide 3

Slide 3 text

αʔϏε঺հ ϚϚϦ

Slide 4

Slide 4 text

αʔϏε঺հ ن໛

Slide 5

Slide 5 text

ࠓ೔ͷ͸ͳ͠

Slide 6

Slide 6 text

σʔλຽओԽ΁ͷಓےͱ ͦͷதͰಘͨ3FEBTIӡ༻पΓͷ஌ݟ ʹ͍͓ͭͯ࿩͠·͢

Slide 7

Slide 7 text

w ίωώτࣾͰͷσʔλຽओԽࣄྫ w 3FEBTIΛ࢖ͬͨۀ຿վળ5*14 w 3FEBTIͷӡ༻5*14 ΞδΣϯμ

Slide 8

Slide 8 text

ίωώτࣾͰͷσʔλຽओԽࣄྫ

Slide 9

Slide 9 text

w σʔλ͕৭ʑͳͱ͜Ζʹଘࡏ͓ͯ͠ΓɺͲ͜ʹ Կ͕͋Δͷ͔Θ͔Βͳ͍ w ΤϯδχΞ΍σʔλʹৄ͍͠σΟϨΫλʔʹґ པ͠ͳ͍ͱσʔλ͕ग़ͤͳ͍ w நग़σʔλͷอଘઌ͕ଟछଟ༷ͰετοΫ͕ग़ དྷͳ͍ ౰๊͍࣌͑ͯͨσʔλपΓͷ՝୊

Slide 10

Slide 10 text

σʔλ෼ੳͷ೰Έ͋Δ͋Δͳঢ়ଶ

Slide 11

Slide 11 text

w ίωώτࣾһ͸ͦΕͧΕʹྑ͍ײ֮ ܦݧɾצ Λ͍࣋ͬͯͨ  αʔϏεͷϢʔβ૚Ͱ͋ΔϚϚ͕ࣾ಺ʹଟ͍  ࣾһ͕αʔϏεΛ৮Δ࣌ؒΛຖ೔ઃ͚͍ͯΔ  ϢʔβΠϯλϏϡʔ΋શࣾһͰ࣮ࢪ w σΟϨΫλʔத৺ʹఆྔతͳ෼ੳʹجͮ͘ҙࢥ ܾఆ σʔλຽओԽલ എܠ

Slide 12

Slide 12 text

σʔλΛ࢖ͬͯݕূͰ͖ͨΒྑ͠ѱ͠Λ൑அ͠΍͍͢ʂ ˣ σʔλग़ͤͳ͍ͱʮߴ౓ʹ٧Ίͯߟ͑ͳ͖Ό͍͚ͳ͍ʯ  ˣ ʮσʔλΛग़͢ʯʹ͸ɺਓʹґཔ͠ͳ͍ͱ͍͚ͳ͍͔Βɺ ʮґཔίετ͕ߴ͍ʯͱ͍͏ѱ॥؀ɾɾɾ  σʔλΛग़ͤΔਓ΋ͦΕ͕ϝΠϯۀ຿Ͱ͸ͳ͍ͷͰޙճ͠ʹͳΓ͕ͪ σʔλΛ࢖ͬͯݕূ͍ͨ͠ͱͳΔͱ

Slide 13

Slide 13 text

ΞΠσΞΛ࣮ݱ͢Δલஈͷίετ͕ߴ͍ঢ়ଶ

Slide 14

Slide 14 text

σʔλग़͠ʹର͢ΔෑډΛԼ͛ΔͨΊ ʮσʔλຽओԽʯͱ໏ଧͬͯ 3FEBTIΛશࣾಋೖ

Slide 15

Slide 15 text

ͳͥ3FEBTI

Slide 16

Slide 16 text

w ௿ίετ &$Πϯελϯε୅ͷΈ   طʹUBCMFBV͸ಋೖ͍͕ͯͨ͠ɺશһͰ࢖͏ʹ͸ίετ͕ɻɻ w (PPHMFೝূ ࣾһͳΒ୭Ͱ΋ݟΕΔ w &$".*Λར༻͠γεςϜӡ༻ίετ΄΅θϩ 3FEBTIͷྑ͍ͱ͜Ζӡ༻໘

Slide 17

Slide 17 text

w ඪ४Ͱ༷ʑͳσʔλιʔεʹܨ͗͜Έ͕ग़དྷΔ w ΫΤϦͷ࠶ར༻ GPSLͰ؆୯ʹग़དྷΔ   ଞͷਓͷΫΤϦ͔Βֶशग़དྷΔ w 63-γΣΞϦϯά ύʔϚϦϯΫ   ࣗ෼ͷԾઆΛؾܰʹ63-ͰγΣΞग़དྷΔ w શͯ42-Ͱ׬݁ ͦͷ··ϏδϡΞϥΠζ w εέδϡʔϧ࣮ߦ w ௨஌ɺ$47ΤΫεϙʔτ 3FEBTIͷྑ͍ͱ͜Ζػೳ໘

Slide 18

Slide 18 text

௿ίετͰ͔ͭඞཁͳػೳ͸΄΅໢ཏ

Slide 19

Slide 19 text

w ΄΅શࣾһूΊͯσʔλຽओԽϓϨθϯ w ͱಉ࣌ʹϛχϚϜͷϋϯζΦϯ  શһʹϩάΠϯ࣮੷Λ࡞ͬͯ΋Β͏ w ܧଓతͳ৘ใڞ༗πʔϧ΁ͷΞ΢τϓοτ w 3FEBTIͰࠔ͍ͬͯΔਓ͕͍ͨΒर͍·͘Δ ࣾ಺΁ͷܒ໤ϓϩηε

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

w ༗ࢤͰͷ42-ษڧձͷ޿͕Γ w ৬छ໰Θ༷ͣʑͳਓ͕3FEBTIͰΫΤϦΛॻ͍ ͯ෼ੳ  Ӧۀ΍σΟϨΫλʔ͕ॻ͍͍ͯΔΫΤϦΛோΊΔͱֶͼ͋Δ ඇΤϯδχΞʹΑΔࣗൃతͳσʔλ෼ੳ

Slide 25

Slide 25 text

୭Ͱ΋ࣗ༝ʹσʔλʹΞΫηεग़དྷΔੈք

Slide 26

Slide 26 text

Ұํɺු͔ͼ্͕͖ͬͯͨ՝୊΋ɻɻ

Slide 27

Slide 27 text

w ԿͰ΋3FEBTIͰ෼ੳग़དྷΔͱ͍͏ݬ૝  ຐ๏ͷπʔϧΈ͍ͨͳɻɻ  దࡐదॴ 5BCMFBV NJYQBOFM wಉ͡Α͏ͳΫΤϦͷྔ࢈  ໋໊ଇͷมߋ  3FEBTIͷΫΤϦڞ༗ձ wఆੑతΞϓϩʔνͷݟ௚͠  ఆྔ෼ੳ͕ਐΜͩ͜ͱʹΑΓ  վΊͯ69ΛֶΜͰ͍͜͏ͱ͍͏ྲྀΕ͕ग़ͨΓ ৽ͨͳ՝୊

Slide 28

Slide 28 text

σʔλຽओԽͷจԽΛৢ੒͢ΔͨΊͷ ܧଓతΞϓϩʔνΛ͜Ε͔Β΋

Slide 29

Slide 29 text

3FEBTIΛ࢖ͬͨۀ຿վળ5*14

Slide 30

Slide 30 text

ຖ೔ͷखಈ࡞ۀΛࣗಈԽ  SFEBTI͕ΫΤϦຖʹൃߦ͢Δ"1*  εϓϨουγʔτͷA*.1035%"5"A            ᶃεϓϨουγʔτͷσʔλߋ৽ࣗಈԽ

Slide 31

Slide 31 text

ΫΤϦΛॻ͖άϥϑΛ࡞੒  3FEBTIඪ४ͷ4MBDL#PU  4MBDLͷ3FNJOEػೳ            ᶄ4MBDL࿈ܞͰຖ೔άϥϑΛఆ఺؍ଌ

Slide 32

Slide 32 text

w ݄ʹҰ౓ूܭͯ͠$47ܗࣜͰఏग़  ूܭ༻ΫΤϦΛ࡞੒  εέδϡʔϧػೳΛ࢖͍݄Ұ࣮ߦʹઃఆ  $47"1*ܦ༝Ͱμ΢ϯϩʔυ ᶅ݄࣍ϨϙʔτͷࣗಈԽ

Slide 33

Slide 33 text

͍ΘΏΔࣗಈԽ΋࣮ݱ

Slide 34

Slide 34 text

3FEBTIͷӡ༻5*14

Slide 35

Slide 35 text

w 3FEBTI্ͰҟͳΔσʔλιʔεΛ+0*/ग़དྷΔ  3FEBTIΠϯελϯε্ͷ42-JUFͰಈ͘  #JH2VFSZ3%4 εϓϨουγʔτ1ZUIPOͱ͔  ࣮ߦ࣌ʹݺͼग़͢ΫΤϦͷϦϑϨογϡ͔͔Δ  42-ߏจͰ+0*/    ྫ   4&-&$5BOBNF CDPVOU  '30.RVFSZ@BΫΤϦ*% #JH2VFSZ   +0*/RVFSZ@CΫΤϦ*% 3%4   0/BJECJE ᶃ2VFSZ3FTVMU࠷ߴʂʂ

Slide 36

Slide 36 text

w ςΩετͰݟ͍ͯΔσʔλ΋ϏδϡΞϥΠζ͢ Δͱ৽ͨͳؾ෇͖͕ ᶄͻͱ·ͣϏδϡΞϥΠζͯ͠ΈΔͷ΋Ұख

Slide 37

Slide 37 text

w &$Ͱఏڙ͞Ε͍ͯΔ".*ར༻ w FOWͱOHJOYͷઃఆͷΈΧελϚΠζ  SFEBTIͰఆٛ͞Ε͍ͯΔ؀ڥม਺  OHJOYͰ44-ϦμΠϨΫτ wΞοϓάϨʔυ࣌Ҏ֎΄΅ϝϯςφϯεϨε  ΫΤϦौ଺ͷղফͱ͔͸͋Δ  ൺֱతڧΊͷΠϯελϯε NMBSHF ᶅγεςϜӡ༻ෛՙ͕ѹ౗తʹ௿͍

Slide 38

Slide 38 text

w WˠWɺWˠWͱೋ౓࣮ࢪ w τϥϒϧແ͠Ͱ࡞ۀ࣌ؒ͸௕ͯ͘΋࣌ؒఔ౓  &$ΠϝʔδόοΫΞοϓ  ΞοϓάϨʔυεΫϦϓτ࣮ߦ͢Δ͚ͩ  DEPQUSFEBTIDVSSFOUTVEPCJOVQHSBEF  ࣦഊͨ͠৔߹͸ɺόοΫΞοϓͨ͠Πϝʔδ͔Β&$ىಈ wଓʑվྑ͞Ε͍ͯΔͷͰ৐͔͍ͬͬͯ͘ ᶆ༰қͳΞοϓάϨʔυ

Slide 39

Slide 39 text

ӡ༻͸ΊͪΌͪ͘Όָʂʂ

Slide 40

Slide 40 text

w 6*͕վྑ͞Ε͔ͯͳΓ៉ྷʹͳͬͯΔ  ຖ೔ݟΔ΋ͷ͔ͩΒେࣄ  μογϡϘʔυͷϨΠΞ΢τ͕ࣗ༝ʹ w ͜Ε͔Β࢝ΊΔͳΒW͕Φεεϝ 3FEBTIW

Slide 41

Slide 41 text

w σʔλຽओԽπʔϧͱͯ͠3FEBTI͸ͪΐ͏Ͳ ͍͍ w ӡ༻ίετ͕΄΅͔͔Βͳ͍ͷͰɺಉ͡Α͏ͳ χʔζ͕͋Ε͹ࢼͯ͠ΈΔͷ͕Φεεϝ ·ͱΊ