データ分析その前に〜Redashでデータ可視化からはじめよう / Data visualization by Redash
by
Hiroshi Shimoju
Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
Slide 1
Slide 1 text
3FEBTIͰσʔλՄࢹԽ͔Β͡ΊΑ͏ Լॏതࢿ(.01FQBCP *OD 8FCݱ.FFUVQ σʔλੳͦͷલʹ
Slide 2
Slide 2 text
ΤϯδχΞ ৽ଔೖࣾ Լॏതࢿ!TIJNPKV@ &$ࣄۀ෦46;63*νʔϜ TIJNPKVPSH
Slide 3
Slide 3 text
No content
Slide 4
Slide 4 text
No content
Slide 5
Slide 5 text
ʮ8FCݱ.FFUVQʯ
Slide 6
Slide 6 text
ʮʰݱʱͰى͖ͨ ʰٕज़վળʱͱʰ৫վળʱ ͷ͓ʯ
Slide 7
Slide 7 text
·ͩଐ͔Β ͦΜͳͷ͋Δʜʁ ৽ଔΤϯδχΞ·ͰݚमͰɺଐ݄Ͱ͢
Slide 8
Slide 8 text
ଐޙͷ՝
Slide 9
Slide 9 text
ଐޙͷ՝ wάοζͷചΕےͲΜͳ࡞ऀ͕ਓؾͳͷ͔ɺ 46;63*͕͍·ͲΜͳঢ়ଶͳͷ͔Θ͔Βͳ͍
Slide 10
Slide 10 text
ଐޙͷ՝ wάοζͷചΕےͲΜͳ࡞ऀ͕ਓؾͳͷ͔ɺ 46;63*͕͍·ͲΜͳঢ়ଶͳͷ͔Θ͔Βͳ͍ wͱ͍͏͔ͦͦऔΕ͍ͯͳ͍ࣈ͕ଟ͍ͧʜ wूܭ͕ඞཁͳͱ͖ɺ͍͍ͪͪσΟϨΫλʔ͕Τϯδ χΞʹґཔͯ͠σʔλूܭ͍ͯͨ͠
Slide 11
Slide 11 text
σʔλੳɺͦͷલʹʜʜ wσʔλੳʹڵຯ͕͋Δ͕ͦ͠͏ wͦͦσʔλ͕औΕ͍ͯͳ͍͠ɺ ເͷ·ͨເͳͷͰʁʁʁ w·ͣσʔλੳͷͨΊͷجૅΛͭ͘Ζ͏
Slide 12
Slide 12 text
ָʹूܭɾՄࢹԽͰ͖ͯɺ ͍ͭͰʹࣗಇԽ͍ͨ͠ʂ
Slide 13
Slide 13 text
No content
Slide 14
Slide 14 text
3FEBTIͱ wσʔλͷՄࢹԽͱڞ༗ͷͨΊͷιϑτΣΞ wϒϥβ͔Β؆୯ʹ42-Λ࣮ߦɾڞ༗ɾάϥϑԽͰ͖ɺ ͦΕΒΛ·ͱΊͨμογϡϘʔυΛ࡞ΕΔ w؆қతͳཧը໘ͷΑ͏ͳΠϝʔδ
Slide 15
Slide 15 text
No content
Slide 16
Slide 16 text
No content
Slide 17
Slide 17 text
No content
Slide 18
Slide 18 text
3FEBTIͷ͍͍ͱ͜Ζ wπʔϧࣗମͷ͍ํ΄΅֮͑ͳ͍͍ͯ͘΄Ͳγϯϓ ϧͰɺ42-͑͞ॻ͚Ε͑Δ w8FC6*ͰΫΤϦΛฤूͰ͖ΔͨΊɺ ʮൿͷ42-ʯΛΈΜͳʹڞ༗Ͱ͖Δ wඇΤϯδχΞͰѻ͍͍͢
Slide 19
Slide 19 text
ϖύϘͱ3FEBTI wશࣾతʹಋೖ͕ਐΜͰ͓Γศརͱ͍͏Λฉ͍͍ͯͨ wࣄۀ෦ͷ3FEBTIΠϯελϯε͕طʹ͋ͬͨͨΊɺ ͦ͜ʹಉډ͢Δ͜ͱʹͯ͠εϐʔυಋೖ wϊϋڞ༗͍͢͠
Slide 20
Slide 20 text
ಋೖ͢Δ w4BB4൛ͱηϧϑϗετ 044 ൛͕͋Δ wηϧϑϗετ൛ʹ"84($&༻Πϝʔδ͕͋Δ΄͔ɺ %PDLFSΠϝʔδ༻ҙ͞Ε͍ͯΔ wηϧϑϗετͷ%PDLFS൛Λར༻͍ͯ͠Δ
Slide 21
Slide 21 text
ઃఆ
Slide 22
Slide 22 text
ઃఆ wڥมͰઃఆΛߦ͏ w%PDLFSͰಈ͔͍ͯ͠Δ߹ɺ EPDLFSDPNQPTFZNMͷFOWʹॻ͘ w͜͜ΒΜʹ͑ͦ͏ͳઃఆ߲͕͋Δ wIUUQTHJUIVCDPNHFUSFEBTISFEBTICMPCNBTUFSSFEBTI TFUUJOHTQZ
Slide 23
Slide 23 text
3&%"4)@%"5&@'03."5 wσϑΥϧτͰ͕%%..::ܗࣜͰಡΈʹ͍͘ w::::..%%ʹ͢Δ w3&%"4)@%"5&@'03."5::::..%%
Slide 24
Slide 24 text
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
Slide 25
Slide 25 text
3&%"4)@"--08@4$3*154@*/@64&3@*/165 wμογϡϘʔυͰϑΥʔϜ͕͑ΔΑ͏ʹͳΔ wϑΥʔϜΛͬͯநग़ର݄Λࢦఆͨ͠Γɺ +BWB4DSJQUͰ%BUF1JDLFSΛೖΕͨΓͰ͖Δ w3&%"4)@"--08@4$3*154@*/@64&3@*/165USVF
Slide 26
Slide 26 text
5JQT
Slide 27
Slide 27 text
ϦϯΫ w63-·ͨBλάΛฦ͢Α͏ʹ͢ΔͱϦϯΫʹͳΔ wϢʔβʔҰཡΛදࣔ͢ΔΫΤϦͰɺαΠτͷϢʔβʔ ϖʔδཧը໘ʹϦϯΫͨ͠ΓͳͲ
Slide 28
Slide 28 text
No content
Slide 29
Slide 29 text
ύϥϝʔλ wΫΤϦதʹ\\QBSBN^^ͱॻ͘ͱɺҙͷύϥϝʔλΛ ࣮ͯ͠ߦ͢Δ͜ͱ͕Ͱ͖Δ wϑΥʔϜʹೖྗ͢Δ͔2VFSZTUSJOHͰ͢ w݄ϢʔβʔΛࢦఆ͍ͨ͠ͱ͖ʹศར
Slide 30
Slide 30 text
No content
Slide 31
Slide 31 text
ϑΥʔϜ wμογϡϘʔυ্ʹϑΥʔϜΛهड़Ͱ͖Δ
Slide 32
Slide 32 text
ಋೖͯ͠Ͳ͏ͩͬͨʁ
Slide 33
Slide 33 text
ΜΓ wҰΫΤϦΛ࡞ΕɺΤϯδχΞͷखΛआΓͣʹৗʹ ࠷৽ͷใΛࢀরͰ͖Δ ఆظ࣮ߦͰ͖Δ w࣍ɾ݄࣍Ͱग़͢σʔλͳͲɺਵ࣌࠷৽ͷใ͕ඞཁ ʹͳΔͷʹޮՌ͕ग़͍ͯΔ wʮࡢͷച্ৄࡉʯʮ݄ผͷϢʔβʔʯͳͲ
Slide 34
Slide 34 text
ΤϯδχΞҎ֎͔Β wඇΤϯδχΞσʔλϕʔεΛѻ͍͘͢ͳΔ wσΟϨΫλʔ$4͕ΫΤϦΛॻ͘ྫ͕૿͑ͨ wطଘͷΫΤϦΛίϐʔ͍ͯ͠͡Δͱ͔͜Β࢝ΊΒΕΔ
Slide 35
Slide 35 text
ࠓޙΓ͍ͨ͜ͱ
Slide 36
Slide 36 text
(PPHMF"OBMZUJDT࿈ܞ w3FEBTI͔Β(PPHMF"OBMZUJDTΛσʔλιʔεʹ Ͱ͖Δ wʹΞοϓσʔτͰ͖͍ͯͳ͍ʜʜ w"OBMZUJDTͷσʔλͱΈ߹ΘͤͨΓ͍ͨ͠
Slide 37
Slide 37 text
4MBDL࿈ܞ w࣮ߦ݁ՌΛ4MBDL௨Ͱ͖ͯɺάϥϑදࣔͰ͖Δ w4MBDL͔Β3FEBTIʹΞΫηεͰ͖Δඞཁ͕͋Δ wݱঢ়ࣾΞΫηεͷΈʹ੍ݶ wIUUQEBUBHVOPTZJPFOUSZTMBDLSFEBTILQJOPUJGZ
Slide 38
Slide 38 text
σʔλੳ wࠓճσʔλूܭɺՄࢹԽͰ͖͚ͨͩ wσʔλੳͷϨϕϧ·ͰਂΊɺΛݩʹͨ͠ࢪࡦఏ ҊͳͲʹͭͳ͍͛ͨ wूܭ݁ՌΛΈ߹ΘͤͨΓɺ3Λ׆༻ͨ͠ΓͳͲ wIUUQUFDIQFQBCPDPNNJOOFSFEBTIEBTICPBSE
Slide 39
Slide 39 text
·ͱΊ
Slide 40
Slide 40 text
·ͱΊ w3FEBTIͰσʔλՄࢹԽɾੳͷجૅΛ࡞ͬͨ wʮσʔλੳͦ͠͏ʜʯ ˠ·ͣൿͷ42-Λڞ༗ͯ͠ՄࢹԽ͠Α͏ wࣗಇԽͨ͠ͷ࣌ؒΛ։ൃʹ͑Δʂ༏উʂʂ