データ分析その前に〜Redashでデータ可視化からはじめよう / Data visualization by Redash

Web現場Meetup〜GMOペパボ×ピクスタ〜エンジニアによる技術・組織改善の裏側
https://pixta-inc.connpass.com/event/59395/

Transcript

1. 3FEBTIͰσʔλՄࢹԽ͔Β͸͡ΊΑ͏
   Լॏതࢿ(.01FQBCP *OD
   8FCݱ৔.FFUVQ
   σʔλ෼ੳͦͷલʹ
   

   View Slide

2. ΤϯδχΞ ೥౓৽ଔೖࣾ
   
   Լॏതࢿ!TIJNPKV@
   &$ࣄۀ෦46;63*νʔϜ
   TIJNPKVPSH
   

   View Slide

3. View Slide

4. View Slide

5. ʮ8FCݱ৔.FFUVQʯ
   

   View Slide

6. ʮʰݱ৔ʱͰى͖ͨ
   ʰٕज़վળʱͱʰ૊৫վળʱ
   ͷ͓࿩ʯ
   

   View Slide

7. ·ͩ഑ଐ͔Β൒೥
   ͦΜͳͷ͋Δʜʁ
   ৽ଔΤϯδχΞ͸೥಺·ͰݚमͰɺ഑ଐ͸݄Ͱ͢
   
   

   View Slide

8. ഑ଐ௚ޙͷ՝୊
   

   View Slide

9. ഑ଐ௚ޙͷ՝୊
   wάοζͷചΕے΍ͲΜͳ࡞ऀ͕ਓؾͳͷ͔ɺ

   46;63*͕͍·ͲΜͳঢ়ଶͳͷ͔Θ͔Βͳ͍
   

   View Slide

10. ഑ଐ௚ޙͷ՝୊
    wάοζͷചΕے΍ͲΜͳ࡞ऀ͕ਓؾͳͷ͔ɺ

    46;63*͕͍·ͲΜͳঢ়ଶͳͷ͔Θ͔Βͳ͍
    wͱ͍͏͔ͦ΋ͦ΋औΕ͍ͯͳ͍਺ࣈ͕ଟ͍ͧʜ
    wूܭ͕ඞཁͳͱ͖͸ɺ͍͍ͪͪσΟϨΫλʔ͕Τϯδ
    χΞʹґཔͯ͠σʔλूܭ͍ͯͨ͠
    

    View Slide

11. σʔλ෼ੳɺͦͷલʹʜʜ
    wσʔλ෼ੳʹ΋ڵຯ͕͋Δ͕೉ͦ͠͏
    wͦ΋ͦ΋σʔλ͕औΕ͍ͯͳ͍͠ɺ

    ເͷ·ͨເͳͷͰ͸ʁʁʁ
    w·ͣσʔλ෼ੳͷͨΊͷجૅΛͭ͘Ζ͏
    

    View Slide

12. ָʹूܭɾՄࢹԽͰ͖ͯɺ
    ͍ͭͰʹࣗಇԽ͍ͨ͠ʂ
    

    View Slide

13. View Slide

14. 3FEBTIͱ͸
    wσʔλͷՄࢹԽͱڞ༗ͷͨΊͷιϑτ΢ΣΞ
    wϒϥ΢β͔Β؆୯ʹ42-Λ࣮ߦɾڞ༗ɾάϥϑԽͰ͖ɺ
    ͦΕΒΛ·ͱΊͨμογϡϘʔυΛ࡞ΕΔ
    w؆қతͳ؅ཧը໘ͷΑ͏ͳΠϝʔδ
    

    View Slide

15. View Slide

16. View Slide

17. View Slide

18. 3FEBTIͷ͍͍ͱ͜Ζ
    wπʔϧࣗମͷ࢖͍ํ͸΄΅֮͑ͳ͍͍ͯ͘΄Ͳγϯϓ
    ϧͰɺ42-͑͞ॻ͚Ε͹࢖͑Δ
    w8FC6*ͰΫΤϦΛฤूͰ͖ΔͨΊɺ

    ʮൿ఻ͷ42-ʯΛΈΜͳʹڞ༗Ͱ͖Δ
    wඇΤϯδχΞͰ΋ѻ͍΍͍͢
    

    View Slide

19. ϖύϘͱ3FEBTI
    wશࣾతʹಋೖ͕ਐΜͰ͓Γศརͱ͍͏੠Λฉ͍͍ͯͨ
    wࣄۀ෦ͷ3FEBTIΠϯελϯε͕طʹ͋ͬͨͨΊɺ

    ͦ͜ʹಉډ͢Δ͜ͱʹͯ͠εϐʔυಋೖ
    wϊ΢ϋ΢ڞ༗͠΍͍͢
    

    View Slide

20. ಋೖ͢Δ
    w4BB4൛ͱηϧϑϗετ 044
    ൛͕͋Δ
    wηϧϑϗετ൛ʹ͸"84($&༻Πϝʔδ͕͋Δ΄͔ɺ
    %PDLFSΠϝʔδ΋༻ҙ͞Ε͍ͯΔ
    wηϧϑϗετͷ%PDLFS൛Λར༻͍ͯ͠Δ
    

    View Slide

21. ઃఆ
    

    View Slide

22. ઃఆ
    w؀ڥม਺ͰઃఆΛߦ͏
    w%PDLFSͰಈ͔͍ͯ͠Δ৔߹ɺ

    EPDLFSDPNQPTFZNMͷFOWʹॻ͘
    w͜͜Β΁Μʹ࢖͑ͦ͏ͳઃఆ߲໨͕͋Δ
    wIUUQTHJUIVCDPNHFUSFEBTISFEBTICMPCNBTUFSSFEBTI
    TFUUJOHTQZ
    

    View Slide

23. 3&%"4)@%"5&@'03."5
    wσϑΥϧτͰ͸೔෇͕%%..::ܗࣜͰಡΈʹ͍͘
    w::::..%%ʹ͢Δ
    w3&%"4)@%"5&@'03."5::::..%%
    

    View Slide

24. 3&%"4)@'&"563&@4)08@1&3.*44*0/4@$0/530-
    wฤूݖݶͷઃఆ͕Ͱ͖ΔΑ͏ʹͳΔ
    wΫΤϦ΍μογϡϘʔυΛڞಉฤूͰ͖Δ
    w3&%"4)@'&"563&@4)08@1&3.*44*0/4@$0/530-USVF
    

    View Slide

