JOIN 2019 at San Francisco Highlight & Playback

σʔλΞφϦςΟΫεࣄۀຊ෦ɹΠϯςάϨʔγϣϯ෦ ͠Μ΍ !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.)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

॓ധઌɿ)PUFM,BCVLJ

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

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

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

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

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

ಥવͷؙُ੡໙

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

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

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

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

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

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

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

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

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

<-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

<-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/

<-PPLFS>ன৯

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

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

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

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

-PPLFS+BQBO%JOOFS ඒຯ͍͠ֈ

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

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

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

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

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

JOIN 2019 at San Francisco Highlight & Playback

JOIN 2019 at San Francisco Highlight & Playback

More Decks by shinyaa31

Other Decks in Technology

Featured

Transcript