AWS分析系＆IaCサービス入門

BigData-JAWS 勉強会 #24 QuickSight分科会
https://jawsug-bigdata.connpass.com/event/284869/

Transcript

1. "84෼ੳܥʴ*B$αʔϏεೖ໳
   (MVF "UIFOB 2VJDL4JHIU $%,
   ΈͷΔΜ !NJOPSVO
   

   View Slide

2. XIPBNJ
   御⽥ 稔 !NJOPSVO
   ,%%*גࣜձࣾ ˍ ,%%*ΞδϟΠϧ։ൃηϯλʔגࣜձࣾʢ,"(ʣ
   ࠷ۙɺຖ೔2JJUBॻ͍ͯͨΒʮޚా͸࣮͸ਓ͍Δʯͱ
   ࣾ಺Ͱ·͜ͱ͠΍͔ʹݴΘΕΔΑ͏ʹͳΓ·ͨ͠
   +"846(43&ࢧ෦ӡӦ +"84%":4࣮ߦҕһ
   • "84$PNNVOJUZ#VJMEFS
   • ,%%*$MPVE4".63"*
   • ,%%*$MPVE"NCBTTBEPST
   

   View Slide

3. ,%%*Ͱ͸$$P&νʔϜͷऔΓ૊Έͱͯ͠
   ࣾ಺ͷ"84ར༻ঢ়گՄࢹԽπʔϧΛ։ൃ͍ͯ͠·͢💪
   ˞$$P&ʹ $MPVE$FOUFSPG&YFMMFODF
   ࣲాʢ10ʣ ޚాʢΤϯδχΞʣ
   ຤ޫʢ4.ʣ
   

   View Slide

4. ௨শ,$-67*5ʢΫϧʔϏοτʣ
   ,%%*$MPVE6UJMJ[BUJPO
   7JTVBMJ[BUJPO*OTJHIU5PPM
   

   View Slide

5. ྫ͑͹ɺࣾ಺ͷ"84Ϣʔβʔ͔Β
   Α͘ฉ͘ͷ͕ʜ
   

   View Slide

6. ͪΐͬͱલʹ("͞ΕͨYYYͱ͍͏
   "84ͷ৽αʔϏε͕ؾʹͳΔΜ͚ͩͲɺ
   ࣾ಺Ͱ࢖ͬͯΔਓ͍ͳ͍͔ͳ͊ʁ
   ίϯγϡʔϚʔ޲͚γεςϜͷ
   Πϯϑϥӡ༻୲౰
   

   View Slide

7. ΫϧʔϏοτͳΒ"84αʔϏε໊Λબ୒͢Δ͚ͩͰ
   ར༻ΞΧ΢ϯτɾҊ໊݅ɾ෦ॺؙ໊͕Θ͔Γʂ
   ౷ׅ
   ຊ෦
   ຊ෦ ෦ ΞΧ΢
   ϯτ*%
   ༻్
   ʢҊ໊݅ͳͲʣ
   ίετ
   

   View Slide

8. ͦͷத͔Β"84ΞΧ΢ϯτΛҰͭબ୒͢Δͱ
   ར༻தαʔϏεͷߏ੒ൺ͕ݟΒΕ·͢
   

   View Slide

9. ࣾ಺ʹ"84ΞΧ΢ϯτ͕ Ҏ্͋ΔͷͰ
   ͜ͷπʔϧ͸͔ͳΓॏๅ͠·͢ɻ
   
   

   View Slide

10. ࣮͸͜ͷπʔϧɺ"84ͷ1SP4FSWF͞Μʹ
    ϓϩτΛ࡞ͬͯ΋Β͍·ͨ͠
    ͦͷޙɺࣗ෼ͨͪͰ಺੡Τϯϋϯε͍ͯ͠·͢
    

    View Slide

11. ͕͢͞"84͞Μ͕
    ॳظઃܭ͚ͨͩ͋ͬͯ͠ɺ
    ෼ੳܥϚωʔδυαʔϏεͷ
    ͓खຊߏ੒ʹͳ͍ͬͯ·͢ɻ
    ͦͯ͠$%,Ͱ͹ͬͪΓ*B$ԽࡁΈʂ
    

    View Slide

12. ࠓ೔͸͜ͷΫϧʔϏοτͷ
    ߏ੒Λ΋ͱʹɺ
    "84ͷ෼ੳܥˍ*B$αʔϏε
    ͷجຊΛΈͳ͞Μʹ঺հ͠·͢ɻ
    

    View Slide

13. ΫϧʔϏοτͷΞʔΩςΫνϟ঺հ
    

    View Slide

14. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    ར༻ऀ
    

    View Slide

15. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    

    View Slide

16. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    μογϡϘʔυ
    

    View Slide

17. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    ݕࡧΫΤϦʔ μογϡϘʔυ
    

    View Slide

18. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    σʔλΧλϩά
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    ݕࡧΫΤϦʔ μογϡϘʔυ
    

    View Slide

19. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    σʔλιʔε σʔλΧλϩά
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    ݕࡧΫΤϦʔ μογϡϘʔυ
    

    View Slide

20. "UIFOB͔Βඥղ͘ͱ෼͔Γ΍͍͢
    (MVF 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    σʔλιʔε σʔλΧλϩά
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    μογϡϘʔυ
    "UIFOB
    ݕࡧΫΤϦʔ
    

    View Slide

21. "NB[PO"UIFOBͱ͸ʁ
    

    View Slide

22. "NB[PO"UIFOBͱ͸ʁ
    ҰݴͰ͍͏ͱ4ͷσʔλΛ42-Ͱ෼ੳͰ͖ΔαʔϏεɻ
    "UIFOB
    4
    

    View Slide

23. "NB[PO"UIFOBͱ͸ʁ
    ͜Ε·Ͱɺܗ͕ࣜἧ͍ͬͯͳ͍༷ʑͳσʔλΛ
    ·ͱΊͯ෼ੳ͢Δͷ͸೉͔ͬͨ͠ɻ
    4όέοτ
    $47 +40/ 1BSRVFU
    

    View Slide

24. "NB[PO"UIFOBͱ͸ʁ
    "UIFOB͸ςʔϒϧఆٛΛߦ͏͜ͱͰ
    ৭ΜͳσʔλΛ%#Խͯ͠42-Ͱ෼ੳՄೳʹͨ͠ʂ
    4όέοτ
    $47 +40/
    "UIFOB
    ςʔϒϧఆٛ
    ͜ͷ$47ͷྻ໨͸
    ʮ6TFS/BNFʯͱ͍͏จࣈྻσʔλͰ͐͢ʂ
    

    View Slide

25. "NB[PO"UIFOBͱ͸ʁ
    Ͱ΋͜ͷςʔϒϧఆٛɺखಈͰϙνϙνઃఆ͢ΔͷͰ
    ݩσʔλ͕ଟ͍ͱΊͪΌେมͳΜͰ͢💦
    

    View Slide

26. ͦ͜Ͱొ৔ͨ͠ͷ͕ʂ
    

    View Slide

27. υυυυʜ
    

    View Slide

28. υυυυʜ
    

    View Slide

29. υυυυʜ
    

    View Slide

30. "84(MVF
    

    View Slide

31. "84(MVFͱ͸ʁ
    खಈͰ"UIFOBͷςʔϒϧఆٛΛઃఆ͠ͳͯ͘΋
    4ΛࣗಈͰΫϩʔϧͯ͠%#Խͯ͘͠ΕΔʂ
    4όέοτ "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    

    View Slide

32. ͦͷͨΊ"UIFOBར༻࣌͸
    4(MVF"UIFOBͷ૊Έ߹Θ͕ͤԦಓɻ
    4όέοτ "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    "84(MVFͱ͸ʁ
    

    View Slide

33. (MVFͷ΋͏Ұͭͷػೳͱͯ͠&5-δϣϒ͕ར༻Մೳɻ
    σʔλม׵ͳͲΛαʔόʔϨεͰ࣮ߦͰ͖Δɻ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    4όέοτ
    (MVF
    &5-δϣϒ
    $47
    • σʔλܗࣜΛม׵
    • ෆཁͳྻΛ࡟আ
    "84(MVFͱ͸ʁ
    4όέοτ
    1BSRVFU
    

    View Slide

34. &5-δϣϒ͸؆қͳ΋ͷͳΒ1ZUIPOγΣϧɺ
    େن໛ͳॲཧ͸4QBSLʢ1ZUIPOPS4DBMBʣͰهड़Մೳɻ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    4όέοτ
    (MVF
    &5-δϣϒ
    $47
    • σʔλܗࣜΛม׵
    • ෆཁͳྻΛ࡟আ
    "84(MVFͱ͸ʁ
    4όέοτ
    1BSRVFU
    

    View Slide

35. ,$-67*5Ͱ͸$PTU&YQMPSFSͷݩσʔλʢ$63ˍ%#3ʣΛ
    &5-δϣϒͰ1BSRVFUܗࣜʹม׵ͯ͠·ͱΊͯ·͢ɻ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    4όέοτ
    (MVF
    &5-δϣϒ
    $47
    1BSRVFU
    "84(MVFͱ͸ʁ
    4όέοτ
    1BSRVFU
    • ίετͱ࢖༻ঢ়گ
    Ϩϙʔτʢ$63ʣ
    • چɿ੥ٻ໌ࡉ
    Ϩϙʔτʢ%#3ʣ ෼ੳઐ༻ͷܗࣜʹͯ͠
    εϦϜԽˍίετ࡟ݮ
    

    View Slide

36. ͜Μͳײ͡Ͱ༷ʑͳσʔλΛ
    ކʢHMVFʣͷΑ͏ʹܨ͗߹Θͤͯ͘ΕΔΜͰ͢ʂ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    4όέοτ &5-δϣϒ
    $47
    1BSRVFU
    "84(MVFͱ͸ʁ
    (MVF
    (MVF
    4όέοτ
    1BSRVFU
    

    View Slide

37. ϫʔΫϑϩʔػೳΛ࢖͑͹
    &5-δϣϒ΍ΫϩʔϥʔΛ
    4UFQ'VODUJPOTͷΑ͏ʹ
    (6*Ͱ૊Έ߹ΘͤΒΕΔ
    "84(MVFͱ͸ʁ
    

    View Slide

38. "NB[PO2VJDL4JHIUͱ͸ʁ
    

    View Slide

39. "NB[PO2VJDL4JHIUͱ͸ʁ
    ࠓݟ͖ͯͨ఺ηοτͰͷσʔλ෼ੳ͸
    ࣗ෼Ͱ42-Λॻ͖ɺ݁Ռ͸ςΩετͰग़ྗ͞ΕΔελΠϧɻ
    (MVF "UIFOB
    4
    • ച্ཤྺͷ$47
    • ঎඼Ϛελͷ&YDFM
    ઌ݄ͷച্૯ֹτοϓ
    ͷ঎඼໊Λग़ྗʂ
    

    View Slide

40. "NB[PO2VJDL4JHIUͱ͸ʁ
    ϢʔεέʔεʹΑͬͯ͸ʮ42-Λॻ͘ͷ͕ϋʔυϧʯ΍
    ʮ݁ՌΛάϥϑͰද͍ࣔͨ͠ʯ͜ͱ΋͋Γɻ
    

    View Slide

41. "NB[PO2VJDL4JHIUͱ͸ʁ
    ͦ͜Ͱศརͳͷ͕2VJDL4JHIUʂ
    (MVF "UIFOB
    4 2VJDL4JHIU
    

    View Slide

42. "NB[PO2VJDL4JHIUͱ͸ʁ
    (6*Ͱ৚݅Λઃఆ͢Δ͚ͩͰάϥϑΛग़ྗͯ͘͠ΕΔɻ
    

    View Slide

43. "NB[PO2VJDL4JHIUͱ͸ʁ
    ଞͷσʔλιʔεΛݩʹʮσʔληοτʯΛ࡞੒ɻ
    ͜ΕΛʮ෼ੳʯͰՄࢹԽ͠ɺμογϡϘʔυͱͯ͠ެ։Ͱ͖Δ
    (MVF "UIFOB
    4
    2VJDL4JHIU
    σʔλ
    ηοτ
    ෼ੳ μογϡ
    Ϙʔυ
    σʔλιʔε
    

    View Slide

44. "NB[PO2VJDL4JHIUͱ͸ʁ
    σʔλιʔεʹ͸"UIFOB΍3%4ͳͲͷ"84Ϧιʔεͷଞɺ
    5XJUUFS΍4OPXGMBLFͳͲͷ֎෦4BB4ʹ΋ରԠɻ
    "UIFOB
    2VJDL4JHIU
    σʔλ
    ηοτ
    ෼ੳ μογϡ
    Ϙʔυ
    σʔλιʔεʢ෼ੳର৅ʣ
    3%4
    5XJUUFS
    4OPXGMBLF
    ˞΄͔ଟ਺ରԠ
    

    View Slide

45. "84$%,ͱ͸ʁ
    

    View Slide

46. $%,ͬͯͲΕ͚ͩͬͨͬʁ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    👉
    

    View Slide

47. "84$%,ͱ͸ʁ
    ͍ΘΏΔ*B$ʢ*OGSBTUSVDUVSFBT$PEFʣπʔϧͷҰͭɻ
    

    View Slide

48. "84$%,ͱ͸ʁ
    Ϋϥ΢υͷૢ࡞͸"1*ͰߦΘΕ͍ͯΔͨΊɺࣗಈԽ͕Մೳɻ
    Թ΋Γͷ͋ΔϚωίϯख࡞ۀΛଔۀͰ͖Δʂ
    

    View Slide

49. "84$%,ͱ͸ʁ
    *B$πʔϧ͸SEύʔςΟ΋ؚΊ͍͔ͯͭ͋͘Γ·͢ɻ
    5FSSBGPSN $MPVE'PSNBUJPO $%,
    

    View Slide

50. "84$%,ͱ͸ʁ
    5FSSBGPSN $MPVE'PSNBUJPO $%,
    SEπʔϧɻ
    "84Ҏ֎ʹ΋ରԠ
    "84ͷݩ૆*B$αʔϏεɻ
    ఆٛϑΝΠϧ෩ʹهड़͢Δ
    5ZQF4DSJQUͳͲͷݴޠͰ
    $'OςϯϓϨʔτΛੜ੒͢Δ
    ϥοϐϯά
    

    View Slide

51. $'Oͱ$%,ͷߏ੒ཁૉ
    $MPVE'PSNBUJPO $%,
    ςϯϓϨʔτ
    ʢ+40/:".-ఆٛϑΝΠϧʣ
    ελοΫ
    ʢੜ੒͞ΕΔ"84Ϧιʔε܈ʣ
    • ྫɿ424ʴ-BNCEBʴ4
    ΞϓϦέʔγϣϯ
    ελοΫ
    ίϯετϥΫτʢྫɿ424ʴ-BNCEBʣ
    ίϯετϥΫτʢྫɿ4ʣ
    

    View Slide

52. $'O WT$%,
    $MPVE'PSNBUJPO $%,
    ελοΫ
    ʢ௕ׂ͗ͯ͢Ѫʣ
    ΞϓϦέʔγϣϯ
    ελοΫ
    ʢίϯετϥΫτར༻ʣ
    ʴ
    

    View Slide

53. ,$-67*5ͷίʔυྫ
    CJO
    MJC
    SFTPVSDFT
    HMVF
    MBNCEB
    ΞϓϦέʔγϣϯUT
    ελοΫUT
    ίϯετϥΫτUT
    ίϯετϥΫτUT
    &5-δϣϒQZ
    ϑΝϯΫγϣϯQZ
    ΠϯελϯεԽ
    ελοΫੜ੒
    Πϯϑϥ
    ʢ$%,ʣ
    ΞϓϦ
    $PEF$PNNJU
    ҰॹʹσϓϩΠ
    

    View Slide

54. ࠷ॳ͔Β$%,ͰίʔυԽ͞Ε͍͓͔ͯͨ͛Ͱɺ
    ։ൃ؀ڥͷ૿ங͕͔ͳΓ؆ུԽͰ͖·ͨ͠ʂ
    

    View Slide

55. ࠷ޙʹએ఻
    

    View Slide

56. ,%%*ΞδϟΠϧ։ൃηϯλʔʢ,"(ʣઈࢍ࠾༻தʂ
    ϑϧϦϞʔτͳιϑτ΢ΣΞΤϯδχΞઈࢍืूͯ͠·͢👍
    

    View Slide

57. དྷिܾணʂ2JJUBͰձࣾର߅͍͍ͶҐΛૂͬͯ·͢🔥
    RJJUBDPNPSHBOJ[BUJPOTLEEJBHJMF
    

    View Slide

58. +"846(౦ژϦϒʔτ͠·͢💪
    ৽ελΠϧ͸ΦϯϥΠϯಛԽʂϑϦʔςʔϚͷϥϯνλΠϜ-5ձ
    

    View Slide