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
910
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.3k
アドベントカレンダーを完走する技術 / 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
Max out Local LLM in Challenging Environments
sashimimochi
2
230
QA経験のないエンジニアリング マネージャーがQAのカジュアル面談に出て 苦労していること・気づいたこと / scrum fest niigata 2024
yoshikiiida
2
530
「できる!」を増やすGitHub Copilot活用法 / How to use GitHub Copilot to expand your possibilities
sansan_randd
1
220
kcp: Kubernetes APIs Are All You Need #techfeed_live / TechFeed Experts Night 28th
ytaka23
1
180
スクラムに出会って「できた」を実感できるようになってきた話 / Scrum makes me feel like I can do it
yayoi_dd
2
100
Documentação de Produtos: Artefatos essenciais na prática
rigolon
1
270
ハードウェアを動かすTypeScriptの世界
9wick
3
1.1k
Password cracking: past, present, future
openwall
0
140
SWC Transformerから見るTypeScript関数記述ベストプラクティス
fujiyamaorange
1
160
Microsoft for Startups Founders Hub_20240429 update
daikikanemitsu
1
2.6k
Dungeons and Dragons and Rails
joelq
0
220
Amplify 🩷 Bedrock 〜生成AI入門〜
minorun365
PRO
10
1.2k
Featured
See All Featured
Clear Off the Table
cherdarchuk
85
310k
Thoughts on Productivity
jonyablonski
60
3.9k
Building an army of robots
kneath
300
41k
Web Components: a chance to create the future
zenorocha
306
41k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
81
44k
How To Stay Up To Date on Web Technology
chriscoyier
782
250k
Typedesign – Prime Four
hannesfritz
36
2.1k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
242
1.2M
The Invisible Side of Design
smashingmag
294
49k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
34
6.1k
Ruby is Unlike a Banana
tanoku
96
10k
Reflections from 52 weeks, 52 projects
jeffersonlam
345
19k
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ΦϑΟεɺͪΌΜͱ๚͍ͨ͠ʂ ɾαϯϑϥϯγείʹ·ͨདྷ͍ͨʂ
͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