Upgrade to Pro — share decks privately, control downloads, hide ads and more …

事業成長をBoostさせるデータ基盤 #devsumi #devboost / 20181215

yuzutas0
December 15, 2018

事業成長をBoostさせるデータ基盤 #devsumi #devboost / 20181215

Developers Boost(デブスト)【B-4】の発表資料です。
https://event.shoeisha.jp/devboost/20181215/session/1896/

ブログに補足を掲載しました。
https://yuzutas0.hatenablog.com/entry/2018/12/16/230000

yuzutas0

December 15, 2018
Tweet

More Decks by yuzutas0

Other Decks in Technology

Transcript

  1. ࣄۀ੒௕ΛBoostͤ͞Δ

    σʔλج൫
    2018-12-15

    Developers Boost ʙU30ΤϯδχΞͷొཽ໳ʙ

    presented by @yuzutas0

    https://www.pexels.com/photo/flight-sky-earth-space-2166/


    View full-size slide

  2. ຊ೔ͷࢿྉ͸WEBʹެ։͠·͢

    #devsumi #devboost



    ࡱӨɾه࿥ͷඞཁ͸͋Γ·ͤΜ

    ͭ͘Ζ͍Ͱௌ͍͍͚ͯͨͩΕ͹ͱࢥ͍·͢

    View full-size slide

  3. εϥΠυ 100+ / 20min

    ϒʔετ͔͚ͯ࿩͠·͢ʂ


    View full-size slide

  4. ɹSho Yokoyamaɹ@yuzutas0
    ɹɹ




    ϦΫϧʔτςΫϊϩδʔζ 

    ITΤϯδχΞϦϯάຊ෦ ϓϩμΫτΤϯδχΞϦϯά෦
    ϕϯνϟʔΩϟϐλϧ͔Β౤ࢿΛड͚︎︎ͯͷىۀɾձࣾܦӦɺ 

    ϦΫϧʔτάϧʔϓձࣾ︎͓͚Δෳ਺︎৽نࣄۀ︎্ཱͪ͛Λܦ︎ͯݱ৬ɻ
    ओ︎ʹٸ੒௕ϓϩμΫτΛର৅︎ʹɺγεςϜΞʔΩςΫνϟ︎࠶ߏங΍

    ΤϯδχΞνʔϜͷ︎্ཱͪ͛ɾཱ︎௚͠ʹ︎ैࣄɻ
    ࠷ۙ︎͸ʮݱ৔︎Ͱ࢖ΘΕΔσʔλج൫ʯΛ࣠ʹ︎ɺ

    ૊৫શମ︎ʹ͓͚Δσʔλ׆༻Λਪਐ͠︎͍ͯ·͢ɻ

    View full-size slide

  5. ຊ೔ͷ಺༰ͱॏෳ͢Δͱ͜Ζ͕ଟʑ͋Γ·͢
    ɹաڈͷʮσʔλج൫ʯࢿྉ


    http://www.atmarkit.co.jp/ait/articles/1804/23/news011.html
    https://speakerdeck.com/yuzutas0

    View full-size slide

  6. l
    z
    ฏۉ೥ऩͷߴ͍৬छ͸……

    ʮData Warehouse ArchitectʯͰ

    15ສ4800υϧʢ1702ສ8000ԁʣ
    ITۀքͰฏۉ೥ऩͷߴ͍৬छ͸ιϑτ΢ΣΞΤϯδχΞ
    ϦϯάϚωʔδϟɺσʔλ΢ΣΞϋ΢εΞʔΩςΫτɺ
    ιϑτ΢ΣΞ։ൃϚωʔδϟͳͲɻถGlassdoor

    https://www.publickey1.jp/blog/18/itglassdoor.html


    ɹσʔλج൫ਓࡐ΁ͷ஫໨ʢधཁʣ

    View full-size slide



  7. ɹσʔλج൫ਓࡐ΁ͷ஫໨ʢڙڅʣ
    IUUQCIBUFOBOFKQFOUSZZV[VUBTIBUFOBCMPHDPNFOUSZ

    View full-size slide

  8. ϓϩμΫτ։ൃ ʹ͓͚Δ

    ʮ࢖ΘΕΔσʔλج൫ʯ ͷ ߏஙࣄྫ ͷ঺հ


    ɹຊ೔ͷΰʔϧ

    View full-size slide

  9. σʔλج൫ͷߏங΍ӡ༻Λ

    ୲౰͢ΔςοΫϦʔυ

    ։ൃݱ৔ʹσʔλจԽΛਁಁ͍ͤͨ͞

    ιϑτ΢ΣΞΤϯδχΞ


    ɹ૝ఆ͢Δର৅

    View full-size slide

  10. ɹɹɹ
    ɹج൫γεςϜʹดͨ͡࿩
    ɹɹɹ
    "ɹج൫Λ௨ͯ͠จԽΛม͑Δ࿩


    ɹΤϯδχΞϦϯάͷձͰ͕͢

    View full-size slide

  11. l
    z

    ιϑτ΢ΣΞ։ൃ্ͷ໰୊ͷଟ͘͸ɺ

    ٕज़తͱ͍͏ΑΓࣾձֶతͳ΋ͷͰ͋Δ

    τϜɾσϚϧίɺςΟϞγʔɾϨελʔʰϐʔϓϧ΢ΣΞʱ

    https://shop.nikkeibp.co.jp/front/commodity/0000/P85240/


    ɹσʔλΛѻ͏ͱ͖ͷน

    View full-size slide

  12. l
    z
    ΤϯδχΞϦϯάͰॏཁͳͷ͸

    ʮͲ͏ͨ͠Βޮ཰Α͘ෆ࣮֬ੑΛݮΒ͍͚ͯ͠Δͷ͔ʯ

    ͱ͍͏ߟ͑ํͳͷͰ͢

    ޿໦ େ஍ʰΤϯδχΞϦϯά૊৫࿦΁ͷট଴ʱ

    https://gihyo.jp/book/2018/978-4-7741-9605-3


    ɹจԽΛΤϯδχΞϦϯά͢Δ

    View full-size slide

  13. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide

  14. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide

  15. ࠗ׆ɾ࿀׆
    ɹϓϩμΫτ

    View full-size slide

  16. ֹ݄՝ۚϞσϧɹ˞࿀݁ͼঁੑϢʔβʔ͸ຊਓ֬ೝྉͷΈ
    ɹར༻ͷྲྀΕ
    45&1 45&1 45&1
    ؾʹͳͬͨΒʮ͍͍Ͷʂʯ ૬ޓ͍͍ͶʂͰϚονϯά ϝοηʔδͰ΍ΓͱΓ։࢝

    View full-size slide

  17. ΄͔:ελοϑ༻︎ۀ຿؅ཧπʔϧ︎︎︎αϒγεςϜ
    ɹɹɹɹɹɹɹɹɹɹɹɹΦϯϓϨ


    ɹγεςϜུ֓

    View full-size slide

  18. ※ถࠃͰ͸݁ࠗͨ͠Χοϓϧͷ1/3͕ΦϯϥΠϯͰͷग़ձ͍


    ɹσʔςΟϯάࢢ৔ͷ֦େ

    View full-size slide



  19. ɹࣄۀ੒௕ → εςʔΫϗϧμʔͷଟ༷Խ
    σβΠϯ
    ηΩϡϦςΟ
    ๏຿
    Πϯϑϥ
    SRE
    ΞϓϦج൫
    ू٬
    ΧελϚʔ

    αϙʔτ
    σʔλ

    αΠΤϯε
    ػցֶश

    ΤϯδχΞ
    ։ൃӡ༻

    νʔϜA
    ։ൃӡ༻

    νʔϜB
    ։ൃӡ༻

    νʔϜC
    PO PO PO
    σΟϨΫγϣϯ
    ޿ใ

    View full-size slide

  20. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide



  21. ɹσʔλج൫ = ֤෦ॺʹσʔλΛఏڙ
    σʔλج൫

    View full-size slide

  22. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide



  23. ɹͲͷΑ͏ʹ׆༻͍ͯ͠Δ͔
    σʔλج൫

    View full-size slide

  24. Ϗδωεࢦඪʢച্΍Daily Active UserʣͷਪҠ


    ຖேͷSlack௨஌ɹɹɹɹSpreadsheetɹɹɹɹμογϡϘʔυ


    ɹɹɹKPIϞχλϦϯά
    1

    View full-size slide

  25. ओཁಋઢʢձһొ࿥͔Β੒ࠗୀձ·Ͱʣʹ͓͚Δར༻ɾ཭୤
    ߦಈϑΝϯωϧɹɹɹɹɹɹδϟʔχʔϚοϓ


    ɹɹɹϢʔβʔߦಈͷՄࢹԽ
    2

    View full-size slide

  26. ɹɹABςετ݁Ռɹɹɹɹ৽ػೳͷར༻౓߹͍


    ɹɹɹࢪࡦͷޮՌݟཱͯɾܭଌ
    3

    View full-size slide



  27. ɹɹɹػցֶशʹΑΔϨίϝϯυ
    4
    http://image.itmedia.co.jp/l/im/ait/articles/1804/23/l_news011_04.jpg

    View full-size slide

  28. ա৒ΞΫηεͳͲͷҟৗύλʔϯΛಛఆ


    ɹɹɹ໎࿭ߦҝͷࣗಈݕ஌
    5

    View full-size slide



  29. ɹɹɹ໰͍߹Θͤͷ܏޲෼ੳ
    6

    View full-size slide



  30. ɹɹɹ޿ࠂ഑৴ͷ࠷దԽ
    7

    View full-size slide

  31. ෼ੳ݁ՌΛϝσΟΞʹ৘ใఏڙ͢Δ͜ͱͰࢢ৔׆ੑԽʹߩݙ


    ɹɹɹχϡʔεϨλʔ
    8
    IUUQXXXSFDSVJUNQDPKQOFXTSFMFBTF@IUNM

    View full-size slide

  32. σόΠεγΣΞ΍Ϋϥογϡ཰ɺϨεϙϯελΠϜ


    ɹɹɹγεςϜϞχλϦϯά
    9
    IUUQZV[VUBTIBUFOBCMPHDPNFOUSZ

    View full-size slide



  33. ɹɹɹো֐ൃੜ࣌ͷӨڹௐࠪ
    10

    View full-size slide

  34. εΫϥϜνʔϜͷϕϩγςΟ ΍ νέοτফԽͷϝτϦΫε


    ɹɹɹνʔϜͷΩϟύγςΟ
    11

    View full-size slide

  35. ͋ΒΏΔ෼໺ɾࢪࡦͰσʔλʹ΋ͱ͍ͮͨ

    ҙࢥܾఆʢBIʣ΍ࣗಈ൑ఆʢMLʣ͕ॏཁʹ


    ɹϢʔεέʔε͸ଟذʹ౉Δ

    View full-size slide

  36. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide



  37. ɹͳͥج൫͕ඞཁʹͳ͔ͬͨ
    σʔλج൫

    View full-size slide

  38. DBͷσʔλΛ࢖͍͍ͨͷͰ

    ೔࣍ͰS3ʹCSVΛग़ྗ͍ͯͩ͘͠͞



    ɹ࠷ॳ͸খ͞ͳσʔλૄ௨ґཔ
    ෦ॺA

    View full-size slide



  39. ɹ૊৫͕εέʔϧ → ֤෦ॺ͔Βґཔ
    ෦ॺB
    ෦ॺC
    ෦ॺD

    View full-size slide

  40. ͬͪ͜Ͱαʔόͱૄ௨πʔϧΛ༻ҙ͠·͢

    ϨϏϡʔˍຊ൪؀ڥʹஔ͍ͯ΋Β͑·͔͢


    ɹରԠʹֻ͕͔࣌ؒΔͱ……
    ੜσʔλΛ౉ͯ͠΋Β͑Ε͹

    ͬͪ͜Ͱ࢖͑ΔΑ͏ʹՃ޻͢ΔͷͰ
    ෦ॺE

    View full-size slide



  41. ɹ֤෦ॺ͝ͱʹσʔλૄ௨ɾՃ޻
    ෦ॺA

    நग़σʔλ
    ෦ॺB

    நग़σʔλ
    ෦ॺA

    Ճ޻ϩδοΫ
    ෦ॺB

    Ճ޻ϩδοΫ

    View full-size slide



  42. ɹମ੍ͷ··ʹγεςϜෳࡶԽ - ίϯ΢ΣΠͷ๏ଇ
    ݩσʔλ
    ֤෦ॺ޲͚ʹσʔλࢀরγεςϜΛܧ͗଍͠

    View full-size slide

  43. ɾফඅ੫ΛؚΉͷ͔
    ɾׂҾ෼͸Ͳ͜Ͱࠩ͠Ҿ͘ͷ͔
    ɾ೥ؒܖ໿ϓϥϯ͸݄࣍Ͱ҈෼͢Δͷ͔
    ɾ҈෼͢Δ৔߹͸్தղ໿ΛͲ͜ʹܭ্͢Δͷ͔
    ɾฦۚ͸ޙͰҰׅͰࠩ͠Ҿ͘ͷ͔ɺߪೖ࣌ʹ͔͞ͷ΅ͬͯࠩ͠Ҿ͘ͷ͔
    ɾϞόΠϧΞϓϦͷ՝ۚ͸Apple΍Google΁ͷܾࡁख਺ྉΛؚΉͷ͔
    ɾ༻్͸ࡒ຿ձܭ͔؅ཧձܭ͔


    ɹ෦ॺ͝ͱʹʮച্ʯ͕ζϨΔ໰୊

    View full-size slide

  44. ʢҰ͕࣌ສࣄ͜ͷௐࢠͳͷͰʣ

    ͋ΔνʔϜ͸ࣗ෼ͨͪͷࢪࡦͰKPI͕େ෯ʹ্͕ͬͨͱओுͯ͠΋
    ผͷνʔϜ͔Β͸Կͷࢀߟʹ΋ͳΒͳ͍਺ࣈʹݟ͑Δ
    Ͳͷσʔλ͕ਖ਼͍͠ͷ͔୭΋෼͔Βͳ͍ͨΊ
    ԣஅͰͷҙࢥܾఆ΍ௐ੔͕ࠔ೉ʹͳΔ


    ɹσʔλͷ৴པੑ

    View full-size slide


  45. http://jp.techcrunch.com/2017/06/25/20170623five-building-blocks-of-a-data-driven-culture/


    ɹମ੍֦େ → σʔλج൫ͷඞཁੑ
    ࣄ࣮ͷ୯Ұ৘ใݯΛ͍࣋ͬͯΔ৔߹ʹ͸ɺΞφϦετ΍

    ଞͷҙࢥܾఆऀͱ͍ͬͨΤϯυϢʔβʔͨͪʹɺ༏ΕͨՁ஋Λ

    ఏڙ͢Δ͜ͱ͕Ͱ͖Δɻ൴Β͸૊৫಺ͰσʔλΛ୳͕࣌ؒ͢

    গͳͯ͘ࡁΉΑ͏ʹͳΓɺσʔλͷར༻ʹΑΓଟ͘ͷ࣌ؒΛ

    ׂ͘͜ͱ͕Ͱ͖ΔΑ͏ʹͳΔ͔Βͩɻ

    View full-size slide

  46. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide



  47. ɹͲͷΑ͏ͳγεςϜΛߏங͔ͨ͠
    σʔλج൫

    View full-size slide

  48. 1. ModelͱViewΛ෼͚Δ΂͠

    2. ͳΔ΂͘ϥΫͯ͠࡞Δ΂͠


    ɹઃܭϙϦγʔ

    View full-size slide



  49. ɹModelͱViewΛ෼͚Δ΂͠
    ɹɹɹɹɹɹɹɹɹɹɹɹɹDWH
    ੹຿ʹԠͨ͡γεςϜͷ෼཭ɾ݁߹

    Model (஝ੵ/Ճ޻) ͱView (ࢀর)

    View full-size slide



  50. ɹ஫ҙɿ෦ॺ͝ͱʹ࠷దͳView͸ҟͳΔ
    Excel
    ؾܰʹ਺ࣈΛม͑ͯ

    γϛϡϨʔγϣϯ
    Ϗδωε෦໳
    Tableau
    ߴՁ֨ɾߴػೳ

    ෼ੳཁٻʹରԠ
    Re:dash
    SQL͕ॻ͚Δͻͱ

    ͓खܰར༻
    σΟϨΫλʔ
    Jupyter

    GitͰίʔυ؅ཧ

    ϓϩάϥϜͷԸܙ
    ΤϯδχΞ
    ෼ੳ෦໳

    View full-size slide



  51. ɹͳΔ΂͘ϥΫͯ͠࡞Δ΂͠
    σʔλૢ࡞ͳΒPython
    ΤίγεςϜʹ৐Δ
    σʔλอଘͳΒBigQuery

    GoogleʹཔΔ
    ΞϓϦ૚ Πϯϑϥ

    View full-size slide

  52. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide



  53. ɹσʔλϑϩʔͷߏங
    ऩू Ճ޻ ׆༻
    ஝ੵ
    ύΠϓϥΠϯ؅ཧ
    Model View

    View full-size slide



  54. ɹσʔλϑϩʔͷߏங
    ऩू Ճ޻ ׆༻
    ஝ੵ
    Model View
    ऩू
    ύΠϓϥΠϯ؅ཧ

    View full-size slide



  55. ɹσʔλऩू
    ݸਓ৘ใ

    ϚεΫࡁΈView
    Recruit Ads
    Console
    Recruit Crash

    Report
    όον
    ετϦʔϛϯά
    WebAPI
    εΫϨΠϐϯά
    requests +
    beautiful soup

    View full-size slide

  56. Python (requests + beautiful soup) on Jupiter ʹΑΔ

    WebAPIίʔϧɾը໘εΫϨΠϐϯά


    ɹখ͘͞ࢼ͠ͳ͕ΒγεςϜΛҭͯΔ
    ·ͣ͸ϩʔΧϧ؀ڥͰࡁ·ͤΔ ܁Γฦ͠࢖͏ͳΒεΫϦϓτԽ
    IUUQTXXXTIBSFJDPOOFUEPDVNFOUpMFQZ

    View full-size slide



  57. ɹσʔλϑϩʔͷߏங
    ऩू Ճ޻ ׆༻
    ஝ੵ
    Model View
    ஝ੵ
    ύΠϓϥΠϯ؅ཧ

    View full-size slide

  58. 3૚ߏ଄

    ࢀߟʰ10೥ઓ͑Δσʔλ෼ੳೖ໳ - SQLΛ෢ثʹσʔλ׆༻࣌୅Λੜ͖ൈ͘ʱ


    ɹσʔλ஝ੵ
    ɹɹɹɹɹɹBigQuery - Google Cloud Platform
    Source

    ݩσʔλͷίϐʔ
    Warehouse

    ओཁࢦඪɾසग़σʔλ

    தؒςʔϒϧ
    App

    ֤πʔϧ͔Β௚઀ࢀর

    ඇٕज़ऀ޲͚IF
    ஝ੵ

    View full-size slide

  59. ྫɿ enmusubi__source__db
    ΞϯμʔείΞ2ͭͰཁૉΛ۠੾Δ

    BEMʢCSSͷઃܭख๏ʣϥΠΫͳنଇ


    ɹσʔληοτͷ໋໊نଇ
    ϓϩμΫτ໊ source
    warehouse
    app
    ϝΠϯDB
    αʔόϩά
    ΞΫηεղੳπʔϧ

    View full-size slide

  60. ૚ߏ଄ʹ͓͚ΔͭͷྲྀΕ


    "QQ
    ར༻ऀ޲͚*'
    㲈σʔλϚʔτ
    8BSFIPVTF
    υϝΠϯ஌ࣝΛද͢σʔλ
    㲈σʔλ΢ΣΞϋ΢ε
    4PVSDF
    ݩσʔλͷίϐʔ
    㲈σʔλϨΠΫ
    σʔλύΠϓϥΠϯʹ͓͍ͯػց͕ॲཧ͢ΔྲྀΕ
    ࣄۀ΍γεςϜͷ

    શσʔλΛίϐʔ͢Δ
    μογϡϘʔυ΍

    ϨϙʔτͱରʹͳΔ
    ։ൃϓϩηεʹ͓͍ͯਓ͕ؒઃܭ͢ΔྲྀΕ
    ूܭɾ෼ੳύλʔϯΛ੔ཧ

    㲈8*5)۟ͷසग़σʔλ
    ᶃ ᶄ ᶅ
    ᶃ ᶃ

    View full-size slide



  61. ɹσʔλϑϩʔͷߏங
    ऩू Ճ޻ ׆༻
    ஝ੵ
    Model View
    Ճ޻
    ύΠϓϥΠϯ؅ཧ

    View full-size slide

  62. 3૚ߏ଄

    ࢀߟʰ10೥ઓ͑Δσʔλ෼ੳೖ໳ - SQLΛ෢ثʹσʔλ׆༻࣌୅Λੜ͖ൈ͘ʱ


    ɹσʔλՃ޻
    ɹɹɹɹɹɹBigQuery - Google Cloud Platform
    Source

    ݩσʔλͷίϐʔ
    Warehouse

    ओཁࢦඪɾසग़σʔλ

    தؒςʔϒϧ
    App

    ֤πʔϧ͔Β௚઀ࢀর

    ඇٕज़ऀ޲͚IF
    Ճ޻ Ճ޻

    View full-size slide



  63. IUUQTHSPXUIIBDLKPVSOBMDPNLQJUSFFGPSBQQ
    ɹओཁࢦඪΛதؒςʔϒϧͰ؅ཧ

    View full-size slide

  64. 8*5)۟ͷͭͭΛΦϒδΣΫτͷΑ͏ʹѻ͏

    ωετͤͣ͞ʹ8*5)͚۟ͩͰෳࡶͳूܭϩδοΫΛ૊Έཱ͍ͯͯ͘
    42-πϦʔʹΑΔूܭϩδοΫ


    JOTQJSFECZlσʔλϒϨϯσΟϯάˍ༧ଌ෼ੳπʔϧzʰ"MUFSZYʱ

    View full-size slide



  65. ɹσʔλϑϩʔͷߏங
    ऩू Ճ޻ ׆༻
    ஝ੵ
    Model View
    ׆༻
    ύΠϓϥΠϯ؅ཧ

    View full-size slide



  66. ɹσʔλ׆༻ - Pushܕ
    IUUQGSFFJMMVTUSBUJPOTHBUBHOFUIUNM
    ػցֶशࢪࡦ

    View full-size slide

  67. ΞυϗοΫ
    ࣗಈԽ


    ɹσʔλ׆༻ - Pullܕ

    View full-size slide



  68. ɹσʔλϑϩʔͷߏங
    ऩू Ճ޻ ׆༻
    ஝ੵ
    Model View
    ύΠϓϥΠϯ؅ཧ

    View full-size slide

  69. ؅ཧπʔϧʹظ଴͢Δཁ݅ʢཧ૝ʣ




    ɹσʔλύΠϓϥΠϯͷ؅ཧ
    1. ίʔυͰόʔδϣϯ؅ཧ

    2. εέδϡʔϧࣗಈىಈ

    3. ηοτΞοϓ΍ϝϯςφϯεͷָ͞(DB಺แͳͲ)

    4. GUI/CUI྆ํͰϩάɾύϑΥʔϚϯεͷ؅ཧ

    5. GUI/CUI྆ํͰม਺ࢦఆͷ࠶࣮ߦ
    6. ࣗಈϦτϥΠॲཧɾεΩοϓػೳ

    7. εΫϦϓτͷฒྻ࣮ߦ

    8. αʔόͷΦʔτεέʔϧ

    9. ༗޲ඇ८ճάϥϑͷࣗಈ࡞੒

    10. Python3.6~ରԠʢςΩετॲཧ͕֨ஈʹָʣ

    View full-size slide

  70. ࠷ॳ͸Jenkinsͷ͓खܰߏங͔Β͸͡Ίͨ

    ɹɹɹɹɹɹ● 2ܥ + BlueOcean + Pipeline of jenkinsfiles

    ɹɹɹɹɹɹ● ϦτϥΠػߏɾॲཧ࠷దԽ͸ଞʹྼΔ

    ɹɹɹɹɹɹ● jenkinsδϣϒ͔ΒγΣϧܦ༝Ͱ֤छॲཧΛίʔϧ


    ɹখ࢝͘͞ΊΔ ※ݱࡏ͸Cloud ComposerʹҠ؅ࡁΈ

    View full-size slide



  71. ɹσʔλϑϩʔͷߏஙʢ׬ʣ
    ऩू Ճ޻ ׆༻
    ஝ੵ
    Model View
    ύΠϓϥΠϯ؅ཧ

    View full-size slide

  72. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide



  73. ɹͲͷΑ͏ͳϓϩηεΛ࠾༻͔ͨ͠
    σʔλج൫

    View full-size slide

  74. ʮσʔλ׆༻ͷج൫ʯܭը͸
    ࣦഊ͔Β࢝·ͬͨ


    View full-size slide



  75. μογϡϘʔυΛ

    ෦԰ͷϞχλʔʹө͢
    ɹ࠷ॳͷҰา

    View full-size slide



  76. 1. ຖ೔ͷKPIΛ͢Β͢Βݴ͑ΔΑ͏ʹͳΔ͔΋


    ɹ2. ҟৗ஋ʹؾ͍ͮͯਝ଎ʹಈ͚ΔΑ͏ʹͳΔ͔΋
    ɹߴ·Δظ଴

    View full-size slide



  77. 1िؒͰ୭΋ݟͳ͘ͳͬͨ
    ɹݱ࣮͸ඇ৘Ͱ͋Δ

    View full-size slide

  78. ɹɹɹ׬ᘳͳاըॻʁ
    ɹɹɹѹ౗తͳ༧ࢉʁ
    ɹɹɹ1೥ؒͷ։ൃϓϩδΣΫτʁ


    ɹʮ࠷ڧͷσʔλج൫ʯΛࢧ͑Δϓϩηεʁ

    View full-size slide

  79. ɹɹɹ׬ᘳͳاըॻʁ
    ɹɹɹѹ౗తͳ༧ࢉʁ
    ɹɹɹ1೥ؒͷ։ൃϓϩδΣΫτʁ


    ɹʮ࠷ڧͷσʔλج൫ʯΛࢧ͑Δϓϩηεʁ

    View full-size slide

  80. ɹɹ● ࢥ͍ͬͯͨͷͱҧͬͨ
    ɹɹ● ྑͦ͞͏͚ͩͲ݁ہ࢖Θͳ͔ͬͨ


    ɹ1೥ޙʹ଴ͭ΋ͷ

    View full-size slide



  81. ɹʮԶͷߟ͑ͨ࠷ڧͷσʔλج൫ʯ͸࢖ΘΕͳ͍
    IUUQXXXQSPKFDUDBSUPPODPN

    View full-size slide

  82. → ͜ΕͳΒ࣮֬ʹ࢖ͬͯ΋Β͑Δ


    ɹগͣͭ͠γεςϜΛஔ͖׵͑ͨ

    ࣮͸͏ͪͷ෦ॺͰຖேSlackʹάϥϑΛ

    खಈͰྲྀ͍ͯ͠ΔΜ͚ͩͲʂ

    ͜ͷػʹࣗಈԽ͠·͔͢ʂ

    View full-size slide

  83. ɹɹɹQ.ɹ࠷ॳʹཁ݅Λશ෦ચ͍ग़ͤ͹OKʁ


    ɹɹɹA.ɹNGʂʮ΍Γ͍ͨ͜ͱʯ͸มΘΔʂ

    ɹɹɹɹɹɹɹ ● ଞࣾϒϩάΛݟͯʮ͏ͪ΋΍Γ͍ͨʂʯ

    ɹɹɹɹɹɹɹ ● ৽͍͠BIπʔϧͷఏҊʹʮ͜Ε͍͍ʂʯ

    ɹɹɹɹɹɹɹ ● ࣮ࡍʹը໘Λ࡞ͬͨΒʮͳΜ͔ҧ͏ʂʯ

    ɹɹ ɹɹ → มԽʹॊೈʹରԠ͢Δʂ


    ɹΠςϨʔγϣϯΛճ͢͜ͱ͕େࣄ

    View full-size slide

  84. TodoΛνέοτ؅ཧ → ॊೈʹ༏ઌॱҐΛೖΕସ͑Δ


    ɹνέοτۦಈ։ൃ

    View full-size slide



  85. ɹλεΫͷ༏ઌॱҐ
    1 σʔλ͕·͕͍ͪͬͯΔ

    ٙ࿭ͷௐࠪ
    ɹ1ͭؒҧ͍ͬͯΔͱશ෦৴༻Ͱ͖ͳ͘ͳΔͷͰ࠷༏ઌରԠɻ

    ɹ͙͢ௐࠪ͢Ε͹ؔ܎ऀͷ৴༻࢒ߴΛ૿΍ͤΔɻ
    2 Modelվम
    ɹσʔλ߲໨௥ՃͳͲɻ

    ɹଟগݟʹͯ͘͘΋࢖͑Δঢ়ଶʹ͢Δ͜ͱ͕༏ઌɻ

    ɹ࠷ѱͷ৔߹Ͱ΋Ͳ͏ʹ͔࢖͏ଆͰ޻෉Ͱ͖ΔͷͰɻ
    3 Viewվम
    ɹάϥϑͷݟӫ͑ͳͲɻ

    ɹҰ൪ʮมԽ͍ͯ͠ΔʯΠϯύΫτ → ؔ܎ߏஙʹ͸د༩ɻ

    ɹ࢖͍खʹͱͬͯ͸ॏཁͳͷͰՄೳͳൣғͰαϙʔτɻ
    4 γεςϜͷอकੑͱ

    ύϑΥʔϚϯε
    ɹϘτϧωοΫʹͳͬͨΒରॲ͢Δɻ

    ɹ࠷ॳ͔ΒڽΔͱʮૣ͗͢Δ࠷దԽʯʹؕΓ͕ͪɻ

    ɹ࡞ۀνέοτʹ͢Δ·Ͱ΋ͳ͍ͭ͘Ͱʹ௚͢श׳Λ͚ͭΔɻ

    View full-size slide



  86. ɹࣗಈςετʹΑΔI/Oͷ୲อ
    ● Excel಺༰Λظ଴஋ʹ൓ө → GreenʹͳΕ͹࠶ݱ׬ྃ - ·͞ʹ “TDD”

    ● SQLνϡʔχϯά΍ϦϑΝΫλ࣌ʹσάϨΛଈ࣌ݕ஌Ͱ͖ΔͷͰ૬ੑྑ͍

    View full-size slide

  87. ɹॏް௕େͳExcelΛ࠶ݱ͢Δˠ·ͣղಡ
    ϚΠϯυϚοϓʹΑΔ੔ཧ

    εϥΠυʹೖΔΑ͏ʹʢೖΓ͖ͬͯͳ͍͚ͲʣॖΊͨΒը૾͕௵Εͯ͠΋͏ͨ……


    View full-size slide

  88. ɹɹ1. Jupyter Notebook Ͱௐࠪ಺༰ͱ

    ɹɹɹσʔλΛ࠶ݱՄೳͳܗͰอଘ͢Δ


    ɹɹ2. Github Preview Λͦͷ··

    ɹɹɹઆ໌ࢿྉͱͯ͠ར༻͢Δ


    ɹطଘͷܭࢉϛε΍σʔλෆ੔߹Λൃݟ

    View full-size slide



  89. ɹχʔζ։୓ͷ޷॥؀
    ֤෦ॺͷϢʔεέʔεΛ

    ώΞϦϯά͠΍͘͢ͳΔ
    ʮσʔλͷ͜ͱ͸͍ͭ͜ʹฉ͚ʯ

    ʹ ࣭໰΍૬ஊ͕དྷΔΑ͏ʹͳΔ
    طଘσʔλͷϛε΍໰୊ɺ

    ͞ΒͳΔհࡏ༨஍ʹؾ෇͚Δ
    খ͞ͳ࣮੷

    طଘσʔλͷܭࢉϛε΍ෆ੔߹Λൃݟ

    → ใࠂͯ͠௚͢

    View full-size slide

  90. ͱʹ͔͘਺ࣈ͕߹Θͳ͍


    ɹ޷॥؀Λࢧ͑Δ೜଱
    γεςϜ࿈ܞͷ్தͰ࢛ࣺޒೖ͕ੵΈॏͳΔ
    Excel͕طʹ 4 x 1990 = 7959 ͱͳ͍ͬͯΔ
    ࣮ߦλΠϛϯάͰूܭ݁Ռ͕มΘΔ

    → طଘͷ਺஋͸୭΋࠶ݱͰ͖ͳ͍

    View full-size slide

  91. ࣮ࡍʹඅ΍ͨ࣌ؒ͠ͷ80% ʹ ͻͨ͢Β஍ಓͳ࡞ۀ

    ·͊ɺେมͰͨ͠ɻ


    ɹ׼ͱྦͷτϥϒϧγϡʔςΟϯά

    View full-size slide



  92. ɹ֤෦ॺ΁ͷσʔλఏڙΛ࣮ݱ
    σʔλج൫

    View full-size slide

  93. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide



  94. ɹΤϯδχΞ͸Measure͔Β࢝ΊͯΈΔ
    Build
    Measure
    Learn
    Ͱ͖͍ͯΔ
    ΍ͬͯΈΔ

    View full-size slide

  95. ɹɹͲΜͳϢʔβʔ͕৽ػೳΛ࢖ͬͨͷ͔

    ɹɹϓϩμΫτʹͲΜͳظ଴Λ΋͍ͬͯΔͷ͔
    ɹɹϏδωεKPI͸Ͳͷఔ౓޲্ͨ͠ͷ͔

    ɹɹ෭࡞༻͸͔͋ͬͨʢ͋ΔػೳΛԡ͠ग़͢ → ผͷػೳ͕࢖ΘΕͳ͘ͳΔՄೳੑʣ


    ɹ࣮ࢪͨ͠ࢪࡦͷ݁ՌΛ෼ੳ
    IUUQHBUBHOFUGSFFJMMVTUSBJUJPO

    View full-size slide



  96. ɹ͜Μͳײ͡Ͱ΍Γ·ͨ͠
    1. ϗϫΠτϘʔυʹ෼ੳཁ݅

    ɹɹΧελϚʔߦಈભҠΛϕʔεͱͨ͠ࢦඪπϦʔ

    ɹɹϩάΠϯ཰͕޲্ → ΞΫγϣϯ͕… → ച্׵ࢉ

    ɹɹɹɹ2. JupyterͰ෼ੳ

    ɹɹɹɹɹίʔυ͸શͯίϛοτཤྺͰ؅ཧ


    ɹɹɹɹɹɹɹɹ3. ෼ੳ݁ՌΛؔ܎ऀʹڞ༗

    ɹɹɹɹɹɹɹɹɹGithubͷϓϨϏϡʔը໘Λ׆༻

    View full-size slide

  97. 1. ํ޲ੑΛҙࣝ͢Δʢϝοηʔδϯάʣ
    2. ମݧͯ͠ΈΔʢτϥΠΞϧʣ
    3. ࢓૊ΈԽ͢Δʢϓϩηε૷ணʣ
    4. ੒ޭܦݧΛڞ༗͢Δ


    ɹจԽΛਁಁͤ͞ΔྲྀΕ

    View full-size slide

  98. ͋ͷख͜ͷखͰʮσʔλ෼ੳ΍Ζ͏ʯͷۭؾΛৢ੒
    ɹ ● σʔλ෼ੳϋοΧιϯͷ։࠵
    ɹ ● ே׆ x ࣗ༝ݚڀʢϏοτίΠϯͷ஋্͕ΓཁҼΛ౷ܭղੳ͢Δۚͷ๢ऀ͕େྔൃੜʣ
    ɹ ● JupyterHubΛ֦ுͨ͠PythonֶशαΠτ΍

    ɹɹ֎ʹஔ͚ͳ͍σʔλ޲͚ͷnbviewerΛࣾ಺ఏڙ


    ɹϝοηʔδϯά

    View full-size slide

  99. 1ͭͷϞχλʔΛғΜͰશһͰ࡞ۀ͢Δ
    ɹɹ ● पғ͕ௐ΂ͨΓΞυόΠε͠ͳ͕ΒਐΊΔ

    ɹɹɹ → ϋϚΒͳ͍ / ࠳ંΛ๷͙ɺTips΍ίπΛڞ༗͋͠͏

    ɹɹ ● օ͕΍ΔͳΒࣗ෼΋΍Δ͔ʂͷޙԡ͠

    ɹɹɹ → ʮ΍ͬͯΈͨΒࢥͬͨҎ্ʹྑ͔ͬͨʯͷମݧ


    ɹମݧɿϞϒ ϓϩάϥϛϯά σʔλ෼ੳ

    View full-size slide


  100. σʔλ࢓༷ʹৄ͍͠ʢগͳ͘ͱ΋ௐࠪ͢ΔεΩϧ͸΋͍ͬͯΔʣΤϯδχΞ͕

    ୲౰ྖҬΛ޿͛Δ͜ͱͰલޙ޻ఔͷϦʔυλΠϜΛ୹ॖ



    ɹϓϩηε૷ணɿ։ൃ޻ఔʹ૊ΈࠐΉ
    ੡଄
    ઃܭ ࢼݧ ϦϦʔε
    ޮՌ

    ଌఆ
    ཁ݅

    ఆٛ
    ཁٻ

    ੔ཧ
    ੡଄
    ઃܭ ࢼݧ ϦϦʔε
    ޮՌ

    ଌఆ
    ཁ݅

    ఆٛ
    ཁٻ

    ੔ཧ
    طʹ΍͍ͬͯΔ
    ෼ੳཁٻ ϩάཁ݅ ܭଌ
    ΞΠσΞ

    View full-size slide

  101. ΤϯδχΞ ʹ ͦͷ৔Ͱσʔλ࢓༷Λௐ΂Δ͜ͱ͕Ͱ͖Δ

    σʔλαΠΤϯε෦໳͕࢓༷ώΞϦϯάΛॏͶͯ

    1ि͔͚͍ؒͯͨ෼ੳ͕1࣌ؒͰ׬ྃʢϑϩʔޮ཰Խʣ


    ɹ੒ޭମݧɿΞδϦςΟͷ޲্
    ϝΠϯϞχλʔ͸

    Jupyter Notebook
    αΠυϞχλʔ͸

    ϓϩμΫτͷιʔείʔυ
    ʴ

    View full-size slide

  102. νʔϜ͝ͱͷຽओԽঢ়گ
    ֤νʔϜ͕σʔλ׆༻Ͱ͖͍ͯΔ͔ϞχλϦϯάˠϒϩοΧʔͷݕ஌ɾ෼ੳˠվળΞΫγϣϯ


    νʔϜ" νʔϜ# νʔϜ$ νʔϜ% νʔϜ& νʔϜ' νʔϜ( νʔϜ) νʔϜ* νʔϜ+ νʔϜ,
    ੜϩά

    ಠࣗར༻
    σʔλ5ࢧԉ

    ۀ຿ґཔ
    σʔλ5ࢧԉ

    σʔλग़ྗ
    ࣗओత

    σʔλग़ྗ
    ୲౰ऀґଘ ୲౰ऀґଘ ୲౰ऀґଘ
    ࣗओత

    σʔλੜ੒
    ଞνʔϜґཔ
    ج൫ߩݙʂ ୲౰ऀґଘ ୲౰ऀґଘ
    ہॴԽͷน
    ࣗ૸ͷน
    վળͷน

    View full-size slide

  103. 1. ϓϩμΫτ / νʔϜ

    2. σʔλج൫ͷߏங
    ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε

    3. σʔλจԽΛ૊৫ʹ૷ண͢Δ


    ɹΞδΣϯμ

    View full-size slide

  104. ɾݱ৔ͷ1ਓ1ਓ͕ओ໾ͱͳΓɺσʔλΛ׆༻ ͯ͠ ϓϩμΫτ΍ۀ຿ Λຏ͖ࠐΉ
    ɾ͜ͷੵΈॏͶʹΑͬͯࣄۀ͕੒௕͠ɺސ٬ʹՁ஋Λಧ͚Δ͜ͱʹͳΔ
    ɹࣄۀͷ੒௕ʢBoostʣΛࢧ͑Δ
    4&$*Ϟσϧ
    ސ٬Ձ஋ উͪےɾUVP
    ΤϯδχΞ ू٬
    σβΠϯ ηΩϡϦςΟ
    ๏຿
    ΧελϚʔαϙʔτ ޿ใ
    ࢧԉऀɾ։୓ऀͱͯ͠ͷ

    σʔλαΠΤϯςΟετ
    σʔλ

    View full-size slide

  105. গ͠Ͱ΋ଟ͘ͷ ։ൃݱ৔ ͕

    ੈͷதʹ ྑ͍ϓϩμΫτ Λఏڙ͢Δ

    ώϯτ ʹͳΕͨΒͱࢥ͍ͬͯ·͢


    ɹ఻͍͑ͨ͜ͱ

    View full-size slide

  106. “σʔλج൫” ʹڵຯͷ͋Δ
    U30ͳιϑτ΢ΣΞΤϯδχΞͷօ༷
    ͥͻҰॹʹಇ͖·ͤΜ͔ʂʁ


    ɹʲએ఻ʳJoin Us !!!

    View full-size slide

  107. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠
    presented by @yuzutas0

    https://www.pexels.com/photo/flight-sky-earth-space-2166/


    View full-size slide