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

Slide 1

Slide 1 text

ࣄۀ੒௕ΛBoostͤ͞Δ  σʔλج൫ 2018-12-15  Developers Boost ʙU30ΤϯδχΞͷొཽ໳ʙ  presented by @yuzutas0   https://www.pexels.com/photo/ﬂight-sky-earth-space-2166/

Slide 2

Slide 2 text

ຊ೔ͷࢿྉ͸WEBʹެ։͠·͢  #devsumi #devboost  ࡱӨɾه࿥ͷඞཁ͸͋Γ·ͤΜ  ͭ͘Ζ͍Ͱௌ͍͍͚ͯͨͩΕ͹ͱࢥ͍·͢

Slide 3

Slide 3 text

εϥΠυ 100+ / 20min   ϒʔετ͔͚ͯ࿩͠·͢ʂ

Slide 4

Slide 4 text

ɹSho Yokoyamaɹ@yuzutas0 ɹɹ     ϦΫϧʔτςΫϊϩδʔζ   ITΤϯδχΞϦϯάຊ෦ ϓϩμΫτΤϯδχΞϦϯά෦ ϕϯνϟʔΩϟϐλϧ͔Β౤ࢿΛड͚︎︎ͯͷىۀɾձࣾܦӦɺ   ϦΫϧʔτάϧʔϓձࣾ︎͓͚Δෳ਺︎৽نࣄۀ︎্ཱͪ͛Λܦ︎ͯݱ৬ɻ ओ︎ʹٸ੒௕ϓϩμΫτΛର৅︎ʹɺγεςϜΞʔΩςΫνϟ︎࠶ߏங΍  ΤϯδχΞνʔϜͷ︎্ཱͪ͛ɾཱ︎௚͠ʹ︎ैࣄɻ ࠷ۙ︎͸ʮݱ৔︎Ͱ࢖ΘΕΔσʔλج൫ʯΛ࣠ʹ︎ɺ  ૊৫શମ︎ʹ͓͚Δσʔλ׆༻Λਪਐ͠︎͍ͯ·͢ɻ

Slide 5

Slide 5 text

ຊ೔ͷ಺༰ͱॏෳ͢Δͱ͜Ζ͕ଟʑ͋Γ·͢ ɹաڈͷʮσʔλج൫ʯࢿྉ http://www.atmarkit.co.jp/ait/articles/1804/23/news011.html https://speakerdeck.com/yuzutas0

Slide 6

Slide 6 text

l z ฏۉ೥ऩͷߴ͍৬छ͸……  ʮData Warehouse ArchitectʯͰ  15ສ4800υϧʢ1702ສ8000ԁʣ ITۀքͰฏۉ೥ऩͷߴ͍৬छ͸ιϑτ΢ΣΞΤϯδχΞ ϦϯάϚωʔδϟɺσʔλ΢ΣΞϋ΢εΞʔΩςΫτɺ ιϑτ΢ΣΞ։ൃϚωʔδϟͳͲɻถGlassdoor  https://www.publickey1.jp/blog/18/itglassdoor.html ɹσʔλج൫ਓࡐ΁ͷ஫໨ʢधཁʣ

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

ϓϩμΫτ։ൃ ʹ͓͚Δ  ʮ࢖ΘΕΔσʔλج൫ʯ ͷ ߏஙࣄྫ ͷ঺հ ɹຊ೔ͷΰʔϧ

Slide 9

Slide 9 text

σʔλج൫ͷߏங΍ӡ༻Λ  ୲౰͢ΔςοΫϦʔυ  ։ൃݱ৔ʹσʔλจԽΛਁಁ͍ͤͨ͞  ιϑτ΢ΣΞΤϯδχΞ ɹ૝ఆ͢Δର৅

Slide 10

Slide 10 text

ɹɹɹ ɹج൫γεςϜʹดͨ͡࿩ ɹɹɹ "ɹج൫Λ௨ͯ͠จԽΛม͑Δ࿩ ɹΤϯδχΞϦϯάͷձͰ͕͢

Slide 11

Slide 11 text

l z   ιϑτ΢ΣΞ։ൃ্ͷ໰୊ͷଟ͘͸ɺ  ٕज़తͱ͍͏ΑΓࣾձֶతͳ΋ͷͰ͋Δ   τϜɾσϚϧίɺςΟϞγʔɾϨελʔʰϐʔϓϧ΢ΣΞʱ  https://shop.nikkeibp.co.jp/front/commodity/0000/P85240/ ɹσʔλΛѻ͏ͱ͖ͷน

