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

Slide 1

Slide 1 text

5BCMFBV4FSWFSPO"84 ʙσʔλ෼ੳͷ݁ՌΛ׆͔ͨ͢Ίʹʙ σʔλΠϯςάϨʔγϣϯ෦ ۄҪྭ

Slide 2

Slide 2 text

εϥΠυ͸ޙͰೖख͢Δ͜ͱ͕ग़དྷ·͢ͷͰ ൃදதͷ಺༰ΛϝϞ͢Δඞཁ͸͋Γ·ͤΜɻ ࣸਅࡱӨΛ͢Δ৔߹͸ ϑϥογϡɾγϟολʔԻ͕ग़ͳ͍Α͏ʹ͝഑ྀ͍ͩ͘͞ Attention

Slide 3

Slide 3 text

ࣗݾ঺հ ۄҪྭʢλϚΠϨΠʣ wσʔλΠϯςάϨʔγϣϯ෦ w੡඼αϙʔτνʔϜɹϦʔμʔ wେࡕΦϑΟε w൒෼Ҏ্͸ࣗ୐ʢಸྑݝʣͰϦϞʔτϫʔΫ w"84ೝఆࢿ֨θϩ • Tableau Desktop Qualiﬁed Associate • Tableau Server Qualiﬁed Associate • Alteryx Designer Core • Alteryx Designer Advanced

Slide 4

Slide 4 text

ࢲͷ%FWFMPQFST*0

Slide 5

Slide 5 text

ຊηογϣϯͰ఻ΘΔͱخ͍͜͠ͱ w σʔλ෼ੳΛ׆༻͢ΔͨΊʹ͸ɺ݁ՌͷՄࢹԽͱڞ༗ ͕େࣄ w ʢ্هΛ࣮ݱ͢Δํ๏͸৭ʑ͋Δ͕ʣ"84ͱ 5BCMFBVΛ૊Έ߹ΘͤΔͱ޾ͤʹͳΕΔʢ͔΋ʣ

Slide 6

Slide 6 text

ຊηογϣϯͷΞδΣϯμ w σʔλ෼ੳʹ͓͚ΔʮՄࢹԽʯͱʮڞ༗ʯʹ͍ͭͯ w ʮ5BCMFBVʯͱ͸ w "84ͱ5BCMFBVͷؔ܎ w 5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δͱ޾ͤ

Slide 7

Slide 7 text

