Data Engineering Study #20 "Introduction to Data Analytics with SQL" Book

Data Engineering Study #20「10年戦えるデータ分析入門」回・前半の発表資料です。

Transcript

1. .JOFSP"PLJ
   ͞Βʹ೥ઓ͑Δ͔΋
   ͠Εͳ͍σʔλ෼ੳೖ໳
   "*ͱ%9ͷ࣌୅Λ͜ͷઌੜ͖ͷ͜Δʹ͸
   

   View Slide

2. EJTDMBJNFS
   ຊηογϣϯͷ಺༰͸ݸਓͷҙݟͰ͋Γɺ
   ൃදऀ͕ॴଐ͢Δɾॴଐͨ͠૊৫ͷެࣜݟղͰ͸͋Γ·ͤΜ
   

   View Slide

3. ࣗݾ঺հ
   ‣ ੨໦ๆ࿠ʢ͓͖͋ΈͶΖ͏ʣ
   ‣ ݩ3VCZίϛολʔɺஶॻଟ਺ˠ
   ‣ લʑ৬ฒྻ3%#.4ϕϯμʔ
   ‣ ฒྻσʔλϕʔεͱग़ձ͏
   ‣ લ৬ΫοΫύου
   ‣ ෼ੳαʔϏεʮͨ΂ΈΔʯͷ։ൃ
   ‣ %8)ͷߏங
   ‣ ݱ৬5SFBTVSF%BUBʢڈ೥͔Βʣ
   ‣ "QQMJDBUJPOTνʔϜʹͯ$%1ͷ։ൃ
   

   View Slide

4. དྷि͔Β%JHEBHΛ΍Γ·͢
   

   View Slide

5. ೥ຊͷ
   ͓͞Β͍
   

   View Slide

6. ʰ೥ઓ͑Δσʔλ෼ੳೖ໳ʱ
   ιϑτόϯΫΫϦΤΠςΟϒɺ
   w લ৬ΫοΫύουͷಉ྅ʹ42-ΛֶΜ
   Ͱ΋Β͏ͨΊͷςΩετͱͯ͠ॻ͍ͨ
   w ΤϯδχΞͩͱ0-51ͷ42-͔͠஌Βͳ
   ͍ਓ͕େ൒Ͱɺલఏ͕߹Θͣۤ࿑ͨ͠
   ͷͰɺͦͷ͋ͨΓʹॏ఺Λஔ͍ͨ
   w ͍ͭͰʹ෼ੳσʔλϕʔεʹ͍ͭͯ
   ೔ʑࢥ͍ͬͯͨ͜ͱ΋ॻ͍ͨ
   w ΤϯλʔϓϥΠζ޲͚اۀʹ͍ͨ਎͔
   Β͢Δͱ%8)͸͋ͨΓ·͑ͷ஌ࣝͩ
   ͕ɺ౰࣌͸·ͩ΢Σϒք۾ʹ͸޿·ͬ
   ͓ͯΒͣɺ஌ࣝͷஅઈ͕͋ͬͨ
   

   View Slide

7. ʙ೥͘Β͍ͷঢ়گ
   ͍ΘΏΔ΢Σϒܥ
   ৽͍͠اۀ
   ͍ΘΏΔ
   ΤϯλʔϓϥΠζاۀ
   ฏۉతͳ΢ΣϒΤϯδχΞ
   ϓϥϯφʔɺσΟϨΫλʔɺʜ
   %8)ʁͳʹͦΕʁ
   %8)ͬͯΦϯϓϨͰ͠ΐ
   ͡Ό͋"DUJWF3FDPSEͰʜ
   )BEPPQ࢖͑͹͍͍ΑͶ
   )BEPPQΑ͘Θ͔ΒΜ
   ϏοάσʔλΑ͘Θ͔ΒΜ
   Α͘Θ͔ΒΜ͚Ͳ
   Ϗοάσʔλ͍ͬͯ͏ౕͰ
   %8)͸Φϫίϯͳͷʁ
   ͳʹ΋Θ͔Βͳ͍
   ဃ཭
   

   View Slide

8. ୈ෦42-ʹΑΔσʔλ෼ੳ
   w ୈষ೥ઓ͑Δσʔλ෼ੳͷٕज़
   w ୈষ͞ΘͬͯΈΑ͏3%#.4
   w ୈষ؆୯ʂTFMFDUจͰσʔλ୳ࡧ
   w ୈষ͢΂ͯͷ෼ੳ͸ूܭ͔Β࢝·Δ
   w ୈষؔ਺Ͱࣗ༝ࣗࡏʹ৽͍͠ΧϥϜΛ࡞Γग़͢
   w ୈষδϣΠϯΛ੍͢Δ΋ͷ͸3%#.4Λ੍͢ʕʕجૅฤ
   w ୈষδϣΠϯΛ੍͢Δ΋ͷ͸3%#.4Λ੍͢ʕʕԠ༻ฤ
   w ୈষ஗Εͯདྷͨ෼ੳ42-࠷ڧͷ෢ثʕʕ΢Οϯυ΢ؔ਺
   w ୈষॎͱԣ͸೉͍͠
   w ୈষΞΫηεϩάͷηογϣϯ෼ੳΛ͢Δ
   ୈ෦෼ੳγεςϜͷߏங
   w ୈষ೥ઓ͑Δσʔλ෼ੳγεςϜ
   w ୈষϏοάσʔλʹཱͪ޲͔͏
   w ୈষ42-όονͷٕ๏
   w ୈষຊॻΛಡΈऴ͑ͨޙʹ
   ʰ೥ઓ͑Δσʔλ෼ੳೖ໳ʱ֓ཁ
   લઆ
   42-ͷ࿩
   42-த৺
   ΞʔΩςΫνϟ
   

   View Slide