Slide 12

Slide 12 text

l z ΤϯδχΞϦϯάͰॏཁͳͷ͸  ʮͲ͏ͨ͠Βޮ཰Α͘ෆ࣮֬ੑΛݮΒ͍͚ͯ͠Δͷ͔ʯ  ͱ͍͏ߟ͑ํͳͷͰ͢   ޿໦ େ஍ʰΤϯδχΞϦϯά૊৫࿦΁ͷট଴ʱ  https://gihyo.jp/book/2018/978-4-7741-9605-3 ɹจԽΛΤϯδχΞϦϯά͢Δ

Slide 13

Slide 13 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 14

Slide 14 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 15

Slide 15 text

ࠗ׆ɾ࿀׆ ɹϓϩμΫτ

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

※ถࠃͰ͸݁ࠗͨ͠Χοϓϧͷ1/3͕ΦϯϥΠϯͰͷग़ձ͍ ɹσʔςΟϯάࢢ৔ͷ֦େ

Slide 19

Slide 19 text

ɹࣄۀ੒௕ → εςʔΫϗϧμʔͷଟ༷Խ σβΠϯ ηΩϡϦςΟ ๏຿ Πϯϑϥ SRE ΞϓϦج൫ ू٬ ΧελϚʔ  αϙʔτ σʔλ  αΠΤϯε ػցֶश  ΤϯδχΞ ։ൃӡ༻  νʔϜA ։ൃӡ༻  νʔϜB ։ൃӡ༻  νʔϜC PO PO PO σΟϨΫγϣϯ ޿ใ

Slide 20

Slide 20 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 21

Slide 21 text

ɹσʔλج൫ = ֤෦ॺʹσʔλΛఏڙ σʔλج൫

Slide 22

Slide 22 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

Ϗδωεࢦඪʢച্΍Daily Active UserʣͷਪҠ    ຖேͷSlack௨஌ɹɹɹɹSpreadsheetɹɹɹɹμογϡϘʔυ ɹɹɹKPIϞχλϦϯά 1

Slide 25

Slide 25 text

ओཁಋઢʢձһొ࿥͔Β੒ࠗୀձ·Ͱʣʹ͓͚Δར༻ɾ཭୤ ߦಈϑΝϯωϧɹɹɹɹɹɹδϟʔχʔϚοϓ ɹɹɹϢʔβʔߦಈͷՄࢹԽ 2

Slide 26

Slide 26 text

ɹɹABςετ݁Ռɹɹɹɹ৽ػೳͷར༻౓߹͍ ɹɹɹࢪࡦͷޮՌݟཱͯɾܭଌ 3

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

ա৒ΞΫηεͳͲͷҟৗύλʔϯΛಛఆ ɹɹɹ໎࿭ߦҝͷࣗಈݕ஌ 5

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

෼ੳ݁ՌΛϝσΟΞʹ৘ใఏڙ͢Δ͜ͱͰࢢ৔׆ੑԽʹߩݙ ɹɹɹχϡʔεϨλʔ 8 IUUQXXXSFDSVJUNQDPKQOFXTSFMFBTF@IUNM

Slide 32

Slide 32 text