ຊηογϣϯͰ͠Ό΂Βͳ͍͜ͱ w ػցֶशؔ࿈ͷ"84αʔϏεࣗମͷ࿩ w ޙͷਓ͕ͨͬͬͬ΀Γ͓࿩͠·͢ɻ w ෼ੳख๏ͷ࿩ w 5BCMFBVͷৄ͍͠આ໌ w "NB[PO2VJDL4JHIU

Slide 8

Slide 8 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ ͳͥσʔλ෼ੳΛ͢Δͷ͔ʁ

Slide 9

Slide 9 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ ʮ՝୊ʯΛղܾ͢ΔͨΊ

Slide 10

Slide 10 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ ՝୊ ࢪࡦ σʔλ෼ੳ ༏ྑސ٬Λ૿΍͍ͨ͠ ༏ྑސ٬ʹͳΓͦ͏ͳϢʔβʔΛ ಛఆͯ͠Ξϓϩʔν͢Δ ϢʔβʔσʔλΛ෼ੳͯ͠ ༏ྑސ٬ϞσϧΛ࡞੒͢Δ ࣗࣾαʔϏεͷձһొ࿥ͷ࣌఺Ͱ ཭୤͢ΔϢʔβʔ͕͍Δ ཭୤͢ΔϙΠϯτΛௐ΂Δ ͦͷϙΠϯτΛվળ͢Δ ձһొ࿥ϖʔδͷ ΞΫηεσʔλΛ෼ੳ͢Δ ࣗࣾͷػց͕༧ظͤ͵λΠϛϯά Ͱނোͯ͠ࠔ͍ͬͯΔ ػցͷނোΛ༧ଌͯ͠ରԠ͢Δ *P5ͷϩάσʔλΛ෼ੳ͢Δ ※͋͘·ͰྫͰ͢

Slide 11

Slide 11 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ w ղܾ͍ͨ͠՝୊͕͋Δ w ͦͷ՝୊Λղܾ͢ΔͨΊʹɺԿΒ͔ͷҙࢥܾఆΛߦ͏ ඞཁ͕͋Δ w ʮ˓˓ͱ͍͏ࢪࡦΛ࣮ࢪͯ͠ɺ՝୊Λղܾ͢Δʯͱ͍ ͏໨తͷͨΊʹσʔλ෼ੳΛߦ͏

Slide 12

Slide 12 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ "*ɺػցֶशɺڭࢣ͋Γֶशɺڭࢣͳֶ͠शɺڧԽֶशɺ χϡʔϥϧωοτϫʔΫɺσΟʔϓϥʔχϯάɺ 1ZUIPOɺKVQZUFSOPUFCPPLɺ3ݴޠɺEQMZSɺ "NB[PO4BHF.BLFSɺ5FOTPS'MPXɺ1Z5PSDIɺ "QBDIF.9/FUɺ$IBJOFSɺ9(#PPTUɺઢܗճؼɺࢦ ਺ฏ׈๏ɺ୯ճؼ෼ੳɺॏճؼ෼ੳɺओ੒෼෼ੳɺܾఆ໦ ෼ੳɺҼࢠ෼ੳɺUݕఆɺΧΠೋ৐ݕఆɺίϯδϣΠϯτ ෼ੳɺΞιγΤʔγϣϯ෼ੳɺ8IBU*G෼ੳɺόϯσΟο τΞϧΰϦζϜɺϚϧίϑ࿈࠯ϞϯςΧϧϩ๏ɺϕΠδΞ ϯωοτϫʔΫɺϕΠζਪఆɺ8JO#6(4ʜFUD FUD FUDʜ

Slide 13

Slide 13 text

Slide 14

Slide 14 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ ໨తແ͖σʔλ෼ੳ͸ແҙຯ

Slide 15

Slide 15 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ ! σʔλ෼ੳͷ݁ՌΛՄࢹԽ͢Δ ! ՄࢹԽͨ݁͠ՌΛڞ༗͢Δ σʔλ෼ੳΛ՝୊ͷղܾʹܨ͛ΔͨΊʹ͸ʁ ʮՄࢹԽʯͱʮڞ༗ʯΛߦ͏ྑ͍ํ๏ͱ͸ʜʁ

Slide 16

Slide 16 text

σʔλ෼ੳʹ͓͚ΔՄࢹԽͱڞ༗ AWS × Tabelau

Slide 17

Slide 17 text

5BCMFBVͱ͸ BIπʔϧͰ͢

Slide 18

Slide 18 text

5BCMFBVͱ͸

Slide 19

Slide 19 text

5BCMFBVͱ͸ w 5BCMFBV%FTLUPQɹˠɹ7J[Λ࡞ΔʢՄࢹԽʣ w 5BCMFBV4FSWFSɹˠɹ7J[Λڞ༗͢Δʢڞ༗ʣ ˞7J[ɿσʔλΛࢹ֮Խͨ͠΋ͷɻ ɹϏϡʔͱ͔μογϡϘʔυͱ͔

Slide 20

Slide 20 text

5BCMFBVͱ͸ ! ૢ࡞ੑ ! දݱͰ͖Δ෯͕͍͢͝ 5BCMFBVͷڧ͍ͱ͜Ζ

Slide 21

Slide 21 text

5BCMFBVͱ͸ IUUQTQVCMJDUBCMFBVDPNKBKQTHBMMFSZUPLBJEPTIJOLBOTFO HBMMFSZGFBUVSFE

Slide 22

Slide 22 text

5BCMFBVͱ͸ https://public.tableau.com/views/IronViz2018Final-Weather-LocationisRelative/WeatherLocationisRelative?:embed=y&:display_count=yes

Slide 23

Slide 23 text

"84ͱ5BCMFBVͷؔ܎ ࣮͸஥͕ྑ͍

Slide 24

Slide 24 text

"84ͱ5BCMFBVͷؔ܎

Slide 25

Slide 25 text

"84ͱ5BCMFBVͷؔ܎

Slide 26

Slide 26 text

"84ͱ5BCMFBVͷؔ܎ "84SF*OWFOU ! &NFSBME ! %JBNPOE ! 1MBUJOVN ! (PME ! 4JMWFS ! #SPO[F

Slide 27

Slide 27 text

"84ͱ5BCMFBVͷؔ܎ 5BCMFBV$POGFSFODF

Slide 28

Slide 28 text

"84ͱ5BCMFBVͷؔ܎ IUUQTQSFSFMFBTFUBCMFBVDPNLFZ"NB[PO4BHFNBLFS&YUFOTJPO

Slide 29

Slide 29 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ ͜ΕΒΛ૊Έ߹Θͤͯσʔλ෼ੳͷ݁ՌΛ εϚʔτʹڞ༗͢Δ

Slide 30

Slide 30 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ ! 8JOEPXT4FSWFS ! -JOVY04 ͬ͘͟Γݴ͏ͱɺԼهͷ04ʹΠϯετʔϧͯ͠࢖༻͠·͢

Slide 31

Slide 31 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ 5BCMFBV4FSWFSʹ࠷దͳΠϯελϯελΠϓ͸ͣ͹Γʜ •C5.4xlarge  •m5.4xlarge  •r5.4xlarge 

Slide 32

Slide 32 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ EC2Λ࡞ͬͯ ͦ͜ʹΠϯετʔϧ͢Ε͹ऴΘΓ͔ʁ

Slide 33

Slide 33 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ ऴΘΓ͡Όͳ͍

Slide 34

Slide 34 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ σʔλ෼ੳͷ݁Ռ͕ஔ͔ΕΔαʔϏε ͔ͬ͠Γ؅ཧ͢Δඞཁ͕͋Δ

Slide 35

Slide 35 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ w ηΩϡϦςΟ w σʔλ෼ੳ݁Ռͷ࿙Ӯ͸ϏδωεΠϯύΫτେ w ΞοϓάϨʔυ w 5BCMFBV͸ϲ݄ຖʹ৽όʔδϣϯϦϦʔε w ৽ػೳͷ௥Ճ΍ɺෆ۩߹౳ͷमਖ਼͕ߦΘΕΔ w ՄೳͳݶΓ࠷৽όʔδϣϯͷ5BCMFBV4FSWFSΛ࢖༻͢Δ w ؂ࢹ w σʔλ෼ੳ݁Ռ͕֬ೝͰ͖ͳ͍ͱ͍͏ঢ়ଶΛૣٸʹݕ஌͢Δ w όοΫΞοϓ w σʔλ෼ੳ݁Ռͷফࣦ͸ϏδωεΠϯύΫτେ w ͦͷଞ

Slide 36

Slide 36 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ ηΩϡϦςΟ

Slide 37

Slide 37 text

ηΩϡϦςΟ 5BCMFBV4FSWFS͸ʢԿ΋ͯ͠ͳ͍ͱʣ੬ऑ

Slide 38

Slide 38 text

ηΩϡϦςΟ ! 63-͑͞஌͍ͬͯΕ͹୭Ͱ΋ΞΫηεՄೳ ! ύεϫʔυϙϦγʔͷઃఆෆՄ ! ύεϫʔυͷϩοΫػೳແ͠ Կ΋͍ͯ͠ͳ͍5BCMFBV4FSWFS͸ʜ

Slide 39

Slide 39 text

ηΩϡϦςΟ σʔλ෼ੳͷ݁Ռ͸ݫॏʹकΒͶ͹ͳΒͳ͍

Slide 40

Slide 40 text

ηΩϡϦςΟ

Slide 41

Slide 41 text

ηΩϡϦςΟ ʢ౰ͨΓલ͕ͩʣ"84ͷجຊతͳαʔϏεͰηΩϡϦςΟΛ୲อ͢Δ

Slide 42

Slide 42 text

ηΩϡϦςΟ w 5BCMFBV4FSWFSͷ؅ཧ্ɺ04ଆʹϩάΠϯ͢Δ࣌΋͋Δ w ౿Έ୆αʔόʔΛ༻ҙ͢Δ

Slide 43

Slide 43 text

ηΩϡϦςΟ

Slide 44

Slide 44 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ ΞοϓάϨʔυ

Slide 45

Slide 45 text

ΞοϓάϨʔυ ! ͦ΋ͦ΋݁ߏ໘౗͍͘͞ ! ΞοϓάϨʔυத͸ར༻ෆՄ ! σʔλ෼ੳͷ݁ՌΛݟΕͳ͍͕࣌ؒൃੜ͢Δ ! σʔλ෼ੳͷ݁Ռͷ׆༻͕஗ΕΔ 5BCMFBV4FSWFSͷΞοϓάϨʔυ͸ʜ

Slide 46

Slide 46 text

ΞοϓάϨʔυ CloudFormationͰϒϧʔ&άϦʔϯσϓϩΠ

Slide 47

Slide 47 text

ΞοϓάϨʔυ

Slide 48

Slide 48 text

ΞοϓάϨʔυ

Slide 49

Slide 49 text

ΞοϓάϨʔυ

Slide 50

Slide 50 text

ΞοϓάϨʔυ

Slide 51

Slide 51 text

ΞοϓάϨʔυ

Slide 52

Slide 52 text

ΞοϓάϨʔυ

Slide 53

Slide 53 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ ؂ࢹ

Slide 54

Slide 54 text

؂ࢹ ! ͜͜Ͱো֐͕ൃੜ͢Δͱ ! 5BCMFBV4FSWFS·Ͱಧ͔ͳ͍ ! σʔλ෼ੳͷ݁ՌΛݟΕͳ͍࣌ؒ ͕ൃੜ͢Δ ! σʔλ෼ੳͷ݁Ռͷ׆༻͕஗ΕΔ

Slide 55

Slide 55 text

؂ࢹ ELBʙTableau Serverؒͷো֐͸ૣٸʹݕ஌

Slide 56

Slide 56 text

؂ࢹ

Slide 57

Slide 57 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ όοΫΞοϓ

Slide 58

Slide 58 text

όοΫΞοϓ ! εφοϓγϣοτͰͷόοΫΞοϓ෮چ͸ඇରԠ ! 5BCMFBV4FSWFSઐ༻ͷίϚϯυͰऔಘͨ͠όοΫΞοϓ ϑΝΠϧ͡Όͳ͍ͱμϝ ! UTNNBJOUFOBODFCBDLVQ 5BCMFBV4FSWFSͷόοΫΞοϓʢͱ෮چʣ͸ʜ

Slide 59

Slide 59 text

όοΫΞοϓ όοΫΞοϓΛ͘͠͡Δͱ σʔλ෼ੳͷ݁Ռ͕ࢮ͵

Slide 60

Slide 60 text

όοΫΞοϓ CloudWatchͱSSMͰࣗಈόοΫΞοϓ

Slide 61

Slide 61 text

όοΫΞοϓ

Slide 62

Slide 62 text

5BCMFBV4FSWFSΛ"84Ͱߏஙɾӡ༻͢Δ ͦͷଞ

Slide 63

Slide 63 text

֤छσʔλग़ྗ ! ʮొ࿥͞Ε͍ͯΔϢʔβʔͷϦετΛఏग़͍ͯͩ͘͠͞ʯ ! ʮొ࿥͞Ε͍ͯΔσʔλιʔεͷϦετΛఏग़͍ͯͩ͘͠͞ʯ ! ʮݖݶઃఆͷҰཡΛఏग़͍ͯͩ͘͠͞ʯ ! ʮ͜ΕΒ͸ຖ݄͓ئ͍͠·͢ʯ ! ʜͳͲͳͲ ૊৫ͷϧʔϧʢ৘γε౳ʣʹର͢Δ໘౗ͳରԠ

Slide 64

Slide 64 text

֤छσʔλग़ྗ ͜͏͍ͬͨରԠʹ࣌ؒΛͱΒΕ͍ͯͯ͸ σʔλ෼ੳͷ׆༻ʹࢧো͕ग़Δʢ͔΋ʣ

Slide 65

Slide 65 text

֤छσʔλग़ྗ LambdaͱTSCͰࣗಈతʹϦετΛग़ྗ

Slide 66

Slide 66 text

֤छσʔλग़ྗ IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTUDSFQPSUSFTUBQJ

Slide 67

Slide 67 text

֤छσʔλग़ྗ

Slide 68

Slide 68 text

ʲ࠶ܝʳຊηογϣϯͰ఻ΘΔͱخ͍͜͠ͱ w σʔλ෼ੳΛ׆༻͢ΔͨΊʹ͸ɺ݁ՌͷʮՄࢹԽʯͱ ʮڞ༗ʯ͕େࣄ w ʢ্هΛ࣮ݱ͢Δํ๏͸৭ʑ͋Δ͕ʣ"84ͱ 5BCMFBVΛ૊Έ߹ΘͤΔͱ޾ͤʹͳΕΔʢ͔΋ʣ

Slide 69

Slide 69 text

No content