25. 3&%"4)@"--08@4$3*154@*/@64&3@*/165
    wμογϡϘʔυͰϑΥʔϜ͕࢖͑ΔΑ͏ʹͳΔ
    wϑΥʔϜΛ࢖ͬͯநग़ର৅݄Λࢦఆͨ͠Γɺ
    +BWB4DSJQUͰ%BUF1JDLFSΛೖΕͨΓͰ͖Δ
    w3&%"4)@"--08@4$3*154@*/@64&3@*/165USVF
    

    View Slide

26. 5JQT
    

    View Slide

27. ϦϯΫ
    w63-·ͨ͸BλάΛฦ͢Α͏ʹ͢ΔͱϦϯΫʹͳΔ
    wϢʔβʔҰཡΛදࣔ͢ΔΫΤϦͰɺαΠτͷϢʔβʔ
    ϖʔδ΍؅ཧը໘ʹϦϯΫͨ͠ΓͳͲ
    

    View Slide

28. View Slide

29. ύϥϝʔλ
    wΫΤϦதʹ\\QBSBN^^ͱॻ͘ͱɺ೚ҙͷύϥϝʔλΛ
    ౉࣮ͯ͠ߦ͢Δ͜ͱ͕Ͱ͖Δ
    wϑΥʔϜʹೖྗ͢Δ͔2VFSZTUSJOHͰ౉͢
    w೥݄΍ϢʔβʔΛࢦఆ͍ͨ͠ͱ͖ʹศར
    

    View Slide

