ITã·ãã¢ãããŒãžã£ãŒããZOZOã®ããŒã¿ã¢ãŒããã¯ãã£ãã解説ããŠã¿ãã
éããŠãæŽããŠãåæããŠãããžãã¹ã«éããäžã€ã®äŒç€Ÿã®äžã§ãããŒã¿ã埪ç°ããä»çµã¿ãããITã®å°éç¥èããªããŠã远ããããã«è§£ãã»ãããŸãã
ããŒã¿ããªãã³çµå¶ãšããèšèãããè³ã«ããããã«ãªããŸãããåãçµéšã ãã«é Œãããäºå®ïŒããŒã¿ïŒã«ããšã¥ããŠæææ±ºå®ãããçµå¶ã®ããšã§ãããšã¯ãããèšèã ããå è¡ããã¡ã§ããå ·äœçã«ã©ããªä»çµã¿ãããã°å®çŸã§ããã®ããã¯å€ããã¯èŠãã«ãããã®ã§ãã
ãã®èšäºã§ã¯ããã¡ãã·ã§ã³ECãZOZOTOWNããéå¶ããæ ªåŒäŒç€ŸZOZOã顿ã«ãå瀟ãæè¡ããã°ãå匷äŒã§å ¬éããŠããæ å ±ãããšã«ãããŒã¿æŽ»çšã®ä»çµã¿ïŒã¢ãŒããã¯ãã£ïŒã解説ããŸããZOZOãéžãã ã®ã¯ãåªããå®è·µã§ããã ãã§ãªããäžèº«ãæãã¿ãªãå ¬éããŠããæ°å°ãªãäŒæ¥ã ããã§ããæ¬èšäºã®å 容ã¯ãã¹ãŠå瀟ã®å ¬éè³æã«åºã¥ããŠããŸãã
解説ã¯ãããŒã¿ã®äžçïŒã©ã€ããµã€ã¯ã«ïŒã«æ²¿ã£ãŠ5ã€ã®ããŒãã§é²ããŸããâ ãªãéããã®ããâ¡ã©ãéããã®ããâ¢ã©ãæŽçã»èç©ããã®ããâ£ã©ãåæããã®ããâ€äœã«åœ¹ç«ãŠãŠããã®ãããŸãã¯å šäœåãäžæã®å³ã§ä¿¯ç°ããŠãããŸãããã

ãã®å³ã®ãäžããäžãžã®æµãããæ¬èšäºã®è骚ã§ãã以éã§ã¯å段ãäžã€ãã€éããŠãããŸããæè¡çšèªã¯äœ¿ããŸãããåããŠåºãŠãããã®ã«ã¯å¿ ããµã ãã®èšèã§è£è¶³ãæ·»ããŸãã
ãªãããŒã¿ãéããã®ã ââ çµå¶ã»ããžãã¹äžã®ç®ç

