JOIN 2019 at San Francisco Highlight & Playback

Transcript

1. σʔλΞφϦςΟΫεࣄۀຊ෦ɹΠϯςάϨʔγϣϯ෦
   ͠Μ΍
   
   !TIJOZBB
   +0*/
   
   BU
   4BO
   'SBODJTDP
   )JHIMJHIU
   
   1MBZCBDL 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.)
2. ࣗݾ঺հ
    ͠Μ΍ "84ίϯαϧςΟϯά෦ʹݱ"84ࣄۀຊ෦ͷલ਎ IUUQTEFWDMBTTNFUIPEKQBVUIPSTIJOZBB @shinyaa31 ೥݄ɿΫϥεϝιου+0*/
 
 ೥݄ʙɿσʔλΠϯςάϨʔγϣϯ෦
 ೥݄ʙɿσʔλΞφϦςΟΫεࣄۀຊ෦
   ɾΫϥϝι೥໨
 ɾ$4" ΧελϚʔετʔϦʔΞφϦςΟΫε
   Ϧʔμʔ
 ɾ޷͖ͳ"84αʔϏεɿ"NB[PO
   3FETIJGU
 ɾ޷͖ͳ-PPLFSͷ7J[ɿςΩετςʔϒϧ -FHBDZ
3. اۀ঺հ
    Ϋϥεϝιουגࣜձࣾ
 $MBTTNFUIPE
   *OD 
 https://classmethod.jp/
 ɾ೥݄೔ઃཱ
 ɾ୅දऔక໾ɹԣా
   ૱
 ɾैۀһ਺ɹ໊ʙ
 ɾΦϑΟε ࠃ಺ 
 ɹळ༿ݪؠຊொࡳຈ্ӽ
 ɹେࡕԬࢁ෱Ԭಹ೼
 ɾΦϑΟε ւ֎ 
 ɹϕϧϦϯ υΠπ 
 ɹόϯΫʔόʔ Χφμ 
 ɹάϧΨΦϯ Πϯυ 
 ɾΫϥ΢υ "84 ɺϞόΠϧΞϓϦɺ
 ɹϏοάσʔλɺ"*ʹ͓͚Δاۀ޲͚
 ɹٕज़ࢧԉΛల։
 ɾzϒϩάͷձࣾz
4. ΧϑΣ΍ͬͯ·͢
    %FWFMPQFST*0
   $"'&
   c
   Ϋϥεϝιου
   IUUQTDBGFDMBTTNFUIPEKQ
 ϨδϨεɺ׬શΩϟογϡϨεళฮʮ%FWFMPQFST*0
   $"'&ʯٕज़঺հ
   
   :PV5VCF
   IUUQTXXXZPVUVCFDPNXBUDI W(3UN0CCPUT ϨδϨεɺ׬શΩϟογϡϨεళฮʮ%FWFMPQFST*0
   $"'&ʯ
5. #FTU
   -PPLFS
   "NCBTTBEPS
   ɺ௖͖·ͨ͠ʂʂ
   
6. ͜ͷϝϯόʔͰ-PPLFSͷϒϩάΛॻ͖·ͨ͠
   
7. ϒϩά঺հ ձࣾશମ
    ɾ೥݄։ઃ
 ɾ݄ؒ17਺ɿສҎ্
 ɾ݄ؒ66਺ɿ
   
   ສҎ্
 ɾ૯͸ͯϒ਺ɿ
   ສҎ্ https://dev.classmethod.jp/
8. ϒϩά঺հ ձࣾશମ
    ɾ೥݄։ઃ
 ɾ݄ؒ17਺ɿສҎ্
 ɾ݄ؒ66਺ɿ
   
   ສҎ্
 ɾ૯͸ͯϒ਺ɿ
   ສҎ্
 ɾ૯هࣄ਺ɿ
 ɹ ຊҎ্ https://dev.classmethod.jp/ ʲॕʳ%FWFMPQFST*0
   ͷϒϩάܝࡌهࣄ͕ສຊΛಥഁ͠·ͨ͠ʂ
   ʛ
   %FWFMPQFST*0
   IUUQTEFWDMBTTNFUIPEKQFUDEFWFMPQFSTJPCMPHQPTUTIBTSFBDIFE
9. ϒϩά঺հ ݸਓ
    ྦྷܭ ໿  ຊͷ͏ͪͷ໿ ຊΛࣥචˍ౤ߘ
10. -PPLFSͱΫϥεϝιου
     ɾ೥ॳ಄ɿฐࣾɺ-PPLFSʹڵຯΛ࣋ͭ
 ɾ೥݄ɿ%FWFMPQFST*0Ͱ-PPLFSϒϩάΛॻ͖࢝ΊΔ ࣍ੈ୅ͷσʔλϓϥοτϑΥʔϜʮ-PPLFSʯػೳ֓ཁ·ͱΊ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSPWFSWJFX
11. -PPLFSͱΫϥεϝιου
     ɾ೥݄ɿ(PPHMFʹΑΔങऩͷ݅ͰΠϯλϏϡʔ࣮ࢪ ʰ(PPHMFʹΑΔങऩʱͰ͜Ε͔ΒͲ͏ͳΔʁ-PPLFSͷதͷਓୡʹ৭ʑ࿩Λฉ͍ͯΈͨ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTJOUFSWJFXXJUIMPPLFSKBQBO
12. -PPLFSͱΫϥεϝιου
     ࣍ੈ୅#*ϓϥοτϑΥʔϜΛఏڙ͢Δ-PPLFSࣾͱͷύʔτφʔܖ໿Λక݁ʙ
 Ϋϥ΢υઓུ͓Αͼࢢ৔Ξϓϩʔνʹ͍ͭͯ-PPLFSࣾ΁ΠϯλϏϡʔ࣮ࢪʙʛϓϨεϦϦʔεʛΫϥεϝιου
 IUUQTDMBTTNFUIPEKQOFXTMPPLFS ɾ೥݄ɿύʔτφʔܖ໿Λൃද

13. -PPLFSͱΫϥεϝιου
     <Ϩϙʔτ>
    ୈੈ୅#*
    -PPLFSͷັྗͱ͸ -PPLFS
    ࿇஑
    ୓࠸
    ࢯ
    r
    %FWFMPQFST*0
    
    JO
    50,:0
    DNEFWJP
    ʛ
    %FWFMPQFST*0
 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTDNEFWJPUPLZPSFQPSUMPPLFSSEHFOFSBUJPOEBUBQMBUGPSN
    ʰ-PPLFSΛ׆༻ͨ͠ՄࢹԽɾ෼ੳۀ຿ͷ࣮ફʱͱ͍͏λΠτϧͰ-PPLFSͷྑ͞ʹ͍ͭͯ࿩͠·ͨ͠
    r
    %FWFMPQFST*0
    
    50,:0
    DNEFWJP
    MPPLFS
    ʛ
    %FWFMPQFST*0
 IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTEFWFMPQFSTJPUPLZPTFMGSFQPSUQSBDUJDFPGWJTVBMJ[BUJPOBOEBOBMZTJTXJUIMPPLFS ɾ೥݄ɿ%FWFMPQFST*0
    
    50,:0։࠵ˍൃද
14. -PPLFSͱΫϥεϝιου
     -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    ʛ
    γϦʔζ
    ʛ
    %FWFMPQFST*0
 IUUQTEFWDMBTTNFUIPEKQTFSJFTMPPLFSKPJOBUTBOGSBODJTDP ɾ೥݄ɿ+0*/
    !αϯϑϥϯγεί
    ࢀՃ ໊
15. -PPLFSͱΫϥεϝιου
     ʰ(PPHMFʹΑΔങऩʱͰ͜Ε͔ΒͲ͏ͳΔʁ-PPLFSͷதͷਓୡʹ৭ʑ࿩Λฉ͍ͯΈͨ
    MPPLFS
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTJOUFSWJFXXJUIMPPLFSKBQBO ɾ೥݄ɿ%FWFMPQFST*0ϒϩά
 ɹɹɹɹɹɹɹɹ
    -PPLFSؔ࿈ΤϯτϦຊୡ੒
 ɾ೥݄ɿࠓʹࢸΔ
16. +0*/
    ʹݱ஍ࢀઓ͖ͯ͠·ͨ͠
     -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    ʛ
    γϦʔζ
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQTFSJFTMPPLFSKPJOBUTBOGSBODJTDP
17. Ϋϥϝιݱ஍ࢀઓϝϯόʔ
    ໊͸ʜ
     ͠Μ΍ ͨ·ͪΌΜ ͍ͤΒ
18. 
      ݄
19. Ӌాൃʙαϯϑϥϯγείண
    
20. ॓ധઌɿ)PUFM
    ,BCVLJ
    
21. ॓ധઌɿ)PUFM
    ,BCVLJ
    
22. ҙຯෆ໌ͳΧϯόϯʁΞʔτʁ͕ࢸΔͱ͜Ζʹ
    
23. αϯϑϥϯγείɺࡔಓͷ֯౓͕εΰ͍
    
24. ΰʔϧσϯήʔτϒϦοδɿॳઓ͸ʜ
    
25. ΰʔϧσϯήʔτϒϦοδɿॳઓ͸େࢂഊ
    PS[
    
26. 
      Ր
27. ͜ͷ೔͸-PPLFSࣾถࠃຊࣾπΞʔʂ
    
28. ಥવͷؙُ੡໙
    
29. ్த(PPHMFʹཱͪدΔ ˞ୠ͠γϣοϓ·Ͱ
    
30. 5IF
    Πϯελө͑ʂʂʂʂʂ
    
31. -PPLFSຊࣾ αϯλΫϧʔζ ౸ண
    
32. -PPLFSࣾͷʰΧϧνϟʔʱΛ஌Δ
     -PPLFSถࠃຊࣾ αϯλΫϧʔζ ʹ๚໰͖ͯͨ͠
    MPPLFS
    +0*/EBUB
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSP⒏DFUPVSJOTBOUBDSV[IFBERVBSUFS
33. ΰʔϧσϯήʔτϒϦοδ ೔ৼΓ౓໨ ͸ʜ
    
34. େউརʂʂʂ΍ͬͨʙʙʙʂʂʂ
    
35. 
     өըʰϰΣϊϜʱͷ͋ͷϩέ஍ʹ
36. <-PPLFS>
    8FMDPNF
    3FDFQUJPO։࢝ɺΠϕϯτ։ນ
     -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    ʮ8FMDPNF
    3FDFQUJPOʯࢀՃϨϙʔτ
    MPPLFS
    +0*/EBUB
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPNBUPNFXFMDPNFSFDFQUJPO
37. 
      ਫ
38. <-PPLFS>
    جௐߨԋͦͷ Φʔϓχϯά
     -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    ʮ.PSOJOH
    ,FZOPUFʢ೔໨ʣʯࢀՃϨϙʔτ
    MPPLFS
    +0*/EBUB
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPTUNPSOJOHLFZOPUF
39. <-PPLFS>
    ग़లϒʔεΠϯλϏϡʔ׶ߦ
     ϒʔε๚໰Ϩϙʔτɿ'JWFUSBOฤ ࣗಈσʔλύΠϓϥΠϯߏங
    r
    -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    MPPLFS
    +0*/EBUB
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPSFQPSUMPPLFSFYIJCJUJPOCPPUIJOUFSWJFXTpWFUSBO
    ϒʔε๚໰Ϩϙʔτɿ%BBTJUZฤ σʔλ෼ੳ͓ΑͼFίϚʔεͷίϯαϧςΟϯά
    r
    -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    MPPLFS
    +0*/EBUB
    ʛ
    %FWFMPQFST*0
    
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPSFQPSUMPPLFSFYIJCJUJPOCPPUIJOUFSWJFXTEBBTJUZ
    ϒʔε๚໰Ϩϙʔτɿ%"4ฤ σʔλ෼ੳίϯαϧςΟϯά
    r
    -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    MPPLFS
    +0*/EBUB
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPSFQPSUMPPLFSFYIJCJUJPOCPPUIJOUFSWJFXTEBT
40. <-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/
41. <-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/
42. <-PPLFS>
    ன৯
    
43. <-PPLFS>
    ֤छϋϯζΦϯɾϒϨΠΫΞ΢τηογϣϯʹࢀՃ
    
44. 
      ໦
45. <-PPLFS>
    جௐߨԋͦͷ -PPLFS
    ͷൃද
     ৽ػೳ੝Γ୔ࢁͷʰ-PPLFS
    ʱൃදʂ.PSOJOH
    ,FZOPUF ೔໨
    ࢀՃϨϙʔτ
    r
    
    -PPLFSɿ+0*/
    
    BU
    4BO
    'SBODJTDP
    MPPLFS
    +0*/EBUB
    ʛ
    %FWFMPQFST*0
    IUUQTEFWDMBTTNFUIPEKQCVTJOFTTCVTJOFTTBOBMZUJDTMPPLFSKPJOBUTBOGSBODJTDPOENPSOJOHLFZOPUF
46. <-PPLFS>
    جௐߨԋͦͷ Ϋϩʔδϯά
    
47. ߹ؒΛ๓ͬͯαϯϑϥϯγεί؍ޫ
    
48. ߹ؒΛ๓ͬͯαϯϑϥϯγεί؍ޫ
    
49. ߹ؒΛ๓ͬͯαϯϑϥϯγεί؍ޫ
    
50. -PPLFS
    +BQBO
    %JOOFS ඒຯ͍͠ֈ
    
51. -PPLFS
    +BQBO
    %JOOFS ඒຯ͍͠ֈ
    
52. 
      ۚ
53. νΣοΫΞ΢τʙग़ࠃʙؼࠃ
    
54. 
     ૯ׅ
55. ૯ׅɿΠϕϯτશମ
     ɾʮ͓΋ͯͳ͠ʯ͕ૉ੖Β͔ͬͨ͠
 ɹɾ೔ຊ͔ΒͷࢀՃऀΛαϙʔτ௖͍ͨ-PPLFS
    +BQBOͷօ༷
 ɹɾΠϕϯτຊฤձ৔ελοϑͷօ༷
    ɾʮϚϧνΫϥ΢υαϙʔτʯͷڧௐ
 ɾࣄྫܥͰग़ͯ͘Δ%8)͕4OPXqBLFͩͬͨ 3FETIJGUͰ΋#JH2VFSZͰ΋ແ͘
    ɾۀքͷಈ޲͕ૉૣ͘ɺܹ͍͠ #*વΓ%8)વΓ
    ɾن໛ײྑ͔ͬͨ
 ɹɾձ৔ن໛ ಈ͖΍͔ͬͨ͢ 
 ɹɾηογϣϯͷ࣌ؒɺཻ౓ औֻ͔ͬΓͱͯ͠৭ʑݟΕͨͷ͕ྑ͔ͬͨ 
 ɾ-PPLFSΛ࠾༻͢Δاۀͷಛ৭ɺಛ௃
    ɹɾ૊৫શମͰͷར༻Λߟ͍͑ͯΔاۀ
    ɹɾ৘ใͷεϜʔζͳڞ༗Λݕ౼͍ͯ͠Δاۀ
    ɹɾٸ੒௕اۀ
56. ૯ׅɿ-PPLFSࣾٴͼ-PPLFSࣾͷzจԽz
     ɾཧ૝తͳΦϑΟε
    ɹɾࣾһͷύϑΥʔϚϯεΛ࠷େݶҾ͖ग़ͨ͢Ίͷ੯͠Έͳ͍౤ࢿ͕
 ɹɹͳ͞Ε͍ͯΔͱ͍͏ҹ৅
 ɹɾΦϑΟεͷ࡞Γʹ͍ͭͯ͸ɺฐࣾ΋৽ઃˍվमͷࡍʹࢀߟʹ͍ͨ͠
 ɾѪݘ࿈Εͯ͜ΕΔͷʁʂ خ
 ɾ&EXBSE
    4OPPLࢯʹΑΔ-PPLFSࣾͷจԽʹؔ͢Δ͓࿩
 ɹɾฐࣾ΋ࣅ͍ͯΔ෦෼͕͋ͬͨ
 ɾ%$- %FQBSUNFOU
    PG
    $VTUPNFS
    -PWF ͷϙϦγʔ
 ɹɾސ٬ॏࢹɺαϙʔτͷࡏΓํʹ͍ͭͯײ໏Λड͚ͨ
 ɹɾ͍ͭ΋͋Γ͕ͱ͏͍͟͝·͢ɻॿ͔ͬͯ·͢ʂ
57. ૯ׅɿ؍ޫ·ΘΓ
     ɾαϯϑϥϯγεί௒ָ͔ͬͨ͠ʂ
    ɾαϯϑϥϯγείΊͬͪΌָ͔ͬͨ͠ʂ
 ɾ॓ധઌϗςϧ )PUFM
    ,BCVLJ ΋շదͩͬͨʂ
    ɾ6CFS
    -ZGU͕ͱͬͯ΋໾ʹཱͬͨʂ Ҡಈ͸΄΅શͯͰ6CFSΛ׆༻
    ɾΰʔϧσϯήʔτϒϦοδɺͪΌΜͱ؍Εͯྑ͔ͬͨʂ
 ɾໄੌ͔ͬͨ ˍໄͷঢ়گΛࣄલʹ֬ೝ͓ͯ͘͜͠ͱͷॏཁੑΛ஌ͬͨ
    ɾΫϥϜνϟ΢μʔඒຯ͔ͬͨ͠ʂ
    ɾֈඒຯ͔ͬͨ͠ʂ
    ɾ ΞϧΧτϥζౡɺߦ͖͔ͨͬͨ
    ɾ (PPHMFΦϑΟεɺͪΌΜͱ๚໰͍ͨ͠ʂ
    ɾαϯϑϥϯγείʹ·ͨདྷ͍ͨʂ
58. 
     ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