σόΠεγΣΞ΍Ϋϥογϡ཰ɺϨεϙϯελΠϜ ɹɹɹγεςϜϞχλϦϯά 9 IUUQZV[VUBTIBUFOBCMPHDPNFOUSZ

Slide 33

Slide 33 text

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

Slide 34

Slide 34 text

εΫϥϜνʔϜͷϕϩγςΟ ΍ νέοτফԽͷϝτϦΫε ɹɹɹνʔϜͷΩϟύγςΟ 11

Slide 35

Slide 35 text

͋ΒΏΔ෼໺ɾࢪࡦͰσʔλʹ΋ͱ͍ͮͨ  ҙࢥܾఆʢBIʣ΍ࣗಈ൑ఆʢMLʣ͕ॏཁʹ ɹϢʔεέʔε͸ଟذʹ౉Δ

Slide 36

Slide 36 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 37

Slide 37 text

ɹͳͥج൫͕ඞཁʹͳ͔ͬͨ σʔλج൫

Slide 38

Slide 38 text

DBͷσʔλΛ࢖͍͍ͨͷͰ  ೔࣍ͰS3ʹCSVΛग़ྗ͍ͯͩ͘͠͞  ɹ࠷ॳ͸খ͞ͳσʔλૄ௨ґཔ ෦ॺA

Slide 39

Slide 39 text

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

Slide 40

Slide 40 text

ͬͪ͜Ͱαʔόͱૄ௨πʔϧΛ༻ҙ͠·͢  ϨϏϡʔˍຊ൪؀ڥʹஔ͍ͯ΋Β͑·͔͢ ɹରԠʹֻ͕͔࣌ؒΔͱ…… ੜσʔλΛ౉ͯ͠΋Β͑Ε͹  ͬͪ͜Ͱ࢖͑ΔΑ͏ʹՃ޻͢ΔͷͰ ෦ॺE

Slide 41

Slide 41 text

ɹ֤෦ॺ͝ͱʹσʔλૄ௨ɾՃ޻ ෦ॺA  நग़σʔλ ෦ॺB  நग़σʔλ ෦ॺA  Ճ޻ϩδοΫ ෦ॺB  Ճ޻ϩδοΫ

Slide 42

Slide 42 text

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

Slide 43

Slide 43 text

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

Slide 44

Slide 44 text

ʢҰ͕࣌ສࣄ͜ͷௐࢠͳͷͰʣ   ͋ΔνʔϜ͸ࣗ෼ͨͪͷࢪࡦͰKPI͕େ෯ʹ্͕ͬͨͱओுͯ͠΋ ผͷνʔϜ͔Β͸Կͷࢀߟʹ΋ͳΒͳ͍਺ࣈʹݟ͑Δ Ͳͷσʔλ͕ਖ਼͍͠ͷ͔୭΋෼͔Βͳ͍ͨΊ ԣஅͰͷҙࢥܾఆ΍ௐ੔͕ࠔ೉ʹͳΔ ɹσʔλͷ৴པੑ

Slide 45

Slide 45 text

  http://jp.techcrunch.com/2017/06/25/20170623ﬁve-building-blocks-of-a-data-driven-culture/ ɹମ੍֦େ → σʔλج൫ͷඞཁੑ ࣄ࣮ͷ୯Ұ৘ใݯΛ͍࣋ͬͯΔ৔߹ʹ͸ɺΞφϦετ΍  ଞͷҙࢥܾఆऀͱ͍ͬͨΤϯυϢʔβʔͨͪʹɺ༏ΕͨՁ஋Λ  ఏڙ͢Δ͜ͱ͕Ͱ͖Δɻ൴Β͸૊৫಺ͰσʔλΛ୳͕࣌ؒ͢  গͳͯ͘ࡁΉΑ͏ʹͳΓɺσʔλͷར༻ʹΑΓଟ͘ͷ࣌ؒΛ  ׂ͘͜ͱ͕Ͱ͖ΔΑ͏ʹͳΔ͔Βͩɻ

Slide 46

Slide 46 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 47

Slide 47 text

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

Slide 48

Slide 48 text

1. ModelͱViewΛ෼͚Δ΂͠  2. ͳΔ΂͘ϥΫͯ͠࡞Δ΂͠ ɹઃܭϙϦγʔ

Slide 49

Slide 49 text

ɹModelͱViewΛ෼͚Δ΂͠ ɹɹɹɹɹɹɹɹɹɹɹɹɹDWH ੹຿ʹԠͨ͡γεςϜͷ෼཭ɾ݁߹  Model (஝ੵ/Ճ޻) ͱView (ࢀর)

Slide 50

Slide 50 text

ɹ஫ҙɿ෦ॺ͝ͱʹ࠷దͳView͸ҟͳΔ Excel ؾܰʹ਺ࣈΛม͑ͯ  γϛϡϨʔγϣϯ Ϗδωε෦໳ Tableau ߴՁ֨ɾߴػೳ  ෼ੳཁٻʹରԠ Re:dash SQL͕ॻ͚Δͻͱ  ͓खܰར༻ σΟϨΫλʔ Jupyter  GitͰίʔυ؅ཧ  ϓϩάϥϜͷԸܙ ΤϯδχΞ ෼ੳ෦໳

Slide 51

Slide 51 text

ɹͳΔ΂͘ϥΫͯ͠࡞Δ΂͠ σʔλૢ࡞ͳΒPython ΤίγεςϜʹ৐Δ σʔλอଘͳΒBigQuery  GoogleʹཔΔ ΞϓϦ૚ Πϯϑϥ

Slide 52

Slide 52 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 53

Slide 53 text

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

Slide 54

Slide 54 text

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

Slide 55

Slide 55 text

ɹσʔλऩू ݸਓ৘ใ  ϚεΫࡁΈView Recruit Ads Console Recruit Crash  Report όον ετϦʔϛϯά WebAPI εΫϨΠϐϯά requests + beautiful soup

Slide 56

Slide 56 text

Python (requests + beautiful soup) on Jupiter ʹΑΔ  WebAPIίʔϧɾը໘εΫϨΠϐϯά ɹখ͘͞ࢼ͠ͳ͕ΒγεςϜΛҭͯΔ ·ͣ͸ϩʔΧϧ؀ڥͰࡁ·ͤΔ ܁Γฦ͠࢖͏ͳΒεΫϦϓτԽ IUUQTXXXTIBSFJDPOOFUEPDVNFOUpMFQZ

Slide 57

Slide 57 text

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

Slide 58

Slide 58 text

3૚ߏ଄  ࢀߟʰ10೥ઓ͑Δσʔλ෼ੳೖ໳ - SQLΛ෢ثʹσʔλ׆༻࣌୅Λੜ͖ൈ͘ʱ ɹσʔλ஝ੵ ɹɹɹɹɹɹBigQuery - Google Cloud Platform Source  ݩσʔλͷίϐʔ Warehouse  ओཁࢦඪɾසग़σʔλ  தؒςʔϒϧ App  ֤πʔϧ͔Β௚઀ࢀর  ඇٕज़ऀ޲͚IF ஝ੵ

Slide 59

Slide 59 text

ྫɿ enmusubi__source__db ΞϯμʔείΞ2ͭͰཁૉΛ۠੾Δ  BEMʢCSSͷઃܭख๏ʣϥΠΫͳنଇ ɹσʔληοτͷ໋໊نଇ ϓϩμΫτ໊ source warehouse app ϝΠϯDB αʔόϩά ΞΫηεղੳπʔϧ

Slide 60

Slide 60 text

૚ߏ଄ʹ͓͚ΔͭͷྲྀΕ "QQ ར༻ऀ޲͚*' 㲈σʔλϚʔτ 8BSFIPVTF υϝΠϯ஌ࣝΛද͢σʔλ 㲈σʔλ΢ΣΞϋ΢ε 4PVSDF ݩσʔλͷίϐʔ 㲈σʔλϨΠΫ σʔλύΠϓϥΠϯʹ͓͍ͯػց͕ॲཧ͢ΔྲྀΕ ࣄۀ΍γεςϜͷ  શσʔλΛίϐʔ͢Δ μογϡϘʔυ΍  ϨϙʔτͱରʹͳΔ ։ൃϓϩηεʹ͓͍ͯਓ͕ؒઃܭ͢ΔྲྀΕ ूܭɾ෼ੳύλʔϯΛ੔ཧ  㲈8*5)۟ͷසग़σʔλ ᶃ ᶄ ᶅ ᶃ ᶃ ᶄ

Slide 61

Slide 61 text

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

Slide 62

Slide 62 text

3૚ߏ଄  ࢀߟʰ10೥ઓ͑Δσʔλ෼ੳೖ໳ - SQLΛ෢ثʹσʔλ׆༻࣌୅Λੜ͖ൈ͘ʱ ɹσʔλՃ޻ ɹɹɹɹɹɹBigQuery - Google Cloud Platform Source  ݩσʔλͷίϐʔ Warehouse  ओཁࢦඪɾසग़σʔλ  தؒςʔϒϧ App  ֤πʔϧ͔Β௚઀ࢀর  ඇٕज़ऀ޲͚IF Ճ޻ Ճ޻

Slide 63

Slide 63 text

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

Slide 64

Slide 64 text

8*5)۟ͷͭͭΛΦϒδΣΫτͷΑ͏ʹѻ͏  ωετͤͣ͞ʹ8*5)͚۟ͩͰෳࡶͳूܭϩδοΫΛ૊Έཱ͍ͯͯ͘ 42-πϦʔʹΑΔूܭϩδοΫ JOTQJSFECZlσʔλϒϨϯσΟϯάˍ༧ଌ෼ੳπʔϧzʰ"MUFSZYʱ