ä»çµã¿ã®è©±ã«å ¥ãåã«ããããããäœã®ããã«ããæŒãããŸããææ®µããå ¥ããšãæè¡ã®è©±ã«åãããŠç®çãèŠå€±ããã¡ã ããã§ããZOZOãããŒã¿ãéããåæ©ã¯ã倧ãã3ã€ã«æŽçã§ããŸãã
çç±1ïŒäžäººã²ãšãã«åã£ãè²·ãç©äœéšãã€ãããã
ZOZOTOWNã«ã¯èšå€§ãªæ°ã®ååãããããŠãŒã¶ãŒã®å¥œã¿ãåå·®äžå¥ã§ããå šå¡ã«åãç»é¢ãèŠããã®ã§ã¯ãªãããã®äººã奜ã¿ãããªååãåºãåããââããããã¬ã³ã¡ã³ãïŒãããã衚瀺ïŒã«ã¯ããŠãŒã¶ãŒã®è¡åããŒã¿ïŒäœãèŠãŠãäœãè²·ããäœããæ°ã«å ¥ãã«å ¥ãããïŒãæ¬ ãããŸãããããŒã¿ã¯ãããŒãœãã©ã€ãºãããäœéšã®çæã§ãã
çç±2ïŒäºæ¥ã®ç¶æ³ãæ£ããã»éãææ¡ãããã
ãæšæ¥ã®å£²äžã¯ãããã®æœçã®å¹æã¯ããåšåº«ã¯é©åãããçµå¶ãçŸå Žã®å€æã¯ãä¿¡é Œã§ããæ°åããã£ãŠåããŠæãç«ã¡ãŸããéèŠãªã®ã¯ãæ°åãæ£ç¢ºã§ããããšããããŠå¿ èŠãªãšãã«éãæã«å ¥ãããšã§ããåŸã§èŠãããã«ãZOZOããªã¢ã«ã¿ã€ã ã®ä»çµã¿ã«ãã ããã®ã¯ããã®ãéãããäºæ¥ã®ç«¶äºåã«çŽçµããããã§ãã
çç±3ïŒããŒã¿ãã®ãã®ããµãŒãã¹ã®äžéšã«ãããã
ZOZOã®ç¹åŸŽã¯ãããŒã¿ããåæããŠçµãããã«ããªãç¹ã«ãããŸããåæã§ã€ãã£ãææããããäžåºŠãµãŒãã¹ã®äžã«çµã¿èŸŒãã§äŸ¡å€ãçããããšãã°ãåšåº«ãæ®ã1ç¹ã«ãªã£ããããã®ååãèŠãŠãã人ã«éç¥ããããäžæ£ãªå©çšãçŽ æ©ãæ€ç¥ããããšãã£ãæ©èœã¯ãããŒã¿ã埪ç°ããŠåããŠå®çŸããŸããããŒã¿ã¯èŠããã®ã§ãããšåæã«ãåãããã®ã§ãããã®ã§ãã
ããããã€ã³ã
ãéããç®çããæç¢ºã ãããããåŸæ®µã®ä»çµã¿ã®åœ¢ã決ãŸããŸãããšãã«â¢äžäººã²ãšããžã®éå ãšâ¡éãã®è¿œæ±ããZOZOã®ã¢ãŒããã¯ãã£ããŠããŒã¯ã«ããŠããŸããç®çããå¯èŠåãã ãã«çœ®ãäŒæ¥ãšã®åããéãããã«ãããŸãã
ã©ãããŒã¿ãéããã®ã ââ åéã®ä»çµã¿ãšããŒã¿ãœãŒã¹

次ã¯ãéãæ¹ãã§ããäžå£ã«ããŒã¿ãšãã£ãŠããZOZOã®äžã§ã¯ããŸããŸãªå Žæã«ãããŸããŸãªåœ¢ã§æ£ãã°ã£ãŠããŸãããŸãã¯ãã®ãæºïŒããŒã¿ãœãŒã¹ïŒãã®å€æ§ããæŒãããŸãããã
ããŒã¿ã®æºã¯20以äžã«æ£ãã°ã£ãŠãã
ZOZOã®ããŒã¿ã¯ã瀟å ã®ãµãŒããŒã«ããåºå¹¹ã·ã¹ãã ïŒæ³šæã»åšåº«ã»äŒå¡æ å ±ãªã©ãäºæ¥ã®æ ¹å¹¹ãæ±ãäžæ žã·ã¹ãã ïŒããåãµãŒãã¹ã®ããŒã¿ããŒã¹ãå€éšã®SaaSïŒã¯ã©ãŠãäžã§äœ¿ããœããïŒãªã©ã20ãè¶ ãããœãŒã¹ã«åãããŠååšããŸããããŒã¿ããŒã¹ã®çš®é¡ãããªã³ãã¬ãã¹ïŒèªç€Ÿã§æã€ãµãŒããŒïŒã®SQL Serverãã¯ã©ãŠãäžã®MySQLãDynamoDBãªã©ããŸããŸã§ãã
ããã§ãããªã³ãã¬ãã¹ãšã¯ãã¯ã©ãŠãã§ã¯ãªãèªç€Ÿã®èšåã§ã·ã¹ãã ãåãã圢æ ã®ããšãZOZOTOWNã®æ ¹å¹¹ã¯é·å¹ŽéçšãããŠãããªã³ãã¬ã®SQL Serverã«ãããããã«æãéèŠãªæ³šæãåšåº«ã®ããŒã¿ãæ¥ã æžã蟌ãŸããŠããŸãããã®ãèªç€ŸãµãŒããŒã«ãã倧äºãªããŒã¿ããããã«ã¯ã©ãŠãã®åæåºç€ãžéã¶ããããåéã®äž»åœ¹ããŒãã«ãªããŸãã
ãå šéšãŸãšããŠ1æ¥1åããšãå€ãã£ãåã ãããããã®2æ¹åŒ
ZOZOã¯ãæ§è³ªã®ç°ãªã2ã€ã®éã³æ¹ã䜵çšããŠããŸãããããåéèšèšã®èã§ããå³2ãèŠãªããèªãã§ãã ããã