9. 42-Ͱ෼ੳ͠Α͏
   σʔλΛϲॴʹूΊΑ͏
   σʔλΛ૚ߏ଄ʹฤ੒͠Α͏
   42-த৺ΞʔΩςΫνϟ
   ݸผʹ࠶ݕ౼͢Δ
   

   View Slide

10. ೥ຊͷ͓͞Β͍ʢຊηΫγϣϯʣ
    ࠷ۙͷ42-ʹ͍ͭͯ
    42-͸͍ͭࢮ͵ͷ͔
    ͜Ε͔Βͷ෼ੳσʔλϕʔεͱ͸
    σʔλ͸ҰϲॴʹूΊΔ΂͖͔
    σʔλΛͲͷΑ͏ʹฤ੒͢Δ͔
    ·ͱΊ
    ຊ೔ͷ಺༰
    

    View Slide

11. ࠷ۙͷ42-
    ʹ͍ͭͯ
    

    View Slide

12. w 42-
    w ࠷ॳͷ42-ඪ४
    w 42-ʢ42-ʣ
    w ͍͍ͩͨͲͷํݴͰ΋࣮૷͞Ε͍ͯΔൣғ
    w 42-ʢ42-ʣ
    w ਖ਼نදݱϚονɺ࠶ؼΫΤϦʔɺ഑ྻɺߏ଄ମɺετΞυϓϩ
    γʔδϟ
    w 42-
    w ΢Οϯυ΢ؔ਺ɺγʔέϯεɺ*EFOUJUZΧϥϜ
    ීٴͨ͠42-ඪ४
    

    View Slide

13. ৽͠Ίͷ42-ඪ४
    ඪ४ ओͳ௥Ճػೳ
    42- 42-9.-
    42- 5SVODBUFTUBUFNFOU
    42- 5FNQPSBM
    42-
    3PXQBUUFSONBUDIJOH +40/PQFSBUJPOT
    1PMZNPSQIJDUBCMFGVODUJPO MJTUBHH
    42-
    ଟ࣍ݩ഑ྻ
    42-
    +40/UZQF 6OEFSTDPSFTJOOVNFSJDMJUFSBMT
    

    1SPQFSUZHSBQIRVFSJFT
    

    View Slide

