JOIN 2019 at San Francisco Highlight & Playback

Slide 1

Slide 1 text

σʔλΞφϦςΟΫεࣄۀຊ෦ɹΠϯςάϨʔγϣϯ෦ ͠Μ΍ !TIJOZBB +0*/BU4BO'SBODJTDP )JHIMJHIU1MBZCBDL JOIN 2019 at San Francisco Highlight & Playback JOIN 2019 at San Francisco Highlight & Playback 2019.12.10 (Tue) Looker Japan Year End Party @ Tokyo shinyaa31(Classmethod, Inc.) 2019.12.10 (Tue) Looker Japan Year End Party @ Tokyo shinyaa31(Classmethod, Inc.)

Slide 2

Slide 2 text

ࣗݾ঺հ ͠Μ΍ "84ίϯαϧςΟϯά෦ʹݱ"84ࣄۀຊ෦ͷલ਎ IUUQTEFWDMBTTNFUIPEKQBVUIPSTIJOZBB @shinyaa31 ೥݄ɿΫϥεϝιου+0*/    ೥݄ʙɿσʔλΠϯςάϨʔγϣϯ෦  ೥݄ʙɿσʔλΞφϦςΟΫεࣄۀຊ෦ ɾΫϥϝι೥໨  ɾ$4" ΧελϚʔετʔϦʔΞφϦςΟΫε Ϧʔμʔ  ɾ޷͖ͳ"84αʔϏεɿ"NB[PO3FETIJGU  ɾ޷͖ͳ-PPLFSͷ7J[ɿςΩετςʔϒϧ -FHBDZ

Slide 3

Slide 3 text

اۀ঺հ Ϋϥεϝιουגࣜձࣾ  $MBTTNFUIPE *OD   https://classmethod.jp/  ɾ೥݄೔ઃཱ  ɾ୅දऔక໾ɹԣా૱  ɾैۀһ਺ɹ໊ʙ  ɾΦϑΟε ࠃ಺   ɹळ༿ݪؠຊொࡳຈ্ӽ  ɹେࡕԬࢁ෱Ԭಹ೼  ɾΦϑΟε ւ֎   ɹϕϧϦϯ υΠπ   ɹόϯΫʔόʔ Χφμ   ɹάϧΨΦϯ Πϯυ   ɾΫϥ΢υ "84 ɺϞόΠϧΞϓϦɺ  ɹϏοάσʔλɺ"*ʹ͓͚Δاۀ޲͚  ɹٕज़ࢧԉΛల։  ɾzϒϩάͷձࣾz

Slide 4

Slide 4 text

ΧϑΣ΍ͬͯ·͢ %FWFMPQFST*0$"'&cΫϥεϝιουIUUQTDBGFDMBTTNFUIPEKQ  ϨδϨεɺ׬શΩϟογϡϨεళฮʮ%FWFMPQFST*0$"'&ʯٕज़঺հ:PV5VCFIUUQTXXXZPVUVCFDPNXBUDI W(3UN0CCPUT ϨδϨεɺ׬શΩϟογϡϨεళฮʮ%FWFMPQFST*0$"'&ʯ

Slide 5

Slide 5 text

#FTU-PPLFS"NCBTTBEPSɺ௖͖·ͨ͠ʂʂ

Slide 6

Slide 6 text

͜ͷϝϯόʔͰ-PPLFSͷϒϩάΛॻ͖·ͨ͠

Slide 7

Slide 7 text

ϒϩά঺հ ձࣾશମ ɾ೥݄։ઃ  ɾ݄ؒ17਺ɿສҎ্  ɾ݄ؒ66਺ɿສҎ্  ɾ૯͸ͯϒ਺ɿສҎ্ https://dev.classmethod.jp/

Slide 8

Slide 8 text