æ¹åŒAïŒæ¥æ¬¡ããã飿ºïŒå
šéšãŸãšããŠ1æ¥1åïŒ
ããããšã¯ããŸãšããŠäžæ¬åŠçããããšããæå³ã§ãã1æ¥1åãåºå¹¹ã·ã¹ãã ã®ããŒã¿ããã£ããã¯ã©ãŠããžè»¢éããŸããéã¶äœæ¥ã«ã¯EmbulkïŒãšã³ãã«ã¯ïŒãšããããŒã¿è»¢éããŒã«ã䜿ããåŠçã®æ®µåãïŒã©ããå
ã«ãã©ããåŸã«åãããïŒã¯DigdagïŒãã£ã°ãã°ïŒãšããã¯ãŒã¯ãããŒãšã³ãžã³ïŒäœæ¥ã®é çªã管çããä»çµã¿ïŒã§å¶åŸ¡ããŸããäœæãã¡ãŒã«ã¢ãã¬ã¹ãšãã£ãç§å¯æ
å ±ã¯ããã®è»¢éã®éäžã§ããã·ã¥åïŒå
ã«æ»ããªãèšå·åã«å€æããäžèº«ãäŒããããšïŒããŠããéã°ããŸãã倧éããŒã¿ã確å®ã«éã¹ãäžæ¹ãæå€§ã§1æ¥ã¶ãã®é
ããåºãã®ã匱ç¹ã§ãã
æ¹åŒBïŒãªã¢ã«ã¿ã€ã 飿ºïŒå€ãã£ãåã ããããïŒ
ãæ®ã1ç¹ã§éç¥ãã®ãããªæ©èœã«ã¯ã1æ¥é
ãã§ã¯éã«åããŸãããããã§ãããŒã¿ã«å€æŽããã£ããã®ç¬éã ããæããŠå³åº§ã«éã¶ä»çµã¿ãå¥ã«çšæããŠããŸããSQL Serverã®Change Trackingãšããæ©èœïŒãã©ã®è¡ãå€ãã£ããããèšé²ããä»çµã¿ïŒã§å€æŽç¹ãæ€ç¥ããPub/SubïŒã¡ãã»ãŒãžã確å®ã«äžç¶ããâããŒã¿ã®å®
é
䟿âã®ãããªãµãŒãã¹ïŒãçµç±ããŠBigQueryãžæµã蟌ã¿ãŸããå
šããŒã¿ãæ¯åéã¶ã®ã§ã¯ãªãå·®åã ããéã¶ã®ã§ã軜ããŠéãã®ãç¹é·ã§ãã
ããã®å·¥å€«ïŒ2ã€ãçµã¿åãããŠãææ°ç¶æ ããåçŸãã
æ¥æ¬¡ã§ãšã£ããå šéããŒã¿ããšããªã¢ã«ã¿ã€ã ã§ãšãç¶ãããå·®åããŒã¿ããéãåããããšãã¯ã©ãŠãäžã®BigQueryã«ãå ã®åºå¹¹ããŒã¿ããŒã¹ã®âããŸã®ç¶æ âãã»ãŒãªã¢ã«ã¿ã€ã ã«åçŸã§ããŸããåå°ãæ¥æ¬¡ã§æŒããããã®äžã®çްããªå€åãå·®åã§è¿œãââãã®äºæ®µæ§ããã確å®ããšéããäž¡ç«ãããå®ç³ã§ãã
ããã«èžã¿èŸŒããšãZOZOã¯ãã®ãªã¢ã«ã¿ã€ã 飿ºã®å¿èéšïŒããŒã¿ã倿ããŠéãåºãETLå±€ïŒExtract/Transform/Loadã®ç¥ã§ãæœåºã»å€æã»æžãåºããæ ãéšåïŒããè¿å¹ŽGoèšèªã§èªäœã®ããã°ã©ã ã«äœãæ¿ããŸãããèæ¯ã«ã¯ãããŒã¿éã®å¢å ã§ã¡ã¢ãªæ¶è²»ãã³ã¹ãããµããããšããçŸå®çãªèª²é¡ããããŸãããäœãæ¿ãã®çµæããã®éšåã®ãµãŒããŒè²»çšãçŽ3åã®1ïŒçŽ67%æžïŒã«ãŸã§å§çž®ããåŠçã®é å»¶ããå šããŒãã«10å以å ãã§å®å®ãããŠããŸããæŽŸæãã¯ãããŸããããããããå°éãªåèšèšã®ç©ã¿éããåºç€ã®äœåãæ¯ããŠããŸãã
ã©ã®ããã«æŽçã»èç©ããã®ãïŒåºç€ãšãã€ãã©ã€ã³