14. NBUDI@SFDPHOJ[F
    42- SPXQBUUFSONBUDIJOH
    
    

    View Slide

15. w ߦͷฒͼʹରͯ͠ਖ਼نදݱϚ
    ονΛ͢Δ͜ͱ͕Ͱ͖Δ
    w Ϛονͨ͠෦෼ΛऔΓग़ͨ͠
    Γूܭͨ͠ΓͰ͖Δ
    w 1SFTUP 4OPX
    fl
    BLF 0SBDMF
    ͳͲ͕࣮૷͍ͯ͠Δ
    ߦͷฒͼʹର͢ΔύλʔϯϚον
    NBUDI@SFDPHOJ[F
    TFMFDUGSPNXFC@BDDFTT
    NBUDI@SFDPHOJ[F
    QBSUJUJPOCZVTFS@JE
    PSEFSCZFWFOU@UJNF
    NFBTVSFT
    TVN BNPVOU
    BTUPUBM@BNPVOU
    QBUUFSO 7$#
    
    EF
    fi
    OF
    7BTFWFOUWJFX
    $BTFWFOUDBSU
    #BTFWFOUCVZ
    
    
    

    View Slide

16. w ͓ͦΒ͘NBUDI@SFDPHOJ[Fͷ
    ݩωλ
    w Ϋϥελʔ಺ʹ)BEPPQ͕ಈ͍
    ͍ͯͯ.BQ3FEVDFͰॲཧ
    w "TUFS%BUB͸ޙʹ5FSBEBUBʹ
    ങऩ͞Εͨ
    "TUFS%BUBͷO1BUI
    TFMFDUGSPNOQBUI
    POXFC@BDDFTT
    

    QBSUJUJPOCZVTFS@JE
    

    PSEFSCZFWFOU@UJNF
    VTJOHNPEF OPOPWFSMBQQJOH
    
    QBUUFSO 7$#
    
    TZNCPMT
    FWFOUWJFXBT7
    FWFOUDBSUBT$
    FWFOUCVZBT#
    
    
    SFTVMU
    TVN BNPVOU
    PG#
    
    
    
    BTU
    

    View Slide

17. ΦϥΫϧຊࣾ
    αϯΧϧϩεۭߓ
    ݩ"TUFS%BUBΦϑΟε
    42-ۭߓ
    

    View Slide

18. w +40/PQFSBUJPOT 42-
    
    w +40/Ͱ͋ΔจࣈྻΛύʔεͯ͠ॲཧ͢Δؔ਺܈ɻ
    w +40/1BUIͰ஋ΛऔΓग़ͨ͠ΓͰ͖Δɻ
    w +40/5ZQF 42-
    
    w ʢύʔεࡁΈͷʣ+40/஋Λσʔλϕʔεʹอଘͯ͠ɺؔ਺Ͱ͸ͳ͘ߏจͰΞΫ
    ηεͰ͖Δɻ
    w จࣈྻॲཧͰ͸ͳ͘ɺ42-ͷߏจͰ+40/Λߏஙͯ͠ฦ͢͜ͱ΋Ͱ͖Δɻ
    +40/UZQFͱ+40/PQFSBUJPO
    

    View Slide

19. w 1PMZNPSQIJD5BCMF'VODUJPO 42-
    
    w ςʔϒϧؔ਺͔Βɺಈతʹܕ͕มΘΔϦϨʔγϣϯΛฦ͢͜ͱ
    ͕Ͱ͖Δɻ
    w ଞͷσʔλϕʔεʹ೚ҙͷΫΤϦʔΛ౤͛ͨ݁ՌΛฦ͢Α͏ͳ
    ؔ਺͕࡞ΕΔɻ
    1PMZNPSQIJD5BCMF'VODUJPO
    

    View Slide

20. w 6OEFSTDPSFTJO/VNFSJD-JUFSBMT 42-
    
    w @@ͱॻ͚Δɻ
    w 1PTUHSF42-΍࠷৽ͷ5SJOPͳͲ͕αϙʔτ͢ΔΒ͍͠ɻ
    ੔਺ϦςϥϧʹԼઢ
    

    View Slide

21. w 1SPQFSUZ(SBQI2VFSJFT 42-
    
    w ςʔϒϧʹอଘ͞Εͨάϥϑʢσʔλߏ଄ʣʹର͢ΔΫΤϦʔ͕ॻ͚Δɻ
    1SPQFSUZ(SBQI2VFSJFT
    $3&"5&1301&35:(3"1)
    fi
    OBODJBM@USBOTBDUJPOT
    7&35&95"#-&4
    1FSTPOT-"#&-1FSTPO1301&35*&4 OBNF
    
    $PNQBOJFT-"#&-$PNQBOZ1301&35*&4 OBNF
    
    "DDPVOUT-"#&-"DDPVOU1301&35*&4 OVNCFS
    
    
    
    &%(&5"#-&4
    5SBOTBDUJPOT
    4063$&,&: GSPN@BDDPVOU
    3&'&3&/$&4"DDPVOUT OVNCFS
    
    %&45*/"5*0/,&: UP@BDDPVOU
    3&'&3&/$&4"DDPVOUT OVNCFS
    
    -"#&-USBOTBDUJPO1301&35*&4 BNPVOU
    
    "DDPVOUT"41FSTPO0XOFS
    4063$&,&: OVNCFS
    3&'&3&/$&4"DDPVOUT OVNCFS
    
    %&45*/"5*0/1FSTPOT
    -"#&-PXOFS/01301&35*&4
    "DDPVOUT"4$PNQBOZ0XOFS
    4063$&,&: OVNCFS
    3&'&3&/$&4"DDPVOUT OVNCFS
    
    %&45*/"5*0/$PNQBOJFT
    -"#&-PXOFS/01301&35*&4
    1FSTPOT"4XPSLT'PS
    4063$&,&: JE
    3&'&3&/$&41FSTPOT JE
    
    %&45*/"5*0/$PNQBOJFT
    /01301&35*&4
    
    
    4&-&$5
    PXOFSOBNF"4BDDPVOU@IPMEFS
    46. UBNPVOU
    "4UPUBM@USBOTBDUFE@XJUI@/JLJUB
    '30.
    ."5$) Q1FSTPO
    <PXOFS> BDDPVOU"DDPVOU
    
    ."5$) BDDPVOU
    BDDPVOU
    
    ."5$) BDDPVOU"DDPVOU
    <PXOFS> PXOFS1FSTPOc$PNQBOZ
    
    8)&3&
    QOBNF/JLJUB
    (3061#:
    PXOFS
    'SPNIUUQTQHRMMBOHPSH
    

    View Slide

22. w RVBMJGZ۟
    w ΢Οϯυ΢ؔ਺͕࣮ߦ͞Εͨ͋ͱʹධՁ͞ΕΔ8)&3&۟ɻ
    w ΢Οϯυ΢ؔ਺Λ࢖͏ͱߴ֬཰Ͱൃੜ͢ΔαϒΫΤϦʔΛ๾໓Ͱ͖Δɻ
    w ݩ͸5FSBEBUBͷಠ֦ࣗு͕ͩɺ͍·͸#JH2VFSZɺ4OPX
    fl
    BLF΋αϙʔτͯ͠
    ͍Δɻ
    w ϥςϥϧࢀর
    w BTͰ෇͚ͨผ໊ΛɺXIFSF۟΍HSPVQCZ͔۟ΒࢀরͰ͖Δɻ
    w ྫʹΑͬͯ5FSBEBUB͕࣮૷͍͕ͯͨ͠3FETIJGUɺ)JWFʹ΋͍ͭͷ·ʹ͔ೖͬ
    ͨɻ
    w ϥϜμࣜ
    w ֤छϓϩάϥϛϯάݴޠʹ͋ΔΞϨɻແ໊ͷؔ਺Λॻ͘͜ͱ͕Ͱ͖Δɻ
    w 5SJOP͕࣮૷͍ͯ͠Δɻ
    42-ඪ४Ͱ͸ͳ͍͕ศརͳߏจ
    

    View Slide

23. w 42-ʹ͸׆ൃʹػೳ͕௥Ճ͞Ε͓ͯΓɺ·ͩ·ͩਐԽத
    w ϦϨʔγϣφϧσʔλͷൣᙝΛӽ͑ͯର৅ྖҬ͕֦େ͍ͯ͠Δ
    ৽͍͠42-ඪ४·ͱΊ
    

    View Slide

24. 42-͸͍ͭ
    ·Ͱ༗ޮ͔ʁ
    

    View Slide

25. 42-Ͱ෼ੳ͠Α͏
    σʔλΛϲॴʹूΊΑ͏
    σʔλΛ૚ߏ଄ʹฤ੒͠Α͏
    42-த৺ΞʔΩςΫνϟ
    

    View Slide

26. w %#ݻ༗ͷ֦ு͕ଟ͗ͯ͢ඪ४42-͚ͩͰ͸Կ΋ॻ͚ͳ͍
    w ʮ͓·͑͸ࠓ·Ͱʹ࢖ͬͨ%#ݻ༗֦ுͷ਺Λ͍֮͑ͯΔͷ͔ʁʯ
    w ֦ுੑօແͳ೥୅ͷจ๏
    w ʮӳޠʹࣅͯΔ͔ΒಡΈ΍͍͢ʯͱ͍͏Ϋιཧ࿦
    w େจࣈΛ࢖͍͕ͨΔ
    w ͱͯ΋֮͑ΒΕͳ͍਺ͷ༧໿ޠ
    w ͳ͔ͥ'30.͕۟ೋ൪໨
    w ॻ͘ऀΛࠞཚͤ͞Δ࠷௿ͳػೳͷ਺ʑ
    w ΏΔ;Θࣗಈܕม׵
    w /6--
    42-ͳΜͯݏ͍ͩ
    

    View Slide

27. ਖ਼௚ɺ໓ͼͯ΄͍͠ʜ
    

    View Slide

28. w ओཁ3%#.4͕͢΂ͯผͷݴޠΛαϙʔτͨ͠Βࢮ͵ʁ
    w 0SBDMF 42-4FSWFS .Z42- 1PTUHSF42- #JH2VFSZ 4OPX
    fl
    BLF
    5FSBEBUB %#͕͢΂ͯ42-Ͱ͸ͳ͍ಉ͡ݴޠΛαϙʔτ͢Δ͜ͱ͸͋Γ͏Δ
    ͔ʁ
    w 3%#.4͕ࢮΜͩΒ42-΋ࢮ͵ʁ
    w ೥୅ͷ,74ϒʔϜ͸3%#.4Λࡴ͢࠷େͷνϟϯεͩͬͨ͸͕ͣͩɺ݁
    Ռͱͯ͠ࡴ͔ͤͨʁ
    w ਓؒͱओཁ#*πʔϧ͕ἧͬͯҧ͏ݴޠΛ࢖͍࢝ΊͨΒࢮ͵ʁ
    w ਓؒ͸$IBU(15͕ॻ͍ͯ͘ΕΔ͔΋͠Εͳ͍
    w #*πʔϧͷݴޠΛม͑Δಈػ͕ͦ͜·Ͱ͋Δ͔ʁ
    Ͳ͏ͳͬͨΒ42-͸ࢮ͵͔
    

    View Slide

29. 42-͸ෆ໓
    େม࢒೦ͳ͓஌ΒͤͰ͕͢
    

    View Slide

30. w 42-Λࡴͦ͏ͱͨ͠ʢʁʣ.BQ3FEVDFɺ4BX[BMMɺ1JHɺͳΜͱ
    ͔2-ͦͷଞ͍Ζ͍Ζ͸ٯʹ͢΂ͯࡴ͞Εͯ͠·ͬͨ
    w &5-΍όον΋͢΂ͯ42-ʹ౷߹͞ΕΔ͔΋͠Εͳ͍ʢޙड़ʣ
    w ετϦʔϜॲཧ͸·ͩະདྷ͕ݟ͑ͳ͍͕42-͕੮ר͢ΔՄೳੑ͕
    ͋Δ
    42-ੈʹጨΔ
    

    View Slide

31. 42-͸ΤλʔφϧϑΥʔε
    

    ϒϦβʔυʢ˞૬ख͸ࢮ͵ʣ
    

    View Slide

32. ΋͔ͯ͠͠
    ਓྨΑΓ௕ੜ͖͢ΔͷͰ͸ʜʜʁ
    

    View Slide

33. w ࢒೦ͳ͕Β42-͸ෆࢮ਎ɻ
    w ͏͔ͬΓࡴͦ͏ͱ͢Δͱࡴ͠ฦ͞ΕΔɻ
    w ਓྨͷखʹ༨ΔͷͰఘΊΑ͏ɻ
    ηΫγϣϯ·ͱΊ
    

    View Slide

34. ͜Ε͔Βͷ෼
    ੳσʔλϕʔε
    ͸Ͳ͏ͳΔ͔
    

    View Slide

35. ೥ޙͷ෼ੳ%#͸Ͳ͏ͳΔʁ
    աڈͷྲྀΕΛݩʹߟ͑Δ
    

    View Slide

36. աڈ೥ͷ෼ੳ%#ͷྲྀΕ
    %8)ઐ༻ػ )BEPPQͱ/P42- ৽͍͠ฒྻ3%#.4
    ʙ 5FSBEBUB૑ۀ
    
    
    (SFFOQMVN૑ۀ ('4࿦จ
    
    
    )BEPPQ
    5FSBEBUB
    0SBDMF&YBEBUB $BTTBOESBϦϦʔε
    
    )JWFϦϦʔε
    #JH2VFSZ("
    "NB[PO3FETIJGU )BEPPQ
    1SFTUP044Խ
    5%1MB[NB4OPX
    fl
    BLF
    
    
    )BEPPQ
    
    
    3FETIJGU3"
    

    View Slide

37. w %8)ઐ༻ػͷ࣌୅
    w ΦϯϓϨTIBSFEOPUIJOH
    w 42-ϕʔεͰτϥϯβΫγϣϯΛαϙʔτ͢Δ
    w )BEPPQͱ/P42-ͷ࣌୅
    w ΦϯϓϨ·ͨ͸Ϋϥ΢υͷTIBSFEOPUIJOHͰϩʔΧϧ)%%ʹ
    σʔλΛอଘ
    w 42-EPFTOUTDBMF
    w OPX৽͍͠ฒྻ3%#.4ͷ࣌୅
    w Ϋϥ΢υલఏͰDPNQVUFͱTUPSBHFΛ෼཭
    w ࠶ͼ42-ϕʔεͰτϥϯβΫγϣϯΛαϙʔτ͢Δ
    աڈ೥ͷ෼ੳ%#ͷྲྀΕ
    

    View Slide