Slide 65

Slide 65 text

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

Slide 66

Slide 66 text

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

Slide 67

Slide 67 text

ΞυϗοΫ ࣗಈԽ ɹσʔλ׆༻ - Pullܕ

Slide 68

Slide 68 text

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

Slide 69

Slide 69 text

؅ཧπʔϧʹظ଴͢Δཁ݅ʢཧ૝ʣ     ɹσʔλύΠϓϥΠϯͷ؅ཧ 1. ίʔυͰόʔδϣϯ؅ཧ  2. εέδϡʔϧࣗಈىಈ  3. ηοτΞοϓ΍ϝϯςφϯεͷָ͞(DB಺แͳͲ)  4. GUI/CUI྆ํͰϩάɾύϑΥʔϚϯεͷ؅ཧ  5. GUI/CUI྆ํͰม਺ࢦఆͷ࠶࣮ߦ 6. ࣗಈϦτϥΠॲཧɾεΩοϓػೳ  7. εΫϦϓτͷฒྻ࣮ߦ  8. αʔόͷΦʔτεέʔϧ  9. ༗޲ඇ८ճάϥϑͷࣗಈ࡞੒  10. Python3.6~ରԠʢςΩετॲཧ͕֨ஈʹָʣ

Slide 70

Slide 70 text

