ããŒã¿ã¢ããªã¹ãã®åœ¹å²ãšéèŠæ§
ããžãã¹çã«ãããŠãããŒã¿ã¢ããªã¹ãã¯ããããŠéèŠãªåœ¹å²ãæ ã£ãŠããŸãããšããã³ã¹ã«åºã¥ããææ決å®ãããžãã¹ã®æåã®éµãšãªãäžãããŒã¿ã¢ããªã¹ãã¯ãã®ããŒã¿ãç解ã解éããäžã§äžå¯æ¬ ãªååšã§ãã
ããŒã¿ã®äŸ¡å€ãæ£ããèªã¿è§£ããæŠç¥çãªæŽå¯ãåŸãããšã§ãããŒã¿ã¢ããªã¹ãã¯äŒæ¥ãããè¯ãããžãã¹æ±ºå®ãäžãããã®ãµããŒããè¡ããŸãããã®ãããªæŽ»åã¯ã競äºãæ¿åããåžå Žã«ãããŠãäŒæ¥ãéèŠãªç«¶äºåªäœæ§ãç¯ãããã«ãŸããŸãå¿ èŠãšãããŠããŸãã
ãã®èšäºã§ã¯ãããŒã¿ã¢ããªã¹ãã®åºæ¬çãªå®çŸ©ãããã®è·åå 容ããããŠçŸä»£ããžãã¹ã«ãããŠãªããã®åœ¹å²ãéèŠã§ãããã解説ããŸãã
ããŒã¿ã¢ããªã¹ããšã¯äœãïŒåºæ¬çãªå®çŸ©
ããŒã¿ã¢ããªã¹ããšã¯ãèšå€§ãªããŒã¿ããæçãªæ å ±ãæ¢ãåºããäŒæ¥ã®ææ決å®ã«åœ¹ç«ãŠãå°éè·ã§ããäž»ã«çµ±èšåŠãæ©æ¢°åŠç¿ãããŒã¿ãã€ãã³ã°ãšãã£ãææ³ãçšããŠããŒã¿ãåæããæ å ±ãæããã«ããŸãã
圌ãã¯ãŸããããŒã¿ã»ããã®å質ãä¿ã€ããã«ããŒã¿ã¯ã¬ã³ãžã³ã°ãååŠçãšãã£ãäœæ¥ãè¡ããããŒã¿ã®æ£ç¢ºæ§ã確å®ã«ãã責任ãæ ã£ãŠããŸããããŒã¿ã®æŽåæ§ãä¿¡é Œæ§ã®ç¢ºä¿ãã粟床ã®é«ãåæçµæãçãããã«ã¯äžå¯æ¬ ã§ãã
ããã«ãããŒã¿ã¢ããªã¹ãã¯åæçµæããããããã圢ã§æ瀺ãã圹å²ãæã£ãŠããŸããããã«ã¯ããŒã¿ããžã¥ã¢ãªãŒãŒã·ã§ã³ã®ã¹ãã«ãèŠæ±ãããèŠèŠçãªã¬ããŒããããã·ã¥ããŒããéããŠãéå°é家ã§ãç解ã§ããããã«æ å ±ãäŒéããå¿ èŠããããŸãã
çŸä»£ããžãã¹ã«ãããããŒã¿ã¢ããªã¹ãã®éèŠæ§
çŸä»£ã®ããžãã¹ç°å¢ã¯ãããŒã¿ã«åºã¥ãæŽå¯ã決å®çãªå·®ãçãå Žã«ãªã£ãŠããŸããåžå Žã®ãã¬ã³ããçŽ æ©ãæãã顧客ã®ããŒãºã«è¿ éã«å¿ããããã«ã¯ãããŒã¿ã®åæãå¿ é ã§ãã
ããŒã¿ã¢ããªã¹ãã¯ãåžå Žåæã顧客è¡åã®ææ¡ãéçšå¹çã®æ¹åãªã©ãããããããžãã¹ããã»ã¹ã«ãããŠéèŠãªåœ¹å²ãæãããŸãã圌ãã¯å¯Ÿè±¡ãšãªãããŒã¿ã®æœåšçãªäŸ¡å€ãåŒãåºãããããæŠç¥çãªããžãã¹ã¢ã¯ã·ã§ã³ã«ç¹ããããšãæ±ããããŸãã
ãŸãããªã¹ã¯ç®¡çãååéçºã«ãããŠããããŒã¿ã¢ããªã¹ãã®åœ¹å²ã¯æ¥µããŠéèŠã§ãããªã¢ã«ã¿ã€ã ã§æ å ±ãåæããäŒæ¥ãæœåšçãªåé¡ãæ©æã«çºèŠããæ©äŒãéããªãããã«ããããšãäžå¯æ¬ ãªã®ã§ãã
ããŒã¿ã¢ããªã¹ãã®äž»ãªè·åå 容
ããŒã¿ã¢ããªã¹ãã®è·åå 容ã¯ãããŒã¿åéãããŒã¿åŠçãåæããããŠçµæã®å ±åã«ãŸã§åã³ãŸãããŸã圌ãã¯ãçµç¹å å€ã®ããŒã¿ãœãŒã¹ããå¿ èŠãªããŒã¿ãåéããŸãã
次ã«ãããŒã¿ã¯ãªãŒãã³ã°ãããŒã¿ãã©ã³ã¹ãã©ãŒã¡ãŒã·ã§ã³ãªã©ã®æè¡ãçšããŠãããŒã¿ãåæçšã®åœ¢åŒã«æŽããŸãããã®æ®µéã§ã¯ããŒã¿ã®è³ªã確ä¿ããåæããã»ã¹ã«ãããŠæ£ç¢ºãªçµæãããããããã®ååŠçãè¡ãããŸãã
ãã®åŸãçµ±èšçææ³ãæ©æ¢°åŠç¿ã¢ã«ãŽãªãºã ãçšããŠããŒã¿ãåæããéèŠãªæŽå¯ããã¿ãŒã³ãæœåºããŸãããããŠæåŸã«ãåæçµæãç解ãããã圢ã§äŒæ¥ã®ææ決å®è ãå©å®³é¢ä¿è ã«äŒãã責任ãè² ããŸãã
ããŒã¿é§ååã®ææ決å®ã®æšé²è ãšããŠã®åœ¹å²
ããŒã¿ã¢ããªã¹ãã¯ããŒã¿é§ååã®ææ決å®ãæšé²ããäžã§äžå¿çãªåœ¹å²ãæãããŸãã圌ãã®åæã¯ã䞻芳ãçŽæã§ã¯ãªãã客芳çãªããŒã¿ã«åºã¥ããææ決å®ãå¯èœã«ããŸãã
ããã«ãããäŒæ¥ã¯ãªã¹ã¯ãæå°éã«æããå¹çãæ倧åããããšãã§ããŸããããŒã¿ã¢ããªã¹ãã«ããããŒã¿ã®è§£éãšåæã¯ãæŠç¥çãªæ¹åæ§ãå®ããããå°æ¥ã®äºæž¬ãè¡ãäžã§æ¬ ãããªãæ å ±ãæäŸããŸãã
æçµçã«ã¯ãããŒã¿ã¢ããªã¹ãã¯äŒæ¥ãããŒã¿é§åæåãæ§ç¯ããããã®æ¯æŽãè¡ããŸããããŒã¿ã掻çšããããæ å ±ã«åºã¥ãã決å®ãäžãæåãå¹ãããšã§ãäŒæ¥ã®ç«¶äºåã¯å€§ããåäžããã®ã§ãã
ããŒã¿ã¢ããªã¹ãã«æ±ããããã¹ãã«ã»ãã
çµ±èšåŠãšããŒã¿åæã®åºæ¬ã¹ãã«
ããŒã¿ã¢ããªã¹ããšããŠã®ãã£ãªã¢ãç¯ãããã«ã¯ãçµ±èšåŠã®ç解ãäžå¯æ¬ ã§ããããŒã¿ã»ããããææ矩ãªæŽå¯ãåŒãåºãã«ã¯ãå¹³åãäžå€®å€ãã¢ãŒããªã©ã®åºæ¬çµ±èšéã ãã§ãªããçžé¢é¢ä¿ãååž°åæã確çååžãšãã£ãããè€éãªçµ±èšçææ³ã«ç²ŸéããŠããããšãæåŸ ãããŸãã
ãŸãã仮説æ€å®ãå®éšèšç»æ³ãªã©ã®é«åºŠãªã¹ãã«ãéèŠã«ãªã£ãŠããŸããããŒã¿ã®äžç¢ºå®æ§ãç解ããé©åãªåæææ³ãéžæããèœåã¯ãããŒã¿ããªãã³ãªææ決å®ããµããŒãããããã«æ¬ ãããŸããã
ãããã®ã¹ãã«ã¯ãããŒã¿ããæŽå¯ãåŸãããã®åæç¥èãšããŠããŸãããŒã¿ã¢ããªã¹ããæäŸããæ å ±ã®ä¿¡é Œæ§ãæ ä¿ããããã«ãæ¥åã«ãããŠæ¥åžžçã«å©çšãããŠããŸãã
ããã°ã©ãã³ã°èšèªãšããŒã¿ããŒã¹ã®ç¥è
ããŒã¿ã¢ããªã¹ãã«ãšã£ãŠãããã°ã©ãã³ã°èšèªã¯ããŒã¿åŠçãšåæã®å¹çåãå®çŸããããã®éèŠãªããŒã«ã§ããç¹ã«ãPythonãRã®ãããªããŒã¿åæã«ç¹åããèšèªã®ç解ã¯ãçŸå Žã§å³æŠåãšãªãããæ±ããããŠããŸãã
ããã«ãSQLãã¯ãããšããããŒã¿ããŒã¹é¢é£ã®ç¥èãã倧éã®ããŒã¿ãå¹ççã«æœåºããæäœããããã§å¿ èŠäžå¯æ¬ ã§ãããããã®æè¡ã䜿ãããªãããšã§ãããŒã¿ã¢ããªã¹ãã¯æè»ã«ããŒã¿ãæ±ããããè€éãªåæãããŒã¿ç®¡çãè¡ãããšãã§ããŸãã
ã³ãŒãã£ã³ã°ã¹ãã«ã¯ãèªååã®æšé²ãããŒã¿ã¯ã¬ã³ãžã³ã°ã®ç²ŸåºŠåäžã«ãå¯äžããçµæãšããŠãããä¿¡é Œæ§ã®é«ãããŒã¿åæçµæãçã¿åºãããšã«ã€ãªããã®ã§ãã
ããŒã¿ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ãšãã¬ãŒã³ããŒã·ã§ã³
ããŒã¿ã¢ããªã¹ãã«ãšã£ãŠãããŒã¿ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ã®ã¹ãã«ã¯ãåæçµæãåãããããäŒéããããã®æ žãšãªãèŠçŽ ã§ããã°ã©ãããã£ãŒãã䜿ã£ãŠãããŒã¿ã®åŸåããã¿ãŒã³ãèŠèŠçã«è¡šçŸããããšã§ãããžãã¹ã®ææ決å®è ãæ å ±ã容æã«ç解ãã¢ã¯ã·ã§ã³ãèµ·ããããšãã§ããããã«ãªããŸãã
ããŒã«ãšããŠã¯ãTableauãPower BIã®ãããªããŒã¿ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³å°éã®ãœãããŠã§ã¢ãããããããã䜿ãããªãããšãæ±ããããŸãããããã¯åŒ·åã§ãããªããçŽæçãªæäœæ§ã§ãããŒã¿ã¢ããªã¹ããè€éãªããŒã¿ãç°¡æœã«äŒããã®ã«åœ¹ç«ã¡ãŸãã
ãã¬ãŒã³ããŒã·ã§ã³ã¹ãã«ããŸãéèŠã§ãããåæçµæãããŒã ã¡ã³ããŒãã¹ããŒã¯ãã«ããŒã«å¯ŸããŠæ確ã«äŒããããšãæ±ããããŸããããã«ã¯ãã¹ããŒãªãŒããªã³ã°èœåãå«ãŸãããããèŠèŽè ã®é¢å¿ãåŒãã€ããå°è±¡ã«æ®ããã¬ãŒã³ããŒã·ã§ã³ãæåŸ ãããŸãã
åé¡è§£æ±ºèœåãšããžãã¹ç解å
ããŒã¿ã¢ããªã¹ãã¯ãããŒã¿ãéããŠããžãã¹äžã®åé¡ãç¹å®ãã解決çãæ瀺ãã圹å²ãæ ããŸããåé¡è§£æ±ºèœåã¯ãããžãã¹ããã»ã¹ãæ±ããŠãã課é¡ã®æ žå¿ãçªãæŽå¯ãæäŸããããã«ãéåžžã«éèŠã§ãã
ããã«ãçµç¹ãæ¥çã«ã€ããŠã®æ·±ãç解ãæã€ããšã§ãããŒã¿ã¢ããªã¹ãã¯ããæŠç¥çãªææ¡ãè¡ãããšãã§ããŸãããã®ãããæ¥çã®ãã¬ã³ããè¿œããããããžãã¹ã¢ãã«ãç解ãã顧客ã®ããŒãºã«åèŽããåæãè¡ãèœåãæ±ããããŸãã
ãã®ããã«ãããŒã¿ã¢ããªã¹ãã¯åã«ããŒã¿ãæäœããã ãã§ãªãããããããžãã¹ææã«ã€ãªããããšãæåŸ ããããããæè¡çãªã¹ãã«ãšããžãã¹ã¹ãã«ã®äž¡æ¹ãæ±ãããããããã§ãã·ã§ãã«ãªååšãªã®ã§ãã
åžå Žã«ãããããŒã¿ã¢ããªã¹ãã®éèŠãšåŸå
ããŒã¿ã¢ããªã¹ãã®åœ¹å²ãäŒæ¥æŠç¥ã«ãããŠãŸããŸãéèŠã«ãªã£ãŠããçŸåšãåžå Žã«ããã圌ãã®éèŠã¯èããå¢å ããŠããŸããããã°ããŒã¿æ代ã«ãªããäŒæ¥ã¯çµå¶æ±ºå®ãè¡ãéã«å€§éã®ããŒã¿ãæ±ãå¿ èŠã«è¿«ãããŠããŸãããã®ããšãããããŒã¿ã®èªã¿åããåæã解éãã§ãã人æãžã®ããŒãºãé«ãŸã£ãŠããŸãã
ããŒã¿é§åã®æ±ºå®ãè¡ãèœåã¯ã競äºãæ¿åããããŸããŸãªæ¥çã«ãããŠäŒæ¥ã«ãšã£ãŠäžå¯æ¬ ãšãªã£ãŠããŸããã¡ãã£ã¢ããã«ã¹ã±ã¢ãéèãµãŒãã¹ããã¯ãããžãŒçãå€ãã®ã»ã¯ã¿ãŒã§ããŒã¿ã¢ããªã¹ãã®ã®éèŠæ§ãå¢ããŠããŸããããããæ¥çš®ã«ãã£ãŠæ±ããããããŒã¿ã¢ããªã¹ãã®ã¹ãã«ã»ãããç¥èãç°ãªãããšãèŠéããŸããã
ããã«ãçµç¹ã®äžã§ããŒã¿ã¢ããªãã£ã¯ã¹ãäžå¿çãªåœ¹å²ãæããããã«ãªãã«ã€ããŠãããŒã¿ã¢ããªã¹ãã®åœ¹å²ã¯é²åãç¶ããŠããŸãã圌ãã¯åã«ããŒã¿ãåæããã ãã§ã¯ãªããããžãã¹ã€ã³ããªãžã§ã³ã¹ã®çæãæŠç¥çå®ãžã®è²¢ç®ãåžå Žã顧客ã®åŸåã®äºæž¬ãªã©ã«ãé¢ãã£ãŠããåŸåã匷ãŸã£ãŠããŸãã
æ¥çã«ããéèŠã®éã
éèæ¥çã§ã¯ãªã¹ã¯ç®¡çãæè³å€æãªã©ãããŒã¿ã«åºã¥ããŠè¡ãããšãããäžè¬çã«ãªã£ãŠãããããŒã¿ã¢ããªã¹ãã¯åžå Žåæã®å°éç¥èãå¿ èŠãšãããŠããŸãã販売ãããŒã±ãã£ã³ã°ã®ããŒã¿åæãæ±ããããå°å£²æ¥çãäŸå€ã§ã¯ãããŸããã
äžæ¹ã§ããã«ã¹ã±ã¢æ¥çã§ã¯æ²»çææã®æ¹åãéçšå¹çåã®ããã«æ£è ããŒã¿ã®åæãå¿ èŠãšãããŠããŸããããã«å ãããã¯ãããžãŒäŒæ¥ãã¹ã¿ãŒãã¢ããäŒæ¥ã§ã¯ã顧客è¡åã®äºæž¬ã補åéçºãžã®ãã£ãŒãããã¯ãšããŠããŒã¿åæãå©çšãããŠããŸãã
éãæ¥çå士ã§æ±ããããããŒã¿ã¢ããªã¹ãã®ã¹ãã«ã»ããã«ã¯å ±éç¹ãããã°ãç¹æã®ç¥èãçµéšãæ±ããããã±ãŒã¹ããããŸãããããã®èŠä»¶ã¯ãæ¥çã®ååããã®æ¥çç¹æã®åé¡è§£æ±ºã«å¿ èŠãªå°éæè¡ã«ãã£ãŠæ±ºãŸããŸãã
æ±äººåžå Žã«ãããããŒã¿ã¢ããªã¹ãã®å°äœ
æ±äººåžå Žã«ãããããŒã¿ã¢ããªã¹ãã®å°äœã¯ç¢ºåºãããã®ãšèšããŸããäŒæ¥ã¯ããžãã¹ã®æé·ãšç¶ç¶çãªæåã®ããã«ããŒã¿ã¢ããªã¹ããå¿ èŠãšãã圌ãã®ã¹ãã«ãžã®æè³ãåããªããªã£ãŠããŸããæ±äººæ°ã®å¢å ã絊äžæ°Žæºã®äžæã¯ããã®åŸåãåŠå®ã«åæ ããŠããŸãã
å°éçãªç¥èã®å¿ èŠæ§ããããŒã¿ã¢ããªã¹ãã¯é«ãè©äŸ¡ãåããå€ãã®å Žåãåªããåæèœåãæã€äººæã¯éãããŠããããã競äºåã®ããå ±é ¬ãåŸãããšãã§ããŸãããã®ç¶æ³ã¯ã·ãã¢ã¬ãã«ã§ãåæ§ã§ãé«åºŠãªåæã¹ãã«ãšããžãã¹çµéšãå ŒãåããããŒã¿ã¢ããªã¹ããžã®éèŠã¯ç¹ã«é«ãã§ãã
é²æ©ãããã¯ãããžãŒãšå ±ã«ããŒã¿åæããŒã«ããœãããŠã§ã¢ã®çºå±ãé²ã¿ãããã«ããããŒã¿ã¢ããªã¹ãã®äœæ¥å¹çãäžãããããè€éãªåæãå¯èœã«ãªããŸããããã®çµæããããªã²ãŒã ãé«åºŠãªã·ãã¥ã¬ãŒã·ã§ã³ã䜿çšããè·æ¥èšç·Žããã°ã©ã ãªã©ãå®è·µçãªã¢ãããŒããæ±äººåžå Žã§éèŠãããããã«ãªã£ãŠããŸãã
ãã£ãªã¢ãã¹ãšæé·å¯èœæ§
ããŒã¿ã¢ããªã¹ãã¯ãã£ãªã¢ã®åæ段éããè€æ°ã®æé·ãã¹ãæããŠããŸããå€ãã¯æè¡ã¹ãã«ã®åäžãç®æããããžãã¹ã€ã³ããªãžã§ã³ã¹ã¢ããªã¹ããããŒã¿ãµã€ãšã³ãã£ã¹ããžãšãã£ãªã¢ãé²ããŠããããšãã§ããŸãã
äžçŽè·ãšããŠã¯ãããŒã¿ç®¡çãããŒã¿ã¬ããã³ã¹ã®åéã§ãªãŒããŒã·ãããåãããã«ãªããã£ã³ã¹ããããŸãããã®ãããªåœ¹å²ã¯ãçµç¹å šäœã®ããŒã¿æŠç¥ãæšé²ããããŒã¿é¢é£ã®ãã©ã¯ãã£ã¹ãæšæºåãã責任ãæã¡ãŸãã
ãŸããæè²ãšå°éç¥èã䌎ã£ãŠæé·ããããšã§ãã³ã³ãµã«ã¿ã³ããããªãŒã©ã³ã¹ãšããŠç¬ç«ããéããããŸãããããããããã§ãã·ã§ãã«ã¯ç«¶åä»ç€Ÿã®ããžãã¹ã¢ãã«ãåžå ŽæŠç¥ãåæããæ¹åã®ææ¡ãè¡ãããšã§éåžžã«é«ã䟡å€ãæäŸããããšãã§ããŸãã
å°æ¥ã®ããžãã¹ã·ãŒã³ã«ãããããŒã¿ã¢ããªã¹ãã®éèŠæ§
å°æ¥ã®ããžãã¹ç°å¢ã«ãããŠãããŒã¿ã¢ããªã¹ãã®åœ¹å²ã¯ç¡èŠã§ããªããã®ã«ãªã£ãŠããŸããããžãã¹æŠç¥ãšããŒã¿åæã¯ãŸããŸãçµ±åãããçµç¹ã®äž»èŠãªææ決å®ããã»ã¹ã«ãããŠããŒã¿ã¢ããªã¹ãã®æäŸããæŽå¯ãéµãšãªã£ãŠããŸãã
äŒæ¥ãæ°ããåžå Žãæ©äŒãçºèŠããå€åã«è¿ éã«å¯Ÿå¿ã§ããããã«ããããã«ã¯ãããŒã¿ã¢ããªã¹ããçã¿åºãäºæž¬ã¢ãã«ããã¬ã³ãåæãäžå¯æ¬ ã§ããããã«ãã£ãŠããªã¹ã¯ãæå°éã«æããããæŠç¥çãªå€æãå¯èœã«ãªããŸãã
AIãæ©æ¢°åŠç¿ã®é åã§åãããŒã¿ã¢ããªã¹ãã¯ãèªååãå¹çåãã¯ãããšããã€ãããŒã·ã§ã³ãæšé²ããç«åœ¹è ãšãªãããšãæåŸ ãããŠããŸãããããããããŒã¿ã¢ããªã¹ãã¯å šæ¥çã«ããã£ãŠéèŠæ§ãå¢ããŠããããšã§ãããã
ããŒã¿ã¢ããªã¹ãã®ããã®æè²ãšãã¬ãŒãã³ã°
å¿ èŠãªæè²èæ¯ãšè³æ Œ
ããŒã¿ã¢ããªã¹ãã«ãªãããã«ã¯ãæ°åŠãçµ±èšåŠãã³ã³ãã¥ãŒã¿ãŒãµã€ãšã³ã¹ãªã©ã®åéã§ã®åŒ·åºãªæè²èæ¯ãæ±ããããŸãããããã®ç¥èã¯ãããŒã¿ãæ£ç¢ºã«åæããæçãªæ å ±ãæœåºããäžã§äžå¯æ¬ ã§ããå€ãã®äŒæ¥ã¯ãé¢é£ããåŠå£«å·ãæã€åè£è ã奜ãåŸåããããŸãã
å ããŠãæ§ã ãªæè¡è³æ ŒãããŒã¿ã¢ããªã¹ãã«ãšã£ãŠãã©ã¹ã«ãªããŸããããšãã°ãSQLãR ãŸã㯠Python ã«é¢ããå°éçãªèšŒææžã¯ãåæã®å¹çãé«ããæèœãå®èšŒããæ段ãšãªããŸãããŸããããŒã¿åæã®å°é家ãšããŠèªããããããã«å šåœãŸãã¯åœéçãªèªèšŒããã°ã©ã ãåããããšãéèŠã§ãã
è³æ ŒãååŸããããšã¯ãæœåšçãªéçšäž»ã«å¯ŸããŠãããŒã¿åæã®é åã§ã®ã³ãããã¡ã³ããšå°éç¥èã瀺ãæ¹æ³ã®äžã€ã§ããããã«ãããä»ã®åè£è ãšæ¯èŒããéã«åªäœã«ç«ã€ããšãã§ããŸãã
èªå·±ç éœãšãããã§ãã·ã§ãã«éçº
ããŒã¿ã¢ããªã¹ããšããŠã®ç¥èãç¶ç¶ããŠæŽæ°ãç¶ããããšã¯éåžžã«éèŠã§ããæ¥çã¯æ¥ã é²åããŠãããæ°ããæè¡ãåææ¹æ³ã次ã ãšç»å ŽããŠããŸããèªå·±ç éœãæ ããã«ãææ°ã®ãã¬ã³ããããŒã«ã«ç©æ¥µçã«åŠã³ãé©å¿ãããå¿ èŠããããŸãã
æžç±ãå°éèªã®å®æçãªé²èŠ§ãåæ¥è ãšã®ãããã¯ãŒãã³ã°ãéããŠæ°ããç¥èãåãå ¥ããããšãæå¹ã§ãããŸãããããã§ãã·ã§ãã«ãšããŠèªåèªèº«ã®ãã©ã³ããç¯ãããœãŒã·ã£ã«ã¡ãã£ã¢ãããã°ã§ç¥èŠãå ±æããããšã§ãå°éç¥èãšåœ±é¿åãæ¡å€§ããŠããããšãéèŠã§ãã
ããã«ãã»ãããŒãæ¥çäŒè°ã«åå ããããšã¯ããããã§ãã·ã§ãã«ãªã³ãã¥ããã£ã®äžå¡ãšããŠèªãã確ç«ãã貎éãªã€ã³ãµã€ããã³ãã¯ã·ã§ã³ãåŸãçŽ æŽãããæ©äŒãšãªããŸãã
ãªã³ã©ã€ã³ã³ãŒã¹ãšã¯ãŒã¯ã·ã§ãã
ããŒã¿ã¢ããªã¹ãã®ã¹ãã«ã»ããã¯ããªã³ã©ã€ã³ã§ã¢ã¯ã»ã¹å¯èœãªæ§ã ãªã³ãŒã¹ãã¯ãŒã¯ã·ã§ãããéããŠåäžãããããšãã§ããŸããå€ãã®æ©é¢ããããŒã¿åæãããžã¥ã¢ãªãŒãŒã·ã§ã³ãæ©æ¢°åŠç¿ãªã©ã«é¢ããå°éçãªãã¬ãŒãã³ã°ãæäŸããŠããŸãã
ãããã®ãªã³ã©ã€ã³ãªãœãŒã¹ãå©çšããããšã§ãåŸæ¥ã®æ宀åã®åŠç¿ã«æ¯ã¹ãŠãèªåã®ããŒã¹ã§åŠã¶ããšãã§ããå°ççãªéå£ããªããªããŸãããŸããææ°ã®ããŒã¿åæããŒã«ãããã°ã©ãã³ã°èšèªã«é¢ããè±å¯ãªææãååšããç¶ç¶çãªåŠç¿ããŒãºã«å¯Ÿå¿ããããšãã§ããŸãã
å®éã®ãããžã§ã¯ãããŒã¹ã®ã¯ãŒã¯ã·ã§ããã«åå ããããšã«ãã£ãŠãçè«çãªç¥èãå®è·µçãªã¹ãã«ã«å€æããçµéšãç©ãããšãã§ããŸããããã«ãããå®ç掻ã§çŽé¢ãããããããªãããŒã¿åæã®åé¡ã«å¯Ÿãã解決çãææ¡ããèœåãé«ããããšãã§ããŸãã
ã€ã³ã¿ãŒã³ã·ãããšçŸå Žçµéšã®éèŠæ§
åŠãã ç¥èãå®äžçã®ããŒã¿åé¡ã«é©çšããæãæå¹ãªæ¹æ³ã®äžã€ã¯ãã€ã³ã¿ãŒã³ã·ãããå®åçµéšãåŸãããšã§ããå€ãã®åŠçããåŠæ¥ã®äžç°ãšããŠã€ã³ã¿ãŒã³ã·ãããè¡ããå®åçµéšãç©ã¿ãŸãã
ã€ã³ã¿ãŒã³ã·ããã¯ãããŒã¿ã¢ããªã¹ããšããŠã®ãã£ãªã¢ãç©ã¿éããããã§ã貎éãªæ¥çç¥èãåŸãã ãã§ãªããæœåšçãªéçšäž»ãšã®ãããã¯ãŒãã³ã°ã®ãã£ã³ã¹ãäžããŠãããŸãããŸãããªã¢ã«ãªããžãã¹ç°å¢ã§ã®ããŒã¿ã®æµããç解ããäžã§ãå®éã«ä»äºãè¡ãçµéšã¯éåžžã«æçã§ãã
ã¯ãŒã¯ã¹ã¿ãã£ããã°ã©ã ãä»»æã®ãããžã§ã¯ãåå ãåæ§ã«ããªã¢ã«ã¯ãŒã«ãã§ã®ããŒã¿åŠçã®ææ³ãè€éããçµéšããäžã§è¯ãæ©äŒãšãªããŸããããããçµéšã¯ãããŒã¿ã¢ããªã¹ããšããŠã®èªä¿¡ãšèœåãç¯ãäžããããã«äžå¯æ¬ ã§ãã
ããŒã¿ã¢ããªã¹ããšããžãã¹ã€ã³ããªãžã§ã³ã¹
ããŒã¿ã¢ããªã¹ãã¯ãããžãã¹ã€ã³ããªãžã§ã³ã¹ïŒBIïŒã®é åã«ãããŠäžå¿ç圹å²ãæãããŸããããã¯ãè€éãªããŒã¿ã»ãããåæããäŒæ¥ãæŠç¥ç決å®ãäžãããã®æŽå¯ãæäŸããå°é家ã§ãã
圌ãã®ã¹ãã«ã»ããã«ã¯ãçµ±èšåŠãæ©æ¢°åŠç¿ãäºæž¬ã¢ããªã³ã°ãããŒã¿å¯èŠåãªã©ãå«ãŸããŸããããããã®æè¡ãé§äœ¿ããŠããžãã¹ããã»ã¹ãæé©åããåžå Žã®ãã¬ã³ããææ¡ããåçãæ倧åããããšãæ±ããããŸãã
ããžãã¹ã€ã³ããªãžã§ã³ã¹ãæŠåšã«ãããŒã¿ã¢ããªã¹ããã¡ã¯äŒæ¥ã®æåã«äžå¯æ¬ ãªãããŒã¿ã«åºã¥ãæŽå¯ãæäŸããŸãã
ããžãã¹ã€ã³ããªãžã§ã³ã¹ãšã®é¢ä¿
ããžãã¹ã€ã³ããªãžã§ã³ã¹ã¯ããŒã¿ã¢ããªã¹ãã«ãšã£ãŠäžå¯åã®é¢ä¿ã«ãããŸããBIã¯ãäºæ¥ã«é¢ãã倧éã®ããŒã¿ããææ矩ãªæ å ±ãæœåºããçµç¹ã®ææ決å®ããã»ã¹ãæ¯æŽãããã¬ãŒã ã¯ãŒã¯ãšããŠæ©èœããŸãã
ããŒã¿ã¢ããªã¹ãã¯ãBIããŒã«ãé§äœ¿ããŠèšå€§ãªããŒã¿ã管çã解éãã競äºåªäœæ§ãåµåºããŸããããã«ããã販売äºæž¬ãã顧客è¡ååæãŸã§ãåºç¯å²ã«ãããäºæ¥é åã«æ·±ãæŽå¯ãããããããšãã§ããŸãã
çµæãšããŠãããŒã¿ã¢ããªã¹ããšããžãã¹ã€ã³ããªãžã§ã³ã¹ã¯å ±åããäžç·ã«ãªã£ãŠçµç¹ã®ããã©ãŒãã³ã¹åäžã«è²¢ç®ããŸãã
ããŒã¿ãŠã§ã¢ããŠã¹ãšããŒã¿ãã€ãã³ã°
ããŒã¿ãŠã§ã¢ããŠã¹ã¯ãçµç¹å šäœã®å€æ§ãªãœãŒã¹ããéããããããŒã¿ãéäžçã«ä¿ç®¡ããã·ã¹ãã ã§ããããŒã¿ã¢ããªã¹ãã«ãšã£ãŠãããã¯ããŒã¿åæã®åºçºç¹ãšãªããŸãã
äžæ¹ãããŒã¿ãã€ãã³ã°ã¯ããŒã¿ãŠã§ã¢ããŠã¹ã«ä¿åããã倧éã®ããŒã¿ãããã¿ãŒã³ãé¢é£æ§ãèŠã€ãåºãããã»ã¹ã§ããããŒã¿ã¢ããªã¹ãã¯ãã®ãã¯ããã¯ãå©çšããŠãäºæãã¬ãã¬ã³ããè¡åã®äºæž¬ãããã«ã¯ãªã¹ã¯ã®èå¥ã«è³ããŸã§ãéèŠãªããžãã¹ã€ã³ãµã€ããæœåºããŸãã
ããŒã¿ãŠã§ã¢ããŠã¹ãšããŒã¿ãã€ãã³ã°ã®çµã¿åããã¯ãããžãã¹ã®ææ決å®ã圢æããæŠç¥çã¢ã¯ã·ã§ã³ã®ããã®ç¢ºããªããŒã¿ã«åºã¥ã蚌æ ãæäŸããŸãã
çµå¶æŠç¥ãžã®ããŒã¿åæã®æŽ»çš
çµå¶æŠç¥ã«ãããŠãããŒã¿åæã®æŽ»çšã¯ä»ãåœããåã®ããšã§ããããŒã¿ã¢ããªã¹ãã¯åæãéããŠçµå¶é£ã«å¯Ÿããåžå Žã®ååãæ¶è²»è ã®ããŒãºãæ¥çã®å€åãªã©ãããŒãšãªãæ å ±ãæäŸããŸãã
å©çæ倧åãã³ã¹ãåæžã顧客æºè¶³åºŠã®åäžãªã©ã®ç®æšãéæããããã«ãããŒã¿ã¢ããªã¹ãã¯çµå¶æŠç¥ã®çå®ã«ç©æ¥µçã«é¢äžããããŒã¿ã«åºã¥ãããœãªã¥ãŒã·ã§ã³ãææ¡ããŸãã
ãããã®ã¢ããªãã£ã¯ã¹ã¯ãäŒæ¥ãé·æçãªç«¶äºåªäœæ§ãç²åŸããæç¶å¯èœãªæé·ãéæããããã®åºç€ãšãªããŸãã
BIããŒã«ã®æŽ»çšãšããŒã¿ã®æå³åã
BIããŒã«ã®æŽ»çšã¯ããŒã¿ã¢ããªã¹ãã«ãšã£ãŠæ¬ ãããªãèŠçŽ ã§ãããããã®ããŒã«ã¯ããŒã¿ã®æœåºãå€æãããŒãïŒETLïŒã®éçšãç°¡çŽ åããè€éãªããŒã¿ã»ãããã䟡å€ããã€ã³ãµã€ããè¿ éã«åŸãããšãå¯èœã«ããŸãã
ããã«ãããŒã¿ã¢ããªã¹ãã¯ãããã®ããŒã«ãå©çšããŠãããŒã¿ã®èåŸã«ããæ·±ãæå³åããç解ãããããããžãã¹ãªãŒããŒã«ããããããäŒéããŸããããŒã¿ã®å¯èŠåãã¬ããŒãäœæã¯ãBIããŒã«ãåŸæãšããé åã§ãããçµå¶å±€ã®ææ決å®ãæ¯æŽãã匷åãªæ段ã§ãã
æçµçã«ãããŒã¿ã¢ããªã¹ãã¯ãããã®å é²ããŒã«ãé§äœ¿ããŠãããŒã¿ãæã€çã®äŸ¡å€ã解ãæãããããžãã¹ã®æé·ã«éèŠãªæŽå¯ããããããŸãã
å®è·µïŒããŒã¿ã¢ããªã¹ãã«ãªãããã®ã¹ããã
ããŒã¿ã¢ããªã¹ããžã®ãã£ãªã¢éå§
ããŒã¿ã¢ããªã¹ããšããŠã®ãã£ãªã¢ãéå§ããããã«ã¯ãããŒã¿åæã®åºç€ç¥èãäžå¯æ¬ ã§ããããããæ¥çã§å¢å äžã®ããŒã¿ããªãã³ãªææ決å®ããã»ã¹ãæ¯ããããã«ãå€å²ã«ãããçµ±èšã¢ãã«ãããŒã¿ãã€ãã³ã°æè¡ã«ç²ŸéããŠããå¿ èŠããããŸãããŸãã¯ããªã³ã©ã€ã³ã³ãŒã¹ãå°éã®ç ä¿®ããã°ã©ã ãåè¬ããåºæ¬çãªã¹ãã«ã»ãããšãã¯ãã«ã«ãªç¥èãèç©ããŸãããã
次ã«ãåžå Žã§éèŠã®é«ãåæããŒã«ãããã°ã©ãã³ã°èšèªïŒäŸïŒPythonãRãSQLïŒã®äœ¿çšã«æ £ããããšãéèŠã§ããçŸä»£ã®ããžãã¹ç°å¢ã«ãããŠããŒã¿ã®åãæ±ãã¯å¿ é ã¹ãã«ãšãªã£ãŠããããããã®ããŒã«ã®ç¥èã¯ãããŒã¿ã¢ããªã¹ããšããŠæ¡çšãããäžã§åªäœã«ç«ã€ããã«åœ¹ç«ã€ã§ãããã
å®åçµéšãç©ãããšããã®ãã£ãªã¢ã®èãšãªããŸããã€ã³ã¿ãŒã³ã·ããããšã³ããªãŒã¬ãã«ã®ããžã·ã§ã³ã§ã®å®åãéããŠãåé¡è§£æ±ºã¹ãã«ããããžã§ã¯ã管çèœåãé€ãããšãå¯èœã§ãããŸããå®éã«ããŒã¿åæã®ãããžã§ã¯ããæ±ãããšã§ãçè«ç¥èãå®éã®ããžãã¹ã·ãŒã³ã«é©çšããçµéšãç©ãããšãã§ããŸãã
æ¥çãäŒæ¥ããšã®ããŒã¿æŽ»çšãç解ãã
ããããã®æ¥çãäŒæ¥ã¯åºæã®æ¹æ³ã§ããŒã¿ã掻çšããŠããŸããäŸãã°ãå°å£²æ¥ã§ã¯é¡§å®¢ã®è³Œè²·è¡åãåšåº«ç®¡çã«ããŒã¿åæãçšããããŸãããéèæ¥çã§ã¯ãªã¹ã¯è©äŸ¡ãåžå Žã®ãã¬ã³ãäºæž¬ã«ããŒã¿åæã掻ããããŸããããŒã¿ã¢ããªã¹ãã«ãªãã«ã¯ãã¿ãŒã²ãããšããæ¥çã®ç¹æ§ãæ£ç¢ºã«ææ¡ãããã®ããŒãºã«æ²¿ã£ãåæãè¡ãèœåãæ±ããããŸãã
äŒæ¥ã®ããžãã¹ã¢ãã«ãç®æšã«åãããããŒã¿æŽ»çšæŠç¥ãç解ããããšããå¹æçãªåæãè¡ãããã«å¿ èŠã§ãããã®ç¥èãæ·±ããããã«ã¯ãç¹å®ã®æ¥çãäŒæ¥ã®ã±ãŒã¹ã¹ã¿ãã£ã調æ»ããæé©ãªããŒã¿æŽ»çšæ³ã暡玢ããããšããå§ãã§ããç 究ãå°é家ã®æèŠãåèã«ããããšãæçã§ãã
ãŸããããã€ãã®æ¥çå£äœãå°éã³ãã¥ããã£ãäž»å¬ããã»ãããŒãã¯ãŒã¯ã·ã§ããã«åå ããããšã§ãæ¥çåºæã®ãã¬ã³ããæåäºäŸã«ã€ããŠåŠã³ãèªèº«ã®ã¢ãããŒããæ¹åããæ©äŒãåŸãããšãã§ããŸãã
å®åã§çŽé¢ãã課é¡ãšãã®è§£æ±ºç
ããŒã¿ã¢ããªã¹ãã¯ãããŒã¿ã®å質ãæŽåæ§ãã»ãã¥ãªãã£ãšãã£ãå€ãã®èª²é¡ã«çŽé¢ããããšããããŸããããšãã°ãäžå®å šãŸãã¯äžæ£ç¢ºãªããŒã¿ã¯åæçµæã«æªåœ±é¿ãåãŒãå¯èœæ§ããããããããŒã¿ã¯ã¬ã³ãžã³ã°ã®ææ³ãç¿åŸããããšãéèŠã§ããé©åãªããŒã¿ã¯ã¬ã³ãžã³ã°ãè¡ãããšã§ãä¿¡é Œæ§ã®é«ãããŒã¿ã»ããã«åºã¥ãåæãæäŸã§ããŸãã
ããŒã¿ãæ±ãéã«ã¯ãæ å ±ã®ã»ãã¥ãªãã£ãšãã©ã€ãã·ãŒã®ä¿è·ãäžå¯æ¬ ã§ãããã®åé¡ã«å¯ŸåŠããããã«ã¯ãGDPRããã®ä»ã®ããŒã¿ä¿è·æ³èŠã«ç²ŸéããäŒæ¥ããããã®èŠå¶ã«éåããªãããã®æŠç¥ãçå®ããããšãæãŸããŸããã³ã³ãã©ã€ã¢ã³ã¹ãä¿èšŒããããšã§ãäŒæ¥ã¯é¡§å®¢ã®ä¿¡é Œãç¶æãããªãŒã¬ã«ãªã¹ã¯ã軜æžã§ããŸãã
ãŸãã倧容éã®ããŒã¿ãå¹ççã«åŠçããèœåãå¿ èŠã§ããBig Dataæè¡ãã¯ã©ãŠãã³ã³ãã¥ãŒãã£ã³ã°ãã©ãããã©ãŒã ã掻çšããããšã§ãè€éã§æéãèŠããããŒã¿åæäœæ¥ãå¹ççã«è¡ããããã«ãªããŸãããããã®ãã¯ãããžãŒã«ç¿çããŠããããšã¯ãçŸä»£ã®ããŒã¿ã¢ããªã¹ãã«ãšã£ãŠé¿ããŠéããªãéã§ãã
ãããã¯ãŒãã³ã°ãšå°éç¥èã®å ±æ
ããŒã¿ã¢ããªã¹ããšããŠæåããããã«ã¯ãå°éçãªãããã¯ãŒãã³ã°ãæ¬ ãããŸãããæ¥çã®ã€ãã³ããã«ã³ãã¡ã¬ã³ã¹ãã»ãããŒã«åå ããŠãä»ã®å°é家ãšç¹ããããšã§æ°ããªèŠç¹ãåŸãããå®åã«åœ¹ç«ã€æŽå¯ãå ±æãããããæ©äŒãæã€ããšãã§ããŸãããŸããææ°ã®ãã¬ã³ãããã¯ãããžãŒã«é¢ããæ å ±ãå ¥æãããããªããŸãã
SNSããªã³ã©ã€ã³ãã©ãŒã©ã ã¯ãå°éç¥èã®å ±æã«ãæå¹ãªãã©ãããã©ãŒã ã§ããLinkedInãå°éçãªããŒã¿åæã³ãã¥ããã£ãéããŠãã¢ã€ãã¢ãçµéšã亀æãããã£ãŒãããã¯ãåãåãããšãå¯èœã§ãããããã®ãã©ãããã©ãŒã ã¯ãèªåèªèº«ã®ãã©ã³ãã確ç«ãããã£ãªã¢ã®å¯èœæ§ãåºããããã«ã䜿ããŸãã
å°éç¥èã®å ±æã¯ãä»ã®ããŒã¿ã¢ããªã¹ãããåŠã³ãå ±åã§åé¡è§£æ±ºãå³ãããšãå¯èœã«ããŸããã¡ã³ã¿ãŒã·ããããã°ã©ã ã«åå ããããšã§ãããã©ã³ã®ã¢ããã€ã¹ãåããããšãã§ããã ãã§ãªããå°æ¥çã«ã¯èªããã¡ã³ã¿ãŒãšãªã£ãŠåŸé²ã®æå°ãè¡ãããšãéèŠã§ããç¥èãšçµéšãå ±æããããšã¯ããããã§ãã·ã§ãã«ã³ãã¥ããã£å šäœã®æé·ãšçºå±ã«ç¹ãããŸãã
ãŸãšã
ããŒã¿ã¢ããªã¹ãã¯ãããŒã¿ã解æãããžãã¹æŠç¥ã«åœ¹ç«ãŠãå°é家ã§ãã圌ãã®ã¹ãã«ã«ã¯çµ±èšåŠãããã°ã©ãã³ã°ãããŒã¿ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ããããŠåé¡è§£æ±ºãå«ãŸããŸããåžå Žã§ã¯ãããŒã¿ã«åºã¥ãææ決å®ã®éèŠæ§ãé«ãŸããã¢ããªã¹ãã®éèŠãæ¡å€§ããŠããŸããæè²èæ¯ã«å ãããªã³ã©ã€ã³ã³ãŒã¹ãã€ã³ã¿ãŒã³ã·ãããéããç¶ç¶çãªåŠç¿ãæ±ããããŸããããžãã¹ã€ã³ããªãžã§ã³ã¹ïŒBIïŒã¯ããŒã¿ã¢ããªã¹ãã«ãšã£ãŠéèŠãªé åã§ãããããŒã¿ã®æå³ãçµå¶æŠç¥ã«æŽ»ããããšãããŒãšãªããŸãããã£ãªã¢ãç©ãããã«ã¯ãæ¥çã®éããç解ãããããã¯ãŒãã³ã°ãéããŠå°éç¥èãé«ããããšãå¿ èŠã§ãã