Tableau Server on AWS～データ分析の結果を活かすために

https://dev.classmethod.jp/business/business-analytics/higobashiaws-tableau-server-on-aws

Transcript

1. 5BCMFBV
   4FSWFS
   PO
   "84
   ʙσʔλ෼ੳͷ݁ՌΛ׆͔ͨ͢Ίʹʙ σʔλΠϯςάϨʔγϣϯ෦
   ۄҪ
   ྭ
2. εϥΠυ͸ޙͰೖख͢Δ͜ͱ͕ग़དྷ·͢ͷͰ ൃදதͷ಺༰ΛϝϞ͢Δඞཁ͸͋Γ·ͤΜɻ ࣸਅࡱӨΛ͢Δ৔߹͸ ϑϥογϡɾγϟολʔԻ͕ग़ͳ͍Α͏ʹ͝഑ྀ͍ͩ͘͞ Attention
3. ࣗݾ঺հ
    ۄҪ
   ྭʢλϚΠ
   ϨΠʣ
   wσʔλΠϯςάϨʔγϣϯ෦
   w੡඼αϙʔτνʔϜɹϦʔμʔ
   wେࡕΦϑΟε
   w൒෼Ҏ্͸ࣗ୐ʢಸྑݝʣͰϦϞʔτϫʔΫ
   w"84ೝఆࢿ֨θϩ • Tableau Desktop Qualified Associate • Tableau Server Qualified Associate • Alteryx Designer Core • Alteryx Designer Advanced
4. ࢲͷ%FWFMPQFST*0
   
5. ຊηογϣϯͰ఻ΘΔͱخ͍͜͠ͱ
    w σʔλ෼ੳΛ׆༻͢ΔͨΊʹ͸ɺ݁ՌͷՄࢹԽͱڞ༗ ͕େࣄ
   w ʢ্هΛ࣮ݱ͢Δํ๏͸৭ʑ͋Δ͕ʣ"84ͱ 5BCMFBVΛ૊Έ߹ΘͤΔͱ޾ͤʹͳΕΔʢ͔΋ʣ
6. ຊηογϣϯͷΞδΣϯμ
    w σʔλ෼ੳʹ͓͚ΔʮՄࢹԽʯͱʮڞ༗ʯʹ͍ͭͯ
   w ʮ5BCMFBVʯͱ͸
   w "84ͱ5BCMFBVͷؔ܎
   w 5BCMFBV
   4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δͱ޾ͤ
7. ຊηογϣϯͰ͠Ό΂Βͳ͍͜ͱ
    w ػցֶशؔ࿈ͷ"84αʔϏεࣗମͷ࿩
   w ޙͷਓ͕ͨͬͬͬ΀Γ͓࿩͠·͢ɻ
   w ෼ੳख๏ͷ࿩
   w 5BCMFBVͷৄ͍͠આ໌
   w "NB[PO
   2VJDL4JHIU
8. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
    ͳͥσʔλ෼ੳΛ͢Δͷ͔ʁ
9. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
    ʮ՝୊ʯΛղܾ͢ΔͨΊ
10. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
     ՝୊ ࢪࡦ σʔλ෼ੳ ༏ྑސ٬Λ૿΍͍ͨ͠ ༏ྑސ٬ʹͳΓͦ͏ͳϢʔβʔΛ ಛఆͯ͠Ξϓϩʔν͢Δ ϢʔβʔσʔλΛ෼ੳͯ͠
    ༏ྑސ٬ϞσϧΛ࡞੒͢Δ ࣗࣾαʔϏεͷձһొ࿥ͷ࣌఺Ͱ ཭୤͢ΔϢʔβʔ͕͍Δ ཭୤͢ΔϙΠϯτΛௐ΂Δ
    ͦͷϙΠϯτΛվળ͢Δ ձһొ࿥ϖʔδͷ
    ΞΫηεσʔλΛ෼ੳ͢Δ ࣗࣾͷػց͕༧ظͤ͵λΠϛϯά Ͱނোͯ͠ࠔ͍ͬͯΔ ػցͷނোΛ༧ଌͯ͠ରԠ͢Δ *P5ͷϩάσʔλΛ෼ੳ͢Δ ※͋͘·ͰྫͰ͢
11. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
     w ղܾ͍ͨ͠՝୊͕͋Δ
    w ͦͷ՝୊Λղܾ͢ΔͨΊʹɺԿΒ͔ͷҙࢥܾఆΛߦ͏ ඞཁ͕͋Δ
    w ʮ˓˓ͱ͍͏ࢪࡦΛ࣮ࢪͯ͠ɺ՝୊Λղܾ͢Δʯͱ͍ ͏໨తͷͨΊʹσʔλ෼ੳΛߦ͏
12. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
     "*ɺػցֶशɺڭࢣ͋Γֶशɺڭࢣͳֶ͠शɺڧԽֶशɺ χϡʔϥϧωοτϫʔΫɺσΟʔϓϥʔχϯάɺ 1ZUIPOɺKVQZUFS
    OPUFCPPLɺ3ݴޠɺEQMZSɺ "NB[PO
    4BHF.BLFSɺ5FOTPS'MPXɺ1Z5PSDIɺ "QBDIF
    .9/FUɺ$IBJOFSɺ9(#PPTUɺઢܗճؼɺࢦ ਺ฏ׈๏ɺ୯ճؼ෼ੳɺॏճؼ෼ੳɺओ੒෼෼ੳɺܾఆ໦ ෼ੳɺҼࢠ෼ੳɺUݕఆɺΧΠೋ৐ݕఆɺίϯδϣΠϯτ ෼ੳɺΞιγΤʔγϣϯ෼ੳɺ8IBU*G෼ੳɺόϯσΟο τΞϧΰϦζϜɺϚϧίϑ࿈࠯ϞϯςΧϧϩ๏ɺϕΠδΞ ϯωοτϫʔΫɺϕΠζਪఆɺ8JO#6(4ʜFUD
    FUD
    FUDʜ
13. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
     "*ɺػցֶशɺڭࢣ͋Γֶशɺڭࢣͳֶ͠शɺڧԽֶशɺ χϡʔϥϧωοτϫʔΫɺσΟʔϓϥʔχϯάɺ 1ZUIPOɺKVQZUFS
    OPUFCPPLɺ3ݴޠɺEQMZSɺ "NB[PO
    4BHF.BLFSɺ5FOTPS'MPXɺ1Z5PSDIɺ "QBDIF
    .9/FUɺ$IBJOFSɺ9(#PPTUɺઢܗճؼɺࢦ ਺ฏ׈๏ɺ୯ճؼ෼ੳɺॏճؼ෼ੳɺओ੒෼෼ੳɺܾఆ໦ ෼ੳɺҼࢠ෼ੳɺUݕఆɺΧΠೋ৐ݕఆɺίϯδϣΠϯτ ෼ੳɺΞιγΤʔγϣϯ෼ੳɺ8IBU*G෼ੳɺόϯσΟο τΞϧΰϦζϜɺϚϧίϑ࿈࠯ϞϯςΧϧϩ๏ɺϕΠδΞ ϯωοτϫʔΫɺϕΠζਪఆɺ8JO#6(4ʜFUD
    FUD
    FUDʜ ͜ΕΒ͸ʮखஈʯ
14. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
     ໨తແ͖σʔλ෼ੳ͸ແҙຯ
15. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
     ! σʔλ෼ੳͷ݁ՌΛՄࢹԽ͢Δ
    ! ՄࢹԽͨ݁͠ՌΛڞ༗͢Δ σʔλ෼ੳΛ՝୊ͷղܾʹܨ͛ΔͨΊʹ͸ʁ ʮՄࢹԽʯͱʮڞ༗ʯΛߦ͏ྑ͍ํ๏ͱ͸ʜʁ
16. σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗
     AWS × Tabelau
17. 5BCMFBVͱ͸
     BIπʔϧͰ͢
18. 5BCMFBVͱ͸
    
19. 5BCMFBVͱ͸
     w 5BCMFBV
    %FTLUPQɹˠɹ7J[Λ࡞ΔʢՄࢹԽʣ
    w 5BCMFBV
    4FSWFSɹˠɹ7J[Λڞ༗͢Δʢڞ༗ʣ ˞7J[ɿσʔλΛࢹ֮Խͨ͠΋ͷɻ
    ɹϏϡʔͱ͔μογϡϘʔυͱ͔
20. 5BCMFBVͱ͸
     ! ૢ࡞ੑ
    ! දݱͰ͖Δ෯͕͍͢͝ 5BCMFBVͷڧ͍ͱ͜Ζ
21. 5BCMFBVͱ͸
     IUUQTQVCMJDUBCMFBVDPNKBKQTHBMMFSZUPLBJEPTIJOLBOTFO HBMMFSZGFBUVSFE
22. 5BCMFBVͱ͸
    
    https://public.tableau.com/views/IronViz2018Final-Weather-LocationisRelative/WeatherLocationisRelative?:embed=y&:display_count=yes
23. "84ͱ5BCMFBVͷؔ܎
     ࣮͸஥͕ྑ͍
24. "84ͱ5BCMFBVͷؔ܎
    
25. "84ͱ5BCMFBVͷؔ܎
    
26. "84ͱ5BCMFBVͷؔ܎
    "84
    SF*OWFOU
    
     ! &NFSBME
    ! %JBNPOE
    ! 1MBUJOVN
    ! (PME
    ! 4JMWFS
    ! #SPO[F
27. "84ͱ5BCMFBVͷؔ܎
    5BCMFBV
    $POGFSFODF
    
    
28. "84ͱ5BCMFBVͷؔ܎
     IUUQTQSFSFMFBTFUBCMFBVDPNLFZ"NB[PO4BHFNBLFS&YUFOTJPO
29. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     ͜ΕΒΛ૊Έ߹Θͤͯσʔλ෼ੳͷ݁ՌΛ εϚʔτʹڞ༗͢Δ
30. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     ! 8JOEPXT
    4FSWFS
    ! -JOVY
    04 ͬ͘͟Γݴ͏ͱɺԼهͷ04ʹΠϯετʔϧͯ͠࢖༻͠·͢
31. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     5BCMFBV
    4FSWFSʹ࠷దͳΠϯελϯελΠϓ͸ͣ͹Γʜ •C5.4xlarge
 •m5.4xlarge
 •r5.4xlarge

32. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     EC2Λ࡞ͬͯ ͦ͜ʹΠϯετʔϧ͢Ε͹ऴΘΓ͔ʁ
33. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     ऴΘΓ͡Όͳ͍
34. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     σʔλ෼ੳͷ݁Ռ͕ஔ͔ΕΔαʔϏε ͔ͬ͠Γ؅ཧ͢Δඞཁ͕͋Δ
35. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     w ηΩϡϦςΟ
    w σʔλ෼ੳ݁Ռͷ࿙Ӯ͸ϏδωεΠϯύΫτେ
    w ΞοϓάϨʔυ
    w 5BCMFBV͸ϲ݄ຖʹ৽όʔδϣϯϦϦʔε
    w ৽ػೳͷ௥Ճ΍ɺෆ۩߹౳ͷमਖ਼͕ߦΘΕΔ
    w ՄೳͳݶΓ࠷৽όʔδϣϯͷ5BCMFBV
    4FSWFSΛ࢖༻͢Δ
    w ؂ࢹ
    w σʔλ෼ੳ݁Ռ͕֬ೝͰ͖ͳ͍ͱ͍͏ঢ়ଶΛૣٸʹݕ஌͢Δ
    w όοΫΞοϓ
    w σʔλ෼ੳ݁Ռͷফࣦ͸ϏδωεΠϯύΫτେ
    w ͦͷଞ
36. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     ηΩϡϦςΟ
37. ηΩϡϦςΟ
     5BCMFBV
    4FSWFS͸ʢԿ΋ͯ͠ͳ͍ͱʣ੬ऑ
38. ηΩϡϦςΟ
     ! 63-͑͞஌͍ͬͯΕ͹୭Ͱ΋ΞΫηεՄೳ
    ! ύεϫʔυϙϦγʔͷઃఆෆՄ
    ! ύεϫʔυͷϩοΫػೳແ͠ Կ΋͍ͯ͠ͳ͍5BCMFBV
    4FSWFS͸ʜ
39. ηΩϡϦςΟ
     σʔλ෼ੳͷ݁Ռ͸ݫॏʹकΒͶ͹ͳΒͳ͍
40. ηΩϡϦςΟ
    
41. ηΩϡϦςΟ
     ʢ౰ͨΓલ͕ͩʣ"84ͷجຊతͳαʔϏεͰηΩϡϦςΟΛ୲อ͢Δ
42. ηΩϡϦςΟ
     w 5BCMFBV
    4FSWFSͷ؅ཧ্ɺ04ଆʹϩάΠϯ͢Δ࣌΋͋Δ
    w ౿Έ୆αʔόʔΛ༻ҙ͢Δ
43. ηΩϡϦςΟ
    
44. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     ΞοϓάϨʔυ
45. ΞοϓάϨʔυ
     ! ͦ΋ͦ΋݁ߏ໘౗͍͘͞
    ! ΞοϓάϨʔυத͸ར༻ෆՄ
    ! σʔλ෼ੳͷ݁ՌΛݟΕͳ͍͕࣌ؒൃੜ͢Δ
    ! σʔλ෼ੳͷ݁Ռͷ׆༻͕஗ΕΔ 5BCMFBV
    4FSWFSͷΞοϓάϨʔυ͸ʜ
46. ΞοϓάϨʔυ
     CloudFormationͰϒϧʔ&άϦʔϯσϓϩΠ
47. ΞοϓάϨʔυ
    
48. ΞοϓάϨʔυ
    
49. ΞοϓάϨʔυ
    
50. ΞοϓάϨʔυ
    
51. ΞοϓάϨʔυ
    
52. ΞοϓάϨʔυ
    
53. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     ؂ࢹ
54. ؂ࢹ
     ! ͜͜Ͱো֐͕ൃੜ͢Δͱ
    ! 5BCMFBV
    4FSWFS·Ͱಧ͔ͳ͍
    ! σʔλ෼ੳͷ݁ՌΛݟΕͳ͍࣌ؒ ͕ൃੜ͢Δ
    ! σʔλ෼ੳͷ݁Ռͷ׆༻͕஗ΕΔ
55. ؂ࢹ
     ELBʙTableau Serverؒͷো֐͸ૣٸʹݕ஌
56. ؂ࢹ
    
57. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     όοΫΞοϓ
58. όοΫΞοϓ
     ! εφοϓγϣοτͰͷόοΫΞοϓ෮چ͸ඇରԠ
    ! 5BCMFBV
    4FSWFSઐ༻ͷίϚϯυͰऔಘͨ͠όοΫΞοϓ ϑΝΠϧ͡Όͳ͍ͱμϝ
    ! UTN
    NBJOUFOBODF
    CBDLVQ 5BCMFBV
    4FSWFSͷόοΫΞοϓʢͱ෮چʣ͸ʜ
59. όοΫΞοϓ
     όοΫΞοϓΛ͘͠͡Δͱ σʔλ෼ੳͷ݁Ռ͕ࢮ͵
60. όοΫΞοϓ
     CloudWatchͱSSMͰࣗಈόοΫΞοϓ
61. όοΫΞοϓ
    
62. 5BCMFBV
    4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ
     ͦͷଞ
63. ֤छσʔλग़ྗ
     ! ʮొ࿥͞Ε͍ͯΔϢʔβʔͷϦετΛఏग़͍ͯͩ͘͠͞ʯ
    ! ʮొ࿥͞Ε͍ͯΔσʔλιʔεͷϦετΛఏग़͍ͯͩ͘͠͞ʯ
    ! ʮݖݶઃఆͷҰཡΛఏग़͍ͯͩ͘͠͞ʯ
    ! ʮ͜ΕΒ͸ຖ݄͓ئ͍͠·͢ʯ
    ! ʜͳͲͳͲ ૊৫ͷϧʔϧʢ৘γε౳ʣʹର͢Δ໘౗ͳରԠ
64. ֤छσʔλग़ྗ
     ͜͏͍ͬͨରԠʹ࣌ؒΛͱΒΕ͍ͯͯ͸ σʔλ෼ੳͷ׆༻ʹࢧো͕ग़Δʢ͔΋ʣ
65. ֤छσʔλग़ྗ
     LambdaͱTSCͰࣗಈతʹϦετΛग़ྗ
66. ֤छσʔλग़ྗ
     IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTUDSFQPSUSFTUBQJ
67. ֤छσʔλग़ྗ
    
68. ʲ࠶ܝʳຊηογϣϯͰ఻ΘΔͱخ͍͜͠ͱ
     w σʔλ෼ੳΛ׆༻͢ΔͨΊʹ͸ɺ݁ՌͷʮՄࢹԽʯͱ ʮڞ༗ʯ͕େࣄ
    w ʢ্هΛ࣮ݱ͢Δํ๏͸৭ʑ͋Δ͕ʣ"84ͱ 5BCMFBVΛ૊Έ߹ΘͤΔͱ޾ͤʹͳΕΔʢ͔΋ʣ