ϒϩά঺հ ձࣾશମ ɾ೥݄։ઃ  ɾ݄ؒ17਺ɿສҎ্  ɾ݄ؒ66਺ɿສҎ্  ɾ૯͸ͯϒ਺ɿສҎ্  ɾ૯هࣄ਺ɿ  ɹ ຊҎ্ https://dev.classmethod.jp/ ʲॕʳ%FWFMPQFST*0ͷϒϩάܝࡌهࣄ͕ສຊΛಥഁ͠·ͨ͠ʂʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQFUDEFWFMPQFSTJPCMPHQPTUTIBTSFBDIFE

Slide 9

Slide 9 text

ϒϩά঺հ ݸਓ ྦྷܭ ໿ ຊͷ͏ͪͷ໿ ຊΛࣥචˍ౤ߘ

Slide 10

Slide 10 text

-PPLFSͱΫϥεϝιου ɾ೥ॳ಄ɿฐࣾɺ-PPLFSʹڵຯΛ࣋ͭ  ɾ೥݄ɿ%FWFMPQFST*0Ͱ-PPLFSϒϩάΛॻ͖࢝ΊΔ ࣍ੈ୅ͷσʔλϓϥοτϑΥʔϜʮ-PPLFSʯػೳ֓ཁ·ͱΊMPPLFSʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSPWFSWJFX

Slide 11

Slide 11 text