éããããŒã¿ã¯ããã®ãŸãŸã§ã¯äœ¿ããŸããã圢ããã©ãã©ã ã£ãããåãã売äžãã§ãèšç®æ¹æ³ã埮åŠã«éã£ããããããã§ãããã®ç« ã¯ãæ£ããã£ãããŒã¿ãæŽçæŽé ããŠâ䜿ããç¶æ âã«ããå·¥çšã§ããZOZOã®ã¢ãŒããã¯ãã£ã§ãã£ãšãäœã蟌ãŸããŠããéšåã§ããããŸãã
äžæ žãšãªãä¿ç®¡åº«ãBigQueryã
éã°ããŠããããŒã¿ã¯ããŸãBigQueryïŒããã°ã¯ãšãªïŒãšãã巚倧ãªããŒã¿å庫ã«éçŽãããŸããããã¯GoogleãæäŸããã¯ã©ãŠãåã®ããŒã¿ãŠã§ã¢ããŠã¹ïŒDWHïŒåæã®ããã«å€§éããŒã¿ããããŠé«éã«éèšã§ããå°çšã®ä¿ç®¡åº«ïŒã§ããèšå€§ãªããŒã¿ã§ãäžç¬ã§éèšã§ããã®ã匷ã¿ã§ãZOZOã®å šç€ŸããŒã¿ã¯ããã«äžå åãããŸãããããããããŒã¿ãããŸãããã«éãŸãããšããäžç¹éäžããåŸã®åæã楜ã«ããŸãã
ãçã®ãŸãŸãããã䜿ãã圢ããž ââ dbtã«ããæ®µéçãªå å·¥
å庫ã«å
¥ããã ãã§ã¯ããŸã çŽ æã®å±±ã§ããZOZOã¯dbtïŒãã£ãŒããŒãã£ãŒïŒãšããããŒã«ã䜿ã£ãŠãããŒã¿ã段éçã«ç£šãäžããŸããdbtã¯ãSQLïŒããŒã¿ãåãåºãããã®åœä»€æïŒã§æžããå å·¥ã®ã«ãŒã«ãæŽçãã倿Žå±¥æŽãæ®ããäŸåé¢ä¿ïŒã©ã®ããŒã¿ãã©ã®ããŒã¿ãå
ã«ããŠãããïŒã管çã§ããããŒã«ã§ããZOZOã¯ç¡åã®dbt Coreãæ¡çšããŠããŸãã
å å·¥ã¯ããããªã宿åãäœãã®ã§ã¯ãªããã¬ã€ã€ãªã³ã°ïŒå±€ã«åããŠæ®µéçã«æŽããèãæ¹ïŒã§é²ããŸããå
·äœçã«ã¯æ¬¡ã®ãããªå±€ãéããŸãã
⢠SourcesïŒãœãŒã¹ïŒïŒéã°ããŠããã°ããã®äžæ¬¡ããŒã¿ãæã€ããã®çŽ æã
⢠StagingïŒã¹ããŒãžã³ã°ïŒïŒéè€ãåãé€ãããã衚èšãæãããããäžããããã®å±€ã
⢠MartsïŒããŒãïŒïŒå®éã®åæãå©çšã«äœ¿ããä»äžãã£ãæçãå
±éã®ææšãèšç®ããäžæ žå±€ãããã«çœ®ãã
ãã®å±€åãã®çãã¯ããåãææšã¯ãåãèšç®å®çŸ©ãäžãæã§æã€ãããšã§ããããšãã°ãäŒå¡æ°ãã®æ°ãæ¹ãéšçœ²ããšã«ãã©ãã©ã ãšãäŒè°ã§æ°åãé£ãéã£ãŠè°è«ã«ãªããŸãããå ±éã®å±€ã§å®çŸ©ãäžæ¬åããŠããã°ã誰ãã©ãã§èŠãŠãåãæ°åã«ãªããå°å³ã§ãããçµç¹ã®æææ±ºå®ã®ä¿¡é Œæ§ãæ ¹ã£ãã§æ¯ããèšèšã§ãã
å å·¥ã®æ®µåããèªåã§åã ââ Cloud Composer
ãããã®å å·¥ã¯ãæ¯æ¥æ±ºãŸã£ãé çªã§ãäŸåé¢ä¿ãå®ããªããèªåå®è¡ããå¿ èŠããããŸãããã®åžä»€å¡ãCloud ComposerïŒã¯ã©ãŠãçã®Airflowã倿°ã®åŠçã®é çªåŸ ã¡ãåå®è¡ã管çããã¯ãŒã¯ãããŒãšã³ãžã³ïŒã§ããããšãã°ãå ããŒã¿ã®é£æºãçµãã£ãŠãããããã䜿ãããŒã¿ããŒããæŽæ°ããããéäžã§å€±æããåŠçã ããèªåã§ããçŽãããšãã£ã段åããã人æãä»ããåããŸãã
èŠæš¡æãè£è¶³ãããšãZOZOã®ããŒã¿åºç€ã«ã¯20以äžã®ãœãŒã¹ã·ã¹ãã ãš1,000ãè¶ ããããŒã¿ããŒããååšããŸããããã ãã®æ°ã«ãªããšãäŸåé¢ä¿ã人ãæã§è¿œãã®ã¯äžå¯èœã§ããdbtã§äŸåé¢ä¿ãæ©æ¢°å¯èªã«ç®¡çããCloud Composerã§å®è¡ãèªåå¶åŸ¡ããââãã®çµã¿åããããã£ãŠåããŠã巚倧ãªåºç€ãç Žç¶»ããã«åããŸãã
éITã®æ¹ãžã®ããšã
BigQueryãã巚倧ãªé£æå庫ããdbtããäžããããããçãä»ããŸã§ã®ã¬ã·ãéããCloud Composerããå šå¡ã®èª¿çã®æ®µåããä»åããããã³ã®æçé·ããçŽ æãéããã ãã§ãªãã誰ãäœã£ãŠãåãå³ïŒåãæ°åïŒã«ãªãããã¬ã·ããäžå 管çããŠããã®ããZOZOã®æŽçè¡ã®æ¬è³ªã§ãã
ã©ã®ããã«åæããã®ã ââ åæææ³ãšçµç¹äœå¶