38. DPNQVUFͱTUPSBHFͷ෼཭
    τϥϯβΫγϣϯͷαϙʔτ
    ୯ҰΠϯελϯε΁ͷճؼ
    ͜ͷηΫγϣϯͷτϐοΫ
    

    View Slide

39. DPNQVUFͱTUPSBHFͷ෼཭
    

    View Slide

40. 3FETIJGUͷྫ %4OPEFUZQF
    
    &UIFSOFU
    MFBEFS
    OPEF
    DPNQVUF DPNQVUF DPNQVUF DPNQVUF
    MPDBM
    EJTL
    MPDBM
    EJTL
    MPDBM
    EJTL
    MPDBM
    EJTL
    w γϯϓϧͳTIBSFEOPUIJOHΞʔΩςΫνϟ
    w σʔλ͸͢΂ͯFQIFNFSBMEJTLʹ഑ஔ
    w ϊʔυΛ௥Ճ͢Δͱશσʔλͷ࠶෼ࢄ͕ඞཁ
    Ͱ೔୯Ґͷ͕͔͔࣌ؒΔ
    

    View Slide

41. 3FETIJGUͷྫ 3"OPEFUZQF
    
    &UIFSOFU
    MFBEFS
    OPEF
    DPNQVUF DPNQVUF DPNQVUF DPNQVUF
    4
    w σʔλ͸͢΂ͯ4ʹ഑ஔ
    w σʔλͱ͸·ͬͨؔ͘܎ͳ͘DPNQVUFϊʔυ
    Λ૿ݮͰ͖Δ
    w ݁Ռͱͯ͠EZOBNJDͳ૿ݮ΍ɺΫϥελʔؒ
    Ͱͷσʔλڞ༗ͳͲ͕ՄೳʹͳΔ
    

    View Slide