-PPLFSͱΫϥεϝιου ɾ೥݄ɿ(PPHMFʹΑΔങऩͷ݅ͰΠϯλϏϡʔ࣮ࢪ ʰ(PPHMFʹΑΔങऩʱͰ͜Ε͔ΒͲ͏ͳΔʁ-PPLFSͷதͷਓୡʹ৭ʑ࿩Λฉ͍ͯΈͨMPPLFSʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTJOUFSWJFXXJUIMPPLFSKBQBO

Slide 12

Slide 12 text

-PPLFSͱΫϥεϝιου ࣍ੈ୅#*ϓϥοτϑΥʔϜΛఏڙ͢Δ-PPLFSࣾͱͷύʔτφʔܖ໿Λక݁ʙ  Ϋϥ΢υઓུ͓Αͼࢢ৔Ξϓϩʔνʹ͍ͭͯ-PPLFSࣾ΁ΠϯλϏϡʔ࣮ࢪʙʛϓϨεϦϦʔεʛΫϥεϝιου  IUUQTDMBTTNFUIPEKQOFXTMPPLFS ɾ೥݄ɿύʔτφʔܖ໿Λൃද 

Slide 13

Slide 13 text

-PPLFSͱΫϥεϝιου <Ϩϙʔτ>ୈੈ୅#*-PPLFSͷັྗͱ͸ -PPLFS࿇஑୓࠸ࢯ r%FWFMPQFST*0JO50,:0DNEFWJPʛ%FWFMPQFST*0  IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTDNEFWJPUPLZPSFQPSUMPPLFSSEHFOFSBUJPOEBUBQMBUGPSN ʰ-PPLFSΛ׆༻ͨ͠ՄࢹԽɾ෼ੳۀ຿ͷ࣮ફʱͱ͍͏λΠτϧͰ-PPLFSͷྑ͞ʹ͍ͭͯ࿩͠·ͨ͠r%FWFMPQFST*050,:0DNEFWJPMPPLFSʛ%FWFMPQFST*0  IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTEFWFMPQFSTJPUPLZPTFMGSFQPSUQSBDUJDFPGWJTVBMJ[BUJPOBOEBOBMZTJTXJUIMPPLFS ɾ೥݄ɿ%FWFMPQFST*050,:0։࠵ˍൃද

Slide 14

Slide 14 text

-PPLFSͱΫϥεϝιου -PPLFSɿ+0*/BU4BO'SBODJTDPʛγϦʔζʛ%FWFMPQFST*0  IUUQTEFWDMBTTNFUIPEKQTFSJFTMPPLFSKPJOBUTBOGSBODJTDP ɾ೥݄ɿ+0*/!αϯϑϥϯγείࢀՃ ໊

Slide 15

Slide 15 text

-PPLFSͱΫϥεϝιου ʰ(PPHMFʹΑΔങऩʱͰ͜Ε͔ΒͲ͏ͳΔʁ-PPLFSͷதͷਓୡʹ৭ʑ࿩Λฉ͍ͯΈͨMPPLFSʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTJOUFSWJFXXJUIMPPLFSKBQBO ɾ೥݄ɿ%FWFMPQFST*0ϒϩά  ɹɹɹɹɹɹɹɹ-PPLFSؔ࿈ΤϯτϦຊୡ੒  ɾ೥݄ɿࠓʹࢸΔ

Slide 16

Slide 16 text

+0*/ʹݱ஍ࢀઓ͖ͯ͠·ͨ͠ -PPLFSɿ+0*/BU4BO'SBODJTDPʛγϦʔζʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQTFSJFTMPPLFSKPJOBUTBOGSBODJTDP

Slide 17

Slide 17 text

Ϋϥϝιݱ஍ࢀઓϝϯόʔ໊͸ʜ ͠Μ΍ ͨ·ͪΌΜ ͍ͤΒ

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Ӌాൃʙαϯϑϥϯγείண

Slide 20

Slide 20 text

॓ധઌɿ)PUFM,BCVLJ

Slide 21

Slide 21 text

॓ധઌɿ)PUFM,BCVLJ

Slide 22

Slide 22 text

ҙຯෆ໌ͳΧϯόϯʁΞʔτʁ͕ࢸΔͱ͜Ζʹ

Slide 23

Slide 23 text

αϯϑϥϯγείɺࡔಓͷ֯౓͕εΰ͍

Slide 24

Slide 24 text

ΰʔϧσϯήʔτϒϦοδɿॳઓ͸ʜ

Slide 25

Slide 25 text

ΰʔϧσϯήʔτϒϦοδɿॳઓ͸େࢂഊPS[

Slide 26

Slide 26 text

Slide 27

Slide 27 text

͜ͷ೔͸-PPLFSࣾถࠃຊࣾπΞʔʂ

Slide 28

Slide 28 text

ಥવͷؙُ੡໙

Slide 29

Slide 29 text

్த(PPHMFʹཱͪدΔ ˞ୠ͠γϣοϓ·Ͱ

Slide 30

Slide 30 text

5IFΠϯελө͑ʂʂʂʂʂ

Slide 31

Slide 31 text

-PPLFSຊࣾ αϯλΫϧʔζ ౸ண

Slide 32

Slide 32 text

-PPLFSࣾͷʰΧϧνϟʔʱΛ஌Δ -PPLFSถࠃຊࣾ αϯλΫϧʔζ ʹ๚໰͖ͯͨ͠MPPLFS+0*/EBUBʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSP⒏DFUPVSJOTBOUBDSV[IFBERVBSUFS

Slide 33

Slide 33 text

ΰʔϧσϯήʔτϒϦοδ ೔ৼΓ౓໨ ͸ʜ

Slide 34

Slide 34 text

େউརʂʂʂ΍ͬͨʙʙʙʂʂʂ

Slide 35

Slide 35 text

өըʰϰΣϊϜʱͷ͋ͷϩέ஍ʹ

Slide 36

Slide 36 text

<-PPLFS>8FMDPNF3FDFQUJPO։࢝ɺΠϕϯτ։ນ -PPLFSɿ+0*/BU4BO'SBODJTDPʮ8FMDPNF3FDFQUJPOʯࢀՃϨϙʔτMPPLFS+0*/EBUBʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPNBUPNFXFMDPNFSFDFQUJPO

Slide 37

Slide 37 text

ਫ

Slide 38

Slide 38 text

<-PPLFS>جௐߨԋͦͷ Φʔϓχϯά -PPLFSɿ+0*/BU4BO'SBODJTDPʮ.PSOJOH,FZOPUFʢ೔໨ʣʯࢀՃϨϙʔτMPPLFS+0*/EBUBʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPTUNPSOJOHLFZOPUF

Slide 39

Slide 39 text

<-PPLFS>ग़లϒʔεΠϯλϏϡʔ׶ߦ ϒʔε๚໰Ϩϙʔτɿ'JWFUSBOฤ ࣗಈσʔλύΠϓϥΠϯߏங r-PPLFSɿ+0*/BU4BO'SBODJTDPMPPLFS+0*/EBUBʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPSFQPSUMPPLFSFYIJCJUJPOCPPUIJOUFSWJFXTpWFUSBO ϒʔε๚໰Ϩϙʔτɿ%BBTJUZฤ σʔλ෼ੳ͓ΑͼFίϚʔεͷίϯαϧςΟϯά r-PPLFSɿ+0*/BU4BO'SBODJTDPMPPLFS+0*/EBUBʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPSFQPSUMPPLFSFYIJCJUJPOCPPUIJOUFSWJFXTEBBTJUZ ϒʔε๚໰Ϩϙʔτɿ%"4ฤ σʔλ෼ੳίϯαϧςΟϯά r-PPLFSɿ+0*/BU4BO'SBODJTDPMPPLFS+0*/EBUBʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPSFQPSUMPPLFSFYIJCJUJPOCPPUIJOUFSWJFXTEBT

Slide 40

Slide 40 text

<-PPLFS>ձ৔ͷงғؾ ։࠵ձ৔͸ϩοΫͷ੟஍ʂʰSVN WestʱϑϩΞผશܠ঺հ – LookerɿJOIN 2019 at San Francisco #looker #JOINdata ʛ Developers.IO  https://dev.classmethod.jp/business/business-analytics/looker-join-2019-at-sanfrancisco-svn-west/

Slide 41

Slide 41 text

Slide 42

Slide 42 text

<-PPLFS>ன৯

Slide 43

Slide 43 text

<-PPLFS>֤छϋϯζΦϯɾϒϨΠΫΞ΢τηογϣϯʹࢀՃ

Slide 44

Slide 44 text

໦

Slide 45

Slide 45 text

<-PPLFS>جௐߨԋͦͷ -PPLFSͷൃද ৽ػೳ੝Γ୔ࢁͷʰ-PPLFSʱൃදʂ.PSOJOH,FZOPUF ೔໨ ࢀՃϨϙʔτr -PPLFSɿ+0*/BU4BO'SBODJTDPMPPLFS+0*/EBUBʛ%FWFMPQFST*0 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPOENPSOJOHLFZOPUF

Slide 46

Slide 46 text

<-PPLFS>جௐߨԋͦͷ Ϋϩʔδϯά

Slide 47

Slide 47 text

߹ؒΛ๓ͬͯαϯϑϥϯγεί؍ޫ

Slide 48

Slide 48 text

߹ؒΛ๓ͬͯαϯϑϥϯγεί؍ޫ

Slide 49

Slide 49 text

߹ؒΛ๓ͬͯαϯϑϥϯγεί؍ޫ

Slide 50

Slide 50 text

-PPLFS+BQBO%JOOFS ඒຯ͍͠ֈ

Slide 51

Slide 51 text

-PPLFS+BQBO%JOOFS ඒຯ͍͠ֈ

Slide 52

Slide 52 text

Slide 53

Slide 53 text

νΣοΫΞ΢τʙग़ࠃʙؼࠃ

Slide 54

Slide 54 text

૯ׅ

Slide 55

Slide 55 text

૯ׅɿΠϕϯτશମ ɾʮ͓΋ͯͳ͠ʯ͕ૉ੖Β͔ͬͨ͠  ɹɾ೔ຊ͔ΒͷࢀՃऀΛαϙʔτ௖͍ͨ-PPLFS+BQBOͷօ༷  ɹɾΠϕϯτຊฤձ৔ελοϑͷօ༷ ɾʮϚϧνΫϥ΢υαϙʔτʯͷڧௐ  ɾࣄྫܥͰग़ͯ͘Δ%8)͕4OPXqBLFͩͬͨ 3FETIJGUͰ΋#JH2VFSZͰ΋ແ͘ ɾۀքͷಈ޲͕ૉૣ͘ɺܹ͍͠ #*વΓ%8)વΓ ɾن໛ײྑ͔ͬͨ  ɹɾձ৔ن໛ ಈ͖΍͔ͬͨ͢   ɹɾηογϣϯͷ࣌ؒɺཻ౓ औֻ͔ͬΓͱͯ͠৭ʑݟΕͨͷ͕ྑ͔ͬͨ   ɾ-PPLFSΛ࠾༻͢Δاۀͷಛ৭ɺಛ௃ ɹɾ૊৫શମͰͷར༻Λߟ͍͑ͯΔاۀ ɹɾ৘ใͷεϜʔζͳڞ༗Λݕ౼͍ͯ͠Δاۀ ɹɾٸ੒௕اۀ

Slide 56

Slide 56 text

૯ׅɿ-PPLFSࣾٴͼ-PPLFSࣾͷzจԽz ɾཧ૝తͳΦϑΟε ɹɾࣾһͷύϑΥʔϚϯεΛ࠷େݶҾ͖ग़ͨ͢Ίͷ੯͠Έͳ͍౤ࢿ͕  ɹɹͳ͞Ε͍ͯΔͱ͍͏ҹ৅  ɹɾΦϑΟεͷ࡞Γʹ͍ͭͯ͸ɺฐࣾ΋৽ઃˍվमͷࡍʹࢀߟʹ͍ͨ͠  ɾѪݘ࿈Εͯ͜ΕΔͷʁʂ خ  ɾ&EXBSE4OPPLࢯʹΑΔ-PPLFSࣾͷจԽʹؔ͢Δ͓࿩  ɹɾฐࣾ΋ࣅ͍ͯΔ෦෼͕͋ͬͨ  ɾ%$- %FQBSUNFOUPG$VTUPNFS-PWF ͷϙϦγʔ  ɹɾސ٬ॏࢹɺαϙʔτͷࡏΓํʹ͍ͭͯײ໏Λड͚ͨ  ɹɾ͍ͭ΋͋Γ͕ͱ͏͍͟͝·͢ɻॿ͔ͬͯ·͢ʂ

Slide 57

Slide 57 text

૯ׅɿ؍ޫ·ΘΓ ɾαϯϑϥϯγεί௒ָ͔ͬͨ͠ʂ ɾαϯϑϥϯγείΊͬͪΌָ͔ͬͨ͠ʂ  ɾ॓ധઌϗςϧ )PUFM,BCVLJ ΋շదͩͬͨʂ ɾ6CFS -ZGU͕ͱͬͯ΋໾ʹཱͬͨʂ Ҡಈ͸΄΅શͯͰ6CFSΛ׆༻ ɾΰʔϧσϯήʔτϒϦοδɺͪΌΜͱ؍Εͯྑ͔ͬͨʂ  ɾໄੌ͔ͬͨ ˍໄͷঢ়گΛࣄલʹ֬ೝ͓ͯ͘͜͠ͱͷॏཁੑΛ஌ͬͨ ɾΫϥϜνϟ΢μʔඒຯ͔ͬͨ͠ʂ ɾֈඒຯ͔ͬͨ͠ʂ ɾ ΞϧΧτϥζౡɺߦ͖͔ͨͬͨ ɾ (PPHMFΦϑΟεɺͪΌΜͱ๚໰͍ͨ͠ʂ ɾαϯϑϥϯγείʹ·ͨདྷ͍ͨʂ

Slide 58

Slide 58 text

͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