ããžãã¹ããŒã¿ãæ¥å¢ããäžããã®èšå€§ãªããŒã¿ããå¿ èŠãªæ å ±ãå¹ççã«åŒãåºãããšãéèŠãªèª²é¡ãšãªã£ãŠããŸãããããªäžã§æ³šç®ãããŠããã®ãããããªã«ããŠã³ããšããåæææ³ã§ããããªã«ããŠã³ãšã¯ã倧ãŸããªéèšçµæããããã詳现ãªæ å ±ãåŸãããã«ã段éçã«ããŒã¿ãæãäžããŠããæè¡ã®ããšãæããŸãããã®ææ³ã掻çšããããšã§ãããžãã¹ã®ææ決å®ã«å¿ èŠãªæ å ±ãã¿ã€ã ãªãŒã«ååŸããããŒã¿ã«åºã¥ããå€æãäžãããšãã§ããããã«ãªããŸããæ¬èšäºã§ã¯ãããªã«ããŠã³ã®åºæ¬æŠå¿µããããã®ä»çµã¿ã掻çšæ¹æ³ãŸã§ãåå¿è åãã«ãããããã解説ããŠãããŸãã
ããªã«ããŠã³ãšã¯
ããªã«ããŠã³ãšã¯ãããŒã¿åæã«ãããŠã倧ãŸããªéèšçµæããããã詳现ãªæ å ±ãåŸãããã«ã段éçã«ããŒã¿ãæãäžããŠããææ³ã®ããšãæããŸããããžãã¹ã®çŸå Žã§ã¯ãèšå€§ãªããŒã¿ãå¹ççã«åæããææ決å®ã«åœ¹ç«ãŠãããšãæ±ããããŠããŸãããã®ãããªäžã§ãããªã«ããŠã³ã¯ãããŒã¿ã®å šäœåãææ¡ããäžã§ãå¿ èŠãªæ å ±ãç確ã«çµã蟌ãããã«æ¬ ãããªãæè¡ãšãªã£ãŠããŸãã
ããªã«ããŠã³ã®æå³
ããªã«ããŠã³ãšããèšèã¯ãè±èªã® “drill down” ãçŽèš³ãããã®ã§ããæãäžããããšããæå³ããããŸããããŒã¿åæã®æèã§ã¯ãéèšãããããŒã¿ãããã现ååãããé ç®ã«å解ããŠããéçšãæãããšãäžè¬çã§ããäŸãã°ãå šåœã®å£²äžããŒã¿ãèŠãåŸãå°åå¥ãåºèå¥ãååå¥ãžãšé çªã«æãäžããŠããããšã§ãããå ·äœç㪠sales ã®åŸåã課é¡ãæããã«ããããšãã§ããŸãã
ããªã«ããŠã³ã¯ãããŒã¿ããã©ãããç¶ã«éå±€åããŠåæããææ³ãšãèšããŸããæäžäœã®éèšããŒã¿ããå§ãŸããäžæ®µäžããããšã«ããã詳现ãªå èš³ããŒã¿ãçŸããæ§é ã«ãªã£ãŠããŸãããã®éå±€æ§é ã掻çšããããšã§ããŠãŒã¶ãŒã¯å¿ èŠãªæ å ±ã«çŽ æ©ãã¢ã¯ã»ã¹ã§ããããã«ãªããŸãã
ããªã«ããŠã³ã®ç®ç
ããªã«ããŠã³ãè¡ãäž»ãªç®çã¯ã以äžã®3ç¹ã«ãŸãšããããŸãã
-
- ããŒã¿ã®å šäœåãç解ããäžã§ãç¹å®ã®åé¡ãæ©äŒãç¹å®ããããš
éèšããŒã¿ãèŠãããšã§ãæ¥çžŸã®å šäœçãªåŸåãã€ããããšãã§ããŸãããã®äžã§ãããªã«ããŠã³ãè¡ãããšã§ãæ¹åãã¹ãç¹ã䌞ã°ãã¹ã匷ã¿ãå ·äœçã«èŠã€ãåºãããšãã§ããŸãã
-
- åå ã®ç©¶æãšåé¡è§£æ±ºã®ããã®æããããåŸãããš
æ¥çžŸã®äœè¿·ãäºæãã¬äºæ ãçºçããéã«ãããªã«ããŠã³ã掻çšããããšã§ããã®åå ãçªãæ¢ããããšãã§ããŸãã詳现ããŒã¿ãåæããããšã§ãåé¡ã®æ žå¿ã«è¿«ããé©åãªå¯Ÿçãè¬ããããã®æ å ±ãåŸãããšãã§ããã®ã§ãã
-
- ææ決å®ã®ã¹ããŒããšè³ªãé«ããããš
ããªã«ããŠã³ãçšããããšã§ãææ決å®ã«å¿ èŠãªæ å ±ãã¿ã€ã ãªãŒã«ååŸã§ããŸããããŒã¿ã«åºã¥ããå€æãäžãããšã§ãææ決å®ã®ã¹ããŒããšè³ªãé«ããããžãã¹ã®ç«¶äºåãé«ããããšã«ã€ãªãããŸãã
ããªã«ããŠã³ã®æäœæ¹æ³
ããªã«ããŠã³ã®æäœæ¹æ³ã¯ã䜿çšããããŒã«ãã·ã¹ãã ã«ãã£ãŠç°ãªããŸãããäžè¬çã«ã¯ä»¥äžã®ãããªæé ã§è¡ãããŸãã
-
- åæ察象ãšãªãããŒã¿ãéžæãã
åæãããããŒã¿ã»ãããç¹å®ããããŒã«ã«åã蟌ã¿ãŸãããã®éãããŒã¿ã®ä¿¡é Œæ§ãšç¶²çŸ æ§ã確èªããããšãéèŠã§ãã
-
- ããŒã¿ãéèšããå šäœåãææ¡ãã
éžæããããŒã¿ããé©åãªåãå£ã§éèšããŸããããã§ã¯ãããŒã¿ã®å€§ãŸããªåŸåãç¹åŸŽãã€ããããšãç®çãšããŸãã
-
- ããªã«ããŠã³ãå®è¡ãã
éèšçµæãèŠãªããããã詳现ãªæ å ±ãå¿ èŠãªé ç®ãéžæããŸããå€ãã®ããŒã«ã§ã¯ãã°ã©ãã®ç¹å®ã®éšåãã¯ãªãã¯ããããšã§ãèªåçã«é¢é£ããããŒã¿ãããªã«ããŠã³ãããä»çµã¿ã«ãªã£ãŠããŸãã
-
- ããªã«ããŠã³çµæãåæããæŽå¯ãåŸã
ããªã«ããŠã³ã«ãã£ãŠåŸããã詳现ããŒã¿ãåæããåé¡ç¹ãæ¹åæ©äŒãç¹å®ããŸããå¿ èŠã«å¿ããŠãããã«ããªã«ããŠã³ãç¹°ãè¿ããããæ·±ãæŽå¯ãåŸãããšãå¯èœã§ãã
ããªã«ããŠã³ãå¹æçã«æŽ»çšããããã«ã¯ãããŒã¿ã®æ§é ãæ¥åããã»ã¹ã«é¢ããæ·±ãç解ãäžå¯æ¬ ã§ãããŸããããªã«ããŠã³ã§åŸãããç¥èŠããå®éã®æ¥åæ¹åãã¢ã¯ã·ã§ã³ã«ã€ãªããŠããããšãéèŠãšãªããŸããããžãã¹ããŒãœã³ã«ã¯ãããŒã¿åæã®ã¹ãã«ã ãã§ãªãã課é¡è§£æ±ºã«åããå®è¡åãæ±ããããŠããã®ã§ãã
ããªã«ããŠã³ã¯ãããã°ããŒã¿æ代ã«ãããå¿ é ã®ããŒã¿åæææ³ã®äžã€ãšèšããŸããèšå€§ã§è€éãªããŒã¿ã®äžãããæ¬åœã«å¿ èŠãªæ å ±ãèŠã€ãåºããããžãã¹ã®ææ決å®ã«æŽ»ãããŠããããã«ã¯ãããªã«ããŠã³ã®ãããªæ®µéçãªã¢ãããŒããæ¬ ãããŸãããããŒã¿ã«åºã¥ãçµå¶ãå®è·µããããã«ãããªã«ããŠã³ã®æŠå¿µãšæäœæ¹æ³ãç解ããæ¥ã ã®æ¥åã«åãå ¥ããŠããããšããçŸä»£ã®ããžãã¹ããŒãœã³ã«æ±ããããŠããã®ã§ãã
ããªã«ããŠã³ã®ä»çµã¿
ããªã«ããŠã³ã¯ãããŒã¿åæã«ãããŠã倧ãŸããªéèšçµæãã段éçã«è©³çŽ°ãªããŒã¿ãžãšæãäžããŠããææ³ã§ãããã®ä»çµã¿ãç解ããããšã¯ãããžãã¹ããŒã¿ãå¹æçã«æŽ»çšããææ決å®ã®è³ªãé«ããããã«éåžžã«éèŠã§ããããã§ã¯ãããªã«ããŠã³ã®ä»çµã¿ã«ã€ããŠãããŒã¿ã®éå±€æ§é ãéèšã¬ãã«ã®æãäžãã詳现ããŒã¿ã®è¡šç€ºã®3ã€ã®èŠ³ç¹ãã解説ããŸãã
ããŒã¿ã®éå±€æ§é
ããªã«ããŠã³ãå®çŸããããã«ã¯ãåæ察象ã®ããŒã¿ãéå±€æ§é ãæã£ãŠããå¿ èŠããããŸããéå±€æ§é ãšã¯ãããŒã¿ãè€æ°ã®ã¬ãã«ã«åãããŠãããäžäœã¬ãã«ã®ããŒã¿ãäžäœã¬ãã«ã®ããŒã¿ãå å«ããé¢ä¿ã«ããããšãæããŸããäŸãã°ã売äžããŒã¿ã®å Žåã以äžã®ãããªéå±€æ§é ãæã€ããšãã§ããŸãã
- å šç€Ÿã¬ãã«
- å°åã¬ãã«
- åºèã¬ãã«
- ååã«ããŽãªã¬ãã«
- åå¥ååã¬ãã«
ãã®éå±€æ§é ãããããšã§ããŠãŒã¶ãŒã¯å šç€Ÿã®å£²äžååããå§ãŸããå¿ èŠã«å¿ããŠå°åãåºèãååã«ããŽãªãåå¥ååãžãšããªã«ããŠã³ããŠããããšãã§ããã®ã§ãã
éèšã¬ãã«ã®æãäžã
ããªã«ããŠã³ã®æ¬è³ªã¯ãéèšã¬ãã«ã段éçã«æãäžããŠããããšã«ãããŸããæåã¯ãããŒã¿å šäœãéçŽããéèšçµæã衚瀺ãããŠãŒã¶ãŒã«ããŒã¿ã®å šäœåãæäŸããŸãããã®åŸããŠãŒã¶ãŒãé¢å¿ãæã£ãé ç®ãã¯ãªãã¯ããããšã§ããã®é ç®ã«é¢é£ãã詳现ããŒã¿ã衚瀺ãããä»çµã¿ã«ãªã£ãŠããŸãã
äŸãã°ãå šç€Ÿã®å£²äžé«ã衚瀺ããç»é¢ã§ãç¹å®ã®å°åãã¯ãªãã¯ãããšããã®å°åã®å£²äžé«ã衚瀺ãããŸããããã«ããã®å°åå ã®ç¹å®ã®åºèãã¯ãªãã¯ããã°ãåºèã¬ãã«ã®å£²äžé«ã衚瀺ããããšããå ·åã§ãããã®äžé£ã®æäœã«ããããŠãŒã¶ãŒã¯å€§ãŸããªæ å ±ããå¿ èŠãªè©³çŽ°æ å ±ãžãšã¹ã ãŒãºã«èŸ¿ãçãããšãã§ããŸãã
詳现ããŒã¿ã®è¡šç€º
ããªã«ããŠã³ã®æçµç®çã¯ããŠãŒã¶ãŒãæ±ãã詳现ããŒã¿ã衚瀺ããããšã§ãã詳现ããŒã¿ã«ã¯ãæ°å€ããŒã¿ã ãã§ãªããã°ã©ããè¡šãå°å³ãªã©ã®ããžã¥ã¢ã«èŠçŽ ãå«ãŸããããšããããŸãããããã®æ å ±ãé©åã«çµã¿åãããããšã§ããŠãŒã¶ãŒã¯çŽæçã«ããŒã¿ãç解ããç確ãªææ決å®ãäžãããšãã§ããŸãã
ãŸããããªã«ããŠã³ã§è¡šç€ºããã詳现ããŒã¿ã¯ãå ã®éèšããŒã¿ãšæŽåæ§ãåããŠããå¿ èŠããããŸããã€ãŸããäžäœã¬ãã«ã®ããŒã¿ãåèšãããšãäžäœã¬ãã«ã®ããŒã¿ãšäžèŽããããã«ãããšããããšã§ãããã®æŽåæ§ãããããšã§ããŠãŒã¶ãŒã¯ããªã«ããŠã³ã®çµæãä¿¡é Œããå®å¿ããŠããŒã¿åæãé²ããããŸãã
ããªã«ããŠã³ã®ä»çµã¿ã¯ãäžèŠã·ã³ãã«ã«èŠããŸããããã®èæ¯ã«ã¯ããŒã¿ã®éå±€æ§é ãæŽåæ§ã®ç¶æãªã©ãæ§ã ãªå·¥å€«ãæœãããŠããŸãããããã®ä»çµã¿ãç解ããé©åã«æŽ»çšããããšããããžãã¹ããŒãœã³ã«ãšã£ãŠéèŠãªã¹ãã«ã®äžã€ãšèšããã§ããããããªã«ããŠã³ã䜿ãããªãããšã§ãèšå€§ãªããŒã¿ã®äžãããææ決å®ã«å¿ èŠãªæ å ±ãçŽ æ©ãåŒãåºããããžãã¹ã®ææã«ã€ãªããŠããããšãã§ããã®ã§ãã
ããªã«ããŠã³ã®æŽ»çšæ¹æ³
ããŒã¿åæã§ã®æŽ»çš
ããªã«ããŠã³ã¯ãããžãã¹ã«ãããããŒã¿åæã®å Žé¢ã§å€§ãã«æŽ»çšãããŠããŸããèšå€§ãªããŒã¿ããå šäœçãªåŸåãææ¡ããåŸãããªã«ããŠã³ãçšããŠè©³çŽ°ãªæ å ±ãåŸãããšã§ãããæ·±ãæŽå¯ãåŸãããšãã§ããŸããäŸãã°ãå šåœã®å£²äžããŒã¿ãèŠãåŸãå°åå¥ãåºèå¥ãååå¥ãžãšããªã«ããŠã³ããŠããããšã§ã売äžã®äŒžã³ãè¯ãå°åãåºèã奜調ãªååã«ããŽãªãªã©ãç¹å®ã§ããŸãã
ãŸããããªã«ããŠã³ã¯ãããŒã¿ã®ç°åžžå€ãå€ãå€ãçºèŠããããã«ãæå¹ã§ããå šäœã®åŸåãã倧ããå€ããæ°å€ãããå Žåããã®é ç®ãããªã«ããŠã³ããããšã§ãç°åžžå€ã®åå ã究æããããšãã§ããŸãããã®ããã«ãããªã«ããŠã³ã掻çšããããšã§ãããŒã¿åæã®ç²ŸåºŠãšå¹çãé«ããããžãã¹ã®ææ決å®ã«åœ¹ç«ãŠãããšãã§ããã®ã§ãã
åé¡ç®æã®ç¹å®
ããžãã¹ã®çŸå Žã§ã¯ãæ§ã ãªåé¡ããã©ãã«ãçºçããŸãããã®ãããªæãããªã«ããŠã³ãçšããŠåé¡ã®åå ãç¹å®ããããšãã§ããŸããäŸãã°ãããååã®å£²äžã䌞ã³æ©ãã§ããå ŽåããŸãã¯å šäœã®å£²äžããŒã¿ã確èªããŸãããã®äžã§ãç¹ã«å£²äžã®äœãå°åãåºèãããªã«ããŠã³ã§çµã蟌ãã§ãããŸããããã«ããã®å°åãåºèã®äžã§ã売äžã®äœãååã«ããŽãªãåå¥ååãç¹å®ããããšã§ãåé¡ã®æåšãæããã«ããããšãã§ããã®ã§ãã
åé¡ç®æãç¹å®ããåŸã¯ããã®æ å ±ãåºã«å¯Ÿçãè¬ããããšãéèŠã§ããããªã«ããŠã³ã§åŸãããç¥èŠã掻çšããããŒã±ãã£ã³ã°æŠç¥ã®èŠçŽããåšåº«ç®¡çã®æ¹åãã¹ã¿ããã®æè²ãªã©ãè¡ãããšã§ãåé¡ã®è§£æ±ºã«ã€ãªããŠããããšãã§ããŸããããªã«ããŠã³ã¯ãåé¡è§£æ±ºã®ããã®åŒ·åãªããŒã«ãšèšããã§ãããã
ææ決å®ãžã®å¿çš
ããžãã¹ã«ãããææ決å®ã¯ãé©åãªã¿ã€ãã³ã°ã§ãæ£ç¢ºãªæ å ±ã«åºã¥ããŠè¡ãããå¿ èŠããããŸããããªã«ããŠã³ã¯ãææ決å®ã«å¿ èŠãªæ å ±ãçŽ æ©ãæäŸããããšã§ããã®è³ªãšã¹ããŒããé«ããããšãã§ããŸããäŸãã°ãæ°ååã®è²©å£²èšç»ãç«ãŠãéãéå»ã®é¡äŒŒååã®å£²äžããŒã¿ãããªã«ããŠã³ã§åæããããšã§ãéèŠã®åŸåãå°åæ§ãªã©ãææ¡ããããšãã§ããŸãããã®æ å ±ãåºã«ãçç£éã®èª¿æŽã販売æŠç¥ã®æé©åãè¡ãããšã§ãæ°ååã®æå確çãé«ããããšãã§ããã®ã§ãã
ãŸããããªã«ããŠã³ã¯ããªã¹ã¯ç®¡çã®é¢ã§ã掻çšã§ããŸããäŸãã°ãåšåº«ç®¡çã«ãããŠãå šäœã®åšåº«éãé©æ£ã§ãã£ãŠããç¹å®ã®å°åãåºèã§åšåº«éå€ãæ¬ åãçºçããŠããªãããããªã«ããŠã³ã§ç¢ºèªããããšãã§ããŸãããã®æ å ±ãåºã«ãåšåº«ã®åé åãè£å ãªã©ã®ææ決å®ãè¡ãããšã§ãããžãã¹ã®ãªã¹ã¯ã軜æžããããšãã§ããŸãã
ããªã«ããŠã³ã掻çšããææ決å®ã¯ãããŒã¿ã«åºã¥ãåççãªã¢ãããŒããšèšããŸããããžãã¹ããŒãœã³ã«ã¯ãããªã«ããŠã³ã«ãã£ãŠåŸãããæ å ±ãé©åã«å€æããã¢ã¯ã·ã§ã³ã«ç§»ãåãæ±ããããŠããŸããããªã«ããŠã³ãææ決å®ã«æŽ»ããããšã§ãããžãã¹ã®ããã©ãŒãã³ã¹ãåäžããã競äºåãé«ããŠããããšãã§ããã®ã§ãã
以äžã®ããã«ãããªã«ããŠã³ã¯ãããŒã¿åæãåé¡ç¹å®ãææ決å®ãªã©ãããžãã¹ã®ããããå Žé¢ã§æŽ»çšããããšãã§ããéèŠãªææ³ã§ããããªã«ããŠã³ãå¹æçã«æŽ»çšããããã«ã¯ãããŒã¿ã®æ§é ãæ¥åããã»ã¹ã«é¢ããç解ãäžå¯æ¬ ã§ããããŸããããªã«ããŠã³ã§åŸãããç¥èŠãå®éã®ã¢ã¯ã·ã§ã³ã«ã€ãªããŠããå®è¡åãæ±ããããŸããããžãã¹ããŒãœã³ãããªã«ããŠã³ã®ã¹ãã«ã身ã«ã€ããæ¥ã ã®æ¥åã«æŽ»ãããŠããããšããããžãã¹ã®æåã«ã€ãªãããšèšããã§ãããã
ãŸãšã
ããªã«ããŠã³ã¯ãããŒã¿åæã«ãããŠå€§ãŸããªéèšçµæãã段éçã«è©³çŽ°ãªããŒã¿ãžãšæãäžããŠããææ³ã§ããèšå€§ãªããŒã¿ããå¿ èŠãªæ å ±ãå¹ççã«åŒãåºããããžãã¹ã®ææ決å®ã«æŽ»ããããšãã§ããŸããããªã«ããŠã³ã掻çšããããšã§ãå šäœã®åŸåææ¡ã ãã§ãªããåé¡ç®æã®ç¹å®ãåå 究æãå¯èœãšãªããŸãããŸããããŒã¿ã«åºã¥ãåççãªææ決å®ãè¡ãããšã§ãããžãã¹ã®ããã©ãŒãã³ã¹åäžã«ã€ãªããããšãã§ããã§ããããããªã«ããŠã³ã®ã¹ãã«ã身ã«ã€ããæ¥ã ã®æ¥åã«åãå ¥ããããšããçŸä»£ã®ããžãã¹ããŒãœã³ã«æ±ããããŠããŸãã