Lookerを活用した可視化・分析業務の実践/Practice of visualization and analysis work using Looker in Developers IO 2019 by shinyaa31

2019年11月1日開催の『Developers.IO 2019』で発表したLookerセッションの資料です。

Transcript

1. -PPLFSΛ׆༻ͨ͠ՄࢹԽɾ෼ੳۀ຿ͷ࣮ફ
   ʴ-PPLFSˍ5BCMFBVͷൺֱͱ࢖͍෼͚ σʔλΞφϦςΟΫεࣄۀຊ෦ɹΠϯςάϨʔγϣϯ෦
   ͠Μ΍
   
   !TIJOZBB
   
2. εϥΠυ͸ޙͰೖख͢Δ͜ͱ͕ग़དྷ·͢ͷͰ ൃදதͷ಺༰ΛϝϞ͢Δඞཁ͸͋Γ·ͤΜɻ ࣸਅࡱӨΛ͢Δ৔߹͸ ϑϥογϡɾγϟολʔԻ͕ग़ͳ͍Α͏ʹ͝഑ྀ͍ͩ͘͞ Attention
3. ຊ೔ͷΠϕϯτϋογϡλά͸ʜ
   
   #cmdevio
4. ࣗݾ঺հ
    ͠Μ΍ "84ίϯαϧςΟϯά෦ʹݱ"84ࣄۀຊ෦ͷલ਎ IUUQTEFWDMBTTNFUIPEKQBVUIPSTIJOZBB @shinyaa31 #cmdevio ೥݄ɿΫϥεϝιου+0*/
 
 ೥݄ʙɿσʔλΠϯςάϨʔγϣϯ෦
 ೥݄ʙɿσʔλΞφϦςΟΫεࣄۀຊ෦
   ɾΫϥϝι೥໨
 ɾ$4" ΧελϚʔετʔϦʔΞφϦςΟΫε
   Ϧʔμʔ
 ɾ޷͖ͳ"84αʔϏεɿ"NB[PO
   3FETIJGU
 ɾ޷͖ͳөըɿϚουϚοΫε
   ౖΓͷσεɾϩʔυ өըؗͰͷ௨ࢉࢹௌճ਺ɿճ 
 ɾ޷͖ͳ4803%ɿୡຏҰՈ
 ɾ޷͖ͳՄࢹԽɿ஍ਤΛ׆༻ͨ͠΋ͷ
5. %FWFMPQFST*0౤ߘ
   ݱࡏͷྦྷܭ౤ߘຊ਺
    ྦྷܭຊΛಥഁɺઅ໨ͷຊ·Ͱ͋ͱҰଉ ˞౤ߘຊ਺͸೥݄೔ݱࡏͷ৘ใͰ͢ #cmdevio
6. ໿ຊ͕ࢲͷ౤ߘͰ͢ ೥࿈ଓz೥ؒຊ౤ߘzܧଓத %FWFMPQFST*0౤ߘ
   શຊ௒ͷ͏ͪ
    ˞౤ߘຊ਺͸೥݄೔ݱࡏͷ৘ใͰ͢ #cmdevio
7. ݸਓผ౤ߘ
   #*ɾ෼ੳपΓͷมભ
    #cmdevio ˞౤ߘຊ਺͸೥݄೔ݱࡏͷ৘ใͰ͢
8. ຊ೔ͷ͜ͷηογϣϯͰ͸
    ࣍ੈ୅ͷσʔλϓϥοτϑΥʔϜ
   ʰ-PPLFSʱʹ͍ͭͯ
   ͓࿩͍͖͍ͯͨ͠͠ͱࢥ͍·͢ʂ #cmdevio
9. ͳ͓ɺຊ೔ͷ%FWFMPQFST*0
   
   50,:0Ͱ͸ʜ
    ౰Πϕϯτ
   ϥϯνηογϣϯʹͯ
 -PPLFS
   ࿇஑͞Μʹ͓࿩͠௖͖·ͨ͠ɻ #cmdevio <Ϩϙʔτ>
   ୈੈ୅#*
   -PPLFSͷັྗͱ͸ -PPLFS
   ࿇஑
   ୓࠸
   ࢯ
   r
   %FWFMPQFST*0
   
   JO
   50,:0
   DNEFWJP
   ʛ
   %FWFMPQFST*0
   IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTDNEFWJPUPLZPSFQPSUMPPLFSSEHFOFSBUJPOEBUBQMBUGPSN
10. ຊ೔ͷ͜ͷηογϣϯΛ͝ཡ௖͍ͨޙͷΠϝʔδ
     ɾ-PPLFSͷ֓ཁΛ೺Ѳ
    ɾ-PPLFSͷར༻ΠϝʔδΛ೺Ѳ
    ɾ-PPLFSͷڧΈɺಛ௃Λ೺Ѳ
    ɾʰ-PPLFSɺྑ͍ͶʱͱͳΔ
    ˠ-PPLFSΛ࢖ͬͯΈΔ #cmdevio
11. ΞδΣϯμ
     ɾࣗݾ঺հˍΠϯτϩ
    ෼
    ɾ-PPLFS֓ཁˍ(PPHMFʹΑΔങऩͷӨڹ
    ෼
    ɾ-PPLFSͷར׆༻Πϝʔδ
    ෼
    ɾ-PPLFSͱ5BCMFBVɺͲͬͪΛ࢖͏ʁͲͬͪ΋࢖͏ʁ ෼
    ɾ·ͱΊ
    ෼ #cmdevio
12. ΞδΣϯμ
     ɾࣗݾ঺հˍΠϯτϩ
    ෼
    ɾ-PPLFS֓ཁˍ(PPHMFʹΑΔങऩͷӨڹ
    ෼
    ɾ-PPLFSͷར׆༻Πϝʔδ
    ෼
    ɾ-PPLFSͱ5BCMFBVɺͲͬͪΛ࢖͏ʁͲͬͪ΋࢖͏ʁ ෼
    ɾ·ͱΊ
    ෼ #cmdevio
13. 
     -PPLFS֓ཁ
14. -PPLFS ϧοΧʔ
     #cmdevio https://looker.com/ ࣍ੈ୅ͷσʔλϓϥοτϑΥʔϜʮ-PPLFSʯػೳ֓ཁ·ͱΊ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSPWFSWJFX
15. -PPLFSͱ͸ͲΜͳ΋ͷͳͷ͔ɿݸਓత௒ͬ͘͟Γཁ఺·ͱΊ
     ɾσʔλͷՄࢹԽɺ෼ੳɺڞ༗ͷͨΊͷ৔ॴ΍ػೳΛఏڙ͢Δ
 ɹʰσʔλϓϥοτϑΥʔϜʱɻ
 ɾσʔλͷ४උ͸ैདྷ௨Γɺ%#%8)ଆͰߦ͓ͬͯ͘ඞཁΞϦ
 ɾ8FC6*Λհ֤ͯ͠छૢ࡞Λߦ͏ ϒϥ΢βͷΈσεΫτοϓΞϓϦແ͠ 
 ɾ-PPL.-ͱ͍͏ݴޠΛ࢖ͬͯཁૉͷ࡞੒ɺઃఆΛߦ͏
 ɾσʔλϕʔε΍σʔλ΢ΣΞϋ΢εʹͷΈରԠ͠ɺ
 ɹϩʔΧϧϑΝΠϧ͸ඇରԠ Ұ୴ԿΒ͔ͷ؀ڥʹऔΓࠐΉඞཁ༗Γ 
 ɾσʔλͷ৘ใΛϓϥοτϑΥʔϜ಺෦ʹอ࣋͠ͳ͍
 ɾ(JU࿈ܞʹඪ४ରԠʰΦϨΦϨఆٛˍՄࢹԽʱཚཱΛ๷ࢭ
 ɾ֤छ֎෦ΞϓϦ΍αʔϏεͱͷॊೈͳ࿈ܞʹରԠ
 ɾҹ৅ͱͯ͠͸ʰ͔Ώ͍ͱ͜Ζʹख͕ಧ͘ɺศརͳαʔϏεʱɻ #cmdevio
16. -PPLFS֓ཁ
     ࣍ੈ୅ͷσʔλϓϥοτϑΥʔϜʮ-PPLFSʯػೳ֓ཁ·ͱΊ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSPWFSWJFX #cmdevio
17. -PPLFS֓ཁ
     ࣍ੈ୅ͷσʔλϓϥοτϑΥʔϜʮ-PPLFSʯػೳ֓ཁ·ͱΊ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSPWFSWJFX #cmdevio
18. -PPLFS֓ཁ
     -PPLFS
    
    %BUBCBTF
    UP
    %BTICPBSE
    5FDIOJDBM
    %FNP
    
    :PV5VCF
    IUUQTXXXZPVUVCFDPNXBUDI W)#H+8$#00;H #cmdevio
19. σʔλϕʔε઀ଓઃఆɿ -PPLFS֓ཁ
     %BUBCBTF
    #VTJOFTT
    *OUFMMJHFODF
    #*
    
    "OBMZUJDT
    4PGUXBSF
    c
    -PPLFS
    IUUQTMPPLFSDPNTPMVUJPOTEBUBCBTFT
    -PPLFSͷରԠσʔλιʔεʹ͍ͭͯ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSBWBJMBCMFEBUBTPVSDFT ɾ༧Ί༻ҙ͓͍ͯͨ͠σʔλϕʔε؀ڥΛࢦఆ
    ɾʮ઀ଓ $POOFDUJPO ʯͷܗͰར༻ग़དྷΔΑ͏ʹ
    ɹ-PPLFSʹઃఆΛొ࿥͓ͯ͘͠
    ɾجຊతͳ઀ଓઃఆ
    ɾͦͷଞৄࡉͳ߲໨ ӬଓԽͳͲ ΋ઃఆՄೳ
    ɾओཁͳ%#ɺ%8)͸͍͍ͩͨରԠ #cmdevio
20. ϞσϧɺΤΫεϓϩʔϥɺϏϡʔͷ࡞੒ͱฤूઃఆɿ -PPLFS֓ཁ
     6OEFSTUBOEJOH
    .PEFM
    BOE
    7JFX
    'JMFT
    IUUQTEPDTMPPLFSDPNEBUBNPEFMJOHHFUUJOHTUBSUFENPEFMEFWFMPQNFOU
    FYQMPSF
    IUUQTEPDTMPPLFSDPNSFGFSFODFFYQMPSFQBSBNTFYQMPSF
    WJFX
    IUUQTEPDTMPPLFSDPNSFGFSFODFWJFXQBSBNTWJFX ɾ-PPLFSͷߏ੒ཁૉΛฤू
    ɾ-PPL.-ͱ͍͏ઃఆݴޠΛ࢖͏ #cmdevio
21. &YQMPSFΛ࢖ͬͯσʔλΛ୳ࡧɿ -PPLFS֓ཁ
     -PPLFSͰͷσʔλ୳ࡧ
    IUUQTEPDTMPPLFSDPNKBFYQMPSJOHEBUBFYQMPSJOHEBUB
    -PPLFSͰͷσʔλ୳ࡧͷجຊ৘ใ
    IUUQTEPDTMPPLFSDPNKBFYQMPSJOHEBUB ɾσʔλΛ୳ࡧ &YQMPSF ͢Δػೳ
    ɾ༻ҙͨ͠Ϟσϧ .PEFM ͔Β
 ɹσʔλΛݟͯ෼ੳΛ͠ͳ͕Β
    ɹϏϡʔ 7JFX
    
    l-PPLz Λ࡞੒ͨ͠Γ
 ɹμογϡϘʔυΛ࡞͍ͬͯ͘ #cmdevio
22. -PPLFSϓϩδΣΫτΛ(JUϦϙδτϦͱ࿈ܞɿ -PPLFS֓ཁ
     6TJOH
    7FSTJPO
    $POUSPM
    BOE
    %FQMPZJOH
    IUUQTEPDTMPPLFSDPNEBUBNPEFMJOHHFUUJOHTUBSUFEWFSTJPODPOUSPMBOEEFQMPZJOHDIBOHFT ɾϓϩδΣΫτ୯ҐͰɺ೚ҙͷ(JUϦϙδτϦͱ
    ɹεϜʔζͳ࿈ܞ͕Մೳ
    ɾ(JUϦϙδτϦ͸جຊతʹ͸Ϣʔβଆ͕༻ҙ
    ɾ(JUૢ࡞͸ը໘6*͔Βૢ࡞
    ɾ(JUϦϙδτϦͱ࿈ܞͯ͠ຊ൪ϦϦʔε͠ͳ͍ͱ
 ɹग़དྷͳ͍ػೳ΋ଟ͍ʹඞવతʹ(JU࿈ܞ͕ߦ͑ɺ
 ɹԁ׈ͳιʔείʔυ؅ཧ͕࣮ݱՄೳ #cmdevio
23. ֎෦σʔλ࿈ܞɿ -PPLFS֓ཁ
     4FOEJOH
    %BUB
    /PX
    IUUQTEPDTMPPLFSDPNTIBSJOHBOEQVCMJTIJOHTDIFEVMJOHBOETIBSJOHTFOEPODF
    4IBSJOH
    %BUB
    IUUQTEPDTMPPLFSDPNTIBSJOHBOEQVCMJTIJOHTIBSJOHEBUB ɾ-PPLFSͰ͸ɺ੒Ռ෺Λ༷ʑͳܗͰ
 ɹڞ༗ɺ࿈ܞ͕Մೳ
    ɾεέδϡʔϧࢦఆ΋Մೳ
    ɾ୯७ʹμ΢ϯϩʔυ΋Մೳ #cmdevio
24. ϏϡʔɾμογϡϘʔυฤूɿ -PPLFS֓ཁ
     #VJMEJOH
    -PPL.-
    %BTICPBSET
    IUUQTEPDTMPPLFSDPNKBEBTICPBSETDSFBUJOHMPPLNMEBTICPBSET ɾϞσϧ͔Β৘ใΛ୳ࡧˍՄࢹԽ
 ɾͦͷ಺༰Λʮ-PPLʯͱͯ͠อଘ
 ɹ -PPL
    
    ୯ҰάϥϑɺϏϡʔ 
 ɾ-PPLΛ·ͱΊͯμογϡϘʔυʹ
    ɾఆٛ͸-PPL.-ͱͯ͠؅ཧ #cmdevio
25. "DUJPO
    )VCɿ -PPLFS֓ཁ
     "ENJO
    4FUUJOHT
    
    "DUJPOT
    IUUQTEPDTMPPLFSDPNBENJOPQUJPOTQMBUGPSNBDUJPOT
    4IBSJOH
    %BUB
    5ISPVHI
    BO
    "DUJPO
    )VC
    IUUQTEPDTMPPLFSDPNTIBSJOHBOEQVCMJTIJOHBDUJPOIVC ɾ-PPLFSͱ౷߹͞ΕͨαʔυύʔςΟ
    ɹαʔϏεʹίϯςϯπΛ഑৴ग़དྷΔػೳ
    ɾγϯϓϧͳσʔλ഑৴͚ͩͰͳ͍
    ɹαʔϏεʹԠͨ͡৘ใɺૢ࡞࿈ܞ͕Մೳʹ #cmdevio
26. -PPLFS
    #MPDLTšɿ -PPLFS֓ཁ
     "DDFMFSBUF
    ZPVS
    "OBMZUJDT
    XJUI
    -PPLFS
    #MPDLTš
    c
    -PPLFS
    IUUQTMPPLFSDPNQMBUGPSNCMPDLT
    3FETIJGU
    0QUJNJ[BUJPO
    CZ
    "84
    c
    -PPLFS
    IUUQTMPPLFSDPNQMBUGPSNCMPDLTTPVSDFSFETIJGUPQUJNJ[BUJPOCZBXT ɾ෼ੳΛՃ଎ͤ͞ΔͨΊʹར༻͢Δ͜ͱ͕ग़དྷΔɺ
    ɹࣄલʹߏங͞Εͨॲཧίʔυͷմ #MPDL ɺ
    ɹʰ෼ੳςϯϓϨʔτʱͷΑ͏ͳ΋ͷ
    ɾؔ࿈ϑΝΠϧΛϓϩδΣΫτʹऔΓࠐΈɺઃఆΛ
    ɹฤू͢Δ͚ͩͰ࠶ར༻͕Մೳʹ
    ɾ༻్ɺछྨ͸ଟذʹ౉Δ
    ɹɾ෼ੳϒϩοΫ
    ɹɾιʔεϒϩοΫ
    ɹɾσʔλϒϩοΫ
    ɹɾσʔλπʔϧ
    ɹɾՄࢹԽϒϩοΫ
    ɹɾຒΊࠐΈϒϩοΫ #cmdevio
27. 1PXFSFE
    CZ
    -PPLFSɿ -PPLFS֓ཁ
     1PXFSFE
    CZ
    -PPLFS
    c
    -PPLFS
 IUUQTMPPLFSDPNOFXTQSFTTMPPLFSFYQBOETFNCFEEFECJQSPHSBNXJUIUIFMBVODIPGQPXFSFECZMPPLFS
    <Ϩϙʔτ>
    ύωϧσΟεΧογϣϯʰ&NCFEEFE
    "OBMZUJDTͷՄೳੑʱ
    r
    +PJOɿUIF
    5PVS
    5PLZP
    
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTSFQPSUMPPLFSKPJOUIFUPVSUPLZPQBOFMEJTDVTTJPOFNCFEEFEBOBMZUJDT ɾ-PPLFSͷਪਐ͢ΔʰຒΊࠐΈ෼ੳʱ
 ɾ"1*ܦ༝Ͱ༷ʑͳΞϓϦέʔγϣϯʹ-PPLFSΛ
 ɹlຒΊࠐΉl &NCFE ͜ͱ͕ग़དྷΔ
 ɾํࣜ͸༷ʑͳܗͰ࣮ݱՄೳ
    ɹɾύϒϦοΫ
    ɹɾϓϥΠϕʔτ
    ɹɾγϯάϧαΠϯΦϯ
    ɹɾΫϩʔζυ #cmdevio
28. 
     (PPHMFʹΑΔങऩͷӨڹ
29. (PPHMFʹΑΔ-PPLFSങऩͷൃද͕͋Γ·ͨ͠
     (PPHMF
    UP
    "DRVJSF
    -PPLFS
    c
    (PPHMF
    $MPVE
    #MPH
    IUUQTDMPVEHPPHMFDPNCMPHUPQJDTJOTJEFHPPHMFDMPVEFYQBOEJOHPVSQMBUGPSNGPSCVTJOFTTJOUFMMJHFODFBOEFNCFEEFEBOBMZUJDT
    -PPLFS
    UP
    +PJO
    (PPHMF
    $MPVE
    c
    -PPLFS
    IUUQTMPPLFSDPNCMPHMPPLFSUPKPJOHPPHMFDMPVE ɾ೥݄೔ൃද
 ɾݱࡏ͸ॾʑͷௐ੔ରԠத
 ɾͪͳΈʹ͜ͷ਺೔ޙɺ
 ɹ4BMFTGPSDF͕5BCMFBVങऩΛൃද #cmdevio
30. ͜ͷχϡʔεɺΫϥϝιࣾ಺΋͟Θ͖ͭ·ͨ͠
     w ʰ"NB[PO
    3FETIJGUͱ͔ɺͦͷଞ"84ͷ
 ɹσʔλιʔεͬͯࠓޙ΋-PPLFS͔Βܨ͕Δͷʁʱ
    w ʰશ෦($1ʹҠͬͪΌ͏ͷ͔ͳʁʱ
    w ʰ͔ͬͯαʔϏεͲ͏ͳΔͷʁʱ
31. ؾʹͳͬͨͷͰ৭ʑฉ͍ͯΈ·ͨ͠
     ʰ(PPHMFʹΑΔങऩʱͰ͜Ε͔ΒͲ͏ͳΔʁ-PPLFSͷதͷਓୡʹ৭ʑ࿩Λฉ͍ͯΈͨ
    MPPLFS
    ʛ
    %FWFMPQFST*0
 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTJOUFSWJFXXJUIMPPLFSKBQBO #cmdevio
32. ʰ-PPLFSͷதͷਓୡʱΠϯλϏϡʔ಺༰ɿཁࢫ
     ʰ(PPHMFʹΑΔങऩʱͰ͜Ε͔ΒͲ͏ͳΔʁ-PPLFSͷதͷਓୡʹ৭ʑ࿩Λฉ͍ͯΈͨ
    MPPLFS
    ʛ
    %FWFMPQFST*0
 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTJOUFSWJFXXJUIMPPLFSKBQBO w -PPLFSͷதͷਓୡతʹ͸lྑ͍ങऩzͩͬͨ
    w ࠓޙ΋Ҿ͖ଓ͖ϚϧνΫϥ΢υରԠ͠·͢
    w 3FETIJGU͸-PPLFSͰѻ͏σʔλιʔεͷ
 ໿Λ઎ΊΔɺࠓޙ΋"84ٴͼ
 "84σʔλιʔεͷରԠ͸ܧଓ
    w -PPLFSͷྑ͞Λ׆͔ͯ͠೔ຊͰͷγΣΞ֦େΛૂ͏ #cmdevio
33. -PPLFS͔Β΋ϗϫΠτϖʔύʔ͕ग़͍ͯ·͢
     -PPLFSɿϚϧνΫϥ΢υʹΑΔࣗ༝ͳબ୒
 IUUQTJOGPMPPLFSDPNMPPLFSKBQBONVMUJDMPVETIPSUGPSNFCPPLKQO #cmdevio
34. ʜͱ͍͏͜ͱͳͷͰɺ
     ͍ͩ͡ΐ͏Ϳͦ͏Ͱ͢ʂ #cmdevio
35. ΞδΣϯμ
     ɾࣗݾ঺հˍΠϯτϩ
    ෼
    ɾ-PPLFS֓ཁˍ(PPHMFʹΑΔങऩͷӨڹ
    ෼
    ɾ-PPLFSͷར׆༻Πϝʔδ
    ෼
    ɾ-PPLFSͱ5BCMFBVɺͲͬͪΛ࢖͏ʁͲͬͪ΋࢖͏ʁ ෼
    ɾ·ͱΊ
    ෼ #cmdevio
36. 
     -PPLFSͷར׆༻Πϝʔδ
37. -PPLFSͷར༻Πϝʔδɺ૝૾ग़དྷ·͢ʁ
     ɾ-PPLFSͱ͍͏#*πʔϧʗαʔϏεͷ࿩୊ɺ
 ɹ࠷ۙྑࣖ͘ʹ͢Δ͚Ͳɺ
 ɹɾ-PPLFSͬͯͲ͏͍͏ಛ௃͕͋ΔΜͩΖ͏ʁ
 ɹɾ-PPLFSΛϓϩδΣΫτʹಋೖ͢Δ৔߹ɺ
 ɹɹ࣮ࡍͲΜͳײ͡Ͱ૊ΈࠐΜͰߦ͘ͷʁ
 ɹɾ-PPLFSΛ࢖͏ͱɺͲΜͳ͜ͱ͕
 ɹɹग़དྷΔΑ͏ʹͳΔͷʁ #cmdevio
38. -PPL.-ͱ͸
     -PPL.-ͱ͸
    IUUQTEPDTMPPLFSDPNKBEBUBNPEFMJOHMFBSOJOHMPPLNMXIBUJTMPPLNM ɾ42-σʔλϕʔε಺ͷσΟϝϯγϣϯɺूܭɺܭࢉ
 ɹٴͼσʔλؔ܎Λهड़͢ΔͨΊͷݴޠ
 ɾ-PPLFS͸͜ͷݴޠΛ࢖ͬͯهड़͞ΕͨϞσϧΛ࢖͍
 ɹಛఆͷσʔλϕʔεʹରͯ͠42-ΫΤϦΛ࡞੒
 ɾ:".-ͬΆ͍هड़ํࣜ
 ɾେ൒ͷཁૉΛɺ-PPL.-Λฤूͯ͠࡞੒͢Δ #cmdevio
39. -PPL.-ͱ͸
     -PPL.-ͱ͸
    IUUQTEPDTMPPLFSDPNKBEBUBNPEFMJOHMFBSOJOHMPPLNMXIBUJTMPPLNM -PPL.-ͷهड़Πϝʔδ #cmdevio
40. -PPL.-ͱ͸
     42-ͷ૊ΈࠐΈͱ-PPL.-ΦϒδΣΫτͷࢀর
    IUUQTEPDTMPPLFSDPNKBEBUBNPEFMJOHMFBSOJOHMPPLNMTRMBOESFGFSSJOHUPMPPLNM -PPL.-ͷهड़Πϝʔδ #cmdevio
41. ͢ͳΘͪʜ
     ੺໦߶ݑͷ໊ݴɾ໊୆ࢺʰϦό΢ϯυΛ੍͢Δऀ͸ࢼ߹Λ੍͢ʱ
    
    IUUQNBOHBNFJHFOJOGPTVSBNVEBOLVBLBHJUBLFOPSJIUNM #cmdevio -PPL.-Λ੍͢Ε͹
    ࢼ߹Λ੍͢Δ͜ͱ͕
 ϧοΧʔ ग़དྷΔ ͱݸਓతʹ͸ࢥ͍ͬͯΔ
42. -PPLFSߏ੒ཁૉɿ֓ཁ
     -PPL.-ͱ͸
    IUUQTEPDTMPPLFSDPNKBEBUBNPEFMJOHMFBSOJOHMPPLNMXIBUJTMPPLNM
    -PPLFSͷߏ੒ཁૉͷؔ܎ੑΛ೺Ѳ͢Δ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSVOEFSTUBOEUIFSFMBUJPOTIJQCFUXFFOUIFDPNQPOFOUTPGMPPLFS #cmdevio
43. -PPLFSߏ੒ཁૉɿϓϩδΣΫτ
     #cmdevio
44. -PPLFSߏ੒ཁૉɿϓϩδΣΫτ
     ϓϩδΣΫτ -PPL.-
    QSPKFDU 
 ɹؔ࿈͢ΔॾཁૉΛؚΊΔ࠷্Ґͷཻ౓ɺཁૉॾʑͷೖΕ΋ͷɻ
 ɹओͳ-PPL.-ཁૉ
 ɹɾϞσϧ NPEFM 
 ɹɾϏϡʔ WJFX 
 ɹɾΤΫεϓϩʔϥ FYQMPSF 
 ɹɾ݁߹ KPJO 
 ɹɾϚχϑΣετϑΝΠϧ NBOJGFTU 
 ɹɾυΩϡϝϯτ
 ɹ˞(JUϦϙδτϦ͸ϓϩδΣΫτ୯ҐͰ࿈ܞ )PX
    B
    1SPKFDU
    8PSLT
    JO
    -PPLFS
    IUUQTEPDTMPPLFSDPNEBUBNPEFMJOHHFUUJOHTUBSUFEIPXQSPKFDUXPSLT
    -PPL.-ͷ༻ޠͱ֓೦
    IUUQTEPDTMPPLFSDPNKBEBUBNPEFMJOHMFBSOJOHMPPLNMMPPLNMUFSNTBOEDPODFQUT #cmdevio
45. -PPLFSߏ੒ཁૉɿϞσϧ
     #cmdevio
46. -PPLFSߏ੒ཁૉɿϞσϧ
     Ϟσϧ .PEFM 
 ɹ୳ࡧʹ༻͍Δཁૉ܈Λఆ͓ٛͯ͘͠΋ͷɻ
 ɹϢʔβʔ͸͜ͷཁૉΛ࢖ͬͯσʔλΛࢀরˍՄࢹԽ͢Δɻ
 ɹɾΤΫεϓϩʔϥ &YQMPSF 
 ɹɹ୳ࡧཁૉͷ࠷େ୯Ґɻ
 ɹɾδϣΠϯ +PJO 
 ɹɹΤΫεϓϩʔϥ಺Ͱɺ೚ҙͷϏϡʔಉ࢜Λ૊Έ߹Θͤͯ
 ɹɹ࢖͏࣌ʹఆٛͱͯ͠༻͍Δɻ42-݁߹ͷΠϝʔδɻ
 #cmdevio
47. -PPLFSߏ੒ཁૉɿϞσϧ
     &YQMPSFϝχϡʔ .PEFMϑΝΠϧ &YQMPSF+PJO7JFX %#ςʔϒϧ U@CMPHQPTUT
 ϒϩά౤ߘσʔλ N@VTFS
    ϢʔβʔϚελ N@SFGDBUT
    ಛूΧςΰϦϚελ &YQMPSF U@CMPHQPTUT
    ϒϩά౤ߘσʔλ U@CMPHQPTUT N@VTFS N@SFGDBUT DNEFWJPεΩʔϚ 7JFX 7JFX 7JFX +PJO +PJO #cmdevio
48. -PPLFSߏ੒ཁૉɿϏϡʔ
     #cmdevio
49. -PPLFSߏ੒ཁૉɿϏϡʔ
     Ϗϡʔ 7JFX 
 ɹϑΟʔϧυ ߲໨ͷ Ϧετٴͼɺ
 ɹجͱͳΔςʔϒϧɾ೿ੜςʔϒϧ΁ͷࢀরΛఆٛɻ
 ɹɾσΟϝϯγϣϯ %JNFOTJPO 
 ɹɹΧςΰϦɺ੾ΓޱͱͳΔ߲໨
 ɹɾϝδϟʔ .FBTVSF 
 ɹɹ਺஋ɺूܭର৅ͱͳΔ߲໨
 ɹɾϑΟʔϧυηοτ 'JFME
    4FU #cmdevio
50. -PPLFSߏ੒ཁૉɿϏϡʔ
     # \d cmdevio.t_blogposts; Table "cmdevio.t_blogposts" Column | Type | Collation | Nullable | Default -----------+-----------------------------+-----------+----------+--------- post_id | integer | | not null | post_date | timestamp without time zone | | not null | title | character varying(500) | | not null | url | character varying(500) | | not null | author_id | character varying(30) | | not null | social | integer | | not null | twitter | integer | | not null | facebook | integer | | not null | hatena | integer | | not null | view | integer | | not null | Indexes: "t_blogposts_pkey" PRIMARY KEY, btree (post_id) ˞ࣗಈੜ੒ͷ৔߹ɺσΟϝϯγϣϯ܈ͱ݅਺ DPVOU ͸༻ҙ͞ΕΔ
    ɹϝδϟʔ͸ඞཁͳ΋ͷΛඞཁͳઃఆͰࣗ࡞͢Δඞཁ͋Γ σΟϝϯγϣϯ܈ͱ݅਺ DPVOU ϝδϟʔ߲໨܈ #cmdevio
51. -PPLFSߏ੒ཁૉɿμογϡϘʔυ
     #cmdevio
52. -PPLFSߏ੒ཁૉɿμογϡϘʔυ
     μογϡϘʔυ %BTICPBSE 
 -PPLFSͷՄࢹԽཁૉΛͻͱ·ͱΊʹͨ͠΋ͷɻ
 ɹɾλΠϧ
 ɹɹɾΫΤϦλΠϧ
    
 ɹɹɹɹطଘ-PPL&YQMPSFΛࢀরͯ͠μογϡϘʔυݻ༗ͷཁૉͱͯ͠࡞੒
 ɹɹɾϧοΫϦϯΫλΠϧ
 ɹɹɹɹطଘ-PPLΛࢀর͢ΔܗͰར༻
 ɹɹɾςΩετλΠϧ
 ɹɹɹɹ૷০༻ͷϔομɾςΩετϥϕϧͱͯ͠ར༻
 ɹɾݕࡧ৚݅
 ɹɾઃఆ #cmdevio ϢʔβʔఆٛܕμογϡϘʔυͷ࡞੒
    IUUQTEPDTMPPLFSDPNKBEBTICPBSETDSFBUJOHVTFSEBTICPBSET
    ϢʔβʔఆٛμογϡϘʔυͷฤू
    IUUQTEPDTMPPLFSDPNKBEBTICPBSETFEJUJOHVTFSEBTICPBSET
53. -PPLFSߏ੒ཁૉɿμογϡϘʔυ
     #cmdevio ݕࡧ৚݅ ςΩετλΠϧ ΫΤϦλΠϧ ϧοΫϦϯΫλΠϧ -PPL
 ୯Ұͷάϥϑ -PPL
 ୯Ұͷάϥϑ ࢀর ෳ੡ ɾλΠϧʹμογϡϘʔυଆͷׅΓ
    ɾλΠϧʹ͸छྨ͋Γɺ͕ͭ-PPLʹؔ͢Δ΋ͷ
    ɾ-PPLʹ-PPLFSͰ࡞੒ग़དྷΔ୯Ұͷάϥϑ
 ɾϧοΫϦϯΫλΠϧ
 ɹɾطଘ-PPLΛࢀরͯ͠දࣔͤ͞ΔܗͰఆٛ
 ɹɾطଘ-PPLΛ࡟আ͢ΔͱɺμογϡϘʔυଆͷ
 ɹɹදࣔ΋͞Εͳ͘ͳΔ
    ɾΫΤϦλΠϧ
 ɹɾطଘ-PPL΍&YQMPSFΛ࢖͍ɺμογϡϘʔυͷ
 ɹɹ͍ͪཁૉͱͯ͠࡞੒
 ɹɾطଘ-PPLΛ࡟আͯ͠΋ɺμογϡϘʔυଆͷ
 ɹɹཁૉͱͯ͠࢒Δ &YQMPSF ৽ن࡞੒
54. -PPLFSߏ੒ཁૉɿͦͷଞ
     #cmdevio
55. -PPLFSߏ੒ཁૉɿͦͷଞ
     6OEFSTUBOEJOH
    0UIFS
    1SPKFDU
    'JMFT
 IUUQTEPDTMPPLFSDPNEBUBNPEFMJOHHFUUJOHTUBSUFEPUIFSQSPKFDUpMFT ͦͷଞϓϩδΣΫτؔ࿈ϑΝΠϧ
 ɹɾυΩϡϝϯτϑΝΠϧ
 ɹɾσʔλϑΝΠϧ
 ɹɾϓϩδΣΫτϚχϑΣετϑΝΠϧ NBOJGFTU 
 ɹɾϩέʔϧετϦϯάϑΝΠϧ
 ɹɾΤΫεϓϩʔϥϑΝΠϧ
 ɹɾͦͷଞ
 #cmdevio
56. -PPLFSϓϩδΣΫτͷਐΊํ શମΠϝʔδ
     #cmdevio
57. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     -PPLFSυϝΠϯͷ४උ ɾ-PPLFSࣾͱܖ໿క݁
 ɾઐ༻ͷυϝΠϯ͕༻ҙ͞ΕΔ
 ɾར༻Ϣʔβʔ΋υϝΠϯ഑Լʹ༻ҙ
 ɾ઀ଓ֬ೝ
 ɾඞཁʹԠ֤ͯ͡छݚमɾτϨʔχϯάΛडߨ #cmdevio
58. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     ՄࢹԽɾ෼ੳର৅ͷௐࠪ ɾଞ#*πʔϧɺαʔϏεಉ༷ɺ
 ɹʰ෼ੳɾՄࢹԽର৅σʔλͷ४උʱ͸ඞཁ
 ɾ·ͨɺ-PPLFSͷ৔߹͸%#ɾ%8)ʹσʔλΛ
 ɹ֨ೲɺ஝ੵ͓ͯ͘͠ඞཁ͕͋Δ ϩʔΧϧϑΝΠϧඇରԠ 
 ɾݟ͍ͨˍ෼ੳ͍ͨ͠σʔλ͔ΒɺͲͷΑ͏ͳ
 ɹܗͰσʔλΛ࣋ͬͯ͘Δ͔ݕ౼ #cmdevio
59. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     σʔλ෼ੳ؀ڥͷ४උ ɾ͍ΘΏΔʰσʔλ෼ੳج൫ʱͷߏங
 ɾҰ࿈ͷॲཧΛ࣮ݱ͢Δ؀ڥΛ༻ҙ
 ɹɾσʔλΛू໿
 ɹɾσʔλΛ%#%8)ʹऔΓࠐΉ
 ɹɾσʔλϚʔτͷ࡞੒
 ɾཁ݅ʹԠͯ͡σʔλΛՃ޻
 ɹɾऔΓࠐΉલʹՃ޻ &5-
    CZ
    ϓϩάϥϜɺπʔϧ 
 ɹɾऔΓࠐΜͰ͔ΒՃ޻ &-5
    CZ
    42- 
 #cmdevio
60. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     ݟ͍ͨɾ෼ੳ
    ͍ͨ͠Πϝʔδ
    ΰʔϧʣ ෼ੳɾՄࢹԽʹඞཁͳ
    σʔλ಺༰ɺߏ଄ %#ɾ%8)ʹऔΓࠐΉ
    ͨΊͷϑΝΠϧ४උ ඞཁͳ
    ݩσʔλ ˞ΰʔϧ͔Βඞཁͳ৘ใ΍಺༰Λٯࢉͯ͠ચ͍ग़͠ɺ·ͣ͸ઌߦͯ͠ຊ

    ʰॲཧͷྲྀΕʱΛ࡞ͬͯΈΔˠن໛࣌ؒϦιʔεײΛ௫ΜͰԣల։ ࣮ॲཧͷྲྀΕ ߟ͑ํͷҰҊ ͷྲྀΕ #cmdevio
61. <13>
    Ϗοάσʔλ෼ੳج൫ఏڙαʔϏεʮ$4"ʯ΍ͬͯ·͢
     Ϋϥεϝιου
    $4" ݕࡧ Ϗοάσʔλ෼ੳج൫ΛςϯϓϨʔτԽɺ
 ୹ظؒͰͷߏஙɾಋೖΛ࣮ݱ
 ɾ"NB[PO
    3FETIJGUରԠ
 ɾओͳػೳ
 ɹɾσʔλऔΓࠐΈ
 ɹɾϓϩάϥϜ࣮ߦ 42-
    1ZUIPO 
 ɹɾ௨஌
 ɹɾδϣϒ؅ཧ
 ج൫ߏஙʹ͓͚Δ༷ʑͳॲཧΛޮ཰Խɺ
 ࣗಈԽͯؔ͠࿈ۀ຿Λαϙʔτ
 ˞ࠓޙ͸ରԠ%#%8)Λ௥Ճ༧ఆ Ϗοάσʔλ෼ੳࢧԉͷΧελϚʔετʔϦʔΞφϦςΟΫεʛΫϥεϝιουʛΫϥεϝιουͷαʔϏε
 https://classmethod.jp/services/bigdata/ #cmdevio
62. <13>
    σʔλϒϨϯσΟϯάɾ෼ੳπʔϧʮ"MUFSZYʯѻͬͯ·͢
     Ϋϥεϝιου
    ΞϧςϦΫε ݕࡧ AlteryxʢΞϧλϦΫεʣͷ͝঺հ | Ϋϥεϝιουͷύʔτφʔ
 https://classmethod.jp/partner/alteryx/detail/ #cmdevio σʔλ෼ੳʹֻ͔Δ࣌ؒ΍ίετΛ࡟ݮ
 ҙࢥܾఆͷεϐʔυΞοϓΛଅਐ
 Ҏ্ͷ༷ʑͳʰॲཧπʔϧʱͰࢥ͍௨Γ
 ͷϫʔΫϑϩʔΛ࣮ݱՄೳ %FTJHOFS 
 ɾσʔλલॲཧ
 ɾϒϨϯσΟϯά
 ɾ෼ੳ
 ଟछଟ༷ͳೖग़ྗσʔλιʔεʹରԠɺ
 ੒Ռ෺͸ؔ࿈ϓϩμΫτʹల։Մೳ
 ɾڞ༗σʔλ౷ׅ 4FSWFS 
 ɾσʔλΧλϩά $POOFDU 
 ɾ༧ଌϦΞϧλΠϜܾఆ"1* 1SPNPUF 
 ๛෋ͳϊ΢ϋ΢ʹΑΔٕज़ࢧԉ
 ࠃ಺།Ұͷʰ"MUFSZY
    "$&ʱͷଘࡏ
63. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     -PPLFSϓϩδΣΫτͷ࡞੒ ɾʰσʔλϕʔε઀ଓʱ͸͋Β͔͡Ί࡞੒͓ͯ͘͠
 ɾ-PPL.-ϓϩδΣΫτʹσʔλϕʔε઀ଓ͕
 ɹඥͮ͘ܗ جຊ͸ϓϩδΣΫτɿ%#઀ଓɺ
 ɹঢ়گʹΑͬͯ͸ෳ਺%#઀ଓͷߏ੒΋Մೳ 
 ɾϓϩδΣΫτ࡞੒ͷλΠϛϯάͱ߹Θͤͯ
 ɹ(JUϦϙδτϦ͸༻ҙ
 ɾ࡞੒௚ޙʹ(JUϦϙδτϦ࿈ܞઃఆਪ঑
 #cmdevio
64. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     ϢʔβʔɾάϧʔϓपΓͷ੔උ ɾʰϩʔϧʱͱʰݖݶʱΛཧղ͢Δ
 ɾάϧʔϓΛݕ౼ɾ࡞੒
 ɾϩʔϧͷ࡞੒
 ɾϢʔβʔͷ࡞੒
 ɾϢʔβʔͷάϧʔϓ΁ͷ௥Ճ #cmdevio
65. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     ୳ࡧϦιʔεͷ࡞੒ ɾϏϡʔ಺༰ͷ੔උ
 ɹɾجຊతʹ͸ςʔϒϧʹϏϡʔ
 ɹɾ42-ϕʔεʗ-PPL.-ϕʔεͰͷϏϡʔ΋Մೳ
 ɾϕʔεͱͳΔ৘ใΛΤΫεϓϩʔϥͰ༻ҙ
 ɹɾඞཁͳΒ͹ϏϡʔΛ݁߹ͤͨ͞ܗͰఏڙ
 ɾ୳ࡧ࡞ۀΛܦͯɺ಺༰Λݟ௚͠ͳ͕Βચ࿅ #cmdevio
66. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     ୳ࡧͷ࣮ફ ɾ४උग़དྷͨ୳ࡧϦιʔεʹ&YQMPSFΛૢ࡞ͯ͠
 ɹσʔλͷ಺༰Λ֬ೝɺ෼ੳ࣮ࢪ
 ɾՄࢹԽͷͨΊͷϏϡʔ -PPL ʹ͍ͭͯ΋
 ɹ಺༰Λ֬ೝɺμογϡϘʔυ࡞੒ͷߏ૝Λݕ౼
 ɾඞཁͳ৘ใ͕͋Ε͹దٓΤΫεϓϩʔϥҎԼͷ
 ɹཁૉʹ൓ө #cmdevio
67. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     ՄࢹԽͷ࡞੒ɾڞ༗ ɾ୳ࡧͷաఔͰݕ౼ͨ͠ʰՄࢹԽʱͷ಺༰Λ࣮ݱ
 ɾϏϡʔ -PPL Λ࡞੒
 ɾμογϡϘʔυ %BTICPBSE Λ࡞੒
 ɹɾ-PPLͷ௥Ճ
 ɹɾμογϡϘʔυͷઃఆ
 ɾڞ༗ɺ࿈ܞͷઃఆ͸ඞཁʹԠͯ͡ #cmdevio
68. -PPLFSϓϩδΣΫτͷਐΊํ ྫ
     ͦͷଞ-PPLFSػೳͷ׆༻ ɾ"DUJPO
    )VCΛ࢖ͬͨαʔϏεؒ࿈ܞ
 ɾ-PPLFS
    #MPDLTäΛ׆༻ͨ͠෼ੳɺՄࢹԽ
 ɹۀ຿ͷଅਐ
 ɾຒΊࠐΈ෼ੳͷར༻
 ɾ-PPLFS
    "1*ͷ׆༻ #cmdevio
69. -PPLFSͷϩʔϧͱύʔϛογϣϯ
     -PPLFSʹ͓͚ΔϩʔϧɾύʔϛογϣϯηοτɾϞσϧηοτͷߟ͑ํ ˍϢʔβʔ࡞੒ೖ໳
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSSPMFQFSNJTTJPOTFUNPEFMTFUBOEDSFBUFVTFS ʻϩʔϧʼ
 ɹɾݖݶΛఆٛͨ͠΋ͷ
    ྫ "ENJO
    %FWFMPQFS
    6TFS
    7JFXFS
 ɹɾϢʔβʔɺάϧʔϓʹ෇༩Մೳ άϧʔϓਪ঑ 
 ɹɾҎԼͷηοτ͔Βߏ੒͞ΕΔ
 ɹɹɾݖݶηοτ 1FSNJTTJPO4FU 
 ɹɹɹɾʮग़དྷΔ͜ͱʯ
 ɹɹɹྫ
    FYQMPSF
    TFF@MPPLNM@EBTICPBSET
    NBOBHF@NPEFMT
 ɹɹɾϞσϧηοτ .PEFM4FU 
 ɹɹɹɾʮΞΫηεग़དྷΔ-PPL.-Ϟσϧͷ૊Έ߹Θͤɺൣғʯ
    #cmdevio
70. -PPLFSͰ࣮ݱग़དྷΔʮΞΫηε੍ޚʯ
     *1
    8IJUFMJTU
 IUUQTEPDTMPPLFSDPNBENJOPQUJPOTTFSWFSJQXIJUFMJTU
 ηΩϡΞͳσʔλϕʔεΞΫηεΛՄೳʹ͢Δ
    IUUQTEPDTMPPLFSDPNKBTFUVQBOENBOBHFNFOUFOBCMJOHTFDVSFEC #cmdevio ɾ-PPLFSΠϯελϯε؀ڥ΁ͷΞΫηε੍ޚ
 ɹɾ*1ϗϫΠτϦετػೳ
 ɾ-PPLFS͕ΞΫηε͢Δ%#%8)΁ͷΞΫηε੍ޚ
 ɹɾ-PPLFSϗετͷ*1ΞυϨεΛʰϗϫΠτϦετʱͱͯ͠
 ɹɹ%#%8)ʹొ࿥
 ɾ-PPLFS΁ͷϩάΠϯೝূ੍ޚ
 ɹɾύεϫʔυೝূ
 ɹɾೋཁૉೝূ
 ɹɾ(PPHMFೝূ
 ɹɾ4".-ೝূ
    ͳͲ
71. -PPLFSͰ࣮ݱग़དྷΔʮΞΫηε੍ޚʯ
     "DDFTT
    $POUSPM
    BOE
    1FSNJTTJPO
    .BOBHFNFOU
    IUUQTEPDTMPPLFSDPNBENJOPQUJPOTUVUPSJBMTQFSNJTTJPOT #cmdevio ɾίϯςϯπʹؔ͢ΔΞΫηε੍ޚ
 ɹɾϑΥϧμ΍ϑΥϧμ಺ͷ-PPLɺμογϡϘʔυͷΞΫηε
 ɾσʔλʹؔ͢ΔΞΫηε੍ޚ
 ɹɾϞσϧηοτ .PEFM
    4FU ɿϩʔϧʹద༻ɺΞΫηεର৅ൣғΛ੍ݶ
 ɹɾΞΫηεϑΟϧλ BDDFTT
    pMUFS ɿදࣔग़དྷΔσʔλߦΛ੍ݶ
 ɹɾΞΫηεڐՄ BDDFTT
    HSBOU ɿ-PPLFS֤छཁૉ΍ϑΟʔϧυ΁ͷΞΫηεΛ੍ݶ
 ɾػೳʹؔ͢ΔΞΫηε੍ޚ
 ɹɾݖݶηοτ 1FSNJTTJPO
    4FU ɿϩʔϧʹద༻ɺϢʔβʔͷʰग़དྷΔ͜ͱʱΛ੍ݶ
 ɾϢʔβʔάϧʔϓͱϩʔϧͷؔ܎
 ɹɾʰϞσϧηοτ .PEFM
    4FU ʱͱʰݖݶηοτ 1FSNJTTJPO
    4FU ʱΛϩʔϧʹ෇༩
 ɹɾϩʔϧΛϢʔβʔ΍άϧʔϓʹ෇༩ʹ֘౰͢ΔϢʔβʔ΍άϧʔϓͷݖݶΛࢦఆ
 ɾϢʔβʔଐੑΛ༻͍ͨΞΫηε੍ݶ
 ɹɾάϧʔϓ΍ϢʔβʔʹʰϢʔβʔଐੑ VTFS
    BUUSJCVUFT ʱͱͯ͠೚ҙͷ஋Λઃఆ
 ɹɾྫ ձ໊ࣾɺॴଐ෦ॺɺϒϥϯυͳͲˠΞΫηεϑΟϧλͰϢʔβʔଐੑͷ஋ΛϑΟϧλϦϯάՄೳ
72. ΞδΣϯμ
     ɾࣗݾ঺հˍΠϯτϩ
    ෼
    ɾ-PPLFS֓ཁˍ(PPHMFʹΑΔങऩͷӨڹ
    ෼
    ɾ-PPLFSͷར׆༻Πϝʔδ
    ෼
    ɾ-PPLFSͱ5BCMFBVɺͲͬͪΛ࢖͏ʁͲͬͪ΋࢖͏ʁ ෼
    ɾ·ͱΊ
    ෼ #cmdevio
73. 
     -PPLFSͱ5BCMFBVɺ
 ͲͬͪΛ࢖͏ʁ
    Ͳͬͪ΋࢖͏ʁ
74. ʮ-PPLFS
    WT
    5BCMFBVʯͱ͍͏ൺֱهࣄ͕-PPLFS͔Βग़͍ͯΔ
     -PPLFS
    WT
    5BCMFBV
    c
    
    $PNQBSJTPO
    c
    -PPLFS
    IUUQTMPPLFSDPNDPNQBSFMPPLFSWTUBCMFBV #cmdevio
75. ʮ-PPLFS
    WT
    5BCMFBVʯͱ͍͏ൺֱهࣄ͕-PPLFS͔Βग़͍ͯΔ
     -PPLFS
    WT
    5BCMFBV
    c
    ೥ൺֱ
    c
    -PPLFS
    IUUQTKBMPPLFSDPNDPNQBSFMPPLFSWTUBCMFBV #cmdevio
76. ݴ͏ͯ΋5BCMFBV͸ධՁ΋ߴ͘ɺݱঢ়෯޿͘ར༻͞Ε͍ͯΔ
     (BSUOFS
    3FQSJOU
    IUUQTXXXHBSUOFSDPNEPDSFQSJOUT JE'1DUTUTC
    5BCMFBV
    
    ೥൛ΨʔτφʔࣾͷϚδοΫɾΫΞυϥϯτͰ
    
    ೥࿈ଓʮϦʔμʔʯʹ
    IUUQTXXXUBCMFBVDPNKBKQBCPVUCMPHUBCMFBVZFBSTMFBEFSHBSUOFSNBHJDRVBESBOU
    (FU
    UIF
    (BSUOFS
    .BHJD
    2VBESBOU
    GPS
    #*
    BOE
    "OBMZUJDT
    c
    -PPLFS
    IUUQTMPPLFSDPNHBSUOFSNBHJDRVBESBOU #cmdevio
77. -PPLFS͔5BCMFBVɺͲͪΒ͔ʹدͤΔ΂͖ʁ
 ˠͦΜͳ͜ͱ͸ͳ͍ɻ ͱݸਓతʹ͸ࢥ͏ ରܾʁରཱʁ
     #cmdevio
78. -PPLFSͱ5BCMFBVɺ૒ํඋ͍͑ͯΔ ͱ-PPLFS͕ఏএ͢Δ ΋ͷ
 ɾඒ͘͠ΠϯλϥΫςΟϒͳϏδϡΞϦθʔγϣϯ
 ɾϙΠϯτˍΫϦοΫܕΠϯλʔϑΣʔεʹΑΔ௚ײతͳ෼ੳ
 ɾ׬શΧελϚΠζՄೳͳμογϡϘʔυ
 ɾ૊ΈࠐΈ͕؆ܿ
 ɾࣗࣾσʔλϕʔεʹ௚઀઀ଓ
 ɾγϯάϧαΠϯΦϯ
 ɾٕज़ʹৄ͘͠ͳ͍Ϣʔβʔ΋؆୯ʹ࢖͑ΔϨϙʔτϏϧμʔ
 ɾϑϧػೳ"1*
 ɾϞόΠϧ୺຤ɺλϒϨοτɺσεΫτοϓͰͷݟ΍͢͞ -PPLFS
    WT
    5BCMFBV
     -PPLFS
    WT
    5BCMFBV
    c
    ೥ൺֱ
    c
    -PPLFS
    IUUQTKBMPPLFSDPNDPNQBSFMPPLFSWTUBCMFBV
 -PPLFS
    WT
    5BCMFBV
    c
    
    $PNQBSJTPO
    c
    -PPLFS
    IUUQTMPPLFSDPNDPNQBSFMPPLFSWTUBCMFBV #cmdevio
79. -PPLFSͷΈ͕උ͍͑ͯΔ ͱ-PPLFS͕ఏএ͢Δ ΋ͷ
 ɾҰݩ؅ཧ͞ΕͨσʔλϓϥοτϑΥʔϜ͔Βͷ࣮֬ͳճ౴
 ɾϏοάσʔλΛ૝ఆͨ͠ΞʔΩςΫνϟ
 ɾݱࡏͷ࠷΋ύϫϑϧͳσʔλϕʔεΛ׬શ׆༻
 ɾσʔλͷநग़͸ෆཁɺ͓٬༷ͷσʔλϕʔεʹσʔλΛҡ࣋
 ɾͻͱͭͷπʔϧ͔Β؆୯ʹͰ͖ΔϦϯΫڞ༗Ͱڞಉ࡞ۀ͕༰қ
 ɾνϟοτ͔Β਺ඵͰςΫχΧϧαϙʔτΛఏڙ
 ɾ࠶ར༻ՄೳͳσʔλϞσϧʹΑΔ൓෮։ൃ
 ɾόʔδϣϯ؅ཧػೳ౥ࡌ
 ɾޮ཰తͰಡΈऔΓՄೳͳ42-Λ࡞੒
 ɾ4NBSU
    $BDIFʹΑΔ࠷৽σʔλ
 ɾϒϥ΢βϕʔε
 ɾΘ͔ͣ਺෼ͰγʔϜϨεʹιϑτ΢ΣΞΛΞοϓάϨʔυ
 ɾ.BDͱ1$ʹରԠ
 ɾ௥੻Λܦͨ؂ࠪՄೳͳ࢖༻ࢦඪ
 ɾݎ࿚ͳεέδϡʔϦϯάͱΞϥʔτͷΦϓγϣϯ
    -PPLFS
    WT
    5BCMFBV
     -PPLFS
    WT
    5BCMFBV
    c
    ೥ൺֱ
    c
    -PPLFS
    IUUQTKBMPPLFSDPNDPNQBSFMPPLFSWTUBCMFBV
 -PPLFS
    WT
    5BCMFBV
    c
    
    $PNQBSJTPO
    c
    -PPLFS
    IUUQTMPPLFSDPNDPNQBSFMPPLFSWTUBCMFBV #cmdevio
80. Ұݩ؅ཧ͞ΕͨσʔλϓϥοτϑΥʔϜ͔Βͷ࣮֬ͳճ౴
 Trustworthy answers from a centralized data platform -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     ɾ-PPL.-Ͱ࡞੒͞ΕͨϞσϧ &YQMPSF Λڞ༗
 ɾ(JUϦϙδτϦ࿈ܞʹΑΔఆٛ৘ใͷόʔδϣϯ؅ཧ
 ˠࢦඪͷཚཱ΍ΧΦεΛ๷ࢭ
 ˠϢʔβʔຖʹಘΒΕΔճ౴͕ҟͳΔɺͱ͍͏ঢ়گΛճආ -PPLFSϓϥοτϑΥʔϜʹ͍ͭͯ
    c
    -PPLFS
    IUUQTKBMPPLFSDPNQSPEVDUMPPLFSEJ⒎FSFODF
    ߴ౓ͳσʔλ෼ੳϓϥοτϑΥʔϜˍιϑτ΢ΣΞ
    c
    -PPLFS
    IUUQTKBMPPLFSDPNQMBUGPSNPWFSWJFX ˞5BCMFBVͰ͸ϫʔΫϒοΫ΍ͦͷଞཁૉͷ؅ཧػೳʹ๡͍͠
    ɹ (JU࿈ܞ౳͸ແ͍ʗ5BCMFBV
    4FSWFSʹू໿͢ΔࣄͰίϯςϯπ؅ཧ͸Մೳ͕ͩ%FTLUPQ্ʹ͔͠ແ͍΋ͷ·Ͱ͸ख͕ٴ͹ͳ͍ 
 ˞·ͨɺ5BCMFBVͰ͸8PSLCPPL಺ͰɺϢʔβʔຖͷʮಠࣗͷࢦඪΛ࣋ͬͨఆٛʯ͕࡞Εͯ͠·͏
 ɹఆٛͷूத؅ཧ͕ग़དྷͳ͘ͳΓɺΧΦεͷݩʹͳΔՄೳੑ΋ #cmdevio
81. ϏοάσʔλΛ૝ఆͨ͠ΞʔΩςΫνϟ
 Architected for the world of big data -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     "TL
    UIF
    &YQFSUT
    %BUB
    "SDIJUFDUVSFT
    GPS
    #FUUFS
    "OBMZUJDT
    XJUI
    "NB[PO
    3FETIJGU
    c
    -PPLFS
    IUUQTMPPLFSDPNCMPHEBUBBSDIJUFDUVSFGPSBNB[POSFETIJGUGPSCFUUFSBOBMZUJDT ɾ"84($14OPXqBLFͳͲɺ࠷৽ͷσʔλ෼ੳج൫ͱ
 ɹ߹Θͤͯར༻͢Δ͜ͱΛ૝ఆ
 ɾ-PPLFS͸ඳը΍σʔλ഑෍ॲཧʹಛԽɺ
 ɹूܭɾԋࢉॲཧͳͲ͸%#ɾ%8)ଆͷར׆༻͕લఏ
 ɹɾʰඳըʱʹ͸ද্ࣔݶΛઃఆ
 ɹˠେن໛σʔλͷzѻ͍zʹؔ͢ΔελϯεΛ໌ࣔ ˞5BCMFBVͰ͸͜ΜͳϗϫΠτϖʔύʔ΋͋Δ໛༷ɿ
    ɹϏοάσʔλʹ͍ͭͯͷ
    5BCMFBV
    ͷϏδϣϯ
    c
    5BCMFBV
    4PGUXBSF
 ɹIUUQTXXXUBCMFBVDPNKBKQMFBSOXIJUFQBQFSTUBCMFBVTWJTJPOCJHEBUB #cmdevio
82. ݱࡏͷ࠷΋ύϫϑϧͳσʔλϕʔεΛ׬શ׆༻
 Fully leverages today's most powerful databases -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     ɾରԠ%#%8)͸3FETIJGU
    #JH2VFSZ
    4OPXqBLF౳
 ɹؚΊɺ࠷ۙͷஶ໊ͳ΋ͷ͸΄΅໢ཏ
 ɾ%#%8)ຖͷ%JBMFDUΛαϙʔτɺΤϯδϯຖʹ࠷దԽ σʔλϕʔεͷઃఆʹؔ͢ΔΠϯετϥΫγϣϯ
    IUUQTEPDTMPPLFSDPNKBTFUVQBOENBOBHFNFOUEBUBCBTFDPOpH
    -PPLFS
    %JBMFDU
    4VQQPSU
    
    42-
    
    -PPLFS
    $PNNVOJUZ
    IUUQTEJTDPVSTFMPPLFSDPNUMPPLFSEJBMFDUTVQQPSU #cmdevio
83. σʔλͷநग़͸ෆཁɺ͓٬༷ͷσʔλϕʔεʹσʔλΛҡ࣋
 Leaves data in your database -- no need to extract data -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     ɾ-PPLFS͸42-Λൃߦ͠ɺ%#ɾ%8)ଆͰ࣮ߦͨ͠
 ɹ݁ՌͷΈΛѻ͏
 ɾ-PPLFSͰ͸ɺzநग़zػೳͷΑ͏ͳ
 ɹʰσʔλΛαʔόଆʹอ࣋ʱ͢Δ࢓૊ΈΛ࣋ͨͳ͍
 
 ˠ͓٬͞·σʔλͷzॴࡏz͕ҠΔ͜ͱ͸ແ͍ ˞5BCMFBVͰ͸ʰநग़ʱͱ͍͏ػೳ͕͋ΓɺσʔλΛʮݸผʹอ࣋ʯ͢Δ͜ͱ͸ग़དྷΔʹศར͕ͩɺॴࡏ͕ࢄΒ͹ΔՄೳੑ΋
 ɹσʔλͷநग़
    
    5BCMFBV
    IUUQTIFMQUBCMFBVDPNDVSSFOUQSPEFTLUPQKBKQFYUSBDUJOH@EBUBIUN #cmdevio
84. ͻͱͭͷπʔϧ͔Β؆୯ʹͰ͖ΔϦϯΫڞ༗Ͱڞಉ࡞ۀ͕༰қ
 Easy link-sharing from a single tool makes collaboration easy -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     ɾ-PPLFS಺ͷίϯςϯπʹ͸ࣗ༝ʹߦ͖དྷ͕Մೳ
 ɹɾυϦϧμ΢ϯ
 ɹɾ෼ੳ݁Ռ͔ΒଞͷμογϡϘʔυ΁ͷભҠ
 ɾೝূɺڐՄ͕͞Ε͍ͯΕ͹ɺ63-ͭͰ৘ใͷڞ༗͕༰қ
 4IBSJOH
    %BUB
    GSPN
    63-T
    IUUQTEPDTMPPLFSDPNKBTIBSJOHBOEQVCMJTIJOHTIBSJOHVSMT
    ύϒϦοΫڞ༗ɺΠϯϙʔτɺຒΊࠐΈ
 IUUQTEPDTMPPLFSDPNKBTIBSJOHBOEQVCMJTIJOHQVCMJTIJOHMPPLTXJUIQVCMJDVSMT ˞5BCMFBVͷ৔߹ɺ8PSLCPPL୯ҐͰಠཱ͍ͯ͠ΔͨΊɺ8PSLCPPLΛ௒͑Δڞ༗͸ෆՄೳ #cmdevio
85. νϟοτ͔Β਺ඵͰςΫχΧϧαϙʔτΛఏڙ
 Technical support available by chat in seconds -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     Support Access https://docs.looker.com/admin-options/settings/support-access ɾ%$- %FQBSUNFOU
    PG
    $VTUPNFS
    -PWF 
 ɹސ٬Λॏࢹͨ͠αϙʔτνʔϜ͕ରԠ
 ɾϝχϡʔ͔Βଈνϟοτ͕ىಈ
 ɾνϟοτͳͷͰ ౰વ Ϩε͕ૣ͍
 ɾ ೔ຊͷ Ӧۀ࣌ؒ಺Ͱ͋Ε͹೔ຊޠͰɺ
 ɹͦΕҎ֎ͷ࣌ؒଳͰ΋ӳޠͰରԠ
 ɾඞཁʹԠͯ͡63-ڞ༗΋࢖͑͹ঢ়گͷ೺Ѳ΋ਝ଎
 ɾ ϝʔϧରԠ΋ΞϦ #cmdevio
86. ࠶ར༻ՄೳͳσʔλϞσϧʹΑΔ൓෮։ൃ
 Iterative development with a reusable data model -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     Data Modeling in Looker https://info.looker.com/data-modeling/data-modeling-in-looker-2 Reusing Code with Extends https://docs.looker.com/data-modeling/learning-lookml/extends ɾ-PPL.-͸ܧঝ΍֦ு͕Մೳ
 ɾ(JUϦϙδτϦ͔ΒɺଞϢʔβʔ͕࡞੒ͨ͠΋ͷΛ
 ɹΠϯϙʔτ͢Δ͜ͱ΋Մೳ
 
 ˠϊ΢ϋ΢ͷڞ༗ɺ੒Ռ෺ͷ࠶ར༻͕ͱͯ΋༰қ ˞5BCMFBVͷ৔߹ɺෳ੡͸ग़དྷͯ΋ܧঝ΍࠶ར༻ͱ͍͏໘Ͱ͸ػೳʹ๡͍͠ #cmdevio
87. όʔδϣϯ؅ཧػೳ౥ࡌ
 Built-in version control -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     4FUUJOH
    6Q
    BOE
    5FTUJOH
    B
    (JU
    $POOFDUJPO
    IUUQTEPDTMPPLFSDPNEBUBNPEFMJOHHFUUJOHTUBSUFETFUUJOHVQHJUDPOOFDUJPO
    6TJOH
    7FSTJPO
    $POUSPM
    BOE
    %FQMPZJOH
    IUUQTEPDTMPPLFSDPNEBUBNPEFMJOHHFUUJOHTUBSUFEWFSTJPODPOUSPMBOEEFQMPZJOHDIBOHFT ɾ-PPL.-ϓϩδΣΫτΛ(JUϦϙδτϦͱ࿈ܞՄೳ
 ɾ ๯಄z֓ཁzͰݴٴͨ͠ͷͰ͜͜Ͱ͸ׂѪ 
 #cmdevio
88. ޮ཰తͰಡΈऔΓՄೳͳ42-Λ࡞੒
 Writes performant, readable SQL for you -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     )PX
    -PPLFS
    (FOFSBUFT
    42-
    IUUQTEPDTMPPLFSDPNEBUBNPEFMJOHMFBSOJOHMPPLNMIPXMPPLFSHFOFSBUFTTRM ɾ-PPLFSଆͰઃఆ಺༰͔Β
 ɹޮ཰తͳ42-ΫΤϦΛൃߦ
 ɾੜ੒಺༰͸<42->λϒͰ
 ɹ֬ೝՄೳ
 ɾ֤ϓϥοτϑΥʔϜʹ࠷దԽ
 ɹ͞Εͨ42-Λੜ੒
 #cmdevio
89. 4NBSU
    $BDIFʹΑΔ࠷৽σʔλ
 Freshest-possible data with Smart Caching -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     Caching Queries and Rebuilding PDTs with Datagroups https://docs.looker.com/data-modeling/learning-lookml/caching Smart Caching Deep Dive by Abby West - YouTube https://www.youtube.com/watch?v=ncWqAHpM3Ac Join 2017_Deep Dive_Smart Caching https://www.slideshare.net/looker/join-2017deep-divesmart-caching ɾઃఆͰΩϟογϡΛޮ͔ͤɺ
 ɹޮ཰ੑΛ޲্
 ɾΩϟογϡ͸ఆظత ࣌ؒࢦఆ΍
 ɹΠϕϯτۦಈ Ͱ಺༰ߋ৽͕Մೳ
 ɾৗʹϏδωε্Ͱඞཁͳ࠷৽ͷ
 ɹσʔλ΁ΞΫηεՄೳʹ #cmdevio
90. ϒϥ΢βϕʔε
 100% browser-based -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     Supported Browsers https://docs.looker.com/admin-options/supported-browsers ɾσεΫτοϓΞϓϦέʔγϣϯ͕ෆཁ
 ɾΠϯλʔωοτΞΫηεՄೳͳ୺຤͕͋Ε͹
 ɹͲ͔͜ΒͰ΋ΞΫηεՄೳ
 ɾ63-Λڞ༗͢Δ͚ͩͰ୭ʹͰ΋ίϯςϯπͷڞ༗͕Մೳʹ
 ɾ3&45
    "1*ͰଞΞϓϦέʔγϣϯͱܨ͕Δࣄ͕ग़དྷΔ
 ɹˠϢʔβʔ͕طʹར༻͍ͯ͠Δۀ຿ΞϓϦέʔγϣϯΛ
 ɹɹؚΜͩۀ຿ϑϩʔͷதʹ-PPLFSΛ؆୯ʹೖΕΔ͜ͱ͕ग़དྷΔ #cmdevio
91. Θ͔ͣ਺෼ͰγʔϜϨεʹιϑτ΢ΣΞΛΞοϓάϨʔυ
 Software upgrades happen seamlessly in minutes -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     #FTU
    1SBDUJDFT
    XIFO
    6QEBUJOH
    ZPVS
    -PPLFS
    *OTUBODF
    r
    -PPLFS
    )FMQ
    $FOUFS
    IUUQTIFMQMPPLFSDPNIDFOVTBSUJDMFT#FTU1SBDUJDFTXIFO6QEBUJOHZPVS-PPLFS*OTUBODF ɾϢʔβʔͷ؀ڥΛ-PPLFS͕؅ཧɺϢʔβʔଆͷ࡞ۀແ͠Ͱ
 ɹ࠷৽൛΁ͷΞοϓάϨʔυ͕Մೳ
 ɾΞοϓάϨʔυ࣌͸ۃྗμ΢ϯλΠϜ͕ൃੜ͠ͳ͍Α͏ͳ
 ɹ࢓૊ΈΛߏஙӡ༻
 ɾϩʔΧϧΞϓϦέʔγϣϯͷ؅ཧ΋ແ͘ɺ
 ɹόʔδϣϯίϯτϩʔϧ΍Πϯετʔϧ࡞ۀ΋Ұ੾ෆཁ #cmdevio
92. .BDͱ1$ʹରԠ
 Works perfectly on Mac and PC -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     ɾ-PPLFS͸ϒϥ΢βϕʔεͷαʔϏε
 ɾϒϥ΢β͕࢖͑Δ୺຤Ͱ͋Ε͹ಉҰػೳಉҰ69ΛఏڙՄೳ
 #cmdevio
93. ௥੻Λܦͨ؂ࠪՄೳͳ࢖༻ࢦඪ
 Tracked and auditable usage metrics -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     ɾ-PPLFSͷ؅ཧػೳ͔Β༷ʑͳ
 ɹߦಈϩά΍ΞΫηε৘ใΛ֬ೝՄೳ
 ɹɾϢʔβʔ
 ɹɾίϯςϯπ
 ɹɾύϑΥʔϚϯε
 ɾ(JU࿈ܞͰ-PPL.-ͷ৘ใ΋؅ཧɺ
 ɹϦϦʔεલͷ֤छ֬ೝ΋εϜʔζʹ 4ZTUFN
    "DUJWJUZ
    1BHFT
    IUUQTEPDTMPPLFSDPNBENJOPQUJPOTTZTUFNBDUJWJUZ
    $SFBUJOH
    -PPLFS
    6TBHF
    BOE
    .FUBEBUB
    3FQPSUT
    XJUI
    J@@MPPLFS
    IUUQTEPDTMPPLFSDPNBENJOPQUJPOTUVUPSJBMTJ@@MPPLFS #cmdevio
94. ݎ࿚ͳεέδϡʔϦϯάͱΞϥʔτͷΦϓγϣϯ
 Robust scheduling and alerting options -PPLFS
    WT
    5BCMFBV
    
    -PPLFSͷΈ͕උ͍͑ͯΔ΋ͷ 
     4DIFEVMJOH
    %BUB
    %FMJWFSJFT
    IUUQTEPDTMPPLFSDPNTIBSJOHBOEQVCMJTIJOHTDIFEVMJOHBOETIBSJOHTDIFEVMJOH
    "MFSUT
    IUUQTEPDTMPPLFSDPNTIBSJOHBOEQVCMJTIJOHBMFSUT #cmdevio
95. Ͳͬͪ΋࢖͓͏ɻ
 ͦΕͧΕہ໘ͱঢ়گʹԠͨ͡ྑ͕͋͞Δɻ
 ࢖͍෼͚Α͏ɻ -PPLFSͱ5BCMFBVɺͲͬͪΛ࢖͏ʁ
     #cmdevio
96. Ͳͬͪ΋࢖͓͏ɻ
 ͦΕͧΕہ໘ͱঢ়گʹԠͨ͡ྑ͕͋͞Δɻ
 ࢖͍෼͚Α͏ɻ
 ˠ͡Ό͋ɺͲ͏΍ͬͯ࢖͍෼͚Δʁ -PPLFSͱ5BCMFBVɺͲͬͪΛ࢖͏ʁ
     #cmdevio
97. ࢲతʰ-PPLFSͷྑ͍ͱ͜Ζʱ ͋ΒͨΊͯ૒ํͷʮಛ௃ʯΛڍ͛ͯΈΔ
     ɾίϯςϯπɾ৘ใͷόʔδϣϯ؅ཧ͕ߦ͑Δ
 ɹɾ(JU࿈ܞΛσϑΥϧτͰαϙʔτ
 ɹɾ੒Ռ෺Λόʔδϣϯ؅ཧՄೳˠ༷ʑͳԸܙ͕ಘΒΕΔ
 ɾઐ༻πʔϧͷಋೖ͕ෆཁ
 ɹɾ-PPLFSར༻Ϣʔβʔ͸ରԠϒϥ΢βࠐΈͷ୺຤͚ͩ͋Ε͹0,
 ɹɾόʔδϣϯΞοϓάϨʔυͷ൥Θ͔͠͞Βղ์͞ΕΔ
 ɾ-PPL.-ͱ͍͏ʰίʔυɾઃఆʱͰશͯΛ؅ཧ
 ɹɾݸਓతʹ͸ίʔυهड़͸ ୭΋͕ ͍ͣΕ౿ΈࠐΉྖҬͩ͠ɺΞϦͩͱࢥ͏
 ɹɾֶशίετΑΓ΋-PPL.-Λ֮͑ΔࣄͰಘΒΕΔϝϦοτͷํ͕େ͖͍
 ɾ֎෦ͱͷσʔλˍαʔϏε࿈ܞ͕ॆ࣮
 ɹɾσʔλΛʰ֎෦ʹ΋࿈ܞՄೳʱͳͷͰ࢖͍উख͕ྑ͍
 ɹɾ-PPLFS
    "1*"DUJPO
    )VCຒΊࠐΈ෼ੳ౳ɺ༷ʑͳػೳΛ׆༻Մೳ
 ɹˠطଘۀ຿ΞϓϦΛத৺ͱͨ͠ۀ຿ϑϩʔ͕૊ΊΔ #cmdevio
98. ࢲతʰ5BCMFBVͷྑ͍ͱ͜Ζʱ ͋ΒͨΊͯ૒ํͷʮಛ௃ʯΛڍ͛ͯΈΔ
     ɾ࢖͍࢝Ίͷϋʔυϧͷ௿͞
 ɹɾ௚ײˍ(6*ૢ࡞Ͱ࢖͍࢝ΊΔ͜ͱ͕ग़དྷΔ
 ɹɾॳظֶशίετ͕ඇৗʹ୹͘ࡁΉ
 ɹɾਓͰ΋࢝ΊΒΕΔϑοτϫʔΫͷܰ͞͸͋Δ
 ɾՄࢹԽͷදݱྗ
 ɹɾଟछଟ༷ͳදࣔܗࣜʹରԠ
 ɹɾΞΠσΞ࣍ୈͰඒྷͳσβΠϯදݱ΋࣮ݱՄೳ
 ɹɾ஍ཧۭؒ৘ใपΓ΋࠷ۙॆ࣮͖ͯͨ͠
 ɾϩʔΧϧϑΝΠϧʹ ΋ ରԠ
 ɹɾʰखݩͷϑΝΠϧΛ͙͢ʹՄࢹԽʱग़དྷΔͷ͸خ͍͠
 ɹɾʰݟ͍ͨ΋ͷʱͷϓϩτλΠϓΛࢼͤΔͷ΋େ͖͍ͱࢥ͏ #cmdevio
99. -PPLFSͱ5BCMFBVΛʰซ༻ʱͯ͠෼ੳɾՄࢹԽΛՃ଎ <-PPLFS>
 ɾϓϩτλΠϓ݁ՌΛ൓ө
 ɾμογϡϘʔυͷڞ༗
 ɾҰൠϢʔβʔͷࢀর༻్ʹ
 ɾ֤छఆٛͷ؅ཧ ʹ(JU࿈ܞ 
 ɾ෼ੳͷڞ༗ ʹຒΊࠐΈ෼ੳ 
 ɾσʔλͷ࿈ܞ -PPLFS
    "1* 
 ɾॲཧͷ࿈ܞ ʹ"DUJPO
    )VC 
 ˞ڞ༗ల։࿈ܞ༻్ʹ׆༻
 ݸਓతʹߟ͑ΔͦΕͧΕͷʰ࢖͍෼͚ํʱྫ
     <5BCMFBV>
 ɾՄࢹԽֶशͷಋೖͱͯ͠
 ɾՄࢹԽϓϩτλΠϓ࡞੒
 ɾΞΧσϛΧϧͳ෼ੳख๏Λ
 ɹۦ࢖͢ΔϢʔβʔͷ
 ɹΞυϗοΫͳਂ۷Γ༻్ʹ
 ɾදݱྗ͕ඞཁͳ7J[ͷ࡞੒
 ˞ݕূਂ۷Γ༻్ʹ׆༻ #cmdevio
100. ΞδΣϯμ
      ɾࣗݾ঺հˍΠϯτϩ
     ෼
     ɾ-PPLFS֓ཁˍ(PPHMFʹΑΔങऩͷӨڹ
     ෼
     ɾ-PPLFSͷར׆༻Πϝʔδ
     ෼
     ɾ-PPLFSͱ5BCMFBVɺͲͬͪΛ࢖͏ʁͲͬͪ΋࢖͏ʁ ෼
     ɾ·ͱΊ
     ෼ #cmdevio
101. 
      ·ͱΊ
102. -PPLFS
     ެࣜ৘ใݯ
      IUUQTXXXJOTUBHSBNDPNMPPLFSEBUB IUUQTXXXGBDFCPPLDPNHSPVQT IUUQTKBMPPLFSDPN IUUQTMPPLFSDPN IUUQTUXJUUFSDPN-PPLFS%BUB -PPLFS
     "1"$
     'PSVN IUUQTXXXZPVUVCFDPNVTFS-PPLFS%BUB #cmdevio
103. -PPLFS
     ެࣜ৘ใݯ
     
     
     
     ɾ-PPLFS
     %PDVNFOUBUJPO
     IUUQTEPDTMPPLFSDPN
     ɾ-PPLFS
     6TFS
     (VJEF
     
     3FTPVSDFT
     c
     -PPLFS
     IUUQTMPPLFSDPNHVJEF
     ɹɾ(FUUJOH
     4UBSUFE
     IUUQTMPPLFSDPNHVJEFHFUUJOHTUBSUFE
     ɹɾ-PPLFS
     )FMQ
     $FOUFS
     IUUQTIFMQMPPLFSDPNIDFOVT
     ɹɾ-PPLFS
     $PNNVOJUZ
     IUUQTEJTDPVSTFMPPLFSDPN
     ɹɾ-PPLFS
     6OJWFSTJUZ
     IUUQTUSBJOJOHMPPLFSDPN ※υΩϡϝϯτ͸೔ຊޠͰ ɹಡΊΔ΋ͷ΋͋Γ·͢ #cmdevio
104. -PPLFSʹڵຯΛ࣋ͨΕͨํ͸1P$ ֓೦࣮ূ Λɿ
     
     
     
     #cmdevio -PPLFS֓೦࣮ূ 1P$
     c
     -PPLFS
     IUUQTKBMPPLFSDPNEFNPQSPPGPGDPODFQU
105. %FWFMPQFST*0Ͱ΋-PPLFSಛूΛల։͍ͯ͠·͢
      -PPLFS
     ʛ
     ಛूΧςΰϦʔ
     ʛ
     %FWFMPQFST*0
     IUUQTEFWDMBTTNFUIPEKQSFGFSFODFDBUCVTJOFTTBOBMZUJDTUPPMTMPPLFS #cmdevio
106. <13>
     -PPLFSˍΫϥεϝιουɺύʔτφʔక݁͠·ͨ͠
      ࣍ੈ୅#*ϓϥοτϑΥʔϜΛఏڙ͢Δ-PPLFSࣾͱͷύʔτφʔܖ໿Λక݁ʙΫϥ΢υઓུ͓Αͼࢢ৔ Ξϓϩʔνʹ͍ͭͯ-PPLFSࣾ΁ΠϯλϏϡʔ࣮ࢪʙʛϓϨεϦϦʔεʛΫϥεϝιου
     IUUQTDMBTTNFUIPEKQOFXTMPPLFS #cmdevio
107. ʰ+0*/
     ʱʹࢀՃ͖ͯ͠·͢ʂ
      -PPLFSͷ೥࣍ΧϯϑΝϨϯεΠϕϯτʰ+0*/
     
     BU
     4BO
     'SBODJTDPʱʹࢀՃ͖ͯ͠·͢
     MPPLFS
     +0*/EBUB
     IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPJOUSP ։࠵೔࣌ɿ Ր ʙ ໦ 
 ։࠵৔ॴɿถࠃαϯϑϥϯγεί
     
     47/
     8FTU
 #cmdevio
108. w -PPLFSʜྑ͍Ͱ͢ʂ
     w -PPLFSʹݶΒͣɺہ໘ʹԠͯ͡ʰదͨ͠ʱπʔϧ΍αʔϏεΛ ซ༻ͯ͠ɺ෼ੳۀ຿ΛՃ଎͍ͤͯ͜͞͏ʂ
     w -PPLFS͸֎෦࿈ܞʹॊೈʹରԠग़དྷΔαʔϏεɻ
 σʔλ࿈ܞɾॲཧ࿈ܞɾຒΊࠐΈ෼ੳͳͲ্ख͘׆༻͠Α͏ʂ
     w Ϋϥεϝιου͸-PPLFSͱͷύʔτφʔక݁Λ݁ΜͰ͍·͢ʂ
     w %FWFMPQFST*0Ͱ-PPLFSͷΞ΢τϓοτɺҾ͖ଓ͖
 ΨϯΨϯ΍ͬͯߦ͖·͢ʂΑΖ͓͘͠ئ͍͠·͢ʂʂ ·ͱΊ
      #cmdevio