ããããå§ããããã« - æææ±ºå®ã«åœ¹ç«ã€å¯èŠåãšããŒã¿æŽ»çšã®ãã€ã³ã
2019幎æåŸã®DS女åéšã»ãããŒã§ã¯ãããŒã¿ã®å¯èŠåãããŒããšãã2æ¬ã®LTã«å ãããçµ±èšåŠãæåŒ·ã®åŠåã§ãããã®èè ã§ããæ ªåŒäŒç€ŸããŒã¿ããŒã¯ã« 西å åæ°ã«ãããè¬æŒããå±ãããŸãããæ¬ã¬ããŒãã§ã¯åè¬æŒãèŠçŽããäŒãããŸãã
LT1ãã¯ãããŠã®GoogleããŒã¿ããŒã¿ã«ããå ¥éããæŽ»çšäºäŸãŸã§ãã
æ ªåŒäŒç€ŸãªãŒã«ã¢ããŠããç¥ä¿ ã¿ãã æ°

ãªãŒã«ã¢ããŠãã¯ç掻ç·åæ å ±ãµã€ãã§ãããŸããŸãªãžã£ã³ã«ã«ã€ããŠå€æ§ãªèšäºãæ²èŒãããŠããŸããèšäºã«æ²èŒãããåºåã®å¹ææ€èšŒãªã©ã®ããã«ããŒã¿åæã¯å¿ é ã®ãã®ã§ããããŸã§ã¯Hadoopãªã©ã䜿çšãããŠãããšã®ããšã§ããã誰ããæ±ããããŒã«ã§ã¯ãªããããåæã«ã¯æéãã³ã¹ããããããã®ã§ãããããããã®çŸå Žãèªç±ã«ããŒã¿ãåæã§ããç°å¢ãå®çŸãã¹ããGoogle瀟ãæäŸããç¡æã®BIããŒã«ãGoogleããŒã¿ããŒã¿ã«ïŒæ§ããŒã¿ã¹ã¿ãžãªïŒãã®ç€Ÿå å©çšãä¿é²ããŠããŸãã
Google ããŒã¿ããŒã¿ã«ã§ã¯ãæ§ã ãªããŒã¿ãœãŒã¹ãäžã€ã®ããã·ã¥ããŒãã§å¯èŠåã§ããBigQueryãMy SQLãªã©æ§ã ãªããŒã¿ãœãŒã¹ãšã®é£æºãå¯èœã§ãããã©ãã°ïŒããããã§ããžã¥ã¢ã«åããã¬ããŒããç°¡åã«äœæããããšãã§ããŸããäœæããã¬ããŒãã«ã¯åç §æš©éãèšå®ã§ãã瀟å ã®ã¡ã³ããŒããããŒãžã¡ã³ããšãç°¡åã«å ±æã§ããç¹ãé åã§ãã
GoogleããŒã¿ã«ãå©çšããããšã§ãåéšéãèªåãã¡ã§ã¬ããŒããç°¡åã«äœæã§ããããšãããããããã«ç€Ÿå ã«åºãŸããŸãããäŸãã°ç·šééšã§ã¯ãKPIã®éæç¶æ³ã®ç¢ºèªãåºåå¹æã®æ€èšŒãååŸããããŒã¿ã®æ€èšŒãªã©ã«äœ¿ãã£ãŠããŸãã ãããã§ã«ãææã®BIããŒã«ã䜿ã£ãŠããç°å¢ã§ããã°ãããããGoogleããŒã¿ã«ã«åãæ¿ããå¿ èŠã¯ãªããããããŸãããBIããŒã«ããŸã äœã䜿ã£ãŠããããããŒã¿åæãã©ãããå§ããã°ããããšæ©ãã§ããã®ã§ããã°ããã®ããã«ç¡æã§äœ¿ãåæã®ããããŒã«ã®å©çšããå§ããããšãããããã§ãã
LT2ãLookerã䜿ã£ãŠåæããæ¬¡ã®ã¢ã¯ã·ã§ã³ãžã
Lookerãè¥¿èŠ éº»å©å æ°