࠷ॳ͸Jenkinsͷ͓खܰߏங͔Β͸͡Ίͨ   ɹɹɹɹɹɹ● 2ܥ + BlueOcean + Pipeline of jenkinsﬁles  ɹɹɹɹɹɹ● ϦτϥΠػߏɾॲཧ࠷దԽ͸ଞʹྼΔ  ɹɹɹɹɹɹ● jenkinsδϣϒ͔ΒγΣϧܦ༝Ͱ֤छॲཧΛίʔϧ ɹখ࢝͘͞ΊΔ ※ݱࡏ͸Cloud ComposerʹҠ؅ࡁΈ

Slide 71

Slide 71 text

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

Slide 72

Slide 72 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 73

Slide 73 text

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

Slide 74

Slide 74 text

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

Slide 75

Slide 75 text

μογϡϘʔυΛ  ෦԰ͷϞχλʔʹө͢ ɹ࠷ॳͷҰา

Slide 76

Slide 76 text

1. ຖ೔ͷKPIΛ͢Β͢Βݴ͑ΔΑ͏ʹͳΔ͔΋    ɹ2. ҟৗ஋ʹؾ͍ͮͯਝ଎ʹಈ͚ΔΑ͏ʹͳΔ͔΋ ɹߴ·Δظ଴

Slide 77

Slide 77 text

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

Slide 78

Slide 78 text

Slide 79

Slide 79 text

ɹɹɹ׬ᘳͳاըॻʁ ɹɹɹѹ౗తͳ༧ࢉʁ ɹɹɹ1೥ؒͷ։ൃϓϩδΣΫτʁ ɹʮ࠷ڧͷσʔλج൫ʯΛࢧ͑Δϓϩηεʁ

Slide 80

Slide 80 text

ɹɹɹ׬ᘳͳاըॻʁ ɹɹɹѹ౗తͳ༧ࢉʁ ɹɹɹ1೥ؒͷ։ൃϓϩδΣΫτʁ ɹʮ࠷ڧͷσʔλج൫ʯΛࢧ͑Δϓϩηεʁ ❌

Slide 81

Slide 81 text

ɹɹ● ࢥ͍ͬͯͨͷͱҧͬͨ ɹɹ● ྑͦ͞͏͚ͩͲ݁ہ࢖Θͳ͔ͬͨ ɹ1೥ޙʹ଴ͭ΋ͷ

Slide 82

Slide 82 text

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

Slide 83

Slide 83 text

→ ͜ΕͳΒ࣮֬ʹ࢖ͬͯ΋Β͑Δ ɹগͣͭ͠γεςϜΛஔ͖׵͑ͨ   ࣮͸͏ͪͷ෦ॺͰຖேSlackʹάϥϑΛ  खಈͰྲྀ͍ͯ͠ΔΜ͚ͩͲʂ   ͜ͷػʹࣗಈԽ͠·͔͢ʂ

