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

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

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

Redash Meetup #2の発表資料です

More Decks by Shoichiro Nagai(shnagai)

Other Decks in Technology

Transcript

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

    View Slide

  2. ࣗݾ঺հ
    ӬҪউҰ࿠
    ίωώτגࣜձࣾΤϯδχΞ

    Πϯϑϥɾ΢ΣϒΦϖϨʔγϣϯ
    5XJUUFS!TIOBHBJ


    2JJUBIUUQTRJJUBDPNOBHBJT

    ϒϩάIUUQLPCJUPTBOIBUFOBCMPHDPN
    ௚ۙͷ৬ྺɿ
    Ұٳ.comɹ 7೥
    ίωώτ ࡢ೥5݄ʹjoin

    View Slide

  3. αʔϏε঺հ ϚϚϦ

    View Slide

  4. αʔϏε঺հ ن໛

    View Slide

  5. ࠓ೔ͷ͸ͳ͠

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  10. σʔλ෼ੳͷ೰Έ͋Δ͋Δͳঢ়ଶ

    View Slide

  11. w ίωώτࣾһ͸ͦΕͧΕʹྑ͍ײ֮ ܦݧɾצ

    Λ͍࣋ͬͯͨ

    αʔϏεͷϢʔβ૚Ͱ͋ΔϚϚ͕ࣾ಺ʹଟ͍

    ࣾһ͕αʔϏεΛ৮Δ࣌ؒΛຖ೔ઃ͚͍ͯΔ

    ϢʔβΠϯλϏϡʔ΋શࣾһͰ࣮ࢪ
    w σΟϨΫλʔத৺ʹఆྔతͳ෼ੳʹجͮ͘ҙࢥ
    ܾఆ
    σʔλຽओԽલ എܠ

    View Slide

  12. σʔλΛ࢖ͬͯݕূͰ͖ͨΒྑ͠ѱ͠Λ൑அ͠΍͍͢ʂ
    ˣ
    σʔλग़ͤͳ͍ͱʮߴ౓ʹ٧Ίͯߟ͑ͳ͖Ό͍͚ͳ͍ʯ

    ˣ
    ʮσʔλΛग़͢ʯʹ͸ɺਓʹґཔ͠ͳ͍ͱ͍͚ͳ͍͔Βɺ
    ʮґཔίετ͕ߴ͍ʯͱ͍͏ѱ॥؀ɾɾɾ

    σʔλΛग़ͤΔਓ΋ͦΕ͕ϝΠϯۀ຿Ͱ͸ͳ͍ͷͰޙճ͠ʹͳΓ͕ͪ
    σʔλΛ࢖ͬͯݕূ͍ͨ͠ͱͳΔͱ

    View Slide

  13. ΞΠσΞΛ࣮ݱ͢Δલஈͷίετ͕ߴ͍ঢ়ଶ

    View Slide

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

    View Slide

  15. ͳͥ3FEBTI

    View Slide

  16. w ௿ίετ &$Πϯελϯε୅ͷΈ

    طʹUBCMFBV͸ಋೖ͍͕ͯͨ͠ɺશһͰ࢖͏ʹ͸ίετ͕ɻɻ
    w (PPHMFೝূ ࣾһͳΒ୭Ͱ΋ݟΕΔ

    w &$".*Λར༻͠γεςϜӡ༻ίετ΄΅θϩ
    3FEBTIͷྑ͍ͱ͜Ζӡ༻໘

    View Slide

  17. w ඪ४Ͱ༷ʑͳσʔλιʔεʹܨ͗͜Έ͕ग़དྷΔ
    w ΫΤϦͷ࠶ར༻ GPSLͰ؆୯ʹग़དྷΔ

    ଞͷਓͷΫΤϦ͔Βֶशग़དྷΔ
    w 63-γΣΞϦϯά ύʔϚϦϯΫ

    ࣗ෼ͷԾઆΛؾܰʹ63-ͰγΣΞग़དྷΔ
    w શͯ42-Ͱ׬݁ ͦͷ··ϏδϡΞϥΠζ

    w εέδϡʔϧ࣮ߦ
    w ௨஌ɺ$47ΤΫεϙʔτ
    3FEBTIͷྑ͍ͱ͜Ζػೳ໘

    View Slide

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

    View Slide

  19. w ΄΅શࣾһूΊͯσʔλຽओԽϓϨθϯ
    w ͱಉ࣌ʹϛχϚϜͷϋϯζΦϯ

    શһʹϩάΠϯ࣮੷Λ࡞ͬͯ΋Β͏
    w ܧଓతͳ৘ใڞ༗πʔϧ΁ͷΞ΢τϓοτ
    w 3FEBTIͰࠔ͍ͬͯΔਓ͕͍ͨΒर͍·͘Δ
    ࣾ಺΁ͷܒ໤ϓϩηε

    View Slide

  20. ೉͍͠ӡ༻ϧʔϧ͸͋͑ͯ࡞Βͣ
    ͱʹ͔͘࢖ͬͯ΋Β͏ࣄΛॏࢹ

    View Slide

  21. ݁Ռ༷ʑͳಈ͖͕

    View Slide

  22. σʔλ΁ͷΞΫηε͕༰қʹͳͬͨ͜ͱͰৼΓฦΓʹ׆༻







    ࢪࡦͷޮՌଌఆৼΓฦΓʹ

    View Slide

  23. λάΫϥ΢υΛ࢖ͬͨϢʔβΠϯαΠτͷ෼ੳ







    ӦۀఏҊͷࡐྉʹ

    View Slide

  24. w ༗ࢤͰͷ42-ษڧձͷ޿͕Γ
    w ৬छ໰Θ༷ͣʑͳਓ͕3FEBTIͰΫΤϦΛॻ͍
    ͯ෼ੳ

    Ӧۀ΍σΟϨΫλʔ͕ॻ͍͍ͯΔΫΤϦΛோΊΔͱֶͼ͋Δ
    ඇΤϯδχΞʹΑΔࣗൃతͳσʔλ෼ੳ

    View Slide

  25. ୭Ͱ΋ࣗ༝ʹσʔλʹΞΫηεग़དྷΔੈք

    View Slide

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

    View Slide

  27. w ԿͰ΋3FEBTIͰ෼ੳग़དྷΔͱ͍͏ݬ૝

    ຐ๏ͷπʔϧΈ͍ͨͳɻɻ

    దࡐదॴ 5BCMFBV NJYQBOFM

    wಉ͡Α͏ͳΫΤϦͷྔ࢈

    ໋໊ଇͷมߋ

    3FEBTIͷΫΤϦڞ༗ձ
    wఆੑతΞϓϩʔνͷݟ௚͠

    ఆྔ෼ੳ͕ਐΜͩ͜ͱʹΑΓ

    վΊͯ69ΛֶΜͰ͍͜͏ͱ͍͏ྲྀΕ͕ग़ͨΓ
    ৽ͨͳ՝୊

    View Slide

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

    View Slide

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

    View Slide

  30. ຖ೔ͷखಈ࡞ۀΛࣗಈԽ

    SFEBTI͕ΫΤϦຖʹൃߦ͢Δ"1*

    εϓϨουγʔτͷA*.1035%"5"A






    ᶃεϓϨουγʔτͷσʔλߋ৽ࣗಈԽ

    View Slide

  31. ΫΤϦΛॻ͖άϥϑΛ࡞੒

    3FEBTIඪ४ͷ4MBDL#PU

    4MBDLͷ3FNJOEػೳ






    ᶄ4MBDL࿈ܞͰຖ೔άϥϑΛఆ఺؍ଌ

    View Slide

  32. w ݄ʹҰ౓ूܭͯ͠$47ܗࣜͰఏग़

    ूܭ༻ΫΤϦΛ࡞੒

    εέδϡʔϧػೳΛ࢖͍݄Ұ࣮ߦʹઃఆ

    $47"1*ܦ༝Ͱμ΢ϯϩʔυ
    ᶅ݄࣍ϨϙʔτͷࣗಈԽ

    View Slide

  33. ͍ΘΏΔࣗಈԽ΋࣮ݱ

    View Slide

  34. 3FEBTIͷӡ༻5*14

    View Slide

  35. 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࠷ߴʂʂ

    View Slide

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

    View Slide

  37. w &$Ͱఏڙ͞Ε͍ͯΔ".*ར༻
    w FOWͱOHJOYͷઃఆͷΈΧελϚΠζ

    SFEBTIͰఆٛ͞Ε͍ͯΔ؀ڥม਺

    OHJOYͰ44-ϦμΠϨΫτ
    wΞοϓάϨʔυ࣌Ҏ֎΄΅ϝϯςφϯεϨε

    ΫΤϦौ଺ͷղফͱ͔͸͋Δ

    ൺֱతڧΊͷΠϯελϯε NMBSHF

    ᶅγεςϜӡ༻ෛՙ͕ѹ౗తʹ௿͍

    View Slide

  38. w WˠWɺWˠWͱೋ౓࣮ࢪ
    w τϥϒϧແ͠Ͱ࡞ۀ࣌ؒ͸௕ͯ͘΋࣌ؒఔ౓

    &$ΠϝʔδόοΫΞοϓ

    ΞοϓάϨʔυεΫϦϓτ࣮ߦ͢Δ͚ͩ

    DEPQUSFEBTIDVSSFOUTVEPCJOVQHSBEF

    ࣦഊͨ͠৔߹͸ɺόοΫΞοϓͨ͠Πϝʔδ͔Β&$ىಈ
    wଓʑվྑ͞Ε͍ͯΔͷͰ৐͔͍ͬͬͯ͘
    ᶆ༰қͳΞοϓάϨʔυ

    View Slide

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

    View Slide

  40. w 6*͕վྑ͞Ε͔ͯͳΓ៉ྷʹͳͬͯΔ

    ຖ೔ݟΔ΋ͷ͔ͩΒେࣄ

    μογϡϘʔυͷϨΠΞ΢τ͕ࣗ༝ʹ
    w ͜Ε͔Β࢝ΊΔͳΒW͕Φεεϝ
    3FEBTIW

    View Slide

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

    View Slide