æŽããããŒã¿ãããããã䜿ããŸãããã ãZOZOã®é¢çœãã¯ãåæâææ³âãã®ãã®ä»¥äžã«ããããŒã¿ãå®å šãã€äŸ¿å©ã«äœ¿ãç¶ããããã®çµç¹ãšä»çµã¿ãã«ãããŸããé ã«èŠãŠãããŸãã
çšéã§åãã3çš®é¡ã®ããã䜿ããããŒã¿ã
ZOZOã¯ãå å·¥æžã¿ããŒã¿ïŒCore DataMartsãšç·ç§°ïŒããå©çšè ã®èŠæ±ã«åãããŠ3çš®é¡ã«äœãåããŠããŸããã1ã€ã®äžèœããŒã¿ã§å šå¡ãæºè¶³ãããããšãããšãããã£ãŠå šå¡ãäžäŸ¿ã«ãªãããšããçŸå®ãžã®çãã§ããå³3ã§å šäœãèŠãŠãã ããã

â Analysis DataMartsïŒå³ææ§éèŠïŒ
ã¢ããªã¹ãããä»ãããã®æ°åãç¥ããããã«å¿ããããã®ãã¯ã€ãããŒãã«ïŒå¿
èŠãªé
ç®ã暪ã«åºããé¢åãªçµåããããã®ãŸãŸäœ¿ããæšªé·ã®è¡šïŒã§ããçŽ æ©ãæ¹ä¿®ã§ããããæè»ã«ä¿ã€ä»£ããã«ãã·ã¹ãã ããã®åç
§ã¯ååçŠæ¢ãé »ç¹ã«åœ¢ãå€ãããã®ã«æ¬çªã·ã¹ãã ãäŸåãããšã倿Žã®ãã³ã«é害ãæãããã§ãã
â¡ Data ProductsïŒå®å®æ§éèŠïŒ
ç¹å®ã®ãµãŒãã¹ã«çµã¿èŸŒãããã®ãèŠä»¶ã«100%åãããå°çšããŒã¿ã»ããã§ãããªããŒã¹ETLïŒåæåºç€ã§äœã£ãææããããäžåºŠæ¥åã·ã¹ãã ãžæ»ãææ³ïŒã§ãµãŒãã¹ã«äŸçµŠãããŸãã責任è
ãšé害æã®å¯Ÿå¿æ¹éãã¯ã£ããããŠãããããå®å®ããŠåãç¶ããŸãã
⢠Dimensional DataMartsïŒåå©çšæ§éèŠïŒ
é·ã䜿ããå
šç€Ÿå
±éã®åå°ã§ãããã£ã¡ã³ã·ã§ãã«ã¢ããªã³ã°ïŒäºå®ïŒå£²äžãªã©ã®æ°å€ãšã屿§ïŒååãäŒå¡ãªã©ã®æ
å ±ãæŽçããŠçµã¿ç«ãŠããå
ç¢ãªããŒã¿èšèšã®ææ³ïŒãæ¡çšããå°æ¥ã®ããžãã¹ã®å€åã«ãèããæ§é ã«ãªã£ãŠããŸãããããå
šç€Ÿã®SSoTïŒSingle Source of TruthïŒå¯äžã®ä¿¡é Œã§ããæ
å ±æºïŒã®äžæ žãæ
ããŸãã
åæãæ¯ããçµç¹ ââ ã3é å à è€åããŒã ã
ZOZOã¯ãããŒã¿ãããžã¡ã³ãã圹å²ã§3é åã«åããå°éå®¶ã飿ºããè€åããŒã ã§éå¶ããŠããŸãã
⢠Data PlatformïŒåºç€ãã®ãã®ã®èª²é¡è§£æ±ºãããŒã¿ãšã³ãžãã¢ããªãŒãã
⢠Core DataMartsïŒããŒã¿ãææšã®æšæºåã»ã¢ããªã³ã°ãã¢ããªãã£ã¯ã¹ãšã³ãžãã¢ããªãŒãã
⢠Data PortalïŒæŽ»çšã«å¿
èŠãªæ
å ±ã®å
¬éã»æŽçãããŒã¿ãããŒãžã£ãŒããªãŒãã
泚ç®ãã¹ãã¯ãåç€Ÿãæ²ãããäžå€®éæš©ã«ãããããé©åºŠãªåæ£ãæèããããšããæ¹éã§ãããã¹ãŠãäžéšçœ²ã§æ±ã蟌ããšçŸå Žã®ã¹ããŒããèœã¡ãéã«åéšçœ²ã«äžžæããããšå質ã厩ããããã®äžéãçããå ±éåãã¹ãéšåïŒææšã®å®çŸ©ãªã©ïŒã¯ãã£ããçµ±å¶ãã€ã€ãçŸå Žã®æè»æ§ã¯æ®ãããã®ãã©ã³ã¹æèŠãããã¬ããã³ã¹ãâ圢骞åãããã«æ©èœãããâèŠè«Šã§ãã
䜿ããããŒã¿ãå®ã ââ å質ãšã³ã¹ãã®çªäºº
䟿å©ãªåºç€ã¯ãæŸã£ãŠãããšãå質ã®å£åããšãã³ã¹ãã®èšåŒµãã«äŸµãããŸããZOZOã¯ããã«ãä»çµã¿ã§å¯ŸåŠããŠããŸãã瀟å ããŒã«CoppeïŒã³ããïŒã§ããŒã¿ã®å質ãç£èŠããç°åžžãããã°ãã£ããïŒSlackïŒãžèªåéç¥ããŸããå ±éããŒã¿ãžã®ã·ã¹ãã ããã®ã¢ã¯ã»ã¹ã¯èš±å¯å¶ã«ããã誰ãã»äœã®ç®çã§äœ¿ã£ãŠãããããç³è«ããŒã¹ã§ææ¡ãå©çšãã°ãããæ³å®å€ã®ã¢ã¯ã»ã¹ãé«é¡ãªã¯ãšãªïŒéèšåœä»€ïŒãæ¥æ¬¡ã§æ€ç¥ããä»çµã¿ãåããŠããŸãã
ã³ã¹ãé¢ã®è±¡åŸŽçãªåãçµã¿ããBIã¬ããŒãã®è³ç£æ£åžãã§ããBIïŒBusiness IntelligenceïŒããŒã«ãšã¯ãããŒã¿ãã°ã©ãã衚ã§å¯èŠåããéå ·ã®ããšãZOZOã§ã¯LookerãPower BIãTableauãªã©ã䜿ãããŠããŸãã䟿å©ããã«ã¬ããŒããåæã§ä¹±ç«ããããã誰ãèŠãŠããªãã®ã«ãè£ã§æ¯æ¥ããŒã¿æŽæ°ãèµ°ãç¶ããŠãµãŒããŒä»£ã ããããããšããç¡é§ãçãŸããŠããŸãããããã§ãéå»90æ¥éã¢ã¯ã»ã¹ã®ãªãã¬ããŒãã¯æŽæ°ãæ¢ããããä¿ããäžèŠãªã³ã¹ããæå¶ããŠããŸããäœãã ãã§ãªãç³ãä»çµã¿ãŸã§çšæããŠããç¹ããéçšã®æç床ãç©èªããŸãã
äœã«åœ¹ç«ãŠãŠããã®ã ââ å ·äœçãªæŽ»çšäºäŸãšææ