Lookerã¯ã2012幎ã«ç±³åœã«ã«ãã©ã«ãã¢ã§èšç«ããããµã³ã¿ã¯ã«ãŒãºãæ¬ç€ŸãšããäŒç€Ÿã§ããã«ã¹ã¿ããŒãµããŒãã®ããŒã ã®åç§°ãDCL (Department of Customer Love)ãšããã®ã¯ãäŒç€Ÿã®ã«ã«ãã£ãŒãããäŒããŠãããšæããŸãã2018幎9æã«ã¢ãžã¢å¯äžã®æ ç¹ãšããŠæ±äº¬ãªãã£ã¹ãéèšãããŸããã2019幎6æã«Googleãå瀟ãè²·åããããšãçºè¡šãããŠãããGoogleã®Cloud Serviceã«çµã¿èŸŒãŸããäºå®ãšã®ããšã§ãã
Lookerã®ãµãŒãã¹ã¯ãããŒã¿åæã®ããã«ã¯ããŒã¿ãšã³ãžãã¢ã«ããããŒã¿åºåãå¿ èŠã§ãªã¢ã«ã¿ã€ã ãªåæãã§ããªãã£ãããšã課é¡ãšæãããšããããçãŸããŸãããç¹åŸŽçãªã®ã¯ãLookerèªäœã¯ããŒã¿ãæããDBã«çŽæ¥ã¢ã¯ã»ã¹ããããšããããŠã人ã«ãã£ãŠç°ãªãããŒã¿é ç®ã®å®çŸ©ïŒäŸãã°ãâ売äžéé¡âãçšèŸŒã®å€ããçšæãã®å€ãããªã©ïŒãLookerã§äžå 管çãå®çŸ©ã®ãºã¬ãè§£æ¶ããä»çµã¿ã§ãã
åçš®ã®ã°ã©ããçµã¿åããç°¡åã«ãªãããªããžã¥ã¢ã«ã®ã¬ããŒããã€ããããšãå¯èœãªããŒã«ã§ããã®ãããªã¬ããŒãã®å®æåºåãã¹ã±ãžã¥ãŒãªã³ã°ããããã¬ããŒããPDFåããŠSlackãã¡ãŒã«ã§å ±æããããšã次ã®ã¢ã¯ã·ã§ã³ã«ã€ãªããããã®æ©èœãå å®ããŠããŸãã
æ¥æ¬ã§ãã倧ããªäŒæ¥ãããã³ã·ã§ã³ã®äžå®€ããå§ãããããªã¹ã¿ãŒãã¢ãããšããŠãŒã¶ãŒäŒæ¥ãå¢ããŠããŠããŸãã
è¬æŒãèŠããåã®ããã®å ã
æ ªåŒäŒç€Ÿ ããŒã¿ããŒã¯ã« æé«è£œå責任è ã西å å æ°
ããŒã¿ãµã€ãšã³ã¹ããã¹ãŠã®äººã«ãšããèãã§ãããŒã¿ããŒã¯ã«ãç«ã¡äžããŸãããããŒã¿ããªãã³ã«ããæææ±ºå®ãäŒæ¥ã®çç£æ§ãROIã¯é«ããšããç ç©¶çµæã¯2011幎ãããããŸãããå®éã«ã¯ããŒã¿ãåæã掻ãããŠããªããšããäŒæ¥ãå€ãçžè«ãããã ããŸãããããŸã§ã¯BIããŒã«ã䜿ã£ãŠãããšããã±ãŒã¹ãå€ããçµéšãšæã«åºã¥ã仮説ãè£ä»ããã ãã§ãåœããåã®çµæããåŸãããªãããšãããèŠããåã®å£ãã«çŽé¢ããŠããããã§ãã
BIããŒã«ãæ ãã®ã¯ãèšè¿°çåæããã€ãŸãéå»ã«äœãèµ·ããããææ¡ããããšã§ãããŒã¿ããªãã³ã«ããæææ±ºå®ã«å¿ èŠãªåæã¯ã蚺æçåæãã§ããããŒã¿ãå ã«ãªããããèµ·ããã®ãå æé¢ä¿ãæ¢çŽ¢ãããããã©ã掻ããããšããæææ±ºå®è ã®æç€ºãããšã«çŸå Žãæœçãå®è¡ããåæè ãå¹æãæ€èšŒãããšãããµã€ã¯ã«ãåãããšãéèŠã§ãã
ããããçŸå®ã«ã¯ãããŒã¿ã¯ããã«å©çšããããšã¯é£ãããåæã¯ç¡æå³ã«é«åºŠãªãã®ãè¡ããæææ±ºå®å±€ã¯ã¬ããŒãããèŠããåãã®ã¬ãã«ã§ããçè§£ã§ãããçŸå Žã¯æœçãå®è¡åŸã«ããã£ã±ãªãã§æ€èšŒãããªãããšããããšãå€ãèŠãããŸãããšãã«ããŒã¿åæã®åã®ããŒã¿åéã»å å·¥ã«å·¥æ°ã䜿ãããããã§æ«æããŠããŸãã®ã§ãã
å¿ èŠãªã¢ãããŒãã¯å€ãã®äŒæ¥ãçŽé¢ãã課é¡ãããããã·ã³ãã«ã«ããããšã ãšèããŠããŸããããŒã¿ã®æºåãå°é£ã§ãããªãã°ãåæã«å¿ èŠãªããŒã¿ãèªåçæããã¢ã¯ã·ã§ã³ã«ã€ãªããæŽå¯ãåŸãããªãã®ã§ããã°ã倿§ãªå€æ°ããæå³ã®ããèŠå ãèªåæ¢çŽ¢ããæææ±ºå®è ãéèšãèŠããåã§ããããããªãã®ã§ããã°ãåæçµæãèªç¶èšèªãšã°ã©ãã§è¡šç€ºãã -- å®éã«ãããå®çŸãã補åãããŒã¿ã»ããŒã¯ã«ã§ã¯æäŸããŠããŸãã
ãåžæ°ããŒã¿ãµã€ãšã³ã¹ããšããèšèãã¬ãŒãããŒç€Ÿã䜿ãå§ããŠããä¹ ããã§ãããä»åŸã¯æ§ã ãªäŒæ¥ã«ããããŒã«ãèªååãããããŒã¿ãµã€ãšã³ãã£ã¹ãã®é¢äžãªãããŒã¿ãåæã掻çšã§ããããã«ãªã£ãŠããã§ãããããããªã£ããšãã«éèŠãªã®ã¯ãéå»ã«äœãèµ·ããã®ããææ¡ããã ãã®ãèŠããåãã§ã¯ãªããªããããèµ·ããã®ããå æé¢ä¿ã«ã€ããŠã®ä»®èª¬ããèšããåãããããšã§ãã
çµç¹ãããŒã¿åæãšãã®æŽ»çšãå®çŸããã«ã¯ãããã¹ïŒæ°åãšçå±ã§æææ±ºå®ã®ãªã¹ã¯ãåãã人ããããšãã¹ããŒãïŒçŸå Žã®äºæ ãšãªãã¬ãŒã·ã§ã³ã®èæèŠããã人ãããããŒã¿ãããŒãžã£ãŒïŒç€Ÿå ã®ããŒã¿ãšITã·ã¹ãã ã®åå°åããã人ãããåææ åœè ïŒITãšããŒãã¯ãŒã¯ãèŠã«ãªããªãè¥æã»äžå 瀟å¡ãã®å šãŠãåããããã«ããããŒã¿ãšæã¡æãåãçµç¹ãã€ããããšãéèŠã§ãã
ã°ã«ãŒããã£ã¹ã«ãã·ã§ã³

