$30 off During Our Annual Pro Sale. View Details »

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

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

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

Hiroshi Shimoju

July 12, 2017
Tweet

More Decks by Hiroshi Shimoju

Other Decks in Programming

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