æåŸã«ããã®åºç€ãå®éã«äœãçãã§ããã®ããèŠãŸããããŒã¿ããåæããŠçµãããã§ã¯ãªãããµãŒãã¹ãçµå¶ã«éã£ãŠããââãã®å ·äœäŸã§ãã
äºäŸ1ïŒéçºã¹ããŒãã3åã®1ã«ãããæ±çšã¬ã³ã¡ã³ãã
ZOZOã¯ããŠãŒã¶ãŒãã¢ã€ãã ã®ç¹åŸŽãæ°å€ã®äžŠã³ïŒEmbeddingïŒåã蟌ã¿ãã¯ãã«ã奜ã¿ãç¹åŸŽããã³ã³ãã¥ãŒã¿ãæ±ããããæ°å€ã®åº§æšã«å€æãããã®ïŒãšããŠè¡šçŸãã䌌ããã®å士ãé«éã«æ¢ãåºãæ±çšçãªã¬ã³ã¡ã³ãã®ä»çµã¿ãæ§ç¯ããŸãããBigQueryã®ãã¯ãã«æ€çŽ¢æ©èœã掻çšããæœçããšã«äœã蟌ãã§ããæšèŠã·ã¹ãã ã䜿ãåããããã«ããã®ã§ããçµæãããæœçã§ã¯æ§ç¯æéãçŽ10é±éããçŽ3é±éãžãšçŽ3åã®1ã«ççž®ãããã¡ãŒã«çµç±ã®æµå ¥æ°ã»è³Œå ¥æ°ã®æ¹åã確èªãããŠããŸããæŽããããããŒã¿åºç€ããããããããæ°ããæœçãçŽ æ©ãæãŠããšãã奜äŸã§ãã
äºäŸ2ïŒåšåº«ãåããç¬éã«å±ãéç¥
第2ç« ã§è§Šãããªã¢ã«ã¿ã€ã 飿ºã¯ããååãæ®ã1ç¹ã«ãªã£ãã¿ã€ãã³ã°ã§ããã®ååã«é¢å¿ãæã€äººãžéç¥ããããšãã£ãæ©èœãæ¯ããŠããŸããããã¯1æ¥é ãã®ããŒã¿ã§ã¯æç«ããŸãããéãããã®ãŸãŸè²©å£²æ©äŒã«ã€ãªãããããŒã¿ã®å³æéå ã®å žåã§ããåãä»çµã¿ã¯ãäžæ£å©çšã®æ©ææ€ç¥ããæœçã®ãªã¢ã«ã¿ã€ã ãªã¢ãã¿ãªã³ã°ã«ã䜿ãããŠããŸãã
äºäŸ3ïŒå šç€Ÿãåãæ°åã§äŒè©±ã§ããç¶æ
掟æãã¯ãªããã®ã®ããã£ãšãçµå¶ã€ã³ãã¯ãã倧ããã®ãããã§ããææšã®å®çŸ©ãdbtã§äžå åããä¿¡é Œã§ããããŒã¿ãå šç€Ÿã§å ±æãããããã«ãæ£åšããŠããBIã¬ããŒããData PortalïŒç€Ÿå ã®ããŒã¿æ å ±ãäžèЧã»åé¡ããŠã誰ããç®çã®ã¬ããŒãã«ãã©ãçããããã«ããå ¥ãå£ïŒã§æŽçããå šç€Ÿãžå ¬éãããããã«ãããã䌌ãŠéãªãã¬ããŒãããŒãããäœãçŽããç¡é§ãæžããçµç¹å šäœã®æææ±ºå®ã®åå°ãæããŸããããŒã¿ããªãã³çµå¶ãšã¯ãçµå±ã®ãšãããå šå¡ãåãæ£ããæ°åãèŠãŠè°è«ã§ããç¶æ ããã€ããããšã ââZOZOã®åãçµã¿ã¯ããæããŠãããŸãã
ææãæ¯ããæ°åã®äžäŸ
æ¬èšäºã§è§Šãããå ¬éãããŠããå®éçãªææãäžèЧã«ããŠãããŸãã