Slide 84

Slide 84 text

ɹɹɹQ.ɹ࠷ॳʹཁ݅Λશ෦ચ͍ग़ͤ͹OKʁ    ɹɹɹA.ɹNGʂʮ΍Γ͍ͨ͜ͱʯ͸มΘΔʂ  ɹɹɹɹɹɹɹ ● ଞࣾϒϩάΛݟͯʮ͏ͪ΋΍Γ͍ͨʂʯ  ɹɹɹɹɹɹɹ ● ৽͍͠BIπʔϧͷఏҊʹʮ͜Ε͍͍ʂʯ  ɹɹɹɹɹɹɹ ● ࣮ࡍʹը໘Λ࡞ͬͨΒʮͳΜ͔ҧ͏ʂʯ   ɹɹ ɹɹ → มԽʹॊೈʹରԠ͢Δʂ ɹΠςϨʔγϣϯΛճ͢͜ͱ͕େࣄ

Slide 85

Slide 85 text

TodoΛνέοτ؅ཧ → ॊೈʹ༏ઌॱҐΛೖΕସ͑Δ ɹνέοτۦಈ։ൃ

Slide 86

Slide 86 text

ɹλεΫͷ༏ઌॱҐ 1 σʔλ͕·͕͍ͪͬͯΔ  ٙ࿭ͷௐࠪ ɹ1ͭؒҧ͍ͬͯΔͱશ෦৴༻Ͱ͖ͳ͘ͳΔͷͰ࠷༏ઌରԠɻ  ɹ͙͢ௐࠪ͢Ε͹ؔ܎ऀͷ৴༻࢒ߴΛ૿΍ͤΔɻ 2 Modelվम ɹσʔλ߲໨௥ՃͳͲɻ  ɹଟগݟʹͯ͘͘΋࢖͑Δঢ়ଶʹ͢Δ͜ͱ͕༏ઌɻ  ɹ࠷ѱͷ৔߹Ͱ΋Ͳ͏ʹ͔࢖͏ଆͰ޻෉Ͱ͖ΔͷͰɻ 3 Viewվम ɹάϥϑͷݟӫ͑ͳͲɻ  ɹҰ൪ʮมԽ͍ͯ͠ΔʯΠϯύΫτ → ؔ܎ߏஙʹ͸د༩ɻ  ɹ࢖͍खʹͱͬͯ͸ॏཁͳͷͰՄೳͳൣғͰαϙʔτɻ 4 γεςϜͷอकੑͱ  ύϑΥʔϚϯε ɹϘτϧωοΫʹͳͬͨΒରॲ͢Δɻ  ɹ࠷ॳ͔ΒڽΔͱʮૣ͗͢Δ࠷దԽʯʹؕΓ͕ͪɻ  ɹ࡞ۀνέοτʹ͢Δ·Ͱ΋ͳ͍ͭ͘Ͱʹ௚͢श׳Λ͚ͭΔɻ

Slide 87

Slide 87 text

ɹࣗಈςετʹΑΔI/Oͷ୲อ ● Excel಺༰Λظ଴஋ʹ൓ө → GreenʹͳΕ͹࠶ݱ׬ྃ - ·͞ʹ “TDD”  ● SQLνϡʔχϯά΍ϦϑΝΫλ࣌ʹσάϨΛଈ࣌ݕ஌Ͱ͖ΔͷͰ૬ੑྑ͍

Slide 88

Slide 88 text

ɹॏް௕େͳExcelΛ࠶ݱ͢Δˠ·ͣղಡ ϚΠϯυϚοϓʹΑΔ੔ཧ  εϥΠυʹೖΔΑ͏ʹʢೖΓ͖ͬͯͳ͍͚ͲʣॖΊͨΒը૾͕௵Εͯ͠΋͏ͨ……

Slide 89

Slide 89 text

ɹɹ1. Jupyter Notebook Ͱௐࠪ಺༰ͱ  ɹɹɹσʔλΛ࠶ݱՄೳͳܗͰอଘ͢Δ     ɹɹ2. Github Preview Λͦͷ··  ɹɹɹઆ໌ࢿྉͱͯ͠ར༻͢Δ ɹطଘͷܭࢉϛε΍σʔλෆ੔߹Λൃݟ

Slide 90

Slide 90 text

