BigData-JAWS 勉強会 #24 QuickSight分科会 https://jawsug-bigdata.connpass.com/event/284869/
"84ੳܥʴ*B$αʔϏεೖ(MVF "UIFOB 2VJDL4JHIU $%,ΈͷΔΜ !NJOPSVO
View Slide
XIPBNJ御⽥ 稔 !NJOPSVO,%%*גࣜձࣾ ˍ ,%%*ΞδϟΠϧ։ൃηϯλʔגࣜձࣾʢ,"(ʣ࠷ۙɺຖ2JJUBॻ͍ͯͨΒʮޚా࣮ਓ͍ΔʯͱࣾͰ·͜ͱ͔͠ʹݴΘΕΔΑ͏ʹͳΓ·ͨ͠+"846(43&ࢧ෦ӡӦ +"84%":4࣮ߦҕһ• "84$PNNVOJUZ#VJMEFS• ,%%*$MPVE4".63"*• ,%%*$MPVE"NCBTTBEPST
,%%*Ͱ$$P&νʔϜͷऔΓΈͱͯࣾ͠ͷ"84ར༻ঢ়گՄࢹԽπʔϧΛ։ൃ͍ͯ͠·͢💪˞$$P&ʹ $MPVE$FOUFSPG&YFMMFODFࣲాʢ10ʣ ޚాʢΤϯδχΞʣޫʢ4.ʣ
௨শ,$-67*5ʢΫϧʔϏοτʣ,%%*$MPVE6UJMJ[BUJPO7JTVBMJ[BUJPO*OTJHIU5PPM
ྫ͑ɺࣾͷ"84Ϣʔβʔ͔ΒΑ͘ฉ͘ͷ͕ʜ
ͪΐͬͱલʹ("͞ΕͨYYYͱ͍͏"84ͷ৽αʔϏε͕ؾʹͳΔΜ͚ͩͲɺࣾͰͬͯΔਓ͍ͳ͍͔ͳ͊ʁίϯγϡʔϚʔ͚γεςϜͷΠϯϑϥӡ༻୲
ΫϧʔϏοτͳΒ"84αʔϏε໊Λબ͢Δ͚ͩͰར༻ΞΧϯτɾҊ໊݅ɾ෦ॺؙ໊͕Θ͔Γʂ౷ׅຊ෦ຊ෦ ෦ ΞΧϯτ*%༻్ʢҊ໊݅ͳͲʣίετ
ͦͷத͔Β"84ΞΧϯτΛҰͭબ͢Δͱར༻தαʔϏεͷߏൺ͕ݟΒΕ·͢
ࣾʹ"84ΞΧϯτ͕ Ҏ্͋ΔͷͰ͜ͷπʔϧ͔ͳΓॏๅ͠·͢ɻ
࣮͜ͷπʔϧɺ"84ͷ1SP4FSWF͞ΜʹϓϩτΛ࡞ͬͯΒ͍·ͨͦ͠ͷޙɺࣗͨͪͰΤϯϋϯε͍ͯ͠·͢
͕͢͞"84͞Μ͕ॳظઃܭ͚ͨͩ͋ͬͯ͠ɺੳܥϚωʔδυαʔϏεͷ͓खຊߏʹͳ͍ͬͯ·͢ɻͦͯ͠$%,ͰͬͪΓ*B$ԽࡁΈʂ
ࠓ͜ͷΫϧʔϏοτͷߏΛͱʹɺ"84ͷੳܥˍ*B$αʔϏεͷجຊΛΈͳ͞Μʹհ͠·͢ɻ
ΫϧʔϏοτͷΞʔΩςΫνϟհ
,$-67*5ʹαʔόʔϨεੳͷ͓खຊߏʂ$%,"84ΞΧϯτʢ,$-67*5ʣར༻ऀ
,$-67*5ʹαʔόʔϨεੳͷ͓खຊߏʂ(MVF "UIFOB 2VJDL4JHIU$%,"84ΞΧϯτʢ,$-67*5ʣ4֤"84ϦιʔεΛσϓϩΠར༻ऀ
,$-67*5ʹαʔόʔϨεੳͷ͓खຊߏʂ(MVF "UIFOB 2VJDL4JHIU$%,"84ΞΧϯτʢ,$-67*5ʣ4֤"84ϦιʔεΛσϓϩΠར༻ऀμογϡϘʔυ
,$-67*5ʹαʔόʔϨεੳͷ͓खຊߏʂ(MVF "UIFOB 2VJDL4JHIU$%,"84ΞΧϯτʢ,$-67*5ʣ4֤"84ϦιʔεΛσϓϩΠར༻ऀݕࡧΫΤϦʔ μογϡϘʔυ
,$-67*5ʹαʔόʔϨεੳͷ͓खຊߏʂ(MVF "UIFOB 2VJDL4JHIU$%,"84ΞΧϯτʢ,$-67*5ʣ4σʔλΧλϩά֤"84ϦιʔεΛσϓϩΠར༻ऀݕࡧΫΤϦʔ μογϡϘʔυ
,$-67*5ʹαʔόʔϨεੳͷ͓खຊߏʂ(MVF "UIFOB 2VJDL4JHIU$%,"84ΞΧϯτʢ,$-67*5ʣ4σʔλιʔε σʔλΧλϩά֤"84ϦιʔεΛσϓϩΠར༻ऀݕࡧΫΤϦʔ μογϡϘʔυ
"UIFOB͔Βඥղ͘ͱ͔Γ͍͢(MVF 2VJDL4JHIU$%,"84ΞΧϯτʢ,$-67*5ʣ4σʔλιʔε σʔλΧλϩά֤"84ϦιʔεΛσϓϩΠར༻ऀμογϡϘʔυ"UIFOBݕࡧΫΤϦʔ
"NB[PO"UIFOBͱʁ
"NB[PO"UIFOBͱʁҰݴͰ͍͏ͱ4ͷσʔλΛ42-ͰੳͰ͖ΔαʔϏεɻ"UIFOB4
"NB[PO"UIFOBͱʁ͜Ε·Ͱɺܗ͕ࣜἧ͍ͬͯͳ͍༷ʑͳσʔλΛ·ͱΊͯੳ͢Δͷ͔ͬͨ͠ɻ4όέοτ$47 +40/ 1BSRVFU
"NB[PO"UIFOBͱʁ"UIFOBςʔϒϧఆٛΛߦ͏͜ͱͰ৭ΜͳσʔλΛ%#Խͯ͠42-ͰੳՄೳʹͨ͠ʂ4όέοτ$47 +40/"UIFOBςʔϒϧఆٛ͜ͷ$47ͷྻʮ6TFS/BNFʯͱ͍͏จࣈྻσʔλͰ͐͢ʂ
"NB[PO"UIFOBͱʁͰ͜ͷςʔϒϧఆٛɺखಈͰϙνϙνઃఆ͢ΔͷͰݩσʔλ͕ଟ͍ͱΊͪΌେมͳΜͰ͢💦
ͦ͜Ͱొͨ͠ͷ͕ʂ
υυυυʜ
"84(MVF
"84(MVFͱʁखಈͰ"UIFOBͷςʔϒϧఆٛΛઃఆ͠ͳͯ͘4ΛࣗಈͰΫϩʔϧͯ͠%#Խͯ͘͠ΕΔʂ4όέοτ "UIFOBσʔλΧλϩάΫϩʔϥʔ(MVF
ͦͷͨΊ"UIFOBར༻࣌4(MVF"UIFOBͷΈ߹Θ͕ͤԦಓɻ4όέοτ "UIFOBσʔλΧλϩάΫϩʔϥʔ(MVF"84(MVFͱʁ
(MVFͷ͏Ұͭͷػೳͱͯ͠&5-δϣϒ͕ར༻ՄೳɻσʔλมͳͲΛαʔόʔϨεͰ࣮ߦͰ͖Δɻ"UIFOBσʔλΧλϩάΫϩʔϥʔ(MVF4όέοτ(MVF&5-δϣϒ$47• σʔλܗࣜΛม• ෆཁͳྻΛআ"84(MVFͱʁ4όέοτ1BSRVFU
&5-δϣϒ؆қͳͷͳΒ1ZUIPOγΣϧɺେنͳॲཧ4QBSLʢ1ZUIPOPS4DBMBʣͰهड़Մೳɻ"UIFOBσʔλΧλϩάΫϩʔϥʔ(MVF4όέοτ(MVF&5-δϣϒ$47• σʔλܗࣜΛม• ෆཁͳྻΛআ"84(MVFͱʁ4όέοτ1BSRVFU
,$-67*5Ͱ$PTU&YQMPSFSͷݩσʔλʢ$63ˍ%#3ʣΛ&5-δϣϒͰ1BSRVFUܗࣜʹมͯ͠·ͱΊͯ·͢ɻ"UIFOBσʔλΧλϩάΫϩʔϥʔ(MVF4όέοτ(MVF&5-δϣϒ$471BSRVFU"84(MVFͱʁ4όέοτ1BSRVFU• ίετͱ༻ঢ়گϨϙʔτʢ$63ʣ• چɿٻ໌ࡉϨϙʔτʢ%#3ʣ ੳઐ༻ͷܗࣜʹͯ͠εϦϜԽˍίετݮ
͜Μͳײ͡Ͱ༷ʑͳσʔλΛކʢHMVFʣͷΑ͏ʹܨ͗߹Θͤͯ͘ΕΔΜͰ͢ʂ"UIFOBσʔλΧλϩάΫϩʔϥʔ4όέοτ &5-δϣϒ$471BSRVFU"84(MVFͱʁ(MVF(MVF4όέοτ1BSRVFU
ϫʔΫϑϩʔػೳΛ͑&5-δϣϒΫϩʔϥʔΛ4UFQ'VODUJPOTͷΑ͏ʹ(6*ͰΈ߹ΘͤΒΕΔ"84(MVFͱʁ
"NB[PO2VJDL4JHIUͱʁ
"NB[PO2VJDL4JHIUͱʁࠓݟ͖ͯͨηοτͰͷσʔλੳࣗͰ42-Λॻ͖ɺ݁ՌςΩετͰग़ྗ͞ΕΔελΠϧɻ(MVF "UIFOB4• ച্ཤྺͷ$47• Ϛελͷ&YDFMઌ݄ͷച্૯ֹτοϓͷ໊Λग़ྗʂ
"NB[PO2VJDL4JHIUͱʁϢʔεέʔεʹΑͬͯʮ42-Λॻ͘ͷ͕ϋʔυϧʯʮ݁ՌΛάϥϑͰද͍ࣔͨ͠ʯ͜ͱ͋Γɻ
"NB[PO2VJDL4JHIUͱʁͦ͜Ͱศརͳͷ͕2VJDL4JHIUʂ(MVF "UIFOB4 2VJDL4JHIU
"NB[PO2VJDL4JHIUͱʁ(6*Ͱ݅Λઃఆ͢Δ͚ͩͰάϥϑΛग़ྗͯ͘͠ΕΔɻ
"NB[PO2VJDL4JHIUͱʁଞͷσʔλιʔεΛݩʹʮσʔληοτʯΛ࡞ɻ͜ΕΛʮੳʯͰՄࢹԽ͠ɺμογϡϘʔυͱͯ͠ެ։Ͱ͖Δ(MVF "UIFOB42VJDL4JHIUσʔληοτੳ μογϡϘʔυσʔλιʔε
"NB[PO2VJDL4JHIUͱʁσʔλιʔεʹ"UIFOB3%4ͳͲͷ"84Ϧιʔεͷଞɺ5XJUUFS4OPXGMBLFͳͲͷ֎෦4BB4ʹରԠɻ"UIFOB2VJDL4JHIUσʔληοτੳ μογϡϘʔυσʔλιʔεʢੳରʣ3%45XJUUFS4OPXGMBLF˞΄͔ଟରԠ
"84$%,ͱʁ
$%,ͬͯͲΕ͚ͩͬͨͬʁ(MVF "UIFOB 2VJDL4JHIU$%,"84ΞΧϯτʢ,$-67*5ʣ4֤"84ϦιʔεΛσϓϩΠ👉
"84$%,ͱʁ͍ΘΏΔ*B$ʢ*OGSBTUSVDUVSFBT$PEFʣπʔϧͷҰͭɻ
"84$%,ͱʁΫϥυͷૢ࡞"1*ͰߦΘΕ͍ͯΔͨΊɺࣗಈԽ͕ՄೳɻԹΓͷ͋ΔϚωίϯख࡞ۀΛଔۀͰ͖Δʂ
"84$%,ͱʁ*B$πʔϧSEύʔςΟؚΊ͍͔ͯͭ͋͘Γ·͢ɻ5FSSBGPSN $MPVE'PSNBUJPO $%,
"84$%,ͱʁ5FSSBGPSN $MPVE'PSNBUJPO $%,SEπʔϧɻ"84Ҏ֎ʹରԠ"84ͷݩ*B$αʔϏεɻఆٛϑΝΠϧ෩ʹهड़͢Δ5ZQF4DSJQUͳͲͷݴޠͰ$'OςϯϓϨʔτΛੜ͢Δϥοϐϯά
$'Oͱ$%,ͷߏཁૉ$MPVE'PSNBUJPO $%,ςϯϓϨʔτʢ+40/:".-ఆٛϑΝΠϧʣελοΫʢੜ͞ΕΔ"84Ϧιʔε܈ʣ• ྫɿ424ʴ-BNCEBʴ4ΞϓϦέʔγϣϯελοΫίϯετϥΫτʢྫɿ424ʴ-BNCEBʣίϯετϥΫτʢྫɿ4ʣ
$'O WT$%,$MPVE'PSNBUJPO $%,ελοΫʢׂ͗ͯ͢ѪʣΞϓϦέʔγϣϯελοΫʢίϯετϥΫτར༻ʣʴ
,$-67*5ͷίʔυྫCJOMJCSFTPVSDFTHMVFMBNCEBΞϓϦέʔγϣϯUTελοΫUTίϯετϥΫτUTίϯετϥΫτUT&5-δϣϒQZϑΝϯΫγϣϯQZΠϯελϯεԽελοΫੜΠϯϑϥʢ$%,ʣΞϓϦ$PEF$PNNJUҰॹʹσϓϩΠ
࠷ॳ͔Β$%,ͰίʔυԽ͞Ε͍͓͔ͯͨ͛Ͱɺ։ൃڥͷ૿ங͕͔ͳΓ؆ུԽͰ͖·ͨ͠ʂ
࠷ޙʹએ
,%%*ΞδϟΠϧ։ൃηϯλʔʢ,"(ʣઈࢍ࠾༻தʂϑϧϦϞʔτͳιϑτΣΞΤϯδχΞઈࢍืूͯ͠·͢👍
དྷिܾணʂ2JJUBͰձࣾର߅͍͍ͶҐΛૂͬͯ·͢🔥RJJUBDPNPSHBOJ[BUJPOTLEEJBHJMF
+"846(౦ژϦϒʔτ͠·͢💪৽ελΠϧΦϯϥΠϯಛԽʂϑϦʔςʔϚͷϥϯνλΠϜ-5ձ