30. View Slide

31. ϑΥʔϜ
    wμογϡϘʔυ্ʹϑΥʔϜΛهड़Ͱ͖Δ
    

    View Slide

32. ಋೖͯ͠Ͳ͏ͩͬͨʁ
    

    View Slide

33. ΂ΜΓ
    wҰ౓ΫΤϦΛ࡞Ε͹ɺΤϯδχΞͷखΛआΓͣʹৗʹ
    ࠷৽ͷ৘ใΛࢀরͰ͖Δ ఆظ࣮ߦ΋Ͱ͖Δ
    
    w೔࣍ɾ݄࣍Ͱग़͢σʔλͳͲɺਵ࣌࠷৽ͷ৘ใ͕ඞཁ
    ʹͳΔ΋ͷʹޮՌ͕ग़͍ͯΔ
    wʮࡢ೔ͷച্ৄࡉʯʮ݄ผͷϢʔβʔ਺ʯͳͲ
    

    View Slide

34. ΤϯδχΞҎ֎͔Β
    wඇΤϯδχΞ΋σʔλϕʔεΛѻ͍΍͘͢ͳΔ
    wσΟϨΫλʔ΍$4͕ΫΤϦΛॻ͘ྫ͕૿͑ͨ
    wطଘͷΫΤϦΛίϐʔ͍ͯ͠͡Δͱ͔͜Β࢝ΊΒΕΔ
    

    View Slide

35. ࠓޙ΍Γ͍ͨ͜ͱ
    

    View Slide

36. (PPHMF"OBMZUJDT࿈ܞ
    w3FEBTI͔Β(PPHMF"OBMZUJDTΛσʔλιʔεʹ
    Ͱ͖Δ
    wʹΞοϓσʔτͰ͖͍ͯͳ͍ʜʜ
    w"OBMZUJDTͷσʔλͱ૊Έ߹ΘͤͨΓ͍ͨ͠
    

    View Slide

37. 4MBDL࿈ܞ
    w࣮ߦ݁ՌΛ4MBDL௨஌Ͱ͖ͯɺάϥϑ΋දࣔͰ͖Δ
    w4MBDL͔Β3FEBTIʹΞΫηεͰ͖Δඞཁ͕͋Δ
    wݱঢ়͸ࣾ಺ΞΫηεͷΈʹ੍ݶ
    wIUUQEBUBHVOPTZJPFOUSZTMBDLSFEBTILQJOPUJGZ
    

    View Slide

38. σʔλ෼ੳ
    wࠓճ͸σʔλूܭɺՄࢹԽͰ͖͚ͨͩ
    wσʔλ෼ੳͷϨϕϧ·ͰਂΊɺ਺஋Λݩʹͨ͠ࢪࡦఏ
    ҊͳͲʹͭͳ͍͛ͨ
    wूܭ݁ՌΛ૊Έ߹ΘͤͨΓɺ3Λ׆༻ͨ͠ΓͳͲ
    wIUUQUFDIQFQBCPDPNNJOOFSFEBTIEBTICPBSE
    

    View Slide

39. ·ͱΊ
    

    View Slide

40. ·ͱΊ
    w3FEBTIͰσʔλՄࢹԽɾ෼ੳͷجૅΛ࡞ͬͨ
    wʮσʔλ෼ੳ͸೉ͦ͠͏ʜʯ

    ˠ·ͣ͸ൿ఻ͷ42-Λڞ༗ͯ͠ՄࢹԽ͠Α͏
    wࣗಇԽͨ͠෼ͷ࣌ؒΛ։ൃʹ࢖͑Δʂ༏উʂʂ
    

    View Slide