ɹχʔζ։୓ͷ޷॥؀ ֤෦ॺͷϢʔεέʔεΛ  ώΞϦϯά͠΍͘͢ͳΔ ʮσʔλͷ͜ͱ͸͍ͭ͜ʹฉ͚ʯ  ʹ ࣭໰΍૬ஊ͕དྷΔΑ͏ʹͳΔ طଘσʔλͷϛε΍໰୊ɺ  ͞ΒͳΔհࡏ༨஍ʹؾ෇͚Δ খ͞ͳ࣮੷  طଘσʔλͷܭࢉϛε΍ෆ੔߹Λൃݟ  → ใࠂͯ͠௚͢

Slide 91

Slide 91 text

ͱʹ͔͘਺ࣈ͕߹Θͳ͍ ɹ޷॥؀Λࢧ͑Δ೜଱ γεςϜ࿈ܞͷ్தͰ࢛ࣺޒೖ͕ੵΈॏͳΔ Excel͕طʹ 4 x 1990 = 7959 ͱͳ͍ͬͯΔ ࣮ߦλΠϛϯάͰूܭ݁Ռ͕มΘΔ  → طଘͷ਺஋͸୭΋࠶ݱͰ͖ͳ͍

Slide 92

Slide 92 text

࣮ࡍʹඅ΍ͨ࣌ؒ͠ͷ80% ʹ ͻͨ͢Β஍ಓͳ࡞ۀ   ·͊ɺେมͰͨ͠ɻ ɹ׼ͱྦͷτϥϒϧγϡʔςΟϯά

Slide 93

Slide 93 text

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

Slide 94

Slide 94 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 95

Slide 95 text

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

Slide 96

Slide 96 text

ɹɹͲΜͳϢʔβʔ͕৽ػೳΛ࢖ͬͨͷ͔  ɹɹϓϩμΫτʹͲΜͳظ଴Λ΋͍ͬͯΔͷ͔ ɹɹϏδωεKPI͸Ͳͷఔ౓޲্ͨ͠ͷ͔  ɹɹ෭࡞༻͸͔͋ͬͨʢ͋ΔػೳΛԡ͠ग़͢ → ผͷػೳ͕࢖ΘΕͳ͘ͳΔՄೳੑʣ ɹ࣮ࢪͨ͠ࢪࡦͷ݁ՌΛ෼ੳ IUUQHBUBHOFUGSFFJMMVTUSBJUJPO

Slide 97

Slide 97 text

ɹ͜Μͳײ͡Ͱ΍Γ·ͨ͠ 1. ϗϫΠτϘʔυʹ෼ੳཁ݅  ɹɹΧελϚʔߦಈભҠΛϕʔεͱͨ͠ࢦඪπϦʔ  ɹɹϩάΠϯ཰͕޲্ → ΞΫγϣϯ͕… → ച্׵ࢉ   ɹɹɹɹ2. JupyterͰ෼ੳ  ɹɹɹɹɹίʔυ͸શͯίϛοτཤྺͰ؅ཧ    ɹɹɹɹɹɹɹɹ3. ෼ੳ݁ՌΛؔ܎ऀʹڞ༗  ɹɹɹɹɹɹɹɹɹGithubͷϓϨϏϡʔը໘Λ׆༻

Slide 98

Slide 98 text

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

Slide 99

Slide 99 text

͋ͷख͜ͷखͰʮσʔλ෼ੳ΍Ζ͏ʯͷۭؾΛৢ੒ ɹ ● σʔλ෼ੳϋοΧιϯͷ։࠵ ɹ ● ே׆ x ࣗ༝ݚڀʢϏοτίΠϯͷ஋্͕ΓཁҼΛ౷ܭղੳ͢Δۚͷ๢ऀ͕େྔൃੜʣ ɹ ● JupyterHubΛ֦ுͨ͠PythonֶशαΠτ΍  ɹɹ֎ʹஔ͚ͳ͍σʔλ޲͚ͷnbviewerΛࣾ಺ఏڙ ɹϝοηʔδϯά

Slide 100

Slide 100 text

