ã¿ã¤ãã«ã¯ã¤ããæ£ããã¯ããã£ãã¨æ»ããã
ããªãæç´ã£ã½ãããæè¿ãããããªãåè«ã«ä»ãåãããã¦ã¹ãã¬ã¹ãã«ãã客ããããã³ãã¼ã«è¦ãããã夢ãè¦ç¬ãããªããèãã¦ãããã¨ãå¤ããªã£ã¦ã
çç±ï¼ï¼Garbage In, Garbege Out.ã»ã»ã»ã»ã»ã»å½ã®ç¸é¢ï¼ã¡ãã£ã¨çµ±è¨ç¨èªã¨ã¯éãã¾ãï¼ã
å¹¾ãã¢ã«ã´ãªãºã ã§æ¢ç´¢ãã£ã¦ããæ段ã¨ç®çãæ··ãã£ã¦çµæã©ããããããªã解æãå¾ãããã ãã
ä¾ãã°ãé©å½ã«ããæ飯é£ã£ããã©ãããã¨ããæ
å ±ã¨ããã¹ãã®ç¹æ°ãã¨ããæ
å ±ããå人ç¹å®æ
å ±ãã§çµã³ä»ãããããããã°ãã¼ã¿ãæ³å®ãããï¼ããã°ã¨ããã«ã¯å°ããããç¥ããªããã©ï¼ã
ä¸æããã¨ããã®ä¸ã§ç¸é¢ã¯å¾ããããããããªãããã©ãããã¯ãæ¨æ¬ç©ºéã®ä¸ã®ç¸é¢é¢ä¿ãã§ãããªããããããã®ã©ã¤ããã°ãå
¨ã¦è©°ã¾ã£ãããã°ãã¼ã¿ãªããããããªãããããã®å¾ãããçµæãç¾å®ç©ºéã«é©å¿ã§ãããã©ããã¯ãããããã¯ã°ã©ã¦ã³ãã®çè«ã«é ¼ããããªãã®ã
å®éãããã°ãã¼ã¿ã¨ãã¦æ
å ±ãå¼ã£ããéããã¨ããçµã³ä»ããããæ
å ±ãã¨ããã®ã¯ãã´ããå«ããæ
å ±ããªããã«æ¯ã¹ãã¨ãã³ã£ããããã»ã©å°ãããªããã
ã¡ããã¨è¨ç»ãã¦ä½ã£ããã¼ã¿ã§ããè¬ã¨ãã§ããå¸è²©å¾èª¿æ»ã«ãªãã¨æ
å ±ã®è³ªã¯æ ¼æ®µã«è½ã¡ãå¯ä½ç¨ã¯çºç件æ°ä»¥ä¸ã«ã¯ãã¦ã«ãªããªãï¼çºç確çã¯ãããã¦ã«ããã¹ãã§ã¯ãªããã ãããããã¼ã¨ããã¬ãã«ã«ãªãï¼ãçºç確ç5%æªæºã¨ããæ¬å½ã«ãããã£ã¦è¨ãããã¨ããããã¼ãããå
çãåãã£ã¦å¦æ¹ãã¦ã¾ãããããã¨ããæããå¯ä½ç¨åºãããªäººã¯åé¿ããããã
ããã¹ãã®ç¹ã«å·çãã人種ãããæ飯ã¨ããå ãã«ããããã¨ããæãããããã§ããããæ¯æ§æ¹ã¨ãã¯ç¹ã«ããåä¾ããã¹ãã®ç¹æ°ãæªããªãè¦å ãæ¸ãããã¨ããã°ã£ã¦ããããããããããããæ飯ãã ããããã®ç¸é¢ã¯æ¬å½ããç¥ããªããã¨æãããã ãã©ããã絵馬ã¨ãè·æ©çããã«ãããã©ããï¼*1èåãªé²å¦æ ¡ã«ã¯å®æç³»åå¤ãã®ã§ãããå©çããããã¨ããçµæã¯ã¨ã¦ãå¾ãããããã¨æããã
ãã®æã®ãå½ã®ç¸é¢ãå
¥ãè¾¼ã¿ãããã®ãããã°ãã¼ã¿ãªã®ã§ã
èãã¢ãã«æ§ç¯åã®æ¢ç´¢ã«ã¯ä½¿ããããç¥ããªããã©ããã
ããå æ¸ãè¦ã人ã®è²ç¼é¡ããçµ±è¨çµæã«è¡¨ããã¨ããæã¯å¨ç¥ãããã¹ããç§å¦ã£ã½ãè¦ãã¦ãããããæè¡ã¬ãã«ã§ãããªãã®ããã
çç±ï¼ï¼ã«ã¼ãã£ããªãã£ãä½ããã®ãããçµæã使ããªã
å¹¾ããªãã§ãæ³å®ãããéå£ãæ°å人ã¨ãã®ã¬ãã«ãªããæ®å¿µãªé©ç¨ç¯å²ã«ãããªããªãã
ãªã¼ãã¼ã¡ã¤ããªæ¨å®ã¨ãã£ã¤ã£ã¦ããå人ã«é©ç¨ããéã«ã¢ãã¿ããã«é·ãæ¤æ»ã調æ»ãå¿
è¦ãªããå°éããããããã¬ã¹ãã³ã¹ãè¦ã¤ã¤é©ç¨ã®æ¹ãçµæçã«æ©ãã£ãããã
çµå±ãããªãã¨ãããã°ãã¼ã¿ã®æ
å ±éãã®ã¾ã¾ãããªãã¦ãæãã£ããæ
å ±éãè½ã¨ããç¶æ
ã§è§£æããæ¹ãè¨ç®ã³ã¹ããä½ãã¦ãå¾ã ã£ããããã®ããå¹¾ãè¨ç®æ©ãé²æ©ãã¦çãã¼ã¿è§£æãæããªãã¾ãããã£ã¤ã£ã¦ããç¡é§ã«ã³ã¹ãæ¯æãã£ã¦ã®ãããã¢ã¬ãªã®ã
çµæãåçã§ãªãã¨å¤§ãã¦æç¨ã§ã¯ãªããã¨ããã®ãããããããããã°ãã¼ã¿ãããªãã¨åãããªãå·®ãªãã¦ããããã使ã£ãã£ã¦å¤§ãã¦å£²ä¸ã«å½±é¿ããªããããªãã ãã
çç±ï¼ï¼å人ã®åä½ã§ãã¼ã¿çµåãããæå³ããã®ï¼
ãããIDã§ç´ä»ãããããæ°æã¡ãåãããã解æã¨ãã¦ãããæ£ããã®ãåãããã
ãã©ãè¦å ãã¨ã«ç´ä»ãããã£ã¦ãããªç¨åº¦ã®å¾åãªã大ä½åºããããããã¨ãããããã§åºãããã¨ãããã¨ããããã°ãã¼ã¿ã§ãããããã«ã¯ãªããã ãããã´ãå¤ããã§ã
ããã®è§£æã使ã£ã¦ä½ãåºæ¥ãå´ã®è¦å ãã§è§£æãã¼ã¿éãã¦ä½¿ãã°ããã ããªãã ãããåºèãã¨ã®å¯¾å¿ãªããåºèãã¨ã«ãã¼ã¿éããã°ããã ãã®è©±ã§ããã®é¡§å®¢å±¤ãã©ãã ãããããªååã売ããã ã®ã¨è§£æããåã«ãèªåã®ã¨ããã®ååã®å±æ§è¦ã¤ã¤ããã®åºã¯ã©ããªå¾åã®ãã®ã売ãããã£ã¦èãããããããã®åå群ãåé¡ãã¦ããæå¤ã¨ãã®ç³»çµ±ã®ååã売ããããããï¼ãã¿ãããªã¨ããã解æããæ¹ããä¸å¤®ã¨ãã§ãã¼ã¿éãã¦é ã²ããããæ°åæ©ãã決å®çã§ãããã
ç®ã®åã®é¡§å®¢ãæ½å¨çã«æã£ã¦ããåºèã¬ãã«ã§ã¯è¦ããªãéè¦ã¨ããããã°ãã¼ã¿ããæ´ãåºããï¼ããããªãã®ããæè©®ããã®èç©ãä¸å¤®ã«æµãã¦ããã ããªãã§ã寧ããåã
ã®åºèã®å·®åãè¦ããªããªãã¬ãã«ã§ãã解æåºæ¥ãªããã
æ£ç´ãªã¨ããã
ãããªç¶æ³ã§BI売ããããªãã§ããåã«ãBIã®æ³¢ã£ã¦ãã£ãã¨æããã ãã©ãã¿ããªDWHã大ããªå¤¢ãè¦ãã¤ã¤çµæçã«ã¯ã·ã§ãã¼ã³ãªçµæã«ãªã£ããã¨ãå¿ãã¦ãããªããã¨æãããã§ããã
OLAPã¨ãã¯ãæ£ç´ããã¿ãªãéãããªãã¨ã*2
*1:ã¡ãªã¿ã«ãç§ã®æ¯æ ¡ã¯ä»æç³»ã ã£ãã®ã§ãå¦æ ¡ã§ãããã£ã¦ã¾ããã
*2:å®éã«ã¯ãOLAPã®æ¹ãæ¬å½ã«ãã£ãããã»ã¹ãã·ã£ã«ã§ãããã¨ããå°ãã¿ã¯ç½®ãã¨ãã¦