42. w ࣮ࡍʹࢼͯ͠Έͨͱ͜Ζ࠷େ͍ͯͲͷ଎౓௿ԼͰࡁΜͩ
    w 4QFDUSVNʢޙड़ʣͷΑ͏ͳ4ΞΫηεΛଟ༻͍ͯ͠Δͱࠩ
    ͸΄΅ग़ͳ͍
    w 3FETIJGU"26"ͷΑ͏ͳΩϟογϡΛ݉ͶͨετϨʔδ૚
    ΛೖΕΔͱΉ͠Ζ଎͘ͳΔ৔߹΋͋Δ
    w എܠͱͯ͠ɺੲʹൺ΂ͯετϨʔδͱωοτϫʔΫͷ଎౓ࠩ
    ͕ॖ·͍ͬͯΔ఺͕͋Δ
    σʔλ͕཭ΕͨΒ஗͘ͳΒͳ͍ʁ
    

    View Slide

43. w γϟοϑϧʢ࠶෼ࢄʣઐ༻ͷผΫϥελʔ
    w 1SFTUP΍#JH2VFSZʹ࣮૷͞Ε͍ͯΔ
    w ωοτϫʔΫసૹ͸͍ͩͿ૿͑Δ͕ɺXSJUFBNQMJ
    fi
    DBUJPOΛ
    ๷͍Ͱߴ଎ԽͰ͖Δʢέʔε͕͋Δʣ
    γϟοϑϧΫϥελʔ
    

    View Slide

