Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
JOIN 2019 at San Francisco Highlight & Playback
Search
shinyaa31
December 10, 2019
Technology
0
900
JOIN 2019 at San Francisco Highlight & Playback
shinyaa31
December 10, 2019
Tweet
Share
More Decks by shinyaa31
See All by shinyaa31
イチから学ぶdbt / Learn dbt from scratch
shinyaa31
0
1.1k
アドベントカレンダーを完走する技術 / Techniques for completing an advent calendar
shinyaa31
0
520
クラスメソッドにおけるConfluenceからNotionへの全社移行事例 / Company-wide Migration Case from Confluence to Notion at Classmethod, Inc.
shinyaa31
0
3.9k
Lookerを活用した可視化・分析業務の実践/Practice of visualization and analysis work using Looker in Developers IO 2019 by shinyaa31
shinyaa31
0
30k
勉強会・カンファレンスレポートを累計400本近く書いたので経緯とか要点をまとめてみた/my-way-of-writing-event-participation-report-by-shinyaa31
shinyaa31
2
15k
AWS(Amazon Redshift)とTableauではじめるビッグデータ分析 / Getting started Bigdata Analysis with Amazon Redshift and Tableau in Innovation Egg 8th
shinyaa31
1
2.2k
DevIO MTUP11-002
shinyaa31
0
250
Other Decks in Technology
See All in Technology
「知的単純作業」を自動化する、地に足の着いた大規模言語モデル (LLM) の活用
nrryuya
8
5.8k
Max out Local LLM in Challenging Environments
sashimimochi
2
200
Rustで「プリズモイダル法」を利用して「土量計算」をガチでやる
nokonoko1203
1
350
Gemini, Google's Large Language Model
glaforge
0
120
Grafana x PagerDuty Better Together
jacopen
1
330
DX企業CTOとして考える技術への向き合い方
shoheitai
0
110
BPStudyの200回を中心にIT業界を振り返る。そしてこれから
haru860
3
430
家族アルバム みてねにおけるGrafana活用術 / Grafana Meetup Japan Vol.1 LT
isaoshimizu
1
1.1k
中年男性がメインフレームから クラウドへキャリアシフトしてみた
uechishingo
1
420
Cypress or Playwright?
rainerhahnekamp
0
180
いいたいことちゃんという
tkengo
0
260
M&A戦略を支えるデータマネジメント (MIDAS Tech Study #16 GENDA Komiyama)
kommy339
1
160
Featured
See All Featured
The Invisible Side of Design
smashingmag
294
49k
The Illustrated Children's Guide to Kubernetes
chrisshort
32
47k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
22
1.4k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
660
120k
YesSQL, Process and Tooling at Scale
rocio
165
13k
Art, The Web, and Tiny UX
lynnandtonic
290
19k
A Tale of Four Properties
chriscoyier
153
22k
Fontdeck: Realign not Redesign
paulrobertlloyd
76
4.9k
WebSockets: Embracing the real-time Web
robhawkes
59
7k
Building Applications with DynamoDB
mza
88
5.6k
What the flash - Photography Introduction
edds
64
11k
Practical Orchestrator
shlominoach
183
9.7k
Transcript
σʔλΞφϦςΟΫεࣄۀຊ෦ɹΠϯςάϨʔγϣϯ෦ ͠Μ !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
॓ധઌɿ)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>ձͷงғؾ ։࠵ձϩοΫͷʂʰ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%JOOFS ඒຯ͍͠ֈ
ۚ
νΣοΫΞτʙग़ࠃʙؼࠃ
૯ׅ
૯ׅɿΠϕϯτશମ ɾʮ͓ͯͳ͠ʯ͕ૉΒ͔ͬͨ͠ ɹɾຊ͔ΒͷࢀՃऀΛαϙʔτ͍ͨ-PPLFS+BQBOͷօ༷ ɹɾΠϕϯτຊฤձελοϑͷօ༷ ɾʮϚϧνΫϥυαϙʔτʯͷڧௐ ɾࣄྫܥͰग़ͯ͘Δ%8)͕4OPXqBLFͩͬͨ 3FETIJGUͰ#JH2VFSZͰແ͘
ɾۀքͷಈ͕ૉૣ͘ɺܹ͍͠ #*વΓ%8)વΓ ɾنײྑ͔ͬͨ ɹɾձن ಈ͖͔ͬͨ͢ ɹɾηογϣϯͷ࣌ؒɺཻ औֻ͔ͬΓͱͯ͠৭ʑݟΕͨͷ͕ྑ͔ͬͨ ɾ-PPLFSΛ࠾༻͢Δاۀͷಛ৭ɺಛ ɹɾ৫શମͰͷར༻Λߟ͍͑ͯΔاۀ ɹɾใͷεϜʔζͳڞ༗Λݕ౼͍ͯ͠Δاۀ ɹɾٸاۀ
૯ׅɿ-PPLFSࣾٴͼ-PPLFSࣾͷzจԽz ɾཧతͳΦϑΟε ɹɾࣾһͷύϑΥʔϚϯεΛ࠷େݶҾ͖ग़ͨ͢Ίͷ੯͠Έͳ͍ࢿ͕ ɹɹͳ͞Ε͍ͯΔͱ͍͏ҹ ɹɾΦϑΟεͷ࡞Γʹ͍ͭͯɺฐࣾ৽ઃˍվमͷࡍʹࢀߟʹ͍ͨ͠ ɾѪݘ࿈Εͯ͜ΕΔͷʁʂ خ ɾ&EXBSE4OPPLࢯʹΑΔ-PPLFSࣾͷจԽʹؔ͢Δ͓
ɹɾฐࣾࣅ͍ͯΔ෦͕͋ͬͨ ɾ%$- %FQBSUNFOUPG$VTUPNFS-PWF ͷϙϦγʔ ɹɾސ٬ॏࢹɺαϙʔτͷࡏΓํʹ͍ͭͯײΛड͚ͨ ɹɾ͍ͭ͋Γ͕ͱ͏͍͟͝·͢ɻॿ͔ͬͯ·͢ʂ
૯ׅɿ؍ޫ·ΘΓ ɾαϯϑϥϯγείָ͔ͬͨ͠ʂ ɾαϯϑϥϯγείΊͬͪΌָ͔ͬͨ͠ʂ ɾ॓ധઌϗςϧ )PUFM,BCVLJ շదͩͬͨʂ ɾ6CFS -ZGU͕ͱͬͯʹཱͬͨʂ
Ҡಈ΄΅શͯͰ6CFSΛ׆༻ ɾΰʔϧσϯήʔτϒϦοδɺͪΌΜͱ؍Εͯྑ͔ͬͨʂ ɾໄੌ͔ͬͨ ˍໄͷঢ়گΛࣄલʹ֬ೝ͓ͯ͘͜͠ͱͷॏཁੑΛͬͨ ɾΫϥϜνϟμʔඒຯ͔ͬͨ͠ʂ ɾֈඒຯ͔ͬͨ͠ʂ ɾ ΞϧΧτϥζౡɺߦ͖͔ͨͬͨ ɾ (PPHMFΦϑΟεɺͪΌΜͱ๚͍ͨ͠ʂ ɾαϯϑϥϯγείʹ·ͨདྷ͍ͨʂ
͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