éååž°åæãšã¯ãããŒã¿åæææ³ã®ã²ãšã€ã§ãããŒã±ãã£ã³ã°æŠç¥ã«æå¹ãªææ®µã§ãã
äŒæ¥æŽ»åã§ã¯ã売äžã Web ãµã€ãã®é²èŠ§è æ°ãåºèãžã®æ¥åºè æ°ã客å䟡ãªã©ãããŸããŸãªããŒã¿ããªã¢ã«ã¿ã€ã ã§èç©ãããŸãããã®ãããªããŸããŸãªããŒã¿ã®äžããå¿ èŠãªãã®ãéžæããŠåæããããŒã±ãã£ã³ã°æŠç¥ã«æŽ»ãããŠããããšãã売äžã䌞ã°ãããã«å¿ èŠã«ãªããŸããããã§äœ¿ãããåæææ³ããéååž°åæã§ããéååž°åæã«ãã£ãŠãããŒã±ãã£ã³ã°æŠç¥ã«æŽ»ãããããŒã¿åæãå¯èœã«ãªããŸãã
ããã§ã¯ãããŒã¿åæææ³ã®ã²ãšã€ã§ããéååž°åæã®æŠèŠãšãããŒã±ãã£ã³ã°æŠç¥ã§ã®æŽ»çšäŸãåæãè¡ãæé ãããããã®ããŒã«ã«ã€ããŠè§£èª¬ããŸãã
äŒæ¥æé·ãå éãããBI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
CONTENTS
- éååž°åæãšã¯ïŒ
- éååž°åæã®å©çšã·ãŒã³
- éååž°åæã®æé
- éååž°åæãè¡ãéã®ãã€ã³ã
- éååž°åæã«äŸ¿å©ãªããŒã«
- Tableau ã«ããéååž°åæã§ãæ°ããªã€ã³ãµã€ããåŸã
- éååž°åæã¯ Tableau ãå©çšããŠè¡ããããŒã±ãã£ã³ã°æŠç¥ã«æŽ»çšããã
éååž°åæãšã¯ïŒ
éååž°åæãšã¯ãçµ±èšåŠäžã®ããŒã¿è§£æææ³ã®ã²ãšã€ã§ããååž°åæãšã¯ãèŠå ãšçµæã®å æé¢ä¿ãæããã«ããåèŠå ãçµæã«äžããŠãã圱é¿åºŠã颿°ã®åœ¢ã§æ°å€åããŠããããããšã«å°æ¥ã®äºæž¬ãè¡ãè§£æææ³ãæããŸãããã®ãã¡ã1 ã€ã ãã®èŠå ãæ±ããã®ããåååž°åæããè€æ°ã®èŠå ãæ±ããã®ããéååž°åæããšåŒã³ãŸãã
éååž°åæãšåååž°åæã®éã
çµ±èšåŠäžã®è§£æææ³ã¯ãèŠå ãšçµæã®é¢ä¿ã«ããã倧ãããåå€éè§£æããšãå€å€éè§£æãã® 2 ã€ã®ã°ã«ãŒãã«åããããŸããåååž°åæã¯åå€éè§£æãéååž°åæã¯å€å€éè§£æã®äžçš®ã§ããåå€éè§£æã¯ãçµæã«å¯ŸããèŠå ã 1 ã€ã®å Žåã«çšããããè§£æææ³ã§ããäžæ¹ã倿°éè§£æã¯ãçµæã«å¯ŸããèŠå ã 2 ã€ä»¥äžã®å Žåã«çšãããããã®ã§ãè€æ°ã®å€æ°ãæã€ããŒã¿ã®é¢é£æ§ãæããã«ããçµ±èšææ³ã®ç·ç§°ã§ããéååž°åæã®ã»ãã«ããå€å¥åæãããžã¹ãã£ãã¯ååž°åæãæ°éå I é¡ãæ°éå II é¡ãªã©ããŸããŸãªææ³ããããŸãã
åååž°åæã¯ãåå€éè§£æã§ãã®ã§ã1 ã€ã®èŠå ïŒèª¬æå€æ°ïŒãçµæïŒç®ç倿°ïŒã«äžãã圱é¿ãåæããçµæãäºæž¬ããŸãã説æå€æ°ãšã¯ãç®ç倿°ã«åœ±é¿ãäžããŠãã倿°ããç®ç倿°ãšã¯ãäœããã®åå ãåããŠçºçããçµæãšãªã£ãŠãã倿°ããæããŸããäŸãã°ãåºåè²»ãšå£²äžã®å®çžŸããŒã¿ãããåºåè²»ïŒèª¬æå€æ°ïŒãâ¯å䜿ã£ãå Žåã®å£²äžïŒç®ç倿°ïŒãäºæž¬ãããããªå Žåã¯åååž°åæã§ãã
äžæ¹ãéååž°åæã¯å€å€éè§£æã§ãã®ã§ãè€æ°ã®èŠå ïŒèª¬æå€æ°ïŒãçµæïŒç®ç倿°ïŒã«äžãã圱é¿ãåæããçµæãäºæž¬ããŸããäŸãã°ããããŸã§ã«éåºãããã§ãŒã³åº 10 åºèã®ç«å°ãååäŸ¡æ Œåž¯ã倩æ°ãåºèé¢ç©ãåŸæ¥å¡æ°ãšå£²äžã®ããŒã¿ãããæ°åºèãéåºããå Žåã®å£²äžãäºæž¬ãããããªå Žåã«éååž°åæãçšããŠããŒã¿ãåæããŸãã
äŒæ¥æé·ãå éãããBI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
éååž°åæã®å©çšã·ãŒã³
éååž°åæã¯ããžãã¹ã®çŸå Žã«ãããŠãããŒã±ãã£ã³ã°æŠç¥ãå¹çããè¡ãããå Žåã«å©çšãããŠããŸããäž»ãªå©çšã·ãŒã³ãšããŠã¯ãæ¬¡ã«æãã 2 ã€ããããŸãã
ããçµæã®èŠå ãåæããããšã
ããçµæã«å¯Ÿããè€æ°ååšããèŠå ãããããã©ãããã圱é¿ããŠããã®ããåæãããå Žåã«ãéååž°åæãå©çšããŸããäŸãã°ã10 åºèãå±éããã«ãã§ãã§ãŒã³ã§ãåºèé¢ç©ãåº§åžæ°ãåŸæ¥å¡ã®æ°ãé§ ããã®è·é¢ãã¢ãŒãã³ã°ãµãŒãã¹ã®æç¡ãšãã£ãèŠçŽ ããåºèã®å£²äžãé客ã«å¯ŸããŠã©ãã ãã€ã³ãã¯ããäžããŠããã®ããåæãããšãã£ãå Žåã§ãã
ããçµæã®äºæž¬ãããããšã
éååž°åæã¯ãã©ã®ãããªçµæã«ãªãã®ããäºæž¬ãããå Žåã«ãå©çšã§ããŸããçµæã«å¯Ÿããããããã®èŠå ãäžãã圱é¿åºŠãæ°å€ã§ç€ºãããã®åŒã®å€æ°éšåã«å¥ã®æ°å€ãåœãŠã¯ããããšã§ãå°æ¥ã®çµæãäºæž¬ããŸããäŸãã°ã10 åºèãå±éããã«ãã§ãã§ãŒã³ã§ãåºèé¢ç©ãåº§åžæ°ãé§ ããã®è·é¢ã«ãã£ãŠæ°åºèã®å£²äžãã©ãå€ãããããéååž°åæãå©çšããŠäºæž¬ããã®ã§ãã
äŒæ¥æé·ãå éãããBI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
é¢é£èšäº
éååž°åæã®æé
éååž°åæãé²ããæé ã«ã€ããŠç޹ä»ããŸããããã§ã¯ãã10 åºèãå±éäžã®ã«ãã§ãã§ãŒã³ããæ°èŠãªãŒãã³äºå®ã®æ°åºèã®å£²äžé«ãäºæž¬ããããã«ãéååž°åæãè¡ãå ŽåããäŸã«ããŸãã
1. åæå¯Ÿè±¡ãšãªãçµæãæ±ºãã
ãŸãã¯ãåæå¯Ÿè±¡ãšãªãçµæïŒç®ç倿°ïŒã決ããŸãããã®å Žåã¯ããæ°åºèã®å£²äžé«ãã§ãã
2. çµæãå·Šå³ããèŠå ãèãã
ããŸããŸãªèŠå ã®äžãããçµæã«åœ±é¿ãäžããŠããããªèŠå ïŒèª¬æå€æ°ïŒãããã¯ã¢ããããŸããã«ãã§ã®å£²äžé«ã«é¢é£ããããããªèŠå ãšããŠã¯ãç«å°ãåå人å£ãåºèé¢ç©ãåŸæ¥å¡æ°ãåº§åžæ°ã客å䟡ãã¡ãã¥ãŒæ°ãåšèŸºã®ç«¶ååºèæ°ãªã©ããããèããããŸãããã£ããå€ãã®åè£ãéããäžã§ããã®äžããäœãéžã¶ããæ éã«æ±ºããããšã«ãªããŸãã
ãªãã説æå€æ°ãéžã¶éã«ã¯ã1 ã€ãã€èª¬æå€æ°ã远å ãããåé€ãããããªããæé©ãªçµã¿åãããæ¢ããã¹ãããã¯ã€ãºæ³ããšããæ¹æ³ãå€ã䜿ãããŸããããã§ã¯ã客å䟡ãåºèé¢ç©ãåº§åžæ°ãåŸæ¥å¡æ°ãåå人å£ãã® 5 ã€ãéžãã ãšä»®å®ããŸãã
3. ããŒã¿ãéãã
ã¹ãããã¯ã€ãºæ³ã䜿ã£ãŠéžãã 説æå€æ°ã®ããŒã¿ãéããŸããä»åã®å Žåã¯ãçŸåšå¶æ¥äžã® 10 åºèã«ã€ããŠãããããã幎é売äžé«ïŒç®ç倿°ïŒãã客å䟡ãåºèé¢ç©ãåº§åžæ°ãåŸæ¥å¡æ°ãåå人å£ïŒèª¬æå€æ°ïŒãã®ããŒã¿ãéããŸãã
ãã®æ®µéã§ããèµ·ãããã¡ãªã®ã¯ã欲ããããŒã¿ã瀟å ã®ãã¡ãã¡ã«æ£ãã°ã£ãŠãããåéã«æéãšæéãããããšããåé¡ã§ããéååž°åæãã¹ã ãŒãºã«é²ããã«ã¯ãããŒã¿ã®äžå 管çãåæã«äœ¿ã BI ããŒã«ãšããŒã¿ããŒã¹ã®é£æºæ©èœãåããŠããã®ãçæ³ã§ãã
4. ããŒã¿ãåæããéååž°åŒãå²ãåºã
è§£æããŒã«ã䜿ã£ãŠåéããããŒã¿ãåæããåèŠå ã®å£²äžãžã®åœ±é¿ã®å€§ãããæ°å€åãããéååž°åŒããå²ãåºããŸããéååž°åŒã¯ãäŸãã°æ¬¡ã®ãããªæ¹çšåŒã®ããšã§ãã
ïŒéååž°åŒã®äŸïŒ
yïŒæ°åºèã®å£²äžé«ïŒïŒïŒ1.02ïŒååž°ä¿æ°ïŒÃ客å䟡ïŒïŒïŒ0.22ïŒååž°ä¿æ°ïŒÃåºèé¢ç©ïŒ+ïŒ0.56ïŒååž°ä¿æ°ïŒÃåº§åžæ°ïŒ+ïŒ0.4ïŒååž°ä¿æ°ïŒÃåŸæ¥å¡æ°ïŒïŒïŒ0.9ïŒååž°ä¿æ°ïŒÃåå人å£ïŒïŒ0.8ïŒå®æ°é
ïŒ
â»æ°åã¯äŸã§ã
å説æå€æ°ã«ä¹ããŠããååž°ä¿æ°ãšã¯ã倿°ã®åœ±é¿åãç€ºãæ°å€ã§ããæ°åã®å€§ããã¯èª¬æå€æ°ã®åäœã«äŸåããã®ã§ãæ°åèªäœã«ããŸãæå³ã¯ãªããæ°åã倧ãããã°å£²äžé«ãžã®åœ±é¿ã倧ãããšããããã§ã¯ãããŸããã圱é¿åºŠã®å€§ãããç¥ãã«ã¯ãè§£æããŒã«ã§åºåããããæšæºåä¿æ°ããšããæ°åãèŠãŸããæåŸã®å®æ°é ãšããã®ã¯ãã©ããªèª¬æå€æ°ã®åœ±é¿ãåããªããåºå®ãããå€ã®ããšã§ãã
5. éååž°åŒã䜿ã£ãŠæ°åºèã®å£²äžé«ãäºæž¬ããèšç»ã®ä¿®æ£ãªã©ãè¡ã
éååž°åŒã®ã客å䟡ãããåºèé¢ç©ããšãã£ãé ç®ã«ãæ°åºèã®èšç»ããŒã¿ãå ¥ããŠèšç®ããŸããèšç®çµæãèŠãŠãå説æå€æ°ã®æ°åºèã®å£²äžé«ãžã®åœ±é¿åºŠã確èªããªãããèšç»ã®ä¿®æ£ãè¡ã£ãŠãããŸããäŸãã°ãæ³å®ãããåº§åžæ°ã®åœ±é¿ã倧ãããåºèé¢ç©ã®åœ±é¿ãå°ãããªã©ãã£ãçµæããäºç®é åãæ€èšãããªã©ãããŸããŸãªäºæž¬ãç«ãŠãŠèšç»ã«åœ¹ç«ãŠãã®ã§ãã
äŒæ¥æé·ãå éãããBI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
éååž°åæãè¡ãéã®ãã€ã³ã
éååž°åæãè¡ãäžã§ã¯ãããã€ããã€ã³ãããããŸããæ¬¡ã«æãã 3 ã€ã®ãã€ã³ãã«æ³šæããŠåæãè¡ããŸãããã
æ±ããçããéååž°åæã§å°ããã®ãã確èªãã
çµæã®èŠå åæããäºæž¬åæãè¡ããå€å€éè§£æã«ã¯ãéååž°åæä»¥å€ã«ãããŸããŸãªææ³ããããŸããç®çã«ãã£ãŠã¯ãã»ãã®åæææ³ã®ã»ãããµããããå Žåãããã®ã§ããéååž°åæã§æ±ããçããåŸãããã®ãããæåã«ãã£ããæ€èšããŸããããäŸãã°ã説æå€æ°ãšããŠãé¡§å®¢ã®æ§å¥ããã倩æ°ããªã©ãæ°éåã§ããªããã®ã°ãããæ±ãããå Žåã¯ããæ°éå I é¡ããšããè§£æææ³ãåããŠããŸãã
倿°ã¯ãã¹ãŠæ°å€åãã
ããŒã¿åæãè¡ãããã«ã¯ãéååž°åŒã«ããèšç®ãå¿ èŠã§ãã®ã§ã倿°ã¯ãã¹ãŠæ°å€åããå¿ èŠããããŸãã説æå€æ°ã«ãã¢ãŒãã³ã°ãµãŒãã¹ã®æç¡ãããé¡§å®¢ã®æ§å¥ããªã©ãæ°éåã§ããªããã®ãå ãããšãã¯ããããïŒ1ããªãïŒ0ããç·ïŒ1ã女ïŒ0ãã®ããã«ãäºè æäžåŒã«å€æŽãããããŒå€æ°ã«çœ®ãæããŸãã
説æå€æ°ãå¢ãããããªã
ããã¯ã¢ãããã説æå€æ°ãå€ããããšãåé ç®ã®çµæãžã®åœ±é¿åºŠåããèŠãã¥ãããªãã®ã§ãå°ãªãã«ããŠããã®ãããããã§ããå€ããŠã 7 åã»ã©ãé©åãšããããŠããŸãã
äŒæ¥æé·ãå éãããBI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
éååž°åæã«äŸ¿å©ãªããŒã«
éååž°åæã䜿ã£ãŠã®å£²äžäºæž¬ã¢ãã«ã®äœæã¯ãExcel ãªã©ã®è¡šèšç®ãœããã§ã宿œå¯èœã§ããããããçŽ æ©ãç°¡åã«åæãè¡ããããªãã倧éã®ããŒã¿ã®åæã»æŽ»çšãå¹ççã«è¡ãããã®å°çšããŒã«ãå©çšããã®ãããããã§ããäžã§ã BI ããŒã«ã¯ããŒã¿ããŒã¹ãšã®é£æºãã¹ã ãŒãºã«ã§ããŸãããç®çã«åãããŠãéååž°åæä»¥å€ã®ããŸããŸãªåæææ³ã䜿ãåããããšãå¯èœã§ãã
äŒæ¥æé·ãå éãããBI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
äŒæ¥æé·ãå éããã BI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ã§ããŒã¿ã®äŸ¡å€ãæå€§åããŸãããïŒ Tableau ã®ç¡æãã©ã€ã¢ã«ãä»ããã詊ããã ããã
Tableau ç¡æãã©ã€ã¢ã«ãããŠã³ããŒãTableau ã«ããéååž°åæã§ãæ°ããªã€ã³ãµã€ããåŸã
éååž°åæãã§ãã BI ããŒã«ã«ã¯ããŸããŸãªãã®ããããŸãããæ®å¿µãªãã䜿ãåæã¯åãã§ã¯ãããŸãããBIããŒã«ã¯ãäŒæ¥å ã«èãããã倧éã®ããŒã¿ãéããŠåæãããããããã瀺ãããšã§ãè¿ éãªæææ±ºå®ã課é¡è§£æ±ºãæ¯æŽãããã®ã§ãããã®ãããBI ããŒã«ãéžã¶éã¯ãåæèœåã ãã§ãªããæäœæ§ã®é«ãããããããããéåžžã«éèŠã«ãªããŸãã
ãã®ç¹ãBI ãã©ãããã©ãŒã ãšããŠããŸããŸãªäŒæ¥ããè©äŸ¡ãåŸãŠãã Tableau ã¯ãããŒã¿åæã«ãããŠãå¿ èŠãªèŠçŽ ãåããäžçäžã§äœ¿çšãããŠããå®çžŸããããŸããTableau ã«ã¯ã以äžã®ãããªã¡ãªããããããŸãã
ã»çŽæçã«æäœã§ãã
Tableau ã§ã¯ãçŽæçã«æäœãã§ããããã«ãªã£ãŠããããã©ãã°ïŒããããã§ããã·ã¥ããŒããäœãäžããããšãå¯èœã§ããããŒã¿åæã®éã«ããæäœæ¹æ³ãªã©äœèšãªããšãèããå¿ èŠããããŸããã
ã»ããŒã¿ãèŠèŠçã«ãããããã
Tableau ã¯ãããŒã¿ãèŠèŠçã«ããããããã€ã³ã¿ãŒãã§ã€ã¹ãæ¡çšããŠããŸããäžç®ã§å 容ãçè§£ããããããããŒã¿ãå¯èŠåããŠããã®ã§ãåæçµæãç¬æã«ææ¡ããããšãã§ããŸãã
ã»å€éšããŒã«ãšã®é£æºæ§ãé«ã
Tableau 㯠ExcelãCSV ãã¡ã€ã«ãOracle ããŒã¿ããŒã¹ãªã©ã100 çš®é¡ä»¥äžã®å€éšããŒã«ãšã®é£æºãå¯èœã§ããã³ãŒãäžèŠã§é£æºã§ããã®ã§ãåæã«å¿ èŠãªç€Ÿå ããŒã¿ã®åéãã¹ã ãŒãºã§ãã
ã»ãªã¢ã«ã¿ã€ã æŽæ°ãå¯èœ
Tableau ã¯ããŒã¿ããŒã¹ãšã®æ¥ç¶åœ¢åŒããã©ã€ãæ¥ç¶ãã«ããããšã§ãããŒã¿ã®ãªã¢ã«ã¿ã€ã æŽæ°ãå¯èœã§ããæ å ±ã®æŽæ°ã«åŽåãè²»ããããšãªããåžžã«ææ°ã®ããŒã¿ã䜿ã£ãŠåæãè¡ããŸãã
ã»è±å¯ãªåææ©èœ
Tableau ã¯ãéååž°åæã¯ãã¡ãããR ãš Python ã®çµåãé«åºŠãªã³ããŒãåæãšãã£ããã®ãŸã§ãè±å¯ãªåææ©èœãåããŠããŸãã
ã»ããŒã ã§çµæãå ±æãããã
Tableau ã§ããã°ããŒã ã§ããã·ã¥ããŒããå ±æããããšãç°¡åã§ããåããªã¢ã«ã¿ã€ã ã®ããŒã¿ãèŠãªãããããŒã±ãã£ã³ã°æŠç¥ãèããããšãã§ããŸãã
äŒæ¥æé·ãå éãããBI ããŒã«ãå°å ¥ããŸãããïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«
éååž°åæã¯ Tableau ãå©çšããŠè¡ããããŒã±ãã£ã³ã°æŠç¥ã«æŽ»çšããã
éååž°åæã¯ãããžãã¹ã§ã¯å£²äžäºæž¬ããã©ã³ãã€ã¡ãŒãžã®åæã顧客æºè¶³åºŠã®åæãªã©ã«å¹ åºãå©çšããããçµ±èšåŠäžã®ããŒã¿è§£æææ³ã®ã²ãšã€ã§ããExcel ãªã©ã®è¡šèšç®ãœããã§ãã§ããªãããšã¯ãããŸããããã¹ã ãŒãºã«åæãè¡ããããªããé«ãåæèœåãšæäœæ§ã®é«ãããããããããåãã BI ããŒã«ãå°å ¥ããã®ãããããã§ãã
äžã§ã BI ãã©ãããã©ãŒã ã® Tableau ã¯ãéååž°åæãããŒã±ãã£ã³ã°æŠç¥ã«æŽ»çšããããã® BI ãã©ãããã©ãŒã ãšããŠãå€ãã®äŒæ¥ããé«ãè©äŸ¡ãåŸãŠããŸãããŸããç¡æãã©ã€ã¢ã«ããã¹ã¿ãŒããããæ¹ã¯ãäžèšã®ãã¿ã³ãã詳现ãã確èªãã ããã
BI ãœãããŠã§ã¢ãç¡æã§äœéšïŒ
ããŒã¿åæãç°¡åã«ãã Tableau ãšã¯ïŒ ä»ããå§ãããïŒTableau ç¡æãã©ã€ã¢ã«