44. 5SFBTVSF%BUB1MB[NB
    4
    1MB[NB
    NFUBEBUB
    1SFTUP
    $PPSEJOBUPS
    1SFTUP
    8PSLFS
    1SFTUP
    8PSLFS
    1SFTUP
    8PSLFS
    1SFTUP
    8PSLFS
    &UIFSOFU
    w DPNQVUFTUPSBHF෼཭ΞʔΩςΫνϟ
    w σʔλ͸͢΂ͯ4ʹ഑ஔ
    w ϝλσʔλ͸1PTUHSF42-ʹஔ͍͍ͯΔͷͰ
    τϥϯβΫγϣϯ͕࢖͑Δ
    

    View Slide

45. 5FSBEBUB7
    #:/&5JOUFSDPOOFDU
    /PEF /PEF /PEF /PEF /PEF
    4UPSBHF"SSBZ
    1&
    ".1
    1&
    ".1
    1&
    ".1
    1&
    ".1
    1&
    ".1
    'JCSF$IBOOFM
    w ϘτϧωοΫʹͳΓ΍͍͢ϊʔυؒ௨৴ʹಠࣗϋʔ
    υ΢ΣΞ#:/&5Λ࢖͏͜ͱͰϦχΞʹεέʔϧ
    w MFBEFS૬౰͕֤ϊʔυʹ͍ΔϚϧνϚελʔ
    w ͓ߴ͍ετϨʔδΞϨΠΛෳ਺ϊʔυؒͰڞ༗͢Δ
    ͜ͱͰϨϓϦ΍OPEFGBJM࣌ͷ࠶෼ࢄΛճආ
    

    View Slide

46. τϥϯβΫγϣϯͷαϙʔτ
    

    View Slide

47. w ͜Ε·Ͱ͸ࢀরॏࢹͩͬͨ෼ੳγεςϜʹߋ৽ܥͷ೾͕དྷ͍ͯΔ
    w τϥϯβΫγϣϯͷαϙʔτ͸ඞવ
    w ετϨʔδ͕ެ։͞Ε͍ͯΔ͔Ͳ͏͔Ͱ೉қ౓͕มΘΔ
    w "QBDIF*DFCFSHͳͲ͸جຊతʹ͸ެ։ετϨʔδΛ૝ఆͨ͠ϑΥʔϚοτ
    ʢ༷ʑͳγεςϜ͕ΞΫηεͰ͖Δʣ
    w 3FETIJGU΍1MB[NBͷετϨʔδ͸4Ͱ͋ͬͯ΋ઐ༻όέοτΛ࢖͏ͷͰτϥ
    ϯβΫγϣϯͷ࣮૷͕γεςϜʹด͡Δ
    w ύϑΥʔϚϯε͔Βߟ͑Δͱઐ༻ετϨʔδΛ࣋ͭ΄͏͕༗ར
    w σʔλϨΠΫͰ͢΂ͯΛ·͔ͳ͏ํ޲ʹ͸ߦ͔ͳ͍ͱ༧૝
    w ઐ༻ετϨʔδ0CKFDU4UPSBHF"DDFTTʢޙड़ʣʹͳΔͷͰ͸ʁ
    τϥϯβΫγϣϯͷαϙʔτ
    

    View Slide

48. ୯ҰΠϯελϯε΁ͷճؼ
    

    View Slide

49. IUUQTNPUIFSEVDLDPNCMPHCJHEBUBJTEFBE
    

    View Slide

50. w େ൒ͷاۀ͸ϏοάσʔλΛ͍࣋ͬͯͳ͍ʢϛυϧσʔλͰ͋
    Δʣ
    w ετϨʔδ͸࣌ؒʹൺྫͯ͠ඞཁྔ͕૿͍͕͑ͯ͘ɺίϯϐϡʔ
    τ͸͍ͨͯ͠૿͑ͳ͍
    w Ϛγϯύϫʔ͸·ͩ૿Ճ͠ଓ͚͓ͯΓɺͭ·Γίϯϐϡʔλʔ
    ୆ͰॲཧͰ͖Δσʔλྔ͸૿͑ଓ͚͍ͯΔ
    #*(%"5"*4%&"%
    VUCYMBSHF୆ͰࡁΉͷͰ͸ʁ
    

    View Slide

51. %VDL%#ʹΑΔ෼ੳ%#ͷߏ੒
    ΫισΧ
    Πϯελϯε
    %VDL%#
    4
    

    View Slide

52. w ࠶෼ࢄ͸ϘτϧωοΫͰͳ͘
    ͳΔ
    w Ϛϧνςφϯτͷ෼ࢄ%#ϕϯ
    μʔʹ͸Өڹ͕͋Δʁ
    มΘΔ͜ͱͱมΘΒͳ͍͜ͱ
    w ෼ੳγεςϜͷத৺ʹίΞͱͳ
    Δฒྻσʔλϕʔε͕ඞཁ
    w ΫΤϦʔ࠷దԽͷखஈ
    w ར༻ଆͷϝϯςίετ
    มΘΔ มΘΒͳ͍
    

    View Slide

53. ΋͔ͯ͠͠ʜʜ
    

    View Slide

54. w DPNQVUFͱTUPSBHFͷ෼཭͸࣌୅ͷ਼੎
    w ॲཧͷ಺༰͝ͱʹΫϥελʔΛ෼͚ΔΞʔΩςΫνϟͷొ৔
    w τϥϯβΫγϣϯαϙʔτ΋࣌୅ͷ਼੎
    w τϥϯβΫγϣϯͷ࣮૷ʹ͸ઐ༻ετϨʔδ͕͋Δ΄͏͕༗ར
    w ͋͑ͯ෼ࢄ͠ͳ͍બ୒ࢶ΋ొ৔ͨ͠
    ηΫγϣϯ·ͱΊ
    

    View Slide

55. ෼ੳαʔϏεϕϯμʔͷಓ Ϣʔβʔاۀͷಓ
    ϚϧνςφϯτͰΫϥελʔΛ
    ॏͶͯεέʔϧΞ΢τͩυʔϯ
    ͜͏͍͏͜ͱʜʜ͔ʁ
    γϯάϧςφϯτͷϊʔυͰ
    ίϯύΫτʹղܾͩ
    

    View Slide

56. σʔλ͸ϲॴ
    ʹूΊΔ΂͖͔
    

    View Slide

57. 42-Ͱ෼ੳ͠Α͏
    σʔλΛϲॴʹूΊΑ͏
    σʔλΛ૚ߏ଄ʹฤ੒͠Α͏
    42-த৺ΞʔΩςΫνϟ
    

    View Slide

58. w ॻ੶Λॻ͍ͨ࣌఺Ͱ͸ɺ҆ఆੑͱ଎౓Λߟ͑Δͱ·ͩ෺ཧతʹҰ
    ϲॴʹूΊΔ΄͏͕Α͍ͱ͍͏൑அͩͬͨ
    w ͦͷޙʹීٴͨͭ͠ͷػೳ
    w 0CKFDU4UPSBHF"DDFTT
    w 'FEFSBUFE2VFSZ
    w %BUB4IBSJOH
    σʔλΛͭͷ%#ʹूΊΔ
    

    View Slide

59. w 4΍$MPVE4UPSBHFͷΑ͏ͳΦϒδΣΫτετϨʔδ্ͷΦϒ
    δΣΫτΛ௚઀ΫΤϦʔ͢Δػೳʢ3FETIJGU4QFDUSVNͳͲʣ
    0CKFDU4UPSBHF"DDFTT
    3FETIJGU 4
    ΫΤϦʔ
    

    View Slide

60. w ଞͷσʔλϕʔεΛ௚઀ΫΤϦʔ͢Δػೳʢ3FETIJGU
    'FEFSBUFE2VFSZͳͲʣ
    w ੓࣏తʹ&5-ΑΓָͩͬͨΓ͢Δ͜ͱ΋͋ΔΒ͍͠
    'FEFSBUFE2VFSZ
    3FETIJGU .Z42-
    ΫΤϦʔ
    

    View Slide

61. w ଞͷσʔλϕʔεͷςʔϒϧΛಁաతʹࢀরͰ͖Δ
    %BUB4IBSJOH
    3FETIJGU
    ΫΤϦʔ
    4
    3FETIJGU
    4
    

    View Slide

62. w 'FEFSBUFE2VFSZ͸αΠζͰ࢖͍෼͚Δͷ͕ݱ࣮త
    w খ͍͞ςʔϒϧ͸&-5ͰऔΓࠐΉΑΓ'FEFSBUFE2VFSZ
    w ڊେͳςʔϒϧ͸Ҿ͖ଓ͖&-5
    w 0CKFDU4UPSBHF"DDFTT͸τϥϯβΫγϣϯ༗ແʹΑΔ
    w ΞΫηεϩάͳͲͷڊେ͕ͩ௥ՃΦϯϦʔͷςʔϒϧ͸0CKFDU4UPSBHF
    "DDFTT
    w Ϛελʔ΍αϚϦʔςʔϒϧ͸಺෦ςʔϒϧ
    w %BUB4IBSJOH͸Ϋϥελʔ෼ׂΛ໨తʹ͢ΔͱΑ͍
    w ྫ͑͹ࢠձࣾͷσʔλΛผΫϥελʔʹ෼͚ͭͭάϧʔϓͰ౷߹͢Δέʔεͳ
    Ͳ
    σʔλ࿈ܞػೳͷ࢖͍Ͳ͜Ζ
    

    View Slide

63. ෺ཧతʹͭͷ%#΁
    σʔλΛूΊΔඞཁ͸ͳ͍͕ɺ
    42-Ͱಁաతʹ
    ΞΫηεՄೳʹ͸͢΂͖
    

    View Slide

64. w 3FETIJGUͷ"VSPSB;FSP&5-
    w "VSPSBͷςʔϒϧ͕ඵ͍ͯͲͰ3FETIJGUʹϨϓϦ͞ΕɺΞΫηεՄೳʹͳ
    Δ
    w 4OPX
    fl
    BLFͷ6OJTUPSF
    w 0-51ΞΫηεʹ޲͍ͨ)ZCSJE5BCMFΛ࡞Δ͜ͱ͕Ͱ͖Δ
    w ෼ੳΫΤϦʔ͔Β΋ී௨ͷςʔϒϧͷΑ͏ʹΞΫηεͰ͖Δ
    0-51ͱͷ౷߹
    ʢ௥Ճʣ;FSP&5-ͱ6OJTUPSF
    

    View Slide

65. ࠓޙ͸σʔλϕʔε୯ମΑΓ΋
    ෼ੳγεςϜશମͷઃܭ͕໰୊
    

    View Slide

66. σʔλΛͲͷ
    Α͏ʹฤ੒͢Δ͔
    

    View Slide

67. 42-Ͱ෼ੳ͠Α͏
    σʔλΛϲॴʹूΊΑ͏
    σʔλΛ૚ߏ଄ʹฤ੒͠Α͏
    42-த৺ΞʔΩςΫνϟ
    

    View Slide

68. &5-ΑΓ&-5
    w ୈ૚ΛʮιʔεσʔλΛͦͷ··ϩʔυ͢ΔεΩʔϚʯͱఆٛ͢Δ͜ͱͰɺ
    ඞવతʹ&-5ʹͳΔ
    ෺ཧσʔλϚʔτΑΓԾ૝σʔλϚʔτ
    w ୈ૚Λ഑ஔͨ͜͠ͱͰɺඞવతʹԾ૝σʔλϚʔτʹͳΔ
    w ˡˠ0-51%#ͰσʔλϚʔτΛ࡞Δ
    σʔλͷྲྀΕ͸Ұํ޲
    w ୈ૚͔Β૚ɺ૚΁ͷํ޲Ͱσʔλ͸ྲྀΕΔ΂͖
    ૊৫ͷ੾Ε໨ʹରԠ͍ͯ͠Δʢ͜ͱ΋͋Δʣ
    w σʔλऔΓࠐΈͱ%8)ߏங͸σʔλϚʔτߏஙͱ͸ผͷνʔϜʹͳΔ͜ͱ͕
    ଟ͍ͷͰɺͦ͜Ͱ੾͓ͬͯ͘
    ૚ߏ੒ͷഎܠ
    

    View Slide

69. w جຊతʹ͸͜ͷ··ͰΑͦ͞͏
    w ७ਮͳσʔλͷ࿩୊͸ٕज़ͷਐาͰมΘΓʹ͍ͨ͘Ί
    w ͕ͩɺ΋ͬͱڧௐ͢΂͖ͩͬͨ͜ͱͳΒ͋Δ
    ૚ߏ੒Λม͑Δ༨஍͸͋Δ͔
    

    View Slide

70. w ෼ੳσʔλϕʔεʹ͸σʔλͷྲྀΕ͕͋Δ
    w 0-51σʔλϕʔεʹ͸͜Μͳʹ͸͖ͬΓͨ͠ྲྀΕ͸ͳ͍
    w ෼ੳσʔλετϦʔϜʹ͸ग़ޱ͕͋Δ
    w ͭ·Γ׆༻ઌ͕͋Δ
    w ׆༻͕σʔλసૹͷ৔߹͸BDUJWBUJPOɺSFWFSTF&5-ͳͲͱݺ͹ΕΔ
    w ͢΂ͯͷσʔλॲཧ͸BDUJWBUJPOͷͨΊʹ͋Δ
    w ͳͥͳΒՁ஋ΛੜΉͷ͸BDUJWBUJPO͔ͩΒ
    w ෼ੳγεςϜશମΛޙΖ͔Β࡞Δ΂͖
    w ׆༻ࢪࡦˠBDUJWBUJPOˠʢσʔλϚʔτʣˠιʔεσʔλ
    ΑΓڧௐ͢΂͖ͩͬͨ͜ͱ
    

    View Slide

71. ·ͱΊ
    

    View Slide

72. w 42-͸·ͩ·ͩਐԽ͓ͯ͠Γɺਰୀͷؾ഑΋ͳ͘ɺద༻ྖҬ͸޿
    ͕͓ͬͯΓɺॏཁ౓͸ߴ·ΔҰํͰ͋Δ
    w σʔλ͸42-ʹΑͬͯಁաతʹΞΫηεͰ͖Δ৔ॴʹूΊΔ΂͖
    Ͱ͋Δ
    w ෼ࢄ%#͔Ͳ͏͔͸Θ͔Βͳ͍͕ɺத৺ʹίΞͱͳΔ෼ੳ%#Λஔ
    ͘͜ͱ͸ࠓޙ΋มΘΒͳ͍
    w Ͳͷσʔλϕʔε͔ΑΓ΋ɺ෼ੳγεςϜશମΛͲͷΑ͏ʹߏ੒
    ͢Δ͔͕ࠓޙ͸໰୊ʹͳΓͦ͏
    w ෼ੳγεςϜ͸ޙΖʢ׆༻ࢪࡦʣ͔Β࡞Δ΂͖
    ·ͱΊ
    

    View Slide

73. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠
    

    View Slide