Excel ã§ã¬ããŒããäœæããæ代ã¯æ¥éã«å€±ããã€ã€ãããæ å ±ã®æ瀺ãšåæã«äŸ¿å©ãªããŒã«ãæ±ããåŸåãããããåéã§èŠãããŸããç§ãã¡ã¯ç€Ÿå ã§ã¬ããŒãã®ããžã¿ã«åã«ã€ããŠé·å¹Žè°è«ããŠãããTableau ã®èŠèŠåããã³ã»ã«ããµãŒãã¹åæã·ã¹ãã ãéžæããŸããã M.Video-Eldorado Group ã®åæãœãªã¥ãŒã·ã§ã³ããã³ã¬ããŒãéšéã®è²¬ä»»è ã§ãã Alexander Bezugly æ°ã¯ãæŠéããã·ã¥ããŒãã®æ§ç¯ã®çµéšãšçµæã«ã€ããŠèªããŸããã
èšç»ããããšããã¹ãŠå®çŸããããã§ã¯ãããŸãããããã®çµéšã¯èå³æ·±ããã®ã§ãããçããã«ãšã£ãŠã圹ç«ã€ããšãé¡ã£ãŠããŸãããŸãããã£ãšè¯ãã§ããæ¹æ³ã«ã€ããŠäœãã¢ã€ãã¢ããæã¡ã®æ¹ãããã£ããããŸããããã¢ããã€ã¹ãã¢ã€ãã¢ãããã ããã°å¹žãã§ãã
以äžã®ã«ããã¯ãç§ãã¡ãééããããšãšåŠãã ããšã«ã€ããŠã§ãã
ã©ãããå§ããã®ã§ããããïŒ
M.Video-Eldorado ã«ã¯ãååã«éçºãããããŒã¿ ã¢ãã«ããããŸããã€ãŸããå¿
èŠãªã¹ãã¬ãŒãžæ·±åºŠãåããæ§é åæ
å ±ãšãèšå€§ãªæ°ã®å®åã¬ããŒãã§ã (詳现ãåç
§)
çŽ 2 幎åãåºå®åœ¢åŒã®ã¬ããŒãã®ä»£ããã«ãSAP Analysis (Excel ã¢ããªã³ãæ¬è³ªçââã«ã¯ OLAP ãšã³ãžã³äžã®ãããã ããŒãã«) ã§åæã¬ããŒãã®äœæãéå§ããŸããããããããã®ããŒã«ã¯ãã¹ãŠã®ãŠãŒã¶ãŒã®ããŒãºãæºããããšãã§ããã倧å€æ°ã¯ã¢ããªã¹ãã«ãã£ãŠè¿œå åŠçãããæ å ±ãåŒãç¶ã䜿çšããŠããŸããã
ãšã³ããŠãŒã¶ãŒã¯æ¬¡ã® 3 ã€ã®ã«ããŽãªã«åé¡ãããŸãã
ããããããžã¡ã³ããé©åã«æ瀺ãããæ確ã«ç解ã§ããæ¹æ³ã§æ å ±ãèŠæ±ããŸãã
äžé管çè·ãäžçŽãŠãŒã¶ãŒãããŒã¿æ¢çŽ¢ã«èå³ããããããŒã«ãå©çšå¯èœãªå Žåã¯ç¬èªã«ã¬ããŒããäœæã§ããã圌ãã¯ãSAP Analysis ã®åæã¬ããŒãã®äž»èŠãŠãŒã¶ãŒã«ãªããŸããã
ãã¹ãŠãŒã¶ãŒã圌ãã¯ããŒã¿ãç¬èªã«åæããããšã«èå³ããªãããã¥ãŒã¹ã¬ã¿ãŒåœ¢åŒã Excel ã®ãããã ããŒãã«ãªã©ãèªç±åºŠãéãããã¬ããŒãã䜿çšããŠããŸãã
ç§ãã¡ã®ã¢ã€ãã¢ã¯ããã¹ãŠã®ãŠãŒã¶ãŒã®ããŒãºãã«ããŒããåäžã®äŸ¿å©ãªããŒã«ãæäŸããããšã§ããããŸãã¯çµå¶ãããããå§ããããšã«ããŸãããäž»èŠãªããžãã¹çµæãåæããããã«ã䜿ããããããã·ã¥ããŒããå¿ èŠã§ãããããã§ãç§ãã¡ã¯ Tableau ããå§ããŠãæåã« 80 ã€ã®æ¹åæ§ãéžæããŸãããXNUMX ã€ã¯ãåæã®æ·±ããšå¹ ãéãããŠããå°å£²æ¥ãšãªã³ã©ã€ã³ã®å£²äžææšã§ãçµå¶ããããèŠæ±ããããŒã¿ã®çŽ XNUMX% ãã«ããŒãããã®ã§ããã
ããã·ã¥ããŒãã®ãŠãŒã¶ãŒã¯çµå¶ãããã§ãã£ãããã補åã®ãã 20 ã€ã®è¿œå KPIãã€ãŸãå¿çé床ãç»å ŽããŸãããããŒã¿ãæŽæ°ããããŸã§ 30 ïœ 4 ç§ãåŸ ã€äººã¯ããŸãããããã²ãŒã·ã§ã³ã¯ 5 ïœ XNUMX ç§ä»¥å ã«å®äºããå¿ èŠããããã§ããã°å³åº§ã«å®äºããå¿ èŠããããŸãããããŠæ®å¿µãªãããç§ãã¡ã¯ãããéæã§ããŸããã§ããã
ã¡ã€ã³ ããã·ã¥ããŒãã®ã¬ã€ã¢ãŠãã¯æ¬¡ã®ããã«ãªããŸãã
éèŠãªã¢ã€ãã¢ã¯ãåèš 19 åããäž»èŠãª KPI æšé²èŠå ãå·ŠåŽã«çµåãããã®ãã€ããã¯ã¹ãšäž»ãªå±æ§ããšã®å
èš³ãå³åŽã«è¡šç€ºããããšã§ããã¿ã¹ã¯ã¯åçŽã«èŠããŸããã詳现ã確èªãããŸã§ã¯ãèŠèŠåã¯è«ççã§ç解ãããããã®ã§ãã
詳现1. ããŒã¿é
幎é売äžé«ã«é¢ããã¡ã€ã³ ããŒãã«ã¯çŽ 300 åè¡ãå ããŸããæšå¹Žãäžæšå¹Žã®ååãåæ ããå¿ èŠããããããå®å£²ããŒã¿ã ãã§çŽ1åè¡ã®ããŒã¿éãšãªããŸããèšç»ããŒã¿ãšãªã³ã©ã€ã³è²©å£²ãããã¯ã®æ å ±ãåå¥ã«ä¿åãããŸãããããã£ãŠãã«ã©ã ãåã€ã³ã¡ã¢ãª DB SAP HANA ã䜿çšããã«ãããããããçŸåšã®ã¹ãã¬ãŒãžãã 15 é±éåã®ãã¹ãŠã®ã€ã³ãžã±ãŒã¿ãŒããªã³ã¶ãã©ã€ã§éžæããã¯ãšãªã®é床ã¯çŽ 20 ïœ XNUMX ç§ã§ããããã®åé¡ã®è§£æ±ºçã¯ãããŒã¿ã®è¿œå ã®å®äœåã§ããããšãããããŸããããããèœãšãç©ŽããããŸããããã«ã€ããŠã¯ä»¥äžã§è©³ãã説æããŸãã
詳现 2. éæ·»å ã€ã³ãžã±ãŒã¿ãŒ
åœç€Ÿã® KPI ã®å€ãã¯ã¬ã·ãŒãã®æ°ã«é¢é£ä»ããããŠããŸãããããŠããã®ã€ã³ãžã±ãŒã¿ãŒã¯è¡æ° (ãã§ãã¯ããããŒ) ã® COUNT DISTINCT ãè¡šããéžæããå±æ§ã«å¿ããŠç°ãªãéã瀺ããŸããããšãã°ããã®ææšãšãã®å°é¢æ°ã¯æ¬¡ã®ããã«èšç®ãããå¿ èŠããããŸãã
èšç®ãæ£ããããã«ã¯ã次ã®ããšãã§ããŸãã
- ã¹ãã¬ãŒãžå ã§ãã®ãããªææšããã®å Žã§èšç®ããŸãã
- Tableau ã®ããŒã¿å šäœã«å¯ŸããŠèšç®ãå®è¡ããŸãã Tableau ã§ã®ãªã¯ãšã¹ãã«å¿ããŠãåä¿¡äœçœ®ã®ç²åºŠã§éžæãããã£ã«ã¿ãŒã«åŸã£ãŠãã¹ãŠã®ããŒã¿ãæäŸããŸãã
- ãã¹ãŠã®ã€ã³ãžã±ãŒã¿ãŒããç°ãªãéå ç®çµæãäžãããã¹ãŠã®ãµã³ãã« ãªãã·ã§ã³ã§èšç®ãããå ·äœåãããã·ã§ãŒã±ãŒã¹ãäœæããŸãã
ãã®äŸã§ã¯ãUTE1 ãš UTE2 ã補åéå±€ãè¡šããããªã¢ã«å±æ§ã§ããããšã¯æããã§ããããã¯éçãªãã®ã§ã¯ãªãããããéããŠç€Ÿå ã®ç®¡çãè¡ãããããã§ããç°ãªããããŒãžã£ãŒãç°ãªã補åã°ã«ãŒããæ åœããŸãããã¹ãŠã®ã¬ãã«ãå€æŽããããšããé¢ä¿ãä¿®æ£ããããšããããã³ XNUMX ã€ã®ã°ã«ãŒããããããŒãããå¥ã®ããŒãã«ç§»åãããšãã«äžå®ã®ãã€ã³ããå€æŽããããšãããã®éå±€ã®ã°ããŒãã«ãªæ¹èšãäœåºŠãè¡ãããŸãããåŸæ¥ã®ã¬ããŒãã§ã¯ãããããã¹ãŠãçŽ æã®å±æ§ãããã®å Žã§èšç®ãããŸããããã®ããŒã¿ãå ·äœåããå Žåããã®ãããªå€æŽã远跡ããå±¥æŽããŒã¿ãèªåçã«åèªã¿èŸŒã¿ããã¡ã«ããºã ãéçºããå¿ èŠããããŸããéåžžã«ç°¡åã§ã¯ãªãã¿ã¹ã¯ã§ãã
詳现3. ããŒã¿æ¯èŒ
ãã®ç¹ã¯åãšåæ§ã§ããèå¿ãªã®ã¯ãäŒæ¥ãåæããéã«ã¯ãåæãšã®æ¯èŒãããã€ãã®ã¬ãã«ã§è¡ãã®ãéäŸã§ãããšããããšã§ãã
åæãšã®æ¯èŒïŒæ¥ããšãé±ããšãæããšïŒ
ãã®æ¯èŒã§ã¯ããŠãŒã¶ãŒãéžæããæé (ããšãã°ã幎㮠33 é±ç®) ã«å¿ããŠã32 é±ç®ãŸã§ã®ãã€ããã¯ã¹ã衚瀺ããå¿ èŠããããšæ³å®ããŠããŸããããšãã°ãXNUMX æãªã©ã®æã®ããŒã¿ãéžæããå Žåãã®å Žåããã®æ¯èŒã¯ XNUMX æãŸã§ã®ååã瀺ããŸãã
æšå¹Žãšã®æ¯èŒ
ããã§ã®äž»ãªãã¥ã¢ã³ã¹ã¯ãæ¥ããšãšé±ããšã«æ¯èŒããå Žåãæšå¹Žã®åãæ¥ãèæ ®ããŠããããã§ã¯ãªããšããããšã§ããçŸåšã®å¹Žãã 4 ãåŒããå€ãå ¥åããããšã¯ã§ããŸãããæ¯èŒããææ¥ã«æ³šç®ããå¿ èŠããããŸããéã«ãæãæ¯èŒããå Žåã¯ãæšå¹Žã®ãŸã£ããåãæŠæ¥ãååŸããå¿ èŠããããŸããããã幎ã«ããã¥ã¢ã³ã¹ããããŸããå ã®ãªããžããªã§ã¯ããã¹ãŠã®æ å ±ãæ¥ããšã«åæ£ãããŠãããé±ãæã幎ãªã©ã®åå¥ã®ãã£ãŒã«ãã¯ãããŸããããããã£ãŠãããã«å ã®å®å šãªåææé¢ãååŸããã«ã¯ãXNUMX ã€ã®æé (ããšãã° XNUMX é±é) ã§ã¯ãªã XNUMX é±éãã«ãŠã³ããããããã®ããŒã¿ãæ¯èŒããŠãã€ããã¯ã¹ãåå·®ãåæ ããå¿ èŠããããŸãããããã£ãŠããã€ããã¯ã¹ã§æ¯èŒãçæããããã®ãã®ããžãã¯ã¯ãTableau ãŸãã¯ã¹ãã¢ããã³ãåŽã§å®è£ ããããšãã§ããŸããã¯ãããã¡ãããèšèšæ®µéã§ã¯ãããã®è©³çŽ°ãç解ããæ€èšããŠããŸããããæçµçãªããã·ã¥ããŒãã®ããã©ãŒãã³ã¹ãžã®åœ±é¿ãäºæž¬ããã®ã¯å°é£ã§ããã
ããã·ã¥ããŒããå®è£ ãããšããç§ãã¡ã¯é·ãã¢ãžã£ã€ã«ã®éããã©ããŸãããç§ãã¡ã®ä»»åã¯ããã¹ãã«å¿ èŠãªããŒã¿ãåããå®çšçãªããŒã«ãã§ããã ãæ©ãæäŸããããšã§ããããã®ãããç§ãã¡ã¯ã¹ããŒãããããçŸåšã®ã¹ãã¬ãŒãžåŽã®äœæ¥ãæå°éã«æããããšããå§ããŸããã
ããŒã 1: Tableau ãžã®ä¿¡ä»°
IT ãµããŒããç°¡çŽ åããå€æŽãè¿ éã«å®è£ ããããã«ãéå ç®ææšãèšç®ããéå»ã®æéãæ¯èŒããããžãã¯ã Tableau ã§äœæããããšã«ããŸããã
ã¹ããŒãž 1. ãã¹ãŠãã©ã€ãã§ããããŠã£ã³ããŠã®å€æŽã¯ãããŸããã
ãã®æ®µéã§ãTableau ãçŸåšã®åºé ã«æ¥ç¶ãã1 幎éã®ã¬ã·ãŒãæ°ãã©ã®ããã«èšç®ããããã確èªããããšã«ããŸããã
çµæïŒ
çãã¯æ鬱ãªãã®ã§ãã - 20åã§ããããããã¯ãŒã¯çµç±ã®ããŒã¿è»¢éãTableau ãžã®é«è² è·ãéå ç®ã€ã³ãžã±ãŒã¿ãŒã䜿çšããããžãã¯ã¯ HANA ã«å®è£ ããå¿ èŠãããããšã«æ°ä»ããŸãããããã¯ç§ãã¡ãããŸãæããããŸããã§ãããç§ãã¡ã¯ãã§ã« BO ãšåæã§åæ§ã®çµéšããããæ£ããèšç®ãããéå ç®çææšãçæããé«éã·ã§ãŒã±ãŒã¹ã HANA ã§æ§ç¯ããæ¹æ³ãç¥ã£ãŠããŸãããããšã¯ãTableau ã«åãããŠèª¿æŽããã ãã§ãã
ã¹ããŒãž 2. ãã£ã¹ãã¬ã€ ã±ãŒã¹ã調æŽããŸããå ·äœåã¯ããããã¹ãŠããã®å Žã§èª¿æŽããŸãã
TABLEAU ã«å¿ èŠãªããŒã¿ããã®å Žã§çæããå¥ã®æ°ããã·ã§ãŒã±ãŒã¹ãäœæããŸãããå šäœçã«ã¯è¯ãçµæãåŸããã9 é±éã§ãã¹ãŠã®ã€ã³ãžã±ãŒã¿ãŒãçæããæéã 10 ïœ 20 ç§ã«ççž®ããŸããããããŠãTableau ã§ã¯ãããã·ã¥ããŒãã®å¿çæéã¯æåã«éããšãã« 30 ïœ 10 ç§ããã®åŸã¯ãã£ãã·ã¥ã®ãã㧠12 ïœ XNUMX ç§ã«ãªãã ãããšæ£çŽã«äºæ³ããŠããŸããããããã¯äžè¬çã«ã¯ç§ãã¡ã«é©ããŠãããšèããããŸãã
çµæïŒ
æåã«ããã·ã¥ããŒããéã: 4 ïœ 5 å
ä»»æã®ã¯ãªãã¯: 3 ïœ 4 å
åºé ã®ä»äºãããã»ã©å¢ãããšã¯èª°ãäºæ³ããŠããŸããã§ããã
ããŒã 2. Tableau ã詳ããèŠã
ã¹ããŒãž 1. Tableau ã®ããã©ãŒãã³ã¹åæãšã¯ã€ãã¯ãã¥ãŒãã³ã°
ç§ãã¡ã¯ãTableau ãæãå€ãã®æéãè²»ãããŠããå Žæã®åæãéå§ããŸããããããŠãããã«ã¯éåžžã«åªããããŒã«ããããããã¯ãã¡ãã Tableau ã®å©ç¹ã§ããç§ãã¡ãç¹å®ããäž»ãªåé¡ã¯ãTableau ãæ§ç¯ããŠããéåžžã«è€é㪠SQL ã¯ãšãªã§ããããããã¯äž»ã«ä»¥äžã«é¢é£ããŠããŸããã
â ããŒã¿ã®è»¢çœ®ã Tableau ã«ã¯ããŒã¿ã»ããã転眮ããããŒã«ããªãããããã¹ãŠã® KPI ã詳现ã«è¡šçŸããããã·ã¥ããŒãã®å·ŠåŽãæ§ç¯ããã«ã¯ãã±ãŒã¹ã䜿çšããŠããŒãã«ãäœæããå¿ èŠããããŸãããããŒã¿ããŒã¹å ã® SQL ã¯ãšãªã®ãµã€ãºã 120 æåã«éããŸããã
- æéã®éžæãããŒã¿ããŒã¹ ã¬ãã«ã§ã®ãã®ãããªã¯ãšãªã¯ãå®è¡ãããã³ã³ãã€ã«ã«æéãããããŸããã
ãããã®ããªã¯ãšã¹ãåŠç 12 ç§ + å®è¡ 5 ç§ã
Tableau åŽã®èšç®ããžãã¯ãç°¡çŽ åããèšç®ã®å¥ã®éšåãã¹ãã¢ããã³ã ã¬ãã«ãšããŒã¿ããŒã¹ ã¬ãã«ã«ç§»åããããšã«ããŸãããããã¯è¯ãçµæããããããŸããã
ãŸãããŠã£ãã§èª¬æãããŠãããã®ã¢ãããŒãã«åŸã£ãŠãVIEW èšç®ã®æçµæ®µéã§å®å
šå€éšçµåãéããŠè»¢çœ®ãå®è¡äžã«è¡ããŸããã
ã€ãŸããèšå®ããŒãã«ãã€ãŸã転眮è¡å (21x21) ãäœæãããã¹ãŠã®ã€ã³ãžã±ãŒã¿ãŒãè¡ããšã«åé¡ããŠåãåããŸããã
ããã¯æ¬¡ã®ãšããã§ãã
ããã¯æ¬¡ã®ããã«ãªããŸããã
ããŒã¿ããŒã¹ã®è»¢çœ®èªäœã«ã¯ã»ãšãã©æéã¯ããããŸããããã®é±ã®ãã¹ãŠã®ã€ã³ãžã±ãŒã¿ãŒã®ãªã¯ãšã¹ãã¯ãçŽ 10 ç§ã§åŠçããç¶ããŸãããããããã®äžæ¹ã§ãç¹å®ã®ææšã«åºã¥ããŠããã·ã¥ããŒããæ§ç¯ãããšããç¹ã§ã¯æè»æ§ã倱ãããŠããŸããããã·ã¥ããŒãã®å³åŽã§ã¯ãç¹å®ã®ã€ã³ãžã±ãŒã¿ãŒã®ãã€ããã¯ã¹ãšè©³çŽ°ãªå
èš³ã衚瀺ãããŸãã以åã¯ããã£ã¹ãã¬ã€ã±ãŒã¹ã¯ 1 ïœ 3 ç§ã§åäœããŠããŸããããªã¯ãšã¹ã㯠XNUMX ã€ã®ã€ã³ãžã±ãŒã¿ãŒã«åºã¥ããŠããŸããããããŒã¿ããŒã¹ã¯åžžã«ãã¹ãŠã®ã€ã³ãžã±ãŒã¿ãŒãéžæããçµæã Tableau ã«è¿ãåã«çµæããã£ã«ã¿ãŒåŠçããããã«ãªããŸããã
ãã®çµæãããã·ã¥ããŒãã®é床ã¯ã»ãŒ 3 åã«äœäžããŸããã
çµæïŒ
- 5 ç§ â ããã·ã¥ããŒããããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ã®è§£æ
- 15 ïœ 20 ç§ - Tableau ã§äºåèšç®ãå®è¡ããŠã¯ãšãªãã³ã³ãã€ã«ããæºå
- 35 ïœ 45 ç§ - SQL ã¯ãšãªã®ã³ã³ãã€ã«ãš Hana ã§ã®äžŠåé次å®è¡
- 5 ç§ â Tableau ã§ã®çµæã®åŠçã䞊ã¹æ¿ããèŠèŠåã®åèšç®
- ãã¡ããããã®ãããªçµæã¯ããžãã¹ã«é©åããªããããæé©åãç¶ããŸããã
ã¹ããŒãž 2. Tableau ã®æå°éã®ããžãã¯ãå®å šãªå ·äœå
ç§ãã¡ã¯ã10 ç§éå®è¡ãããã¹ãã¢ããã³ãã§æ°ç§ã®å¿çæéãæã€ããã·ã¥ããŒããæ§ç¯ããããšã¯äžå¯èœã§ããããšãç解ããå¿ èŠãªããã·ã¥ããŒãã«ç¹åããŠããŒã¿ããŒã¹åŽã§ããŒã¿ãå ·äœåãããªãã·ã§ã³ãæ€èšããŸãããããããç§ãã¡ã¯äžèšã®ãããªäžççãªåé¡ãã€ãŸãéå ç®çææšã«ééããŸããããã£ã«ã¿ãŒãããªã«ããŠã³ãå€æŽãããšãã«ãTableau ãããŸããŸãªã¹ãã¢ããã³ããšãããŸããŸãªè£œåéå±€åãã«äºåã«èšèšãããã¬ãã«ãæè»ã«åãæ¿ããŠãããã©ããã確èªã§ããŸããã§ãã (äŸã§ã¯ãUTE ã䜿çšãããUTE1 ãš UTE2 ã䜿çšãã XNUMX ã€ã®ã¯ãšãªãç°ãªãçµæãçæããŸã)ããããã£ãŠãããã·ã¥ããŒããç°¡çŽ åããããã·ã¥ããŒãå ã®è£œåéå±€ãæŸæ£ããç°¡ç¥åãããããŒãžã§ã³ã§ã©ãã ãé«éã«ãªããã確èªããããšã«ããŸããã
ãã®ããããã®æåŸã®æ®µéã§ããã¹ãŠã® KPI ã転眮圢åŒã§è¿œå ããå¥ã®ãªããžããªãäœæããŸãããããŒã¿ããŒã¹åŽã§ã¯ããã®ãããªã¹ãã¬ãŒãžãžã®ãªã¯ãšã¹ã㯠0,1 ïœ 0,3 ç§ã§åŠçãããŸããããã·ã¥ããŒãã«ã¯æ¬¡ã®çµæã衚瀺ãããŸããã
æåã®éå£éšïŒ8ã10ç§
ä»»æã®ã¯ãªãã¯: 6 ïœ 7 ç§
Tableau ã«è²»ããããæéã¯æ¬¡ã®ãšããã§ãã
- 0,3ç§â ããã·ã¥ããŒãã® SQL ã¯ãšãªã®è§£æãšã³ã³ãã€ã«
- 1,5ïœ3ç§â ã¡ã€ã³ã®èŠèŠåã®ããã® Hana ã§ã® SQL ã¯ãšãªã®å®è¡ (ã¹ããã 1 ãšäžŠè¡ããŠå®è¡)
- 1,5ïœ2ç§â ã¬ã³ããªã³ã°ãããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ã®åèšç®
- 1,3ç§â é¢é£ãããã£ã«ã¿ãŒå€ (ãã©ã³ããéšéãéœåžãåºè) ãååŸããããã®è¿œå ã® SQL ã¯ãšãªã®å®è¡ãçµæã®è§£æ
ç°¡åã«ãŸãšãããš
èŠèŠåã®èŠ³ç¹ããã¯ãTableau ããŒã«ãæ°ã«å ¥ããŸããããããã¿ã€ãã³ã°ã®æ®µéã§ãè€éãªãã«ãã¬ãã«ã®ã»ã°ã¡ã³ããŒã·ã§ã³ããã«ããã©ã€ã㌠ãŠã©ãŒã¿ãŒãã©ãŒã«ãªã©ãããŸããŸãªèŠèŠåèŠçŽ ãæ€èšãããããã¯ãã¹ãŠã©ã€ãã©ãªã§èŠã€ãããŸããã
äž»èŠãªè²©å£²ææšãå«ãããã·ã¥ããŒããå®è£ ããŠãããšãã«ããŸã å æã§ããŠããªãããã©ãŒãã³ã¹ã®åé¡ã«ééããŸããã 2 ãæ以äžããããŸããããæ©èœçã«ã¯äžå®å šãªããã·ã¥ããŒããåãåããŸãããããã®å¿çé床ã¯èš±å®¹ç¯å²ã«éããŠããŸãããããŠç§ãã¡ã¯èªåèªèº«ã§æ¬¡ã®çµè«ãå°ãåºããŸããã
- Tableau ã¯å€§éã®ããŒã¿ãæ±ãããšãã§ããŸãããå ã®ããŒã¿ ã¢ãã«ã« 10 GB (çŽ 200 å X 50 è¡) ãè¶ ããããŒã¿ãããå Žåãããã·ã¥ããŒãã®é床ãå€§å¹ ã«äœäžããã¯ãªãã¯ããšã« 10 ç§ããæ°åããããŸããã©ã€ãæ¥ç¶ãšæœåºã®äž¡æ¹ãå®éšããŸãããåäœé床ã¯åçã§ãã
- è€æ°ã®ã¹ãã¬ãŒãž (ããŒã¿ã»ãã) ã䜿çšããå Žåã®å¶éäºé ãæšæºçãªæ段ã䜿çšããŠããŒã¿ã»ããéã®é¢ä¿ã瀺ãæ¹æ³ã¯ãããŸãããåé¿çã䜿çšããŠããŒã¿ã»ãããæ¥ç¶ãããšãããã©ãŒãã³ã¹ã«å€§ããªåœ±é¿ãäžããŸããç§ãã¡ã®å Žåãå¿ èŠãªãã¥ãŒ ã»ã¯ã·ã§ã³ããšã«ããŒã¿ãå®äœåãã以åã«éžæãããã£ã«ã¿ãŒãä¿æããªãããå®äœåãããããŒã¿ã»ããã«åãæ¿ããè¡ããªãã·ã§ã³ãæ€èšããŸãããããã㯠Tableau ã§ã¯äžå¯èœã§ããããšãå€æããŸããã
- Tableau ã§ã¯åçãã©ã¡ãŒã¿ãŒãäœæããããšã¯ã§ããŸãããæœåºäžãŸãã¯ã©ã€ãæ¥ç¶äžã«ããŒã¿ã»ããããã£ã«ã¿ãªã³ã°ããããã«äœ¿çšããããã©ã¡ãŒã¿ã«ã¯ãããŒã¿ã»ããããã®å¥ã®éžæã®çµæãå¥ã® SQL ã¯ãšãªã®çµæãå ¥åããããšã¯ã§ããŸããããã€ãã£ã ãŠãŒã¶ãŒå ¥åãŸãã¯å®æ°ã®ã¿ãå ¥åã§ããŸãã
- OLAP|ããããããŒãã«èŠçŽ ã䜿çšããããã·ã¥ããŒãã®æ§ç¯ã«é¢é£ããå¶éã
MSTRãSAP SACãSAP Analysis ã§ã¯ãããŒã¿ã»ãããã¬ããŒãã«è¿œå ãããšããã®ããŒã¿ã»ããäžã®ãã¹ãŠã®ãªããžã§ã¯ããããã©ã«ãã§çžäºã«é¢é£ä»ããããŸãã Tableau ã«ã¯ããããªããããæ¥ç¶ãæåã§æ§æããå¿ èŠããããŸããããã¯ããããããæè»ã§ããããã¹ãŠã®ããã·ã¥ããŒãã«ãšã£ãŠãããã¯èŠçŽ ã®å¿ é èŠä»¶ã§ãããããè¿œå ã®äººä»¶è²»ãããããŸããããã«ãããšãã°å°åããã£ã«ã¿ãªã³ã°ãããšãã«ãéœåžã®ãªã¹ãããã®å°åã®éœåžã®ã¿ã«å¶éãããããã«é¢é£ãã£ã«ã¿ãŒãäœæãããšããã ã¡ã«ããŒã¿ããŒã¹ãŸãã¯æœåºã«å¯Ÿããé£ç¶ããã¯ãšãªãçºçããåŠçé床ãèããäœäžããŸããããã·ã¥ããŒãã - æ©èœã®å¶éãäžæ¬å€æã¯ãæœåºã«å¯ŸããŠããç¹ã« Live-connecta ããã®ããŒã¿ã»ããã«å¯ŸããŠãå®è¡ã§ããŸããããã㯠Tableau Prep ãéããŠå®è¡ã§ããŸãããè¿œå äœæ¥ãå¿ èŠã§ãããåŠç¿ããã³ä¿å®ãå¿ èŠãªå¥ã®ããŒã«ã§ããããšãã°ãããŒã¿ã転眮ããããããŒã¿èªäœãšçµåãããããããšã¯ã§ããŸãããåã ã®åãŸãã¯ãã£ãŒã«ãã®å€æã«ãã£ãŠéãããããã®ã¯ãcase ãŸã㯠if ã«ãã£ãŠéžæããå¿ èŠããããããã«ããéåžžã«è€é㪠SQL ã¯ãšãªãçæãããããŒã¿ããŒã¹ã¯ã¯ãšãª ããã¹ãã®ã³ã³ãã€ã«ã«ã»ãšãã©ã®æéãè²»ãããŸãããã®ãããªããŒã«ã®æè»æ§ã®äœãã¯ã·ã§ãŒã±ãŒã¹ ã¬ãã«ã§è§£æ±ºããå¿ èŠããããããã«ããã¹ãã¬ãŒãžãããè€éã«ãªããè¿œå ã®ããŠã³ããŒããšå€æãå¿ èŠã«ãªããŸãã
ç§ãã¡ã¯ Tableau ãè«Šããããã§ã¯ãããŸãããããããç§ãã¡ã¯ Tableau ãç£æ¥çšããã·ã¥ããŒããæ§ç¯ã§ããããŒã«ããäŒæ¥ã®äŒæ¥å ±åã·ã¹ãã å šäœã眮ãæããŠããžã¿ã«åããããŒã«ãšã¯èããŠããŸããã
çŸåšãå¥ã®ããŒã«ã§åæ§ã®ããã·ã¥ããŒããç©æ¥µçã«éçºããŠãããåæã« Tableau ã®ããã·ã¥ããŒã ã¢ãŒããã¯ãã£ãããã«ç°¡çŽ åããããã«æ¹èšããããšããŠããŸããã³ãã¥ããã£ãèå³ãæã£ãŠããã ããã°ãçµæã«ã€ããŠãç¥ããããŸãã
ãŸããå°å£²åºãããã¯ããã«å€ãã®ããŒã¿ãååšãã Web ãµã€ããæã£ãŠãããããTabeau ã§ãã®ãããªå€§éã®ããŒã¿ãåºã«è¿
éãªããã·ã¥ããŒããæ§ç¯ããæ¹æ³ã«é¢ããã¢ã€ãã¢ãã¢ããã€ã¹ããåŸ
ã¡ããŠããŸãã
åºæïŒ habr.com