ãŸãšã ââ ZOZOã®ã¢ãŒããã¯ãã£ãã©ããåªããŠããã®ã
æåŸã«ãæ¬èšäºã§èŠãŠãããåªããŠããç¹ãã5ã€ã«åçž®ããŸãã
⢠ç®çãæç¢ºïŒãå¯èŠåãã§æ¢ãããäžäººã²ãšããžã®éå
ãšéãã®è¿œæ±ãŸã§ç®çã«æ®ããŠããã
â¢ äºæ®µæ§ãã®åéïŒæ¥æ¬¡ã®å
šéãšãªã¢ã«ã¿ã€ã ã®å·®åãçµã¿åããã確å®ããšéããäž¡ç«ã
⢠äžç¹éäžïŒæ®µéå å·¥ïŒBigQueryã«éçŽããdbtã®ã¬ã€ã€ãªã³ã°ã§ãåãææšã¯åãå®çŸ©ããæ
ä¿ã
⢠çšéå¥ã®äœãåãïŒå³ææ§ã»å®å®æ§ã»åå©çšæ§ã§3çš®ã®ããŒã¿ããŒããçšæããå
šå¡ã®äžäŸ¿ãè§£æ¶ã
⢠圢骞åããªãã¬ããã³ã¹ïŒé©åºŠãªåæ£ãå質ç£èŠãã³ã¹ãã®æ£åžããŸã§ãéçšãä»çµã¿ã§æ¯ããã
ã©ãããéæ³ã®ãããªæ°æè¡ãã§ã¯ãããŸãããããããåœããåã®ããšããç®çã«æ²¿ã£ãŠãå°éã«äœã蟌ã¿ãéçšãç¶ããŠããããšãæ¬åœã®åŒ·ã¿ã§ãããããŠå瀟ãããããå ¬éãç¶ããŠããäºå®ãã®ãã®ããããŒã¿ããªãã³çµå¶ãå¿ãå€ãã®çµç¹ã«ãšã£ãŠã®éããã¹ã«ãªã£ãŠããŸããèªç€Ÿã®ããŒã¿æŽ»çšãèŠçŽããšããæ¬èšäºã®5ã€ã®åãââãªãã»ã©ãéãã»ã©ãæŽãã»ã©ãåæãã»äœã«éããââãé ã«åœãŠãŠã¿ãããšããæåã®äžæ©ãšããŠããããããŸãã
泚æ:
æ¬èšäºã¯ãçè åäººã®ææ³ããã³èå¯ã«ããšã¥ããã®ã§ãããæ ªåŒäŒç€ŸZOZOãªãã³ã«é¢ä¿å瀟ã®å ¬åŒèŠè§£ã represent ãããã®ã§ã¯ãããŸããã
å·çã«ããã£ãŠã¯ãå瀟ãå ¬éããŠããæè¡ããã°ãç»å£è³æãªã©ãããšã«ãã§ãããããæ£ç¢ºãªæ å ±ããŸãšããããåªããŸããããçè ã®çè§£äžè¶³ã«ãã誀解ãäºå®ã®åãéããå«ãŸããŠããå¯èœæ§ããããŸãããããããã誀ãããããŸããããããããããè©«ã³ç³ãäžããŸãã
ãŸããæ¬èšäºã§åç §ããæ å ±ã¯ãããŸããŸãªææã«å ¬éããããã®ã暪æçã«ãŸãšããŠããŸããããŒã¿åºç€ã¯æ¥ã é²åãç¶ããŠãããããæ¬èšäºã®å 容ãå¿ ãããææ°ã®ç¶æ ãæ£ç¢ºã«åæ ããŠãããšã¯éããªãç¹ã«ãçæãã ãããèšèŒãããæ§æãæ°å€ã¯ããããŸã§ãããæç¹ã®å ¬éæ å ±ãããšã«ããæŠèŠ³ããšãèãããã ããã°ãšæããŸãã
ãã®ããã§æ¬èšäºã¯ãZOZOã®å®æ ãå³å¯ã«ææ¡ããããšãç®çãšãããã®ã§ã¯ãããŸããããããããããŒã¿ããªãã³çµå¶ãæ¯ããã¢ãŒããã¯ãã£ã¯ããããªãµãã«çµã¿ç«ãŠãããã®ãããšããäžã€ã®åèäºäŸãšããŠãèªè ã®ã¿ãªããŸã®ãã³ãã«ãªãã°å¹žãã§ããæ£ç¢ºãªæ å ±ãææ°ã®åãçµã¿ã«ã€ããŠã¯ããã²å瀟ã®å ¬åŒãªçºä¿¡ãçŽæ¥ã確èªãã ããã
