ã¬ãŒãããŒãçºè¡šããŠãããããžãã¯ã»ã¯ã¢ãã©ã³ãããããœãªã¥ãŒã·ã§ã³éžå®ã®ããã²ãŒã·ã§ã³ãšããŠå©çšããŠããäŒæ¥ã¯å€ãã ãããå幎ã§ã¯ãªããæ°å¹Žåãæ¯èŒããŠèŠããšåžå Žã«ãããããžã·ã§ã³ã®å€åãªã©ãèŠãŠãšããããããžãã¹ã€ã³ããªãžã§ã³ã¹ããã³åæãã©ãããã©ãŒã åéã«ãããŠã¯ã2016幎çã§å€§ããªå€åããã£ãã
ã¬ãŒãããŒã®ããžãã¯ã»ã¯ã¢ãã©ã³ãã¯ãç¹å®ã®åžå Žã«ããããªãµãŒãã®é倧æã§ãããžã§ã³ã®å®å šæ§ãšå®è¡èœåãšãã2ã€ã®é¢ãããã³ããŒãè©äŸ¡ããããšã«ãããåžå Žå ã§ç«¶åãããã³ããŒã®çžå¯Ÿçãªäœçœ®ä»ããåºãèŠéããæç€ºããã
![]() |
ã¬ãŒãããŒã®ããžãã¯ã»ã¯ã¢ãã©ã³ã |
4ã€ã®ãããã¯ã«åããŠããžã·ã§ã³è¡šç€ºãããäžã§ãããžãã¹ã€ã³ããªãžã§ã³ã¹ããã³åæãã©ãããã©ãŒã éšéã«ãããŠã¯ãå³äžã«ãããããªãŒããŒãã«å ¥ããã®ã2014幎ã¯10瀟ã2015幎ã«ã¯9瀟ãã£ããã2016幎çã§ã¯ããã3瀟ã«ãªã£ãŠãããæ®ã£ãã®ã¯ãTableauãããMicrosoftãããQlikTechãã®3瀟ã ãããããæ°å¹ŽåããããªãŒããŒãã«å ¥ã£ãŠããäŒæ¥ã§ã¯ãããããªããã®ãããªçµæã«ãªã£ãã®ã ããã?
ããŸããä»åã®ããžãã¯ã»ã¯ã¢ãã©ã³ãã«ã¯ååãŸã§ãã®ãšé£ç¶æ§ããªããªã£ãŠããŸããè©äŸ¡åºæºãå€ãã£ããããéå»ã®ãã®ãšæ¯èŒããŠã©ãã䌞ã³ããšããæå³ã§ã¯ãããŸããããšèªãã®ã¯ãã¬ãŒãã㌠ãžã£ãã³ ãªãµãŒãéšé ã¢ããªã±ãŒã·ã§ã³ãº ãããŒãžã³ã° ãã€ã¹ ãã¬ãžãã³ãã®å å ç§ææ°ã ã
|
ã¬ãŒãã㌠ãžã£ãã³ ãªãµãŒãéšé ã¢ããªã±ãŒã·ã§ã³ãº ãããŒãžã³ã° ãã€ã¹ ãã¬ãžãã³ã å å ç§ææ° |
æ°ããªè©äŸ¡åºæºãšããŠå ããããã®ã¯ãæè¿ã®ããžãã¹ãŠãŒã¶ãŒã®ããŒãºã ãšããã
ãITéšéãåæãè¡ãã®ã§ã¯ãªãããŠãŒã¶ãŒèªèº«ãæå ã§åæãç°¡åã«è¡ãããšããµããŒããããŠãããããŒã«ã«éèŠããããŸãããšå å æ°ããã®ãããã»ã«ããµãŒãã¹BIãæ¯æŽããæ©èœã®æç¡ãªã©ãæ°ããªè©äŸ¡åºæºã远å ãããåèŠçŽ ã®éã¿ä»ãã倿Žãããçµæã2016幎çã«åæ ãããŠããã®ã ãšããã
ããããããã°ã©ãã£ã«ã«ãªåæãã§ããããŒã«ãçŸå ޿޻çšããããŒãºãæ¡å€§
2016幎çã§ãªãŒããŒã«å ¥ã£ã3瀟ã¯ãããããã°ã©ãã£ã«ã«ãªåºåãåããExcelãAccessã䜿ã£ãããšããããŠãŒã¶ãŒãªãã°æ¯èŒç容æã«äœ¿ãããšãããããããããã€ã³ã¿ãã§ãŒã¹ã®è£œåãæã€ãšãã£ãç¹åŸŽããããçšéã¯ãããžãã¹éšéãè¡ãããŒã¿æŽ»çšã ã
ãBIã«ãããŠã¯ãITéšéããŠãŒã¶ãŒéšéã®èŠæããã¢ãªã³ã°ããŠå šç€Ÿçã«å±éããã¬ããŒãã£ã³ã°ãšããã®çµæãå€éšããŒã¿çãçµã¿åãããŠãŠãŒã¶ãŒéšéãè¡ãã»ã«ããµãŒãã¹BIããããŸããã¬ããŒãã£ã³ã°ã®æ¹ã¯ã»ãŒæçããç¶æ ã«ãããŸããããããŸã§Excelçã§è¡ãããŠããã»ã«ããµãŒãã¹BIãç°¡åã«ã§ãããã®ãä»ã®ãã¬ã³ãã§ãããšå å æ°ã¯èª¬æããã
ãã¬ã³ããšããããšããããããããã«ãçŸåšéèŠããããã売ããŠãããšããç¹ãè©äŸ¡ããŠãããã§ã¯ãªããããããããŒã«ãæ±ããããŠããã®ã ããããããã¯ãã¬ããŒãã£ã³ã°åã®BIãæ®åããŠããããšãäžå ã ãšããã
ãã¬ããŒãã£ã³ã°ã«ãã£ãŠããŒã¿ãæã£ãŠããããšãããããŸããããããŒã¿ã容æã«æã«å ¥ãããã«ãªããŸããããã®çµæããŠãŒã¶ãŒãå€åœ©ãªèŠæ¹ãããããªã£ãããã§ãã(å å æ°)
ã¬ããŒãã£ã³ã°ã§åºåãããããŒã¿ãã«ã¹ã¿ãã€ãºããŠå©çšããŠãããŠãŒã¶ãŒéšéãããã1段éäžã®èªç±åºŠãæ±ããçµæããã»ã«ããµãŒãã¹BIã®éèŠã«ãªã£ãŠããããã ã
ããã¯äžççãªæµãã ããæ¬§ç±³ã§ã¯ãããŸã§ITéšéãäž»å°ããŠãããã®ãçŸå Žã«ãå±éããããšãã圢ã§äŒžã³ãŠããäžæ¹ãæ¥æ¬ã®å Žåã¯ãã§ã«çŸå ŽãExcelçãå©çšããŠå®çŸããŠãããã®ããããç°¡åã«å®çŸã§ããããŒã«ãšããŠã®éèŠã ã
ãŠãŒã¶ãŒéšéãITéšéããµããŒãããããšãããè¯ãããŒã¿æŽ»çšã®æ¡ä»¶
ã»ã«ããµãŒãã¹BIããŒã«ã¯ãæ¯èŒçå®äŸ¡ãªè£œåãå€ãããããéšéã®å šå¡ã§å©çšãããå šç€Ÿçã«å°å ¥ãããªã©ã倧éå°å ¥ãè¡ããšããŒã¿ã«ã®ã©ã€ã»ã³ã¹ã³ã¹ãã倧ãããªã£ãŠããŸãããã®ãããã¬ããŒãã£ã³ã°ãšã®æ£²ã¿åãã䜿ãåããèããŠäžæã«å°å ¥ããããšããã ã
ãã»ã«ããµãŒãã¹BIããŒã«ã¯ã¹ã¢ãŒã«ã¹ã¿ãŒãããããããšãããããã£ãšäŒžã³ãŠããŸããå®äŸ¡ã§ãããããéé¡ããŒã¹ã®éèšã§ã¯ç®ç«ã£ãååšã«ãªãã¥ããã®ã§ãããéèŠã¯ä»¥åãããããŸããã(å å æ°)
2016幎çã®ããžãã¯ã»ã¯ã¢ãã©ã³ãã§ããªãŒããŒãã«ãªã£ãäŒæ¥ãæäŸããããŒã«ã¯ããããããã¢ã³ã¹ãã¬ãŒã·ã§ã³ãäžæããèŠãç®ã«èªåãã§ãããã ãšæãããã補åã ãšãããã³ã¹ãã«å ããŠãããã£ãéšåãéèŠã®é«ãŸããåŸæŒãããŠããããæ³šæç¹ãããã
ãäœ¿ãæ¹ã¯ç°¡åã§ãããããŒã¿ã®äºåå å·¥ã¯å¿ èŠã«ãªããŸããããšãã°è£œé æãšåºè·æã販売æã§ããããåäœãéãå ŽåãèªåãèŠããããŒã¿ã®åäœã«åãããŠå šäœãæŽããå¿ èŠãåºãŠããŸãããããã£ãããšã¯çµå±äººããããããªãã®ã§ãäžéšè£œåã«ã¯ãããæ¯æŽããæ©èœãåãã£ãŠããŸãããšå å æ°ã¯èªãã
ãŸããã»ã«ããµãŒãã¹BIã®æ®åã«ãã£ãŠãITéšéã«ã¯ãããŸã§ãšéã£ã察å¿ãå¿ èŠãšããããšãããããã¯ãŠãŒã¶ãŒéšéã®ãµããŒãã ã
ã誰ããé 匵ã£ãŠåæããçµæãããããæ¯æé Œããããšç¹å®ã®äººã«è² æ ããããç¶ããŠããŸãããšããããŸãããŸãããŠãŒã¶ãŒéšéãããããæå ã§åæãè¡ãããã«ãªã£ãçµæã瀟å ã§åãäœæ¥ãéè€ãããããªããŸããITéšéã¯ãŠãŒã¶ãŒéšéã®åãããã£ããèŠãªãããå¿ èŠãããã°æ¯æè¡ããããªäœæ¥ã¯ITéšéåŽã§åŒãåããéè€ããŠããäœæ¥ãå·»ãåããªã©ããããŸã§ãšã¯éã£ã察å¿ãå¿ èŠã«ãªããŸãããšå å æ°ã¯ææããã
æè¿ãªãéããæã«å ¥ããããšã«åœ¹ç«ã€ã»ã«ããµãŒãã¹BIããŒã«
å å æ°ã¯ç¹°ãè¿ããããžãã¯ã»ã¯ã¢ãã©ã³ããèŠãŠãå³äž(ãªãŒããŒ)ã®ãããã¯ã«ãããããã補åã ãããããããéžãŒãããšå®æã«ã¯èããŠæ¬²ãããªãããšèªãã
補ååºè·æ°ãæ©èœã ãã§ãªããŠãŒã¶ãŒãªãã¡ã¬ã³ã¹çãèæ ®ããããããåªç§ãªè£œåã§ãããžãã¯ã»ã¯ã¢ãã©ã³ãã«å ¥ã£ãŠããªããšããããšã¯ååã«ããããã®ã ããŸããäžçã§2ã€ä»¥äžã®å°åã§å©çšãããŠããããšãšããåææ¡ä»¶ãããåœç£ããŒã«ãªã©ã¯ãŠãŒã¶ãŒã®è©äŸ¡ãé«ãã§ããéžåºãããªããšãã宿 ãããã
ãããããžãã¯ã»ã¯ã¢ãã©ã³ããçŸåšã®åžå ŽããŒãºã匷ãåæ ãããã®ã§ããã®ã確ãã ãä»åŸã¯ããæå ã§ç©æ¥µçãªããŒã¿æŽ»çšãè¡ããããšããããžãã¹ããŒãœã³ãå¢ããããŒã«ãå°å ¥ããäŒæ¥ã¯å¢ããŠããã ãããã»ã«ããµãŒãã¹BIããŒã«ã«ããåæã®åæ ãã瀟å ã§ã®ããŒã¿ãµã€ãšã³ãã£ã¹ãã®è²æãªã©ãé²ãããšãæåŸ ã§ãããã ã
æåŸã«å å æ°ã¯ãã仮説ãç«ãŠãŠåæããOK/NGã®èŠæ¥µããç¹°ãè¿ãããŒã¿æŽ»çšã¯ãéãæ¢ããŠãããããªãã®ã§ããããŒã¿ãçµãããšã¯éã®ãããããªæã«ç®æãã€ããŠäœæ¥ããããšãšäŒŒãŠããŸãã倧éã®ããŒã¿ã¯éå±±ã§ãããéã®å»¶ã¹æ¿ã§ã¯ãªãã®ã§ããéé±ã¯èŠãç®ã§ã¯åšåŠããããã¥ãããèŠåŽãããŠããããå°ãã®éãåãåºããŸããäžçãå€ããããšããææ°èŸŒã¿ãªããããè¯ãã§ãããããäžå°äŒæ¥ã«ãšã£ãŠã¯è·ã®éã話ã§ããã ã£ãããã£ãšæè»œã«ãéãå«ããšåãã£ãŠãã補åããã®æœåºã詊ã¿ãæ¹æ³ãè¯ãã§ããããããã§ã«è²Žéå±ãšããŠç²Ÿè£œãããŠãããã®ã溶ãããŠåºãçŽããšããããæ¹ããããŸãããšãããã°ããŒã¿ãšãã圢ã§ã¯ãªããèªç€Ÿã®ç®çãããžãã¹èŠæš¡ã«åãããŠãæå ã«ããããŒã¿ã®çµã¿åããããã»ã«ããµãŒãã¹BIãå©çšããŠããŒã¿æŽ»çšããŠããããšã®éèŠæ§ãææããã


