AWS(Amazon Redshift)とTableauではじめるビッグデータ分析 / Getting started Bigdata Analysis with Amazon Redshift and Tableau in Innovation Egg 8th

"84 "NB[PO3FETIJGU ͱ 5BCMFBVͰ͸͡ΊΔϏοάσʔλ෼ੳ ೥݄೔ʙ *OOPWBUJPO&HHୈճʰՄࢹԽɾ՝୊ͱࢧ͑Δٕज़  !ΤϜΦʔςοΫε৽େࡕϏϧ #IEgg Ϋϥεϝιουגࣜձࣾ͠Μ΍
!TIJOZBB ⡥$MBTTNFUIPE *OD

ձࣾ঺հ Ϋϥεϝιουגࣜձࣾ ɾ૑ཱɿ೥݄೔ ͦΖͦΖ૑ཱप೥ ɾࣾһ਺ɿ໿ਓ ೥݄ݱࡏ ɾ୅දɿԣా૱
"84$PNNVOJUZ)FSPFT ɾओͳࣄۀ෼໺ #IEgg ˞"84ίϛϡχςΟώʔϩʔʹͳΓ·ͨ͠ʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQDMPVEBXTDPNNVOJUZIFSPFT ɾ ϒϩά

ձࣾ঺հ Ϋϥεϝιουגࣜձࣾ ɾ૑ཱɿ೥݄೔ ͦΖͦΖ૑ཱप೥ ɾࣾһ਺ɿ໿ਓ ೥݄ݱࡏ ɾ୅දɿԣా૱
"84$PNNVOJUZ)FSPFT ɾओͳࣄۀ෼໺ #IEgg ˞"84ίϛϡχςΟώʔϩʔʹͳΓ·ͨ͠ʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQDMPVEBXTDPNNVOJUZIFSPFT ɾ"84 ɾJ04 ɾϏοάσʔλ ɾ*P5 ౳ͳͲ

%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQ ɾ೥݄ΑΓ։ઃ ͦΖͦΖप೥ ɾ૯ϒοΫϚʔΫ਺௒ ɹ ࠃ಺*5ܥاۀҐ
ɾྦྷܭΤϯτϦຊ਺໿ຊ ɾྦྷܭ"84ؔ࿈ΤϯτϦຊ਺ຊ ɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹ ˞ݱࡏ

%FWFMPQFST*0 ˞ԼهΤϯτϦͰ঺հ͞Ε͍ͯΔ৘ใʹ͍ͭͯ࠶ूܭΛߦ͍ɺ্Ґ݅Λදࣔɻ೥݄೔ݱࡏ ɹ8&#ܥ֤ࣾͷٕज़ϒϩάͷ͸ͯϒ਺Λௐ΂ͯΈͨNJLFEBͷ೔هIUUQNJLFEBIBUFOBCMPHDPNFOUSZ

ࣗݾ঺հ ໊લɿ͠Μ΍ 5XJUUFS*%ɿ!TIJOZBB ɾ೥݄ʹΫϥεϝιουʹ+0*/ ɾओʹϏοάσʔλʗ#*पΓͷҊ݅Λ୲౰ ɾ͋ͱࣾ಺ϒϩάࣥචଅਐ׆ಈ ɾ޷͖ͳ"84αʔϏεɿ"NB[PO3FETIJGU ɾ޷͖ͳ#*πʔϧɿ5BCMFBV ɾ޷͖ͳөըɿϚουϚοΫεౖΓͷσεɾϩʔυ
ܶ৔ʹͯճؑ৆ࡁ ɾࣗࣾϒϩάʰ%FWFMPQFST*0ʱࣥච ɹ͠Μ΍ʛ%FWFMPQFST*0IUUQEFWDMBTTNFUIPEKQBVUIPSTIJOZBB ɹ೥݄೔ݱࡏͷྦྷܭ౤ߘຊ਺ɿຊ ೔ຊ೔ʹຊ #IEgg

ϒϩά౤ߘঢ়گͷՄࢹԽ #IEgg ˞ࣾһͷϒϩά౤ߘຊ਺ྦྷܭ ࣾһผ

ϒϩά౤ߘঢ়گͷՄࢹԽ #IEgg ˞ࣾһͷ೥಺ྦྷܭ౤ߘຊ਺݄ฏۉຊ਺

ϒϩά౤ߘঢ়گͷՄࢹԽ #IEgg ˞શz౤ߘzຊ਺ͷ࣌ؒผʗ༵೔ผώʔτϚοϓ

ձࣾ঺հ ࠃ಺ΦϑΟε #IEgg ळ༿ݪ ਆాࠤٱؒொɾؠຊொ ࡳຈ ্ӽົߴ

ձࣾ঺հ ւ֎ΦϑΟε <Ϋϥεϝιου>όϯΫʔόʔϦʔδϣϯ͸͡Ί·ͨ͠ʛ%FWFMPQFST*0IUUQEFWDMBTTNFUIPEKQFUDWBODPVWFSP⒏DFTUBSU <Ϋϥεϝιου>ϕϧϦϯϦʔδϣϯ͸͡Ί·ͨ͠ʛ%FWFMPQFST*0IUUQEFWDMBTTNFUIPEKQFUDCFSMJOP⒏DFTUBSU ೔ຊࠃ಺ˍւ֎ڌ఺ମ੍Ͱ࣌ؒ೔ͷΠϯϑϥαϙʔτͱ ࣌ࠩΛ׆͔ͨ͠"84ίϯαϧςΟϯάαʔϏεΛల։ɻ #IEgg ΧφμɾόϯΫʔόʔ υΠπɾϕϧϦϯ

େࡕΦϑΟε/FX #IEgg ˞ͳʹΘͩΑΓʛγϦʔζʛ%FWFMPQFST*0IUUQEFWDMBTTNFUIPEKQTFSJFTMFUUFSGSPNPTBLB

ΞδΣϯμ ࣗݾ঺հʗձࣾ঺հ౳ ֓ཁઆ໌ɿ"NB[PO3FETIJGU5BCMFBV4PGUXBSF 3FETIJGUͱ5BCMFBVͰ͸͡ΊΔՄࢹԽ ৽όʔδϣϯϦϦʔεʂ5BCMFBV ૣ͘࢖ͬͯΈ͍ͨʂ"NB[PO2VJDL4JHIU ͍͞͝ʹ #IEgg

"NB[PO3FETIJGU ɾ௒ߴ଎ฒྻॲཧϑϧϚωʔδυ%8) ɾ1PTUHSF42-४ڌ W ɹ3%#Λѻ͏ײ֮Ͱར༻Մೳ ɾখ࢝͘͞ΊͯɺඞཁʹԠͯ͡ॊೈʹ֦ுՄೳ ɹˠ࠷খαΠζɿ(# ɹˠ࠷େαΠζɿ1#
ɾΧϥϜφܕ ྻࢦ޲ܕ ɿྻຖʹσʔλΛѹॖར༻ ɾ.11 ௒ฒྻॲཧ ΞʔΩςΫνϟɿ ɹϊʔυ਺૿Ͱॲཧੑೳ޲্ #IEgg ˞"NB[PO3FETIJGUͱ͸ "NB[PO3FETIJGUIUUQEPDTBXTBNB[PODPNKB@KQSFETIJGUMBUFTUNHNUXFMDPNFIUNM

"NB[PO3FETIJGU ɾ͍͍ͩͨͷࣄ͸͜͜ʹॻ͍ͯ͋Γ·͢ɻ ɹ%FWFMPQFST*0"NB[PO3FETIJGUಛू IUUQEFWDMBTTNFUIPEKQSFGFSFODFDBUBXTSFETIJGU

5BCMFBV4PGUXBSF ɾຊࣾɿถࠃγΞτϧ೥ઃཱɺ೥্৔ ɾ೔ຊ๏ਓ 5BCMFBV+BQBO ɿ೥݄ઃཱ ɾ૑ཱऀͷਓ͸1JYBS ถࠃө૾੍࡞ձࣾ ग़਎ ɹ
1BU)BOSBIBOɿΞΧσϛʔՊֶٕज़৆ଞଟ਺ͷड৆ྺ #IEgg

5BCMFBV4PGUXBSF ੡඼ϥΠϯφοϓ ɾ5BCMFBV%FTLUPQɿΫϥΠΞϯτɺߴػೳɺଟ࠼ͳ઀ଓσʔλιʔεɺৄࡉͳ෼ੳ ɾ5BCMFBV4FSWFSɿαʔόɺ৘ใڞ༗ɺίϯςϯπ؅ཧɺεέδϡʔϧ ɾ5BCMFBV0OMJOFɿ5BCMFBV4FSWFSͷ4BB4൛ ɾ5BCMFBV.PCJMFɿ5BCMFBV4FSWFSʗ0OMJOFͱ࿈ܞɺରԠ04ɿJ04ˍ"OESPJE ɾ5BCMFBV1VCMJDɿແঈɺެ։8FCαΠτͰίϯςϯπڞ༗ɺର৅σʔλιʔε͸ݶఆ ɾ5BCMFBV3FBEFSɿ5BCMFBVϫʔΫϒοΫಡΈऔΓઐ༻πʔϧ ɾ7JTBCMFɿJ04J1BE༻ΞϓϦέʔγϣϯɺ5BCMFBVͱͷ௚઀ͷؔ܎͸ແ͠
˞੡඼c5BCMFBV4PGUXBSFIUUQXXXUBCMFBVDPNKBKQQSPEVDUT ˞7J[BCMFCZ5BCMFBV%BUBBOBMZUJDTGPSFWFSZPOFIUUQTWJ[BCMFUBCMFBVDPN ˞5BCMFBV%FTLUPQͰग़དྷΔࣄͷ·ͱΊʛ%FWFMPQFST*0 ɹIUUQEFWDMBTTNFUIPEKQDMPVEBXTUBCMFBVEFTLUPQGFBUVSFTNBUPNF ˞5BCMFBV4FSWFSͰग़དྷΔࣄͷ·ͱΊʛ%FWFMPQFST*0 ɹIUUQEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTUBCMFBVTFSWFSGFBUVSFT #IEgg

5BCMFBV4PGUXBSF ɾεϜʔζͳૢ࡞ײ ɾ׳Εͯ͘Δͱ௚ײͰՄࢹԽΛ࡞੒ग़དྷΔ ɾඳըͷࣗ༝౓͕ߴ͘ɺΞΠσΞ࣍ୈͰ৭ʑ࡞ΕΔ ɾࢀߟ৘ใ͕ॆ࣮͍ͯ͠Δ ɹɾެࣜϔϧϓɺφϨοδϕʔε ,# ɹɾ5BCMFBV1VCMJDੈքத͔Βίϯςϯπ͕ू݁
ɹɾݴٴϒϩά͕ଟ͍ ಛʹւ֎ ɹɾࠃ಺ɿ%FWFMPQFST*0 ɾϊϦ͕ྑ͍ #IEgg

5BCMFBV1VCMJD #IEgg 'SFF%BUB7JTVBMJ[BUJPO4PGUXBSFc5BCMFBV1VCMJD IUUQTQVCMJDUBCMFBVDPN

5BCMFBV1VCMJD #IEgg ˞ʰ+ϦʔάͷΫϥϒνʔϜͷྺ࢙ʱΛՄࢹԽͯ͠Έͨʛ5BCMFBV4PGUXBSF5JQT7J["EWFOU$BMFOEBSUBCMFBVʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTBEWFOUDBMFOEBSUBCMFBVWJTVBMJ[BUJPOPGKMFBHVFDMVCUFBNIJTUPSZ

5BCMFBV1VCMJD #IEgg ˞ʰശࠜӺ఻ʱΛՄࢹԽͯ͠Έͨʛ5BCMFBV4PGUXBSF5JQT7J["EWFOU$BMFOEBSUBCMFBVʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTBEWFOUDBMFOEBSUBCMFBVWJTVBMJ[BUJPOPGIBLPOFFLJEFO

5BCMFBV1VCMJD #IEgg ˞ʰস఺ʱग़ԋऀͷྺ࢙ΛՄࢹԽͯ͠Έͨʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDT WJTVBMJ[FTIPUFOIJTUPSZCZUBCMFBV

5BCMFBV1VCMJD #IEgg ˞͋ͷੈքతөըΞΫγϣϯελʔͷʰոզҰཡʱΛՄ ࢹԽͯ͠Έͨʛ5BCMFBV4PGUXBSF5JQT7J["EWFOU $BMFOEBSUBCMFBVʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTT BOBMZUJDTBEWFOUDBMFOEBSUBCMFBV WJTVBMJ[BUJPOPGKBDLJFDIBOJOKVSZMJTU

5BCMFBVMPWFT45"38"34 #IEgg ˞ʲ࠷৽࡞ެ։ه೦ʳөըʰελʔ΢Υʔζʱʹؔ͢Δ5BCMFBVՄࢹԽωλΛूΊͯΈͨ4UBS8BST%BUBʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTUBCMFBVTUBSXBSTWJ[

5BCMFBV4PGUXBSF ɾ͍͍ͩͨͷࣄ͸͜͜ʹॻ͍ͯ͋Γ·͢ɻ ɹ%FWFMPQFST*05BCMFBVಛू 5BCMFBVʛಛूΧςΰϦʔʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQSFGFSFODFDBUCVTJOFTTBOBMZUJDTUPPMTUBCMFBV

5BCMFBV4PGUXBSF #IEgg

೔ຊͰͷ5BCMFBV͸ Θ͕͠ҭͯͨ 5BCMFBV4PGUXBSF #IEgg

3FETIJGUY5BCMFBV ɾ"845BCMFBVڞʹΨʔτφʔʹͯʰϦʔμʔʱධՁɻ ɹ ˞ڞʹ೥࿈ଓ ˞ "84 IUUQTBXTBNB[PODPNKQSFTPVSDFTHBSUOFSNRMFBSONPSF ˞ 5BCMFBV
IUUQHFUUBCMFBVDPNKBKQHBSUOFSNBHJDRVBESBOUIUNM #IEgg

3FETIJGUY5BCMFBV ɾΫϥεϝιουͰ΋ʰਪ͠ʱͷ૊Έ߹Θͤɻ #IEgg ΧελϚʔετʔϦʔσʔλʛΫϥεϝιουגࣜձࣾ IUUQTDMBTTNFUIPEKQTFSWJDFTDVTUPNFSTUPSZ

3FETIJGUY5BCMFBV #IEgg ˞ಋೖࣄྫʛΫϥεϝιουגࣜձࣾIUUQDMBTTNFUIPEKQDBTFT

NJOVUFTQBTTFE #IEgg ˞`.BE.BY'VSZ3PBEc"OBUPNZPGB4DFOFX%JSFDUPS(FPSHF.JMMFSc5IF/FX:PSL5JNFT:PV5VCF ɹIUUQTXXXZPVUVCFDPNXBUDI W645K5.(C$* ͜͜ͰਫΛҿΉ

ՄࢹԽͷ͸͡Ίํ #IEgg

ՄࢹԽର৅ͷબఆɾΠϝʔδԽ ɾ·ͣ͸ͭɺҰ൪ڵຯͷ͋ΔʗखࠒͳσʔλΛ ɹՄࢹԽͯ͠ΈΔ͜ͱ͔Β࢝ΊΔɻ ɾͦͷࡍʰͦͷσʔλͷɺԿΛɺͲΜͳ෩ʹݟ͍͔ͨʱ ɹΛؔ܎ऀؒͰΠϝʔδ͓ͯ͘͠ࣄ͕ॏཁɻ ɹ ՄࢹԽ࡞ۀͷzΰʔϧzΠϝʔδͷڞ༗ ɾΠϝʔδ͸ڞ༗ग़དྷΔ΋ͷͰ͋Ε͹ԿͰ΋0,ɻ
ɹ ը໘Ωϟϓνϟ&9$&-ϋϦϘςϑϦʔϋϯυ #IEgg

ՄࢹԽ࡞ۀͷ࣮ફ #IEgg 5BCMFBVͰՄࢹԽϏϡʔΛ࡞੒ ՄࢹԽΠϝʔδͷڞ༗ αϚϦɾϚʔτςʔϒϧͷ४උ σʔλͷϩʔυฤूՃ޻ ςʔϒϧఆٛͷઃܭɾ࡞੒ ϑΝΠϧग़ྗ ϑΝΠϧՃ޻
ݸผςʔϒϧɾதؒςʔϒϧͷ४උ

ݸผςʔϒϧɾதؒςʔϒϧͷ४උ 5BCMFBVͰͲ͏΍ͬͯ ϏϡʔΛ૊ΈཱͯΔ͔ʁ 5BCMFBVͰ࢖͏%#߲໨͸ Կ͕͋Ε͹ࣄ଍ΓΔ͔ʁ ୯ҰςʔϒϧͰ0,ʁ ෳ਺ςʔϒϧ݁߹͕ඞཁʁ ϩʔυࡁͷσʔλ͸ ฤूɾՃ޻͕ඞཁʁ ͲͷΑ͏ͳςʔϒϧఆ͕ٛ σʔλ֨ೲ্޷·͍͔͠ʁ σʔλϩʔυલʹՃ޻Λ ࢪ͓ͯ͘͠΂͖͔ʁ Ճ޻ͷखؒΛল͘ʹ͸ Ͳ͏͍ͬͨग़ྗ͕ྑ͍͔ʁ

ݸผςʔϒϧɾதؒςʔϒϧͷ४උ

ݸผςʔϒϧɾதؒςʔϒϧͷ४උ &5-πʔϧ΍ ϓϩάϥϜͰ σʔλΛՃ޻ ϑΝΠϧΛ4ʹΞοϓϩʔυ $01:ॲཧͰ౤ೖ 42-ͰฤूɾՃ޻ σʔλ͔ΒखಈͰઃܭ γεςϜͰࣗಈ൑ผ 42-Ͱ݁߹ ผςʔϒϧʹ౤ೖ Ϗϡʔ΍μογϡ Ϙʔυͷ࡞੒ 5BCMFBVʹΑΔ σʔλͷฤूͳͲ $47ɾ547ͱͯ͠ग़ྗ

ՄࢹԽ࡞ۀͷ࣮ફ #IEgg 3FETIJGU 5BCMFBV 5BCMFBVͷ࢖͍ํʹ׳ΕΔ ՄࢹԽͷΞΠσΞग़͠ ඞཁͳσʔλɾ߲໨ɾςʔϒϧͷચ͍ग़͠ ౤ೖσʔλͷ४උ ౤ೖσʔλͷ&5-Ճ޻ݕ౼
4Ξοϓϩʔυˍσʔλϩʔυ $01: தؒςʔϒϧσʔλϚʔτ࡞੒ʗ&5- 5BCMFBV%FTLUPQϩʔΧϧσʔλͰ ϓϩτλΠϓ࡞੒ 5BCMFBV%FTLUPQܦ༝Ͱ࣮σʔλࢀর ύϑΥʔϚϯενϡʔχϯά σʔλྔɺ૿෼αΠΫϧ͔ΒΫϥελͷ ॳظαΠζΛݕ౼ ΫϥελεΩʔϚߏ੒౳ͷݕ౼ ύϑΥʔϚϯενϡʔχϯά ςʔϒϧఆٛɺ42-ͷݟ௚͠ αϚϦςʔϒϧͷݕ౼ Ϋϥελઃఆͷݟ௚͠ ϫʔΫϒοΫɾϏϡʔߏ੒ͷݟ௚͠ ࣌ ؒ ࣠

ՄࢹԽ࡞ۀͷ࣮ફ #IEgg 3FETIJGU 5BCMFBV 5BCMFBV%FTLUPQɿগਓ਺ར༻Ͱ࢝ΊΔ σ ʛ λ ྔ
গ ଟ গ ଟ ར ༻ ऀ ਺ 5BCMFBV%FTLUPQɿར༻ऀ਺૿Ճ 5BCMFBV4FSWFSɿՄࢹԽͷڞ༗ 5BCMFBV4FSWFSɿσʔλͷߋ৽ 5BCMFBV4FSWFSɿՄࢹԽͷ഑৴ ॳظར༻࣌ͷσʔλ͕ऩ·Δ ΫϥελαΠζͰӡ༻։࢝ Ϋϥελσʔλ૿෼ϖʔεΛ೺Ѳ ΫϥελύϑΥʔϚϯεΛ֬ೝ ඞཁʹԠͨ͡Ϋϥελ֦ு΍ௐ੔ͷ࣮ࢪ ϊʔυ਺ͷ૿Ճ ϊʔυλΠϓͷมߋ ύϑΥʔϚϯενϡʔχϯάͷݕ౼ɾ࣮ࢪ 5BCMFBV4FSWFSɿ෼ࢄ؀ڥ΁ͷҠߦ ϫʔΫϩʔυ؅ཧͷݟ௚͠ 5BCMFBV.PCJMFɿ4FSWFSʴ.PCJMFͰͷར༻ 5BCMFBV3FBEFSɿࢀরܥίϯςϯπͷӾཡ

ՄࢹԽ΁ͷಓͷΓ ɾ៉ྷͳσʔλɺ෼ੳ͠΍͍͢σʔλʹ࣋ͬͯߦ͘ͷ͸ ɹ΍͸ΓҰےೄͰ͸͍͔ͳ͍ ͜ͷล͸σʔλͷ੔උ۩߹ʹ΋ΑΔ ɾ͍͖ͳΓશσʔλΛՄࢹԽɺͰ͸ແ͘·ͣগͣͭ͠ࢼͯ͠ΈΔ ɹˠͦ͜Ͱಘͨ஌ݟΛ࣍ճҎ߱ʹϑΟʔυόοΫͯ͠ߦ͘ͱεϜʔζ ɹˠݱ৔Ͱͷ໰୊՝୊ͷසग़Օॴɺखؒ޻਺ײΛ͋Δఔ౓೺Ѳग़དྷΔ ɾσʔλΛ์ΓࠐΉ͚ͩͰ͸ʰԿ͔ྑ͍ײ͡ʹʱʹ͸ͳΒͳ͍
ɾʰԿΛʱݟ͍͔ͨɺʰͳͥʱݟ͍͔ͨΛ ɹ໰ֻ͍͚ͳ͕ΒਐΊ͍ͯ͘ͷ͕େࣄ #IEgg

ɾ લड़ͷ ݱ৔Ͱͷ஌ݟڞ༗ɺϑΟʔυόοΫ ɾϕετϓϥΫςΟεΛࢀߟʹ͢Δ ɹɾςʔϒϧઃܭ 3FETIJGU ɹɾσʔλϩʔυ 3FETIJGU
ɹɾύϑΥʔϚϯενϡʔχϯά 3FETIJGU5BCMFBV ɹɾՄࢹԽɺϫʔΫϒοΫ࡞੒ 5BCMFBV #IEgg ՄࢹԽ΁ͷಓͷΓ

NJOVUFTQBTTFE #IEgg ͜͜ͰਫΛҿΉ ˞.BE.BY'VSZ3PBE0⒏DJBM5SBJMFSr8BSOFS#SPT6,:PV5VCF ɹIUUQTXXXZPVUVCFDPNXBUDI W:EL;B.T1%.

5BCMFBV ϕʔλ൛ల։தɺԼهαΠτʹͯ֓ཁˍར༻ਃࠐՄೳ IUUQXXXUBCMFBVDPNDPNJOHTPPO ˞ݱࡏ #IEgg

5BCMFBV 5BCMFBV৽ػೳ঺հʛγϦʔζʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQTFSJFTUBCMFBVOFXGFBUVSFT #IEgg

5BCMFBVϩʔυγϣʔ ੡඼͓൸࿐໨ձΠϕϯτ ɾ౦ژɺେࡕ #IEgg

5BCMFBV ʲσʔλʳ ɾΫϩεσʔλϕʔεδϣΠϯ ɾ৽نσʔλιʔεରԠ ɹɾ(PPHMF4IFFU .BSLFUP ,PHOJUP౳ ɾϫΠϧυΧʔυϢχΦϯ ɾநग़ࣦഊ࣌ͷ௨஌ػೳ
ʲϞόΠϧʳ ɾ"OESPJEରԠ ɾσόΠεຖͷը໘ϨΠΞ΢τ؅ཧ ɾϞόΠϧσόΠε؅ཧػೳ ɾετϦʔϜϥΠϯαΠϯΠϯػೳ ʲ8FCʳ ɾ8FC্ͰͷՄࢹԽฤूػೳ ɾσʔλιʔεͷར༻ঢ়گ෼ੳ ɾϦϏδϣϯཤྺػೳͷվળ ɾύϒϦογϡػೳͷվળ ʲ෼ੳʳ ɾΫϥελϦϯά ɾ৭ృΓϚοϓͷΧελϚΠζ ݁߹ ɾΫϩεσʔλιʔεϑΟϧλ ɾબ୒ཁૉͷϋΠϥΠτػೳ )JHIMJHIUFS ɾόʔνϟʔτͷվળ ɾ֤छάϥϑػೳͷػೳ௥Ճ ʲΤϯλʔϓϥΠζʳ ɾଞऀ΁ͷϝʔϧ഑৴͕Մೳʹ ɾ8FC%BUB$POOFDUPS ɾ֤छ"1*ػೳͷվળ ɾϒϥ΢βύϑΥʔϚϯεͷվળ ʲσβΠϯʳ ɾσβΠϯ໘ͷશ໘ϦχϡʔΞϧ ɾॻࣜઃఆ ओͳػೳIUUQXXXUBCMFBVDPNDPNJOHTPPO #IEgg

5BCMFBV ɾ$PNJOH4PPO ɹIUUQXXXUBCMFBVDPNDPNJOHTPPO ɾ#VTJOFTT*OUFMMJHFODF#MPHc5BCMFBV4PGUXBSF ɹIUUQTXXXUBCMFBVDPNKBKQBCPVUCMPH ɾ5BCMFBVϕʔλϓϩάϥϜʹࢀՃ͢Δͷཧ༝c5BCMFBV4PGUXBSF ɹIUUQXXXUBCMFBVDPNKBKQBCPVUCMPHSFBTPOTKPJOUBCMFBVCFUB ɾ5BCMFBV1BEBXBOT5JQT5SJDLT ɹIUUQUBCMFBVKQOCMPHTQPUKQ
ɾ5BCMFBV৽ػೳ঺հʛγϦʔζʛ%FWFMPQFST*0 ɹIUUQEFWDMBTTNFUIPEKQTFSJFTUBCMFBVOFXGFBUVSFT #IEgg

"NB[PO2VJDL4JHIU ɾ೥݄ɺ"84SF*OWFOUʹͯൃද ɾඇৗʹߴ଎ͳɺΫϥ΢υରԠͷ#*αʔϏε ɾݱࡏϓϨϏϡʔ൛ͰͷΈར༻Մೳ ɾ৘ใݯ ɹ "84ެࣜ ֓ཁIUUQTBXTBNB[PODPNKQRVJDLTJHIU ɹ
"84ެࣜ ྉۚIUUQTBXTBNB[PODPNKQRVJDLTJHIUQSJDJOH ɹ "84ެࣜ '"2IUUQTBXTBNB[PODPNKQRVJDLTJHIUGBRT ɹ %FWFMPQFST*0 2VJDL4JHIUಛू ɹIUUQEFWDMBTTNFUIPEKQSFGFSFODFDBUBXTRVJDLTUBSU #IEgg

"NB[PO2VJDL4JHIU #IEgg *OUSPEVDJOH"NB[PO2VJDL4JHIU:PV5VCFIUUQTXXXZPVUVCFDPNXBUDI W5KH89*W6

"NB[PO2VJDL4JHIU #IEgg ओͳػೳɾಛ௃ '"2ΑΓൈਮ ɾσʔληοτͷ࡞੒ ɾ෼ੳͷ࡞੒ ɾ෼ੳͷڞ༗ ɾର৅σʔλιʔε
ɹɾϦϨʔγϣφϧσʔλετΞ "NB[PO"VSPSBɺ"NB[PO3FETIJGUɺ ɹɹ"NB[PO3%4r.Z42-ɺ1PTUHSF42-ɺ.BSJB%#ɺ0SBDMFɺ42-TFSWFSɺ ɹɹ"NB[PO&$Ͱ࣮ߦ͞ΕΔΧελϜͷ+%#$0%#$σʔλϕʔεɺ·ͨ͸ΦϯϓϨϛε ɹɾϑΝΠϧΞοϓϩʔυ $47ɺ547ɺ$-'ɺ͓Αͼ&-' ɺ ɹɾ.BQ3FEVDFσʔλετΞ "NB[PO&.3 ɹɾ/P42-σʔλετΞ "NB[PO%ZOBNP%# ɹɾετϦʔϛϯάσʔλιʔε "NB[PO,JOFTJT͓Αͼ"NB[PO%ZOBNP%#ετϦʔϜ ɹɾ"1*ϕʔεͷσʔλιʔε 4BMFTGPSDF ˞Α͋͘Δ࣭໰"NB[PO2VJDL4JHIUc"84IUUQTBXTBNB[PODPNKQRVJDLTJHIUGBRT

41*$& #IEgg ˞"NB[PO2VJDL4JHIUʢߴ଎ͷϏδωεΠϯςϦδΣϯεʣc"84IUUQTBXTBNB[PODPNKQRVJDLTJHIU Ϋϥ΢υͷͨΊʹҰ͔Βઃܭ͞Εͨ"NB[PO2VJDL4JHIUͷ௒ߴ଎ͰύϥϨϧɺΠϯϝϞϦͷܭࢉΤϯδϯ ʮ41*$&ʯ͸ɺྻࢦ޲ετϨʔδͷ૊Έ߹Θͤɺ࠷৽ͷϋʔυ΢ΣΞΠϊϕʔγϣϯʹΑͬͯՄೳʹͳͬͨΠϯϝ ϞϦٕज़ɺϚγϯίʔυੜ੒ɺσʔλѹॖΛར༻͍ͯ͠ΔͷͰɺϢʔβʔ͕େن໛σʔληοτʹΠϯλϥΫςΟ ϒͳΫΤϦΛ࣮ߦ͠ɺ͢͹΍͘ϨεϙϯεΛಘΔ͜ͱΛՄೳʹ͠·͢ɻ41*$&͸ॆ࣮ͨ͠ܭࢉΛαϙʔτ͍ͯ͠Δ ͷͰɺސ٬͕ΠϯϑϥετϥΫνϟͷϓϩϏδϣχϯά΍؅ཧʹ͍ͭͯҰ੾৺഑͢Δ͜ͱͳ͘෼ੳ͔ΒՁ஋͋Δಎ ࡯ΛಘΔͷʹ໾ཱͪ·͢ɻ41*$&Ͱ͸σʔλ͕ߴՄ༻ੑͷͨΊʹࣗಈతʹෳ੡͞Εɺ·ͨ"NB[PO2VJDL4JHIU
Λ਺ઍਓ΋ͷϢʔβʔ͕ɺଟ࠼ͳ"84ͷσʔλιʔεશମͰߴ଎͔ͭΠϯλϥΫςΟϒͳ෼ੳΛ͢΂ͯಉ࣌ʹ࣮ ߦ͢ΔͨΊʹεέʔϧͤ͞Δ͜ͱ΋Մೳʹ͠·͢ɻ 4VQFSGBTU 1BSBMMFM *ONFNPSZ $BMDVMBUJPO &OHJOF

ηϛφʔ։࠵ͷ͓஌Βͤ #IEgg ݄ॳ०ɺେࡕʹͯ։࠵͠·͢ʂ ˞<࣮ࢪࡁ>࣌ؒͰθϩ͔Βֶ΂Δ"84Ϗοάσʔλ෼ੳϋϯζΦϯηϛφʔ ɹ ྲྀ௨ۀϚʔέςΟϯά୲౰༷޲͚ ʛ&WFOU3FHJTUʢΠϕϯτϨδετʣ ɹIUUQFWFOUSFHJTUDPNFDMBTTNFUIPE@

ΧελϚʔετʔϦʔɾΞφϦςΟΫε Ծ #IEgg ɾҰݴͰݴ͏ͱʮσʔλ෼ੳج൫ૣظಋೖςϯϓϨʔτʯɻ ɾσʔλ෼ੳͷج൫ͱͳΔ؀ڥΛ"84্ʹૣ͘ɺ҆͘ߏங ˞ఏڙ༧ఆػೳ ͷҰ෦ ɾςʔϒϧࣗಈੜ੒ɺΧϥϜ௥ՃରԠ
ɾϩʔυσʔλࣗಈม׵ʢจࣈίʔυɺ࣌ࠁදه౳ʣ ɾϑΝΠϧϩʔυॲཧࣗಈԽɺࣦഊ࣌ॲཧϧʔϧԽ ɾอकӡ༻αϙʔτʢεέʔϧΞοϓɺεέʔϧΞ΢τʣ ɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹ˞೥಺ఏڙ։࢝༧ఆɹ

ϝϯόʔζ ϝϯόʔζʛΫϥεϝιουגࣜձࣾIUUQTDMBTTNFUIPEKQTFSWJDFTNFNCFST

8FBSF)JSJOH ˞Ϋϥεϝιουͷࣾ಺੍౓ͱࣾ෩Λ͝঺հ͠·͢ʛ%FWFMPQFST*0IUUQEFWDMBTTNFUIPEKQFUDJOUSPEVDFBOJOIPVTFTZTUFN ˞࠾༻৘ใʛΫϥεϝιουגࣜձࣾIUUQDMBTTNFUIPEKQSFDSVJU ձࣾઆ໌ձ!େࡕΛ։࠵͠·͢ʂ ୈճΫϥεϝιουձࣾઆ໌ձʲେࡕฤʳʛ%FWFMPQFST*0 IUUQEFWDMBTTNFUIPEKQOFXTKPCGBJS

࠷ޙ·Ͱ͝ཡ௖͖͋Γ͕ͱ͏͍͟͝·ͨ͠ɻ Thank you for Witnessing My Session.

AWS(Amazon Redshift)とTableauではじめるビッグデータ分析 / Get...

AWS(Amazon Redshift)とTableauではじめるビッグデータ分析 / Getting started Bigdata Analysis with Amazon Redshift and Tableau in Innovation Egg 8th

More Decks by shinyaa31

Other Decks in Technology

Featured

Transcript