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

Redash Meetup #2の発表資料です

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