ããŒã¿ãµã€ãšã³ãã£ã¹ããšããè·çš®ãèŒãããæªæ¥ãéœãéµãšãããäžæ¹ã§ããã®çŸå®ã¯å¿ ãããç°¡åã§ã¯ãããŸããããã®èšäºã§ã¯ãããŒã¿ãµã€ãšã³ãã£ã¹ãã®å€¢ãšçŸå®ã®ã®ã£ããã«çŠç¹ãããŠããªããããŒã¿ãµã€ãšã³ãã£ã¹ã ãããšãããšã®å£°ãäžããã®ããæ¢æ±ããŸããããžãã¹ããŒãœã³ãçŽé¢ããæåŸ ãšãã¬ãã·ã£ãŒãæ¡çšåžå Žã§ã®ãã¹ãããããã£ãªã¢ãã¹ã®é£ãããŸã§ããªã¢ã«ãªæ¥çã®å£°ããå±ãããŸãããããŠãæåãžã®ã³ãã代æ¿ãã£ãªã¢ãã¹ãæ¢ã£ãŠããããšã§ãããªãèªèº«ã®ãã£ãªã¢éžæã«åœ¹ç«ã€æŽå¯ãæäŸããŸããããŒã¿ãµã€ãšã³ã¹ã®äžçã§ã®çãæ¹ãèããããã®å§ãã®äžæ©ã«ããŸãããã
ããŒã¿ãµã€ãšã³ãã£ã¹ããšã¯äœãïŒ
ããŒã¿ãµã€ãšã³ãã£ã¹ããšã¯ãèšå€§ãªããŒã¿ãã䟡å€ããæŽå¯ãåŒãåºããããžãã¹ãç 究ã«åœ¹ç«ãŠãå°éè·ã§ãã圌ãã¯æ°åŠãçµ±èšåŠã®é«åºŠãªç¥èãé§äœ¿ããããŒã¿ã®è§£æãã¢ãã«æ§ç¯ãè¡ãããšãæ±ããããŸãã
ãã®è·çš®ã¯ãã€ãŠã¯ãã¶ã»ã»ã¯ã·ãŒãªè·æ¥ããšãŸã§åŒã°ããäŒæ¥ããã®æåŸ ã¯éåžžã«é«ãŸããŸããããããããã®å®æ ãå¿ èŠãšãããã¹ãã«ã»ããã«ã€ããŠã¯ããã°ãã°èª€è§£ãçããŠããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã«æ±ããããã®ã¯ããã ããŒã¿ãçºããŠããã ãã§ã¯ãªããå®éã«ãã®ããŒã¿ãå ã«ææ決å®ãè¡ããããžãã¹ææã«è²¢ç®ããããšãéèŠèŠãããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®çæ³ãšçŸå®
å€ãã®äººãããŒã¿ãµã€ãšã³ãã£ã¹ãã®ãã£ãªã¢ã«é äºãããã®ã¯ããã®çæ³åã«åŒãããããã§ããçæ³ãšããŠã¯ãããŒã¿ãé§äœ¿ããŠæªç¥ã®æŽå¯ãçºèŠããäŒæ¥ã®ã€ãããŒã·ã§ã³ãæšé²ããããšãæããããŸãã
ãããçŸå®ã¯ãããŒã¿ã®ã¯ãªãŒãã³ã°ãååŠçã«å€ãã®æéãè²»ãããåæãããããŒã¿ã®è³ªãæŽåæ§ã«æ©ãŸãããå Žåãå€ãã®ã§ãããŸããçµæãããžãã¹ã«æŽ»ããããã®ã³ãã¥ãã±ãŒã·ã§ã³èœåãéèŠã§ãã
åæçµæãäŒããããã®ã¹ããŒãªãŒããªã³ã°èœåããéæè¡çãªã¹ã¿ãããšã®é£æºããããŒã¿ãµã€ãšã³ãã£ã¹ãã«ãšã£ãŠæ¬ ãããªãã¹ãã«ãšãªã£ãŠããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®ä»äºå 容
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®ä»äºå 容ã¯å€å²ã«ããããŸããããŒã¿ã®åéã»åŠçããå§ãŸããçµ±èšçãªåæãäºæž¬ã¢ããªã³ã°ãæ©æ¢°åŠç¿ã®é©çšãšç¶ããŸãã
å ããŠã圌ãã¯åæçµæãå¯èŠåããæè¡ãšéæè¡ã®äž¡æ¹ã®ã¹ããŒã¯ãã«ããŒã«å¹æçã«äŒãã圹å²ãæããå¿ èŠããããŸãã
ãŸãããããžã§ã¯ãã®ç®çã«å¿ããŠæé©ãªããŒã«ãã¢ãããŒããéžå®ããæã«ã¯æ°ããã¢ã«ãŽãªãºã ã®éçºã«ãæºããããšããããŸãã
æ±ããããã¹ãã«ã»ãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã«ãªãããã«ã¯ãçµ±èšåŠãæ°åŠãããã°ã©ãã³ã°ã¹ãã«ãäžå¯æ¬ ã§ããç¹ã«ãPythonãRãšãã£ãããã°ã©ãã³ã°èšèªã«ç²ŸéããŠããå¿ èŠããããŸãã
ããã«ãããŒã¿ããŒã¹ç®¡çãã¯ã©ãŠãã³ã³ãã¥ãŒãã£ã³ã°ã®ç¥èãæ±ãããã倧éã®ããŒã¿ãåãæ±ãéã«ã¯ãããŒã¿ãšã³ãžãã¢ãªã³ã°ã®ã¹ãã«ãéèŠã§ãã
ãã®äžã§ãããžãã¹ã®ç¥èãæããããŒã¿ãéããŠäŒç€Ÿã®ç®æšéæã«å¯äžããèœåãå¿ èŠãšãªããŸããããŒã¿ã ãã§ã¯ãªãããã®èæ¯ã«ããããžãã¹ããã»ã¹ãç解ããããšãæ±ããããã®ã§ãã
æ¥çã§ã®ããŒã¿ãµã€ãšã³ãã£ã¹ãã®åœ¹å²
åæ¥çã«ãããŠããŒã¿ãµã€ãšã³ãã£ã¹ãã¯ãããã°ããŒã¿ãæ±ãããšãå¢ããçŸä»£ã«ãããŠéèŠãªåœ¹å²ãæãããŸãã圌ãã¯ããŒã¿é§åã®ææ決å®ãå¯èœã«ãã競äºåªäœæ§ãããããããšãã§ããŸãã
å¥åº·ãéèãå°å£²ã補é æ¥ãªã©å¹ åºãåéã§ãããŒã¿ãµã€ãšã³ãã£ã¹ãã¯é¡§å®¢ã®è¡åæŽå¯ããªã¹ã¯ã®è©äŸ¡ã補åã®æé©åãªã©ã®ããã®åæãè¡ããŸãã
ããããæè¡ã®é²åã«äŒŽããèªååããŒã«ãå¢ããŠããããšãããããŒã¹ããªåŠç¿ãšã¹ãã«ã®ã¢ããããŒãããããŒã¿ãµã€ãšã³ãã£ã¹ãã«ã¯åžžã«æ±ããããŠããŸãã
ãªããããŒã¿ãµã€ãšã³ãã£ã¹ã ãããšãããšèšãããã®ã
è¿å¹ŽããããŒã¿ãµã€ãšã³ãã£ã¹ã ãããšãããšããèšèãè³ã«ããããšãå¢ããŠããŸããããã¯äœãæŒ ç¶ãšããäžå®ãç œãããã®èšèã§ã¯ãããŸãããçŸå®ã«ããŒã¿ãµã€ãšã³ãã£ã¹ãã®è·æ¥ã«å¯ŸããŠæ±ãããŠããæžå¿µãããã®ãã¬ãŒãºã«ã¯èŸŒããããŠããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã¯ãäŒæ¥ã®ããŒã¿ã解æããããžãã¹ã«ãšã£ãŠäŸ¡å€ããæŽå¯ãæäŸãã圹å²ãæ ã£ãŠãããšãããŸãããããããã®éèŠãšå®æ ãšã®éã«ã¯ãããã€ãã®èªèã®éœéœ¬ãååšããã®ã§ãã
æ¬èšäºã§ã¯ãããŒã¿ãµã€ãšã³ãã£ã¹ãã®è·ã«å¯Ÿãã幟ã€ãã®æžå¿µç¹ã詳现ã«èª¬æãããã®èæ¯ã«ããåé¡ç¹ãæããã«ããŠãããŸãã
æ¡çšåžå Žã®ãã¹ããã
æ¡çšåžå Žã§ã®ãã¹ãããã¯ãããŒã¿ãµã€ãšã³ãã£ã¹ããšããè·æ¥ã«å¯Ÿããäžå®ã®å€§ããªåå ã®äžã€ã§ããå€ãã®äŒæ¥ãããŒã¿ãµã€ãšã³ãã£ã¹ããæ±ããŠããäžæ¹ã§ãå¿åè ãæã€ã¹ãã«ã»ãããšäŒæ¥ãæ±ããã¹ãã«ã»ããã«ã¯å€§ããªéããããããŸãã
äŒæ¥åŽã¯ããŒã¿ãµã€ãšã³ãã£ã¹ãã«å¯ŸããŠãé«åºŠãªçµ±èšåŠã®ç¥èã ãã§ã¯ãªããããžãã¹ã®æŽå¯åãã³ãã¥ãã±ãŒã·ã§ã³èœåãŸã§ããèŠæ±ãããŸããããããå®éã®ãšãããããããå šãŠã®èŠçŽ ãå ŒãåããŠãã人æã¯çšã§ããããã®çµæãæ¡çšåžå Žã«ãºã¬ãçããŠããŸãã
ãŸããé床ãªæåŸ ã誀解ããããããããŒã¿ãµã€ãšã³ãã£ã¹ãã®åœ¹å²ã«ã€ããŠæ£ããç解ããŠããªãäŒæ¥ãå°ãªããããŸãããæ±ããã¹ãã«ãäžæ確ã§ãããããã«ãæ¡çšåŸã圹å²ã®äžäžèŽãé¡åšåãããã©ã¹ãã¬ãŒã·ã§ã³ãçãŸããããç¶æ³ã«ãããŸãã
æåŸ ãããææãšã®ã®ã£ãã
å€ãã®äŒæ¥ãããŒã¿ãµã€ãšã³ãã£ã¹ãã«å¯ŸããŠãããžãã¹äžã®å³æŠåãšãªãããšãæåŸ ããŠããŸããã«ãããããããé«åºŠãªå°éç¥èãèŠãããã®è·æ¥ã¯ãçæéã®å ã«ææãåºãããã®ã§ã¯ãããŸããã
ããŒã¿ã«æœããã¿ãŒã³ãåŸåãèŠåºãããããããžãã¹äŸ¡å€ã«è»¢æããã«ã¯æéãšçµéšãå¿ èŠã§ããããããå€ãã®äŒæ¥ã§ã¯ãã®ããã»ã¹ã«å¯ŸããŠç解ãäžè¶³ããŠãããäžæºãçãŸããåå ãšãªã£ãŠããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãèªèº«ããäŒæ¥ãæ±ãéçŸå®çãªæåŸ å€ã«ãã¬ãã·ã£ãŒãæããè·æ¥ãšããŠã®æç¶å¯èœæ§ã«ã€ããŠæžå¿µãæ±ãããã«ãªã£ãŠããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®ãã£ãªã¢ãã¹
ããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠã®ãã£ãªã¢ãã¹ã¯éåžžã«äžéæã§ãããåŸäºããè ã«ãšã£ãŠå°æ¥ã«å¯Ÿãã確å®ãªèŠéããç«ãŠã«ããã®ãçŸå®ã§ããç¹å®ã®å°éåéã§ã¹ãã«ã極ãããšããŠããããã次ã®è·ã«ã©ã®ããã«æŽ»ããããã®ãäžæçãªç¹ãå€ãã§ãã
å ããŠãæè¡ã®æ¥éãªé²åã«ãã£ãŠå¿ èŠãšãããã¹ãã«ã»ããã絶ããå€ããããã®ããã«åžžã«ææ°ã®ç¥èãåŠã³ç¶ããªããã°ãªããŸããããã®ãããªç°å¢ã¯ããã£ãªã¢ã®å®å®æ§ãçºå±æ§ã«å¯ŸããŠããã¬ãã£ããªåœ±é¿ãåãŒããŠããŸãã
äŒæ¥åŽããŸããããŒã¿ãµã€ãšã³ãã£ã¹ãã®èœåãã©ã®ããã«è©äŸ¡ãããã£ãªã¢ãæ¯æŽããŠããã¹ããã«ã€ããŠãæ確ãªåºæºãæã¡åãããŠããªãã®ãäžè¬çã§ãã
ã¢ã«ããã¢ãšããžãã¹ã®ã¹ãã«ã®ã£ãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã«æ±ããããã¢ã«ãããã¯ãªç¥èãšãå®éã®ããžãã¹çŸå Žã§å¿ èŠãšãããã¹ãã«ã®éã«ã¯å€§ããªã®ã£ãããååšããŸããå€ãã®ããŒã¿ãµã€ãšã³ãã£ã¹ããåŠè¡ç 究ãçè«çãªèæ¯ãæã£ãŠããäžæ¹ã§ãããžãã¹ã®åé¡è§£æ±ºã«çŽæ¥çãªã¹ãã«ãäžè¶³ããŠããããšããã°ãã°ææãããŸãã
ããã«ã¯ã倧åŠãæè²æ©é¢ãæäŸããã«ãªãã¥ã©ã ãããžãã¹ã®çŸå®ãšä¹é¢ããŠããããšãäžå ãšãããŠããŸããå®è·µçãªãããžã§ã¯ããããžãã¹ã±ãŒã¹ã¹ã¿ãã£ãžã®é²åºãå åã§ã¯ãªããããå®éã®è·å Žã«å ¥ã£ãéã«èŠåŽããããšãå€ãã®ã§ãã
åŸã£ãŠãããŒã¿ãµã€ãšã³ã¹ãã«ãšã£ãŠã¯ãããžãã¹ã»ã³ã¹ã磚ããã³ãã¥ãã±ãŒã·ã§ã³èœåãé«ããããšãéèŠã ãšãããŠããŸãããããããããã®ã¹ãã«ã¯çæéã§èº«ã«ã€ãããããã®ã§ã¯ãªããçŸå Žã§ã®çµéšãéããŠåŸã ã«ç¿åŸããå¿ èŠããããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®ãã£ãªã¢ã®çŸå®
å€ãã®è¥æå°é家ã泚ç®ããããŒã¿ãµã€ãšã³ãã£ã¹ããšããè·æ¥ã§ããããã®å®æ ã¯ãã°ãã°èª€è§£ãããŠããŸããããã§ã¯ããã®ãã£ãªã¢ãã¹ãéžã¶äžã§ç¥ã£ãŠããã¹ãå®éã®ç¶æ³ãã話ãããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã¯ãããã°ããŒã¿ãçšããåæãäºæž¬ã¢ãã«ã®æ§ç¯ãè¡ããŸãããããã«ã¯é«åºŠãªå°éç¥èãšå€æ§ãªã¹ãã«ãå¿ èŠã§ããä»äºå 容ã®ç解äžè¶³ãåžå Žã®å€åã«ãããæåŸ ãšç°ãªããã£ãªã¢ã«ãªãããšãå°ãªããããŸããã
ãã®èšäºãéããŠãããŒã¿ãµã€ãšã³ãã£ã¹ããç®æãæ¹ã ããå®éã®æ¥åããã£ãªã¢ã®å±éãä»äºã®æºè¶³åºŠããããŠåžå Žã§ã®ç«¶äºãªã©ãèæ ®ããäžã§ããã®è·çš®ã«ã€ããŠããæ·±ãç解ãåŸãããšãã§ããã°ãšæããŸãã
æ¥çš®ã«ããä»äºã®éã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®ä»äºå 容ã¯ãå€åããæ¥çš®ã«ãã£ãŠå€§ããç°ãªããŸããéèãå»çããã¯ãããžãŒãå°å£²ãªã©ãåæ¥çã§æ±ããããããŒã¿åæã®ã¹ãã«ãšå¿çšãéããããå°éæ§ãéåžžã«éèŠã«ãªããŸãã
äŸãã°ãéèæ¥çã§ã¯ãªã¹ã¯ç®¡çãè©æ¬ºæ€åºã®ããã®äºæž¬ã¢ãã«ãæ±ããããããšãå€ããå»çæ¥çã§ã¯æ£è ã®æ²»ççµæãäºæž¬ããããã®çµ±èšã¢ãã«ãå¿ èŠãšãããŸãããããã®ç¹å®åéã«ç²Ÿéããããšã¯ãæ±è·è ã«ãšã£ãŠäžã€ã®éå£ãšãªãããšããããŸãã
ããã«ãæ¥çš®ã«ãã£ãŠã¯ãããŒã¿åéã®æ¹æ³ãå©çšå¯èœãªããŒã«ãç°ãªããããããã®æ¥çç¹æã®èŠå¶ãå«çåé¡ã«ã粟éããŠããå¿ èŠããããŸãã
ãã£ãªã¢ã¢ããã®é£æ床
ããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠã®ãã£ãªã¢ãç©ã¿éããŠããäžã§ãå€ãã®å°é家ãçŽé¢ããã®ããã£ãªã¢ã¢ããã®é£ããã§ãã é«åºŠãªæè¡ãšçµéšãå¿ èŠãšãããè·çš®ã§ããäžæ¹ã§ãäžäœããžã·ã§ã³ãžã®ç«¶äºãéåžžã«æ¿ãããªã£ãŠããŸãã
æåããããã«ã¯ãåã«æè¡çãªã¹ãã«ã磚ãã ãã§ãªããããžãã¹æŠç¥ããªãŒããŒã·ããèœåã身ã«ã€ããããšãæ±ããããŸãããããã®èœåã¯ãå®éã«ã¯è·å Žã§ã®çµéšãéããŠåŸã ã«ç²åŸããŠãããã®ã§ãããæéãšåŽåãèŠããããã»ã¹ã§ãã
ããã«ãé«ãå°éæ§ãæããããŒã¿ãµã€ãšã³ãã£ã¹ãã管çè·ã«å°±ãããšã¯çšã§ããããã®ããã«ã¯å€æ¹é¢ã§ã®å®çžŸãå¿ èŠãšãªããŸãã
ä»äºã®æºè¶³åºŠãšã¹ãã¬ã¹
ä»äºã®æºè¶³åºŠã«é¢ããŠèšãã°ãããŒã¿ãµã€ãšã³ãã£ã¹ãã¯è§£æã«ãã£ãŠæ°ããªçºèŠãããããšã§å€§ããªãããããæããããšãã§ããŸãã
ããããåžžã«ææ¥ãææã«è¿œãããç¶æ³ã§åãããšã¯ãã¹ãã¬ã¹ã®å€§ããªåå ãšããªããŸããããã«ãããŒã¿åéãã¯ãªãŒãã³ã°ãšãã£ãå°å³ã§ç ©éãªäœæ¥ã«å€ãã®æéãå²ãå¿ èŠããããããããã«å¯Ÿããå¿èãå¿ èŠãšãããŸãã
äŒæ¥ã®çµå¶å±€ãä»ã®éšçœ²ãšã®ææçéãå¿ èŠã§ãããåæã®éèŠæ§ãç解ããŠãããããšãé£ããå Žåãããããããã¹ãã¬ã¹ã®äžå ãšãªãããšããããŸãã
転è·åžå Žã§ã®ç«¶äºç
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®éèŠã¯åŒãç¶ãé«ããã®ã®ã転è·åžå Žã§ã®ç«¶äºã¯ããªãæ¿ãããªã£ãŠããŸããç¹ã«ãå®åçµéšã®ããæèœãªäººæã«å¯ŸããéèŠã¯é«ããã®ã®ãæ°åè ãæªçµéšè ãçŽé¢ãã競äºã¯å³ãããã®ããããŸãã
æ°ããªããžã·ã§ã³èªäœã¯å¢å ããŠãããã®ã®ãåè£è éã§ã®æè¡ãçµéšã®ç«¶äºãæ¿åããŠãããç¹ã«å°éåéã§ç®ç«ã£ãå®çžŸãã¹ãã«ãæã€äººæãæå©ãšãããŠããŸãã
転è·ãèããéã«ã¯ãèªèº«ã®ã¹ãã«ã»ãããæ確ã«ããããŒãºã«åãããã¢ããŒã«ãæ±ããããã®ã§ãç¶ç¶çãªåŠç¿ãšæè¡ã®æŽæ°ãäœãããéèŠã§ãã
ããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠæåããããã«ãããã€ãã®éèŠãªã¹ããããèžãå¿ èŠããããŸãããã®èšäºã§ã¯ããã®éãæ©ã¿å§ããããã®éèŠãªæ å ±ãæäŸããããšæããŸãã
ããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠæåããããã«
å¿ èŠãªåŠç¿ãšçµéš
ããŒã¿ãµã€ãšã³ãã£ã¹ãã«ãªãããã«ã¯ãé«åºŠãªçµ±èšåŠãæ©äŒåŠç¿ãããã°ã©ãã³ã°ã¹ãã«ãå¿ èŠã§ãããããã®ã¹ãã«ã¯ãæ§ã ãªãªã³ã©ã€ã³ã³ãŒã¹ãå°éçãªãã¬ãŒãã³ã°ããã°ã©ã ãéããŠç¿åŸããããšãã§ããŸããã³ãŒãã£ã³ã°èœåãšããŠã¯ãPythonãRã®ãããªããŒã¿è§£æãåŠçã«é©ããèšèªãåŠã¶ããšã倧åã§ãã
ãŸããå®åçµéšãç©ãããšã¯æ¥µããŠéèŠã§ããã€ã³ã¿ãŒã³ã·ããããããžã§ã¯ãã®ä»äºãéããŠãçŸå®ã®ããŒã¿åé¡ã解決ããæ¹æ³ãåŠã³ãŸããåŠãã çè«ãå®éã®ããžãã¹ã®æµãã«çµ±åããã©ã®ããã«ããŒã¿ããæçšãªæŽå¯ãåŒãåºããããç解ããããšãå¿ é ã§ãã
ããã«ãããŒã¿åæã®ããã®é«åºŠãªããŒã«ããœãããŠã§ã¢ã®äœ¿ãæ¹ã«ãæ £ããå¿ èŠããããŸããããŒã¿ã®å¯èŠåãåŠçã®ããã«TableauãExcelãæŽã«ã¯ããŒã¿ããŒã¹ãæäœããããã®SQLã®ãããªæè¡ã身ã«ä»ããªããã°ãªããŸããã
æ¥çããŒãºãç解ãã
ããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠæåããããã«ã¯ãåžå Žã®ååãæ¥çãžã®æ·±ãç解ãæ±ããããŸããã©ã®æ¥çãããŒã¿ã掻çšããŠæŠç¥ãç«ãŠãŠãããããããããã®ã»ã¯ã¿ãŒãçŽé¢ããŠãããŠããŒã¯ãªææŠã«å¯Ÿå¿ã§ããå°éç¥èãæã€ããšã䟡å€ãçã¿åºããŸãã
ããã«ã¯ãç¹å®ã®æ¥çã®ããžãã¹ã¢ãã«ã顧客ã®è¡åã競åä»ç€Ÿã®ååãªã©ãåºç¯ãªç¥èãå¿ èŠã§ãããããã®ç¥èã¯ãç¬èªã®ããŒã¿ã»ããã解æããå®è¡å¯èœãªæŽå¯ãæäŸããã ãã§ãªããæ¥çã«åœ±é¿ãäžãã倧ããªãã¬ã³ããäºæž¬ããã®ã«ã圹ç«ã¡ãŸãã
æ¥çå¥ã®ããŒã¿ãæ±ãéã«ã¯ãèŠå¶ãæ³çãªèŠä»¶ã«ã粟éããŠããªããã°ãªããŸãããäŸãã°ãéèããã«ã¹ã±ã¢ã®åéã§ã¯ãããŒã¿ãã©ã€ãã·ãŒãšã»ãã¥ãªãã£ãéåžžã«éèŠã§ããããããã®èŠä»¶ãç解ãéµå®ããããšãããããã®ã»ã¯ã¿ãŒã§åãããŒã¿ãµã€ãšã³ãã£ã¹ãã«ã¯å¿ èŠäžå¯æ¬ ã§ãã
ãããã¯ãŒãã³ã°ãšãã£ãªã¢æ§ç¯
ãããã§ãã·ã§ãã«ãªãããã¯ãŒãã³ã°ã¯ãããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠã®ãã£ãªã¢ãç¯ãäžã§éåžžã«éèŠã§ããæ¥çã®ã€ãã³ããã³ã³ãã¡ã¬ã³ã¹ã«åå ããããšã§ãåãåéã®ãããã§ãã·ã§ãã«ãšã€ãªãããç¥èãå ±æãã貎éãªæŽå¯ãåŸãããšãã§ããŸãã
ããã«ãLinkedInã®ãããªãããã§ãã·ã§ãã«ãªãœãŒã·ã£ã«ã¡ãã£ã¢ãã©ãããã©ãŒã ã掻çšããããšããã£ãªã¢ãç¯ãããã«ã¯äžå¯æ¬ ã§ãããããã®ãã©ãããã©ãŒã ãéããŠãä»äºã®æ©äŒãèŠã€ããããå°é家ãšã®é¢ä¿ãç¯ããããææ°ã®æ¥çååã«ã€ããŠè©±ãåãããšãå¯èœã§ãã
ãŸãã匷åãªããŒããã©ãªãªãæ§ç¯ããããšã¯ãæœåšçãªéçšäž»ãããªãã®ã¹ãã«ãšçµéšã«æ³šç®ããããã®æãããæ¹æ³ã®äžã€ã§ãããããžã§ã¯ããææç©ãå ¬éããããšã§ãæè¡çèœåã ãã§ãªããè€éãªããŒã¿åé¡ãå¹æçã«è§£æ±ºã§ããããšã瀺ããŠãã ããã
ãã¬ãŒã ã¯ãŒã¯ãšã¡ãœãããžãŒ
ããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠæåããããã«ã¯ãé©åãªãã¬ãŒã ã¯ãŒã¯ãã¡ãœãããžãŒã®ç¥èãå¿ èŠã§ããããã«ã¯ãããŒã¿ã®åéãæž æãçµ±åãåæã«äœ¿çšãããæ§ã ãªæè¡ãææ³ãå«ãŸããŸãã
ããšãã°ãããŒã¿ã®ååŠçã«ã¯ç¶¿å¯ãªã¢ãããŒããå¿ èŠã§ããããã®ããã«ã¯CRISP-DMãSEMMAã®ãããªããŒã¿ãã€ãã³ã°ããã»ã¹ã¢ãã«ãç解ããŠããã¹ãã§ãããŸããããŒã¿ã®å質ãä¿ã€ããã®ç®¡çæè¡ããããŒã¿ã®æ€èšŒãšåŠçã®ããã®èªååãããã¯ãŒã¯ãããŒãèšèšããèœåãäžå¯æ¬ ã§ãã
æŽã«ãããã°ããŒã¿æè¡ã®é²åã«äŒŽããHadoopãSparkã®ãããªåæ£åŠçãã¬ãŒã ã¯ãŒã¯ãåŠã¶ããšãå¢ããŠããŸãããããã®æè¡ã«æ £ããããšã§ã倧èŠæš¡ãªããŒã¿ã»ãããå¹ççã«æ±ãããã粟å¯ãªæŽå¯ãåŸãããšãã§ããããã«ãªããŸãã
ãã®èšäºããããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠæåããããã®æŽå¯ãæäŸããäžå©ãšãªãã°å¹žãã§ããããŒã¿ãµã€ãšã³ã¹ã®åéã¯æ¥ã é²åããŠãããããåžžã«åŠã¶å§¿å¢ãæã¡ç¶ããããšãéèŠã§ãã
代æ¿ãã£ãªã¢ãã¹ïŒããŒã¿ãµã€ãšã³ãã£ã¹ã以å€ã®éžæè¢
ããŒã¿ã¢ããªã¹ããšã¯
ããŒã¿ã¢ããªã¹ãã¯ãããŒã¿ãç解ã解éããããšã§ãããžãã¹ã«ãšã£ãŠæçšãªã€ã³ãµã€ããæäŸãã圹å²ãæ ããŸãã圌ãã¯éããããããŒã¿ãã¯ã¬ã³ãžã³ã°ããçµ±èšçãªåæãè¡ããçµæãèŠèŠçã«è¡šçŸããããšã§çµç¹ã®ææ決å®ãæ¯ããŸãã
ããŒã¿ã¢ããªã¹ãã«ãšã£ãŠéèŠãªã¹ãã«ã«ã¯ãçµ±èšç¥èãSQLãExcelãšãã£ãããŒã¿ãã³ããªã³ã°ããŒã«ã®äœ¿ãæ¹ãããã«ã¯ããŒã¿å¯èŠåã®ããã®ããŒã«ã®ç¥èãå«ãŸããŸãããããã®ã¹ãã«ã¯åŠã¶ããšãå¯èœã§ãããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠã®é«åºŠãªããã°ã©ãã³ã°èœåãæ©æ¢°åŠç¿ã®å°éç¥èãå¿ èŠãšããŸããã
åžå Žã«ã¯ããŒã¿ã¢ããªã¹ããæ±ãã声ãå€ããããããã®ãã£ãªã¢ãåèããŠããè ã«ãšã£ãŠé åçãªéžæè¢ã®ã²ãšã€ã§ãããŸããããŒã¿é§ååã®ææ決å®ãé²ãäžã§ã圌ãã®éèŠæ§ã¯ä»åŸãå¢ããŠè¡ãã§ãããã
ããŒã¿ãšã³ãžãã¢ãªã³ã°ã®é
ããŒã¿ãšã³ãžãã¢ãšã¯ãããã°ããŒã¿ã®ã€ã³ãã©ãæ§ç¯ããŠç®¡çãããããã§ãã·ã§ãã«ã§ããããŒã¿ãµã€ãšã³ã¹ã®ãããžã§ã¯ãã§ã¯åæã®ããã«æŽã£ãããŒã¿ãå¿ èŠã§ããããããæäŸããã®ããã®è·çš®ã®äž»ãªåœ¹å²ã§ãã
ããŒã¿ãšã³ãžãã¢ã®èŠæ±ãããã¹ãã«ã»ããã«ã¯ãããŒã¿ããŒã¹ç®¡çãããŒã¿ãŠã§ã¢ããŠãžã³ã°ãETLïŒæœåºã»å€æã»èªã¿èŸŒã¿ïŒããã»ã¹ãã¯ã©ãŠããã©ãããã©ãŒã ãžã®ç解ãå«ãŸããŸãããŸããããã°ã©ãã³ã°ã¹ãã«ãæ¬ ããããPythonãScalaãªã©ãæ±ããããããšãå€ãã§ãã
ãã®åéãžã®éèŠã¯é«ãŸã£ãŠãããããŒã¿ãããžãã¹ã«ãããã䟡å€ãå¢ãã«ã€ããŠéèŠæ§ãé«ããªã£ãŠããŸãããšã³ãžãã¢ãªã³ã°ã«èå³ãããããããŒã¿ãµã€ãšã³ãã£ã¹ãã®éã¯é¿ããã人ã«ãšã£ãŠãããŒã¿ãšã³ãžãã¢ã¯éåžžã«è¯ã代æ¿ãã£ãªã¢ãã¹ãšãªãã§ãããã
ããžãã¹ã€ã³ããªãžã§ã³ã¹å°é家
ããžãã¹ã€ã³ããªãžã§ã³ã¹ïŒBIïŒå°é家ã¯ãããžãã¹ã®ããã©ãŒãã³ã¹æ¹åã«çŽçµããããŒã¿ã«çŠç¹ãåœãŠãŸãã圌ãã¯èšå€§ãªéã®ããŒã¿ããæå³ã®ããæ å ±ãæœåºãããã®æ å ±ã䜿ã£ãŠäŒæ¥ã®æŠç¥ç«æ¡ãæ¥çžŸåæãªã©ãè¡ããŸãã
BIå°é家ã¯äž»ã«ãããŒã¿ãŠã§ã¢ããŠã¹ã®éçšããªã³ã©ã€ã³åæåŠçïŒOLAPïŒãããŒã¿ãã€ãã³ã°çãé§äœ¿ããŸããããã«ããã¬ããŒãã£ã³ã°ãããã·ã¥ããŒãã®äœæãå¯èœã«ãªããçµçã®ãªãŒããŒãææ決å®è ãè¿ éãã€å¹æçãªå€æãè¡ããããã«æ¯æŽããŸãã
ããŒã¿ãµã€ãšã³ã¹ã®å°éæè¡ã«æµæãããããã©ãããŒã¿ã®åãä¿¡ãã人ã ã«ãšã£ãŠãããžãã¹ã€ã³ããªãžã§ã³ã¹ã¯ãŽã£ããã®ãã£ãªã¢ãã¹ãããããŸããã
ããŒã¿ãµã€ãšã³ã¹ã®é£æ¥è·çš®
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®ãã¹ãé©ããªããšæããŠããããŒã¿ã«é¢ããæ§ã ãªé£æ¥è·çš®ã«æ³šç®ããããšã§ãããŒã¿ã®äžçã§æŽ»èºããéãèŠåºãããšãã§ããŸããããšãã°ãããŒã±ãã£ã³ã°ã¢ããªã¹ãããã¡ã€ãã³ã·ã£ã«ã¢ããªã¹ãããªã¹ã¯ç®¡çãªã©ããããŸãã
ãããã®è·çš®ã¯ããŒã¿ã掻çšããèœåãæ±ããããŸãããããŒã¿ãµã€ãšã³ãã£ã¹ãã»ã©ã®é«åºŠãªå°éæè¡ãè€éãªã¢ãã«æ§ç¯ã¯å¿ èŠãšãããŸãããããã§ãããããã®è·çš®ã¯çµç¹å ã§ããŒã¿ã«åºã¥ããææ決å®ãè¡ãäžã§éåžžã«éèŠãªåœ¹å²ãæãããŠããŸãã
çµå±ã®ãšãããèªåã«ãšã£ãŠæãé©ãããã£ãªã¢ãã¹ãèŠã€ããã«ã¯ãå人ã®èå³ãã¹ãã«ããããŠé·æçãªç®æšã«åºã¥ããŠæ€èšããããšãäžå¯æ¬ ã§ããããŒã¿ãµã€ãšã³ã¹ã®åéã¯å€å²ã«ããããããæ§ã ãªéžæè¢ã®äžããèªåã«åã£ããã®ãèŠã€ãåºããŸãããã
èªè ã®äœéšè«ïŒããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠã®ç掻
ããŒã¿ãµã€ãšã³ãã£ã¹ãã®æ¥åžž
å€ãã®ããŒã¿ãµã€ãšã³ãã£ã¹ãã¯ãèšå€§ãªéã®ããŒã¿ã«æ¥ã åãåããããŒã¿ã¯ã¬ã³ãžã³ã°ãåæãã¢ããªã³ã°ãªã©ãè¡ããŸãããã®å埩äœæ¥ã«ã¯é«ãéäžåãšç²Ÿå¯ãªãã¯ããã¯ãå¿ èŠã§ãããç·»å¯ãªã¢ãããŒããæ¥åžžãšãªã£ãŠããŸãã
ããããããã ããããŒã¿ãµã€ãšã³ãã£ã¹ãã®å šãŠã§ã¯ãããŸãããããŒã ãšååããŠåé¡ã解決ããã³ãã¥ãã±ãŒã·ã§ã³èœåããããžã§ã¯ãã®ææãåãããããäŒãããã¬ãŒã³ããŒã·ã§ã³èœåãéèŠã§ãããããã®ã¹ãã«ã®ãã©ã³ã¹ããšãããšããæ¥ã ã®ææŠã圢äœããŸãã
äžéšã®äººã¯ãããŒã¿ãµã€ãšã³ãã£ã¹ãã®ä»äºãå調ã ãšæããããšãããããã§ããã¯ãªãšã€ãã£ããã£ãæ±ããæ¹ã«ãšã£ãŠã¯ãã«ãŒãã³ã¯ãŒã¯ãå€ãããšããã¡ãªããã«æããããå ŽåããããŸãã
æåãšå€±æã®ã¹ããŒãªãŒ
ãã£ãªã¢ã®äžã§å€§ããªææãäžããããŒã¿ãµã€ãšã³ãã£ã¹ããããã°ãæåŸ ã«å¿ããããšãã§ããã«è»¢è·ãäœåãªãããã人ãããŸããæåã®ã«ã®ã¯ãæè¡åã ãã§ãªãããžãã¹ãžã®ç解ãšããŒã¿ããåŸãããã€ã³ãµã€ããå®éã®ææ決å®ã«ã©ãçµã³ä»ãããã«ãããŸãã
äžæ¹ã§ããããžã§ã¯ããæåŸ éãã®çµæã«çµã³ã€ããªãããšãå°ãªããããŸããã倱æããåŠã³ãæé·ããèœåãè©ŠãããŸãããããã®äœéšè«ã¯ãããŒã¿ãµã€ãšã³ãã£ã¹ãã«ãšã£ãŠéåžžã«äŸ¡å€ã®ãããã®ã§ãã
ãã¡ããšããããŒã¿ãå ã«æ£ããåæãè¡ã£ãã«ãé¢ãããããããããžãã¹äžã®æåã«ç¹ãããªãããšããããŸãããããããã®çµæããæ°ããªèª²é¡ãçºèŠãã次ã®ã¹ãããã«ç¹ããæè»æ§ãäžå¯æ¬ ã§ãã
æ¥çã®å€åãžã®é©å¿
ããŒã¿ãµã€ãšã³ã¹ã®äžçã¯ããŸããããå€åããŠããŸããæ°ãããã¯ãããžãŒãã¢ã«ãŽãªãºã ã®ç»å Žã«ãããåŠã³ç¶ãã姿å¢ãæ±ããããŸããæ¥çã®æåç·ã§æŽ»èºãç¶ããã«ã¯ãåžžã«ææ°ã®ãã¬ã³ãã«ç®ãå ãããããšãäžå¯æ¬ ã§ãã
ãŸããèŠå¶ãå«ççãªåé¡ã«å¯Ÿããç解ããããããã®ããŒã¿ãµã€ãšã³ãã£ã¹ãã«ã¯éèŠãšãªããŸãããã©ã€ãã·ãŒä¿è·ã®èŠæ±ãé«ãŸãäžãã©ã®ããã«ããŒã¿ãæ±ããã¯å€§ããªåé¡ã§ãã
絶ããå€åã«é©å¿ããæ欲ããªããšãããã«æ代é ããšãªã£ãŠããŸããŸããå€åãæãããæ°ããç¥èãåãå ¥ããç©æ¥µæ§ãå¿ èŠã§ãã
ãã£ãªã¢ã¢ããã®ç§èš£ãšèª²é¡
ããŒã¿ãµã€ãšã³ãã£ã¹ããšããŠã®ãã£ãªã¢ãç¯ãã«ãããããã¯ãã«ã«ã¹ãã«ã¯ãã¡ãããããžãã¹ã¹ãã«ããªãŒããŒã·ãããåæã«ç£šãããšã倧åã§ãã人ã ãå°ãããããžã§ã¯ããæåã«å°ãããã®ã¹ãã«ãé«ããããšããã£ãªã¢ã¢ããã«ã€ãªãããŸãã
ããããå°éæ§ãé«ãåéã§ããããããã£ãªã¢ã®éžæè¢ãéãããããšããããŸããã©ã®æ¥çã§ã©ã®ãããªåœ¢ã§èªåã®ã¹ãã«ã掻ããã®ããæ éã«èããããšãéèŠãšãªããŸãã
ãŸãããã¯ãããžãŒã®é²æ©ã«ãããä»äºã®ããæ¹ã倧ããå€ããå¯èœæ§ããããŸããèªå·±åçºãšãã£ãªã¢ãã©ã³ã®èŠçŽããå®æçã«è¡ããåžå ŽäŸ¡å€ãé«ãç¶ããããšããé·æçãªæåã®ç§èš£ãšãªãã§ãããã
ãŸãšã
ããŒã¿ãµã€ãšã³ãã£ã¹ãã¯ãããã°ããŒã¿ã解æã䟡å€ãçã¿åºãå°éè·ã§ãããçæ³ãšçŸå®ã«ã¯ã®ã£ãããååšããŸããä»äºå 容ã¯å€å²ã«ããããé«åºŠãªã¹ãã«ã»ãããæ±ããããŸããæ¥çå ã§ã®ãã®åœ¹å²ãéèŠæ§ãå¢ããŠããŸãããããããããŒã¿ãµã€ãšã³ãã£ã¹ã ãããšãããšãã声ã¯æ¡çšåžå Žã®ãã¹ããããæåŸ ãšå®éã®ææã®ã®ã£ããããã£ãªã¢ãã¹ã®äžéæããã¢ã«ããã¢ãšããžãã¹éã§ã®ã¹ãã«ã®ä¹é¢ã«èµ·å ããŠããããšãå€ãã§ãããã£ãªã¢ã®çŸå®ã¯ç£æ¥ã«ãã£ãŠç°ãªããè·åã®æºè¶³åºŠãã¹ãã¬ã¹ã転è·åžå Žã§ã®ç«¶äºãæ¿ãããã®ããããŸããæåããã«ã¯ãç¶ç¶çãªåŠç¿ãæ¥çããŒãºã®ç解ããããã¯ãŒãã³ã°ããã¬ãŒã ã¯ãŒã¯ã®é©çšãå¿ èŠã§ããããŒã¿ãµã€ãšã³ãã£ã¹ã以å€ã®ãã£ãªã¢ãã¹ãšããŠã¯ãããŒã¿ã¢ããªã¹ããããŒã¿ãšã³ãžãã¢ãããžãã¹ã€ã³ããªãžã§ã³ã¹å°é家ãªã©ããããŸããå®éã®ããŒã¿ãµã€ãšã³ãã£ã¹ãããã®äœéšè«ãåèã«ãªãã§ãããããã£ãªã¢ã¢ããã®å©èšãšæ¥çå€åãžã®é©å¿ãéèŠã§ãã