質å1ïŒããŒã¿ãå¯èŠåããåãæ±ºãŸã£ãŠããŸã£ãŠãããå¶æ¥çŸå Žãã©ãããèŠæ¹ããããããåŒãåºããªãã
ã¢ããã€ã¹ïŒ
- å¶æ¥çŸå Žã䜿ããããŒã«ãå ¥ããã®ãè¯ããããããªãïŒç¥ä¿æ°ïŒ
- å¶æ¥éšãããŒã¿ã«è§Šããæ©äŒãäœããšè¯ããããããªããå匷äŒãšããåã®äžãå šéšçœ²ãã人ãéãŸã楜ããç®çãæã£ãŠåæããæ©äŒãèšããŠããã¯ã©ã€ã¢ã³ãããã£ãïŒè¥¿èŠæ°ïŒ
- ãããããæããŠããã®ã¯ãããŒã¿ãèŠãŠãããŠãããšããããšãªã®ã§ããããšã©ã®æ°åãåºãŠãããšå¬ãããããã®ãå¬ãããã®å ã«ã©ããªã¡ãªããããã£ãŠãã©ãããçµæã§ããã°æææ±ºå®ãã§ããããã話ãåã£ãŠã¿ããšãããïŒè¥¿å æ°ïŒ
質å2ïŒ æ±ãã¹ãããŒã¿ãèšå€§ããããããŒã«ã«ããŒã¿ãèªã¿èŸŒãŸãããããªã«ããçæããããããããããªãããŸãå ·äœçã«ã¯ãææ¥ãåãããŠå幎æ¯ã®æ¯èŒããããããã©ãæäœããããããããããªãã
ã¢ããã€ã¹ïŒ
- SQLã䜿ããããã«ããã®ã¯æå¹ãããããªããSQLã¯ããŒã¿åæã§ã¯å ¬çšèªãšãèšã£ãŠãããã®ã§ãProcedure Languageãšéã£ãŠæé ãæžãå¿ èŠãªããäœã欲ããããèšè¿°ãããè±èªåã®äººãªãèªç¶èšèªã«è¿ããããã®èšèªããµãŒããŒãç«ãŠããšãªããšITèŠä»¶ãšãªãããããªãŒã®DBãœããã䜿ãMacãPCã«DBãäœã£ãŠSQLã䜿ãããšãå¯èœãäºç®ããããªãMicrosoftã®SQLãµãŒããŒãšPowerBIã®çµã¿åããããããïŒè¥¿å æ°ïŒ
質å3ïŒç€Ÿå ã§ããžã¥ã¢ã«åããã°ã©ããå ±æãããã宿°ãèŠãã®ã«æ £ããããŠããŠãã°ã©ãã䜿ã£ã説æãè ã«èœã¡ãŠããªãæ§åãèŠãæ¹ã説æã®ä»æ¹ãšããŠäœã«æ°ãã€ããã¹ããã
ã¢ããã€ã¹ïŒ
- ã©ã®é ç®ãã°ã©ãã®çžŠè»žã«æã£ãŠãããšå¬ãããããŸãã¯æ±ºãããšè¯ããããã«å¯ŸããŠããã€ãã®æšªè»žãèŠããããšã§ã瞊軞ã®å€ãæ¯èŒã§ããæçµçã«ã©ã®æšªè»žãéžæãããã話ãåããšããïŒè¥¿å æ°ïŒ
質å4ïŒããŒã¿å¯èŠåã®ããã«Webã¢ããªã±ãŒã·ã§ã³ãäœã䜿ã£ãŠãããäžã®äžã«ã¯äŸ¿å©ãªBIããŒã«ãããããããã®ã«ã䜿ããŠããªã
ã¢ããã€ã¹ïŒ
- GoogleããŒã¿ããŒã¿ã«ã®ãããªç¡æããŒã«ã§ãããŒã¿ã®æ·±æããã§ããããã«ãªã£ãŠãããææããŒã«ã§ã¯ã§ããããšã¯ãã£ãšåºããïŒç¥ä¿æ°ïŒ
- ãéãåºã䟡å€ãããããã ãšæããããçšåºŠã®åæãªãã°ç¡æããŒã«ããå§ãããããšãããïŒè¥¿èŠæ°ïŒ
質å5ïŒããŒã¿ãå ¥åããéšéãšç®¡çããéšéã䜿ãéšéããã©ãã©ã§çžŠå²ããå¿ èŠãªãããŒã¿ããå©çšã§ããªãããŒã¿ãç¡é§ã«æºãŸã£ãŠãããšãèšãããããŒã¿å å·¥ã®åã®æ®µéã§ãå°ã£ãŠããã
ã¢ããã€ã¹ïŒ
- äžç·ã«åæãåããŠã¿ãŸãããããšèªãããšã¯æå¹ãããããªããææãåºãã°ããã§ããããè¶³ããªãããŒã¿ãããã°ãªã¯ãšã¹ãããããïŒè¥¿å æ°ïŒ
質å6ïŒå®æ§ããŒã¿ãéèŠããã¡ãªããŒã ã«ãå®éããŒã¿ã®éèŠæ§ãšããŒã«ã®æçšæ§ãåèããªããŠã¯ãªããªãã
ã¢ããã€ã¹ïŒ
- 瀟äŒç§åŠã§ã¯ã宿§ãšå®éã¯äž¡èŒªã§ãã©ã¡ããéèŠãéå»ã«è¡ã£ãã¯ãŒã¯ã·ã§ããã§ãéåãã§ããã°ã«ãŒããšã§ããªãã°ã«ãŒãã«éãŸã£ãŠããªãã§ã§ããŠããªãã®ã ãããšããããšãçè§£ããŠããããšãã詊ã¿ããã£ããã°ãŒã°ã«ãã©ãŒã ã®ãããªãã®ããšäœ¿ããå®éã«ã€ã³ã¿ãã¥ãŒè³ªåããåŸããã宿§çãªåçãå®éçãªè³ªåã«èœãšã蟌ãã§ããŒã¿ãéãããã®åçãåæãããšããããšãäžç·ã«ãã£ãŠã¿ããšè¯ããããããªããããŒã¿ãšã¯ããããããªãç¡æ©è³ªãªãã®ã§ã¯ãªããã ãããæã£ãŠããããšããŸãšããŠããã®ã ããšããããšãããŒã¿ãå«ããªäººã«åãã£ãŠããããïŒè¥¿å æ°ïŒ
質å7ïŒåææ £ããããŠããªãããBIããŒã«ã䜿ãã«ãçµ±èšãªã©ã®ç¥èã¯å¿ èŠã§ã¯ãªããããŸããæ±ºè£ãåãããã«ã©ãããææ¡ãããã°ãããã
ã¢ããã€ã¹ïŒ
- ãã®å·®ã誀差ã§ãããã©ãããèŠæ¥µããããããšã¯å¿ èŠãªç¥èã§ãçµ±èšåŠã¯ããã£ãŠããæ¹ããããšæããããçšåºŠããŒã¿ã貯ãŸããšãèª€å·®ãæ°ã«ããªãã§ãããªããããããBIããŒã«ã䜿ãå¢çãšèšãããããããªããå°å ¥ã®æææ±ºå®è ã«ãã©ã€ãã«ã¯ããããããšããã£ãŠããŸããããšäŒããããããšæå¹ãããããªãïŒè¥¿å æ°ïŒ
質å8ïŒãšã¯ã»ã«ã«äŸåããŠãããæãã ããªãã
ã¢ããã€ã¹ïŒ
- Excelãæªããšã¯æããªãããExcelã䜿ãããšã«ãã£ãŠãªã«ãåé¡ãèµ·ããŠãããªãããã®åé¡ãæããã«ã察å¿ã§ããããŒã«ãæ€èšããïŒè¥¿èŠæ°ïŒ
- å ·äœçã«ããŒã¿ãåæéçšãèŠããªããšäžå®ãªäººã¯Excelã«ãã ãããæœè±¡åãèŠæãªã¿ã€ããªã®ã§ãå ·äœçã«èª¬æããŠãããããŸãšãããšãããªãããšèª¬æããããšãéèŠãããŒã¿éãå€ãExcelã§ã¯å¯Ÿå¿ã§ããªããšããã®ã§ããã°ããã®äººã®åã§äœæ¥ããŠPCãéŒè¿«ãããšãããèŠããã®ãã¢ã€ãã¢ïŒè¥¿å æ°ïŒ
質å9ïŒåæãããããšããŠããããŒã¿ã«æ¬ æããã£ãããã¹ã¯ãããŠãããããŠãæåã§ã®ã¯ã¬ã³ãžã³ã°ãå¿ é ãã«ã©ã ããšã®ããŒã¿ãäžå®ã§ã¯ãªãã£ãããã
ã¢ããã€ã¹ïŒ
- ããŒã¿ããã¹ãŠãããã«ããããšã¯çŸå®çã§ã¯ãªããå¿ èŠãªãšãããããäŸãã°ãéãå ·äœçã«åããšãããã³ã³ããŒãžã§ã³ã«é¢ä¿ãããšãããããããŒã¿ããããã«ããŠãããšè¯ãããããã¯ãçŽè¿ã®ããŒã¿ãã綺éºã«ãããçµæãåºãŠããããã«ãªããšãããŒã¿ãå ¥åéã«é©åãªããŒã¿ãå ¥ããããååããŠããããããïŒè¥¿å æ°ïŒ
æåŸã«ã»ã»ã»
ãèŠããåãã®éèŠæ§ãšå¿ èŠæ§ã¯ãããŸã誰ããåæãããšããã§ããããããããªãããå®éã«ãããã§ããŠããäŒæ¥ã¯ãŸã ããäžéšãªã®ãããããŸããã ä»åã®ã»ãããŒã§ã¯ãGoogle ããŒã¿ããŒã¿ã«ãšLookerãšãã2ã€ã®ãšãŠã䜿ãããããããŒã«ã玹ä»ããã ããŸããããŸãã°ã«ãŒããã£ã¹ã«ãã·ã§ã³ã§å ±æããããçãããçŽé¢ããŠãã課é¡ãšè¬åž«éã®ã¢ããã€ã¹ãåèã«ã次ã®ã¹ããããžãšé²ãã€ã¡ãŒãžãããå ·äœçã«æã£ãŠããã ããã®ã§ã¯ãªãããšæããŸããããã«ãèŠããåãã«æ¢ãŸããããªããã®äºè±¡ãèµ·ããã®ãã®å æé¢ä¿ãæããã«ããããšãããªãã¡ãèšããåããç®æããªããŠã¯ãªããªããšããè¥¿å æ°ã®ã¡ãã»ãŒãžã¯ãšãŠãå°è±¡çã§ããã
ããããã€ãã³ã
é¢é£ããã€ãã³ã