1ͭͷϞχλʔΛғΜͰશһͰ࡞ۀ͢Δ ɹɹ ● पғ͕ௐ΂ͨΓΞυόΠε͠ͳ͕ΒਐΊΔ  ɹɹɹ → ϋϚΒͳ͍ / ࠳ંΛ๷͙ɺTips΍ίπΛڞ༗͋͠͏  ɹɹ ● օ͕΍ΔͳΒࣗ෼΋΍Δ͔ʂͷޙԡ͠  ɹɹɹ → ʮ΍ͬͯΈͨΒࢥͬͨҎ্ʹྑ͔ͬͨʯͷମݧ ɹମݧɿϞϒ ϓϩάϥϛϯά σʔλ෼ੳ

Slide 101

Slide 101 text

  σʔλ࢓༷ʹৄ͍͠ʢগͳ͘ͱ΋ௐࠪ͢ΔεΩϧ͸΋͍ͬͯΔʣΤϯδχΞ͕  ୲౰ྖҬΛ޿͛Δ͜ͱͰલޙ޻ఔͷϦʔυλΠϜΛ୹ॖ  ɹϓϩηε૷ணɿ։ൃ޻ఔʹ૊ΈࠐΉ ੡଄ ઃܭ ࢼݧ ϦϦʔε ޮՌ  ଌఆ ཁ݅  ఆٛ ཁٻ  ੔ཧ ੡଄ ઃܭ ࢼݧ ϦϦʔε ޮՌ  ଌఆ ཁ݅  ఆٛ ཁٻ  ੔ཧ طʹ΍͍ͬͯΔ ෼ੳཁٻ ϩάཁ݅ ܭଌ ΞΠσΞ

Slide 102

Slide 102 text

ΤϯδχΞ ʹ ͦͷ৔Ͱσʔλ࢓༷Λௐ΂Δ͜ͱ͕Ͱ͖Δ   σʔλαΠΤϯε෦໳͕࢓༷ώΞϦϯάΛॏͶͯ  1ि͔͚͍ؒͯͨ෼ੳ͕1࣌ؒͰ׬ྃʢϑϩʔޮ཰Խʣ ɹ੒ޭମݧɿΞδϦςΟͷ޲্ ϝΠϯϞχλʔ͸  Jupyter Notebook αΠυϞχλʔ͸  ϓϩμΫτͷιʔείʔυ ʴ

Slide 103

Slide 103 text

νʔϜ͝ͱͷຽओԽঢ়گ ֤νʔϜ͕σʔλ׆༻Ͱ͖͍ͯΔ͔ϞχλϦϯάˠϒϩοΧʔͷݕ஌ɾ෼ੳˠվળΞΫγϣϯ νʔϜ" νʔϜ# νʔϜ$ νʔϜ% νʔϜ& νʔϜ' νʔϜ( νʔϜ) νʔϜ* νʔϜ+ νʔϜ, ੜϩά  ಠࣗར༻ σʔλ5ࢧԉ  ۀ຿ґཔ σʔλ5ࢧԉ  σʔλग़ྗ ࣗओత  σʔλग़ྗ ୲౰ऀґଘ ୲౰ऀґଘ ୲౰ऀґଘ ࣗओత  σʔλੜ੒ ଞνʔϜґཔ ج൫ߩݙʂ ୲౰ऀґଘ ୲౰ऀґଘ ہॴԽͷน ࣗ૸ͷน վળͷน

Slide 104

Slide 104 text

1. ϓϩμΫτ / νʔϜ   2. σʔλج൫ͷߏங ɹɹϢʔεέʔεɹߏஙͷഎܠɹઃܭϙϦγʔɹσʔλϑϩʔɹ։ൃϓϩηε   3. σʔλจԽΛ૊৫ʹ૷ண͢Δ ɹΞδΣϯμ

Slide 105

Slide 105 text

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

Slide 106

Slide 106 text

গ͠Ͱ΋ଟ͘ͷ ։ൃݱ৔ ͕  ੈͷதʹ ྑ͍ϓϩμΫτ Λఏڙ͢Δ  ώϯτ ʹͳΕͨΒͱࢥ͍ͬͯ·͢ ɹ఻͍͑ͨ͜ͱ

Slide 107

Slide 107 text

“σʔλج൫” ʹڵຯͷ͋Δ U30ͳιϑτ΢ΣΞΤϯδχΞͷօ༷ ͥͻҰॹʹಇ͖·ͤΜ͔ʂʁ ɹʲએ఻ʳJoin Us !!!

Slide 108

Slide 108 text

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ presented by @yuzutas0  https://www.pexels.com/photo/ﬂight-sky-earth-space-2166/