
äŒèšããŒã¿ × Tableau
äŒèšæ¥åãšTableauã®
ã¹ãã·ã£ãªã¹ããããã«ããã

Success Mark ã®äºäŸäžèЧ
âïŒãŠãŒã¹ã±ãŒã¹ïŒ
Success Markã®ãµãŒãã¹ã®ç¹é·
äŒèšæ¥åãšTableauã®
è±å¯ãªç¥èŠ
é«åºŠãªäŒèšç¥èãæã€Tableauã¹ãã·ã£ãªã¹ããè±å¯ã«åšç±ããèŠä»¶å®çŸ©ããæ§ç¯ã»å®çã»éçšãŸã§ãäžæ°éé¢ã§ãµããŒãããŸãã
äžè²«ããããŒã¿åºç€ã®æ§ç¯
ããã·ã¥ããŒãã®æ§ç¯ã«ãšã©ãŸãããé«åºŠãªELTæè¡ã«ããåçš®ã·ã¹ãã ïŒå€æ ãäŒèšã人äºçµŠäžçïŒããã®ããŒã¿èªå飿ºããåæã«æé©ãªããŒã¿ããŒãã®æ§ç¯ãè¡ããŸãã
â
ïŒETLæè¡ãšã¯ãExtractïŒæœåºïŒãTransformïŒå€æïŒãLoadïŒæ ŒçŽïŒã®3ã€ã®å·¥çšã§ã瀟å
å€ã®æ§ã
ãªå Žæã«ããããŒã¿ãéããåæãããã圢ã«å å·¥ã»æŽåœ¢ããããŒã¿ãŠã§ã¢ããŠã¹ïŒDWHïŒãªã©ã«äžå
çã«æ ŒçŽããããŒã¿çµ±åã»å å·¥ããã»ã¹
å°éçãª
ããã·ã¥ããŒãæ©èœ
KPIèšèšãã€ã³ã¿ã©ã¯ãã£ããªæäœèšèšã«å ãã圹è·ãæ åœéšéããšã«é²èЧç¯å²ãå¶éããè¡ã¬ãã«ã»ãã¥ãªãã£ãŒïŒRLSïŒãªã©ã®é«åºŠãªæš©éå¶åŸ¡ãå®è£ å¯èœã§ãã
ïŒè¡ã¬ãã«ã»ãã¥ãªãã£ïŒRLS: Row-Level SecurityïŒãšã¯ãããŒã¿ããŒã¹ãBIããŒã«ã«ãããŠããŠãŒã¶ãŒãã°ã«ãŒãããšã«ããŒãã«å
ã®ãè¡ïŒã¬ã³ãŒãïŒãåäœã§ããŒã¿ã®é²èŠ§ã»æäœæš©éã现ããå¶åŸ¡ããä»çµã¿
æè»ãªã¢ãžã£ã€ã«éçº
ïŒã¹ã¢ãŒã«ã¹ã¿ãŒãïŒ
ã¹ã¢ãŒã«ã¹ã¿ãŒãã§å§ããŠæ®µéçã«æ©èœãæ¡åŒµããããš ãå¯èœã§ãããããã¿ã€ããçšããå ·äœçãªèŠä»¶å®çŸ©ããã¬ãã¥ãŒãéããå®æåºŠã®é«ãããã·ã¥ããŒãæ§ç¯ãè¡ããŸãã
é«åºŠãªæè¡é£æºãšä¿¡é Œæ§
Azure FilesãTableau BridgeãæŽ»çšããå®å®ããããŒã¿ãã€ãã©ã€ã³ãæ§ç¯ããŸããå€éšã·ã¹ãã ãšã¯API飿ºãè¡ãããšã§ãããŒã¿ã®æŽåæ§ãšã»ãã¥ãªãã£ã確ä¿ããä¿¡é Œæ§ã®é«ãåæåºç€ãå®çŸããŸãã

Success Markã¯ãåãªãããã·ã¥ããŒãæ§ç¯ãµãŒãã¹ã§ã¯ãããŸãããäŒèšã·ã¹ãã ãäžå¿ãšããåºå¹¹ã·ã¹ãã ã®ããŒã¿ãèªåã§åéããé«åºŠãªELTæè¡ã«ããèšå€§ãªããŒã¿ããéšéãç®çå¥ã«å¿ èŠãªæ å ±ãæœåºã»å å·¥ãè¿ éãªçµå¶å€æã«ã€ãªããããã·ã¥ããŒãã®æäŸãããå®çã»éçšæ¯æŽãŸã§äŒŽèµ°ãããããŒã¿ã«æ¯æŽãµãŒãã¹ã§ãã

Success Markã®ãµãŒãã¹å°å ¥ã®ã¡ãªãã
æ¥åå¹çã®å€§å¹ ãªåäž
åŸæ¥ãExcelãªã©ã§æäœæ¥ã§è¡ã£ãŠããããŒã¿æŽåœ¢ã»éèšã»å¯èŠåãèªååããããšã§ãã¬ããŒãäœæã®æéãçããæ¥åå¹çãåçã«æ¹åããŸãã
ã³ã³ãã©ã€ã¢ã³ã¹ãš
å
éšçµ±å¶ã®åŒ·å
åŽååºæºæ³ã«åºã¥ãã36åå®éµå®ç¶æ³ãã®èªåã¢ãã¿ãªã³ã°ããç°åžžå€ã»äžæ£ã®å åãè¿ éã«çºèŠã§ãããç£æ»å¯Ÿå¿ããã·ã¥ããŒããã«ãããã¬ããã³ã¹ã®åŒ·åãšãªã¹ã¯ã®æªç¶é²æ¢ãæ¯æŽããŸãã
ããŒã¿ããªãã³ãª
è¿
éãªçµå¶å€æ
å£²äžæšç§»ãè²»çšæ§æããã£ãã·ã¥ãããŒãªã©ã®çµå¶ææšããªã¢ã«ã¿ã€ã ã§å¯èŠåã§ãããããçµå¶è ããæèŠãã§ã¯ãªããããŒã¿ãã«åºã¥ããè¿ éãªæææ±ºå®ãè¡ããããã«ãªããŸãã
ççŽæã§ã®å°å ¥
éåžžã®åž³ç¥šç»é¢éçºã§ã¯çŽ1幎ããããããªã±ãŒã¹ã§ããBIãæŽ»çšããããšã§3ã4ãæãšããçæéã§ã®å°å ¥ãå¯èœã§ãã
çµå¶ææšã®å¯èŠåãšåæãããã¯ããã
åãªãåž³ç¥šäœæäœæ¥ã«ãªã£ãŠããïŒïŒ
åãªãåž³ç¥šäœæã§ã¯çµå¶ããŒãºãæºããããæææ±ºå®ã®é å»¶ãšç²ŸåºŠäœäžãã³ã¹ãå¢ãç«¶äºåäœäžãªã©ãçµå¶ãªã¹ã¯ãçãã§ããå¯èœæ§ããããŸãã
ãããã課é¡
-
æ¯æã®éèšã»å å·¥ã«é倧ãªå·¥æ°ãã¬ããŒãã¯èŠèªæ§ãäœãäœæã«æé
-
Excelè·äººåã«ããå±äººåãšãã¹ãªã¹ã¯ãæŽæ°ã®é å»¶
-
äœæ¥æéãè¶³ãããæ°åã®æ·±æããå€è§çåæã¯æªçæ
-
ä»ã®BIããŒã«ã¯ããŒã¿é£æºã®èšå®ãé£ããã垳祚ã®è¿œå ã»å€æŽãå°é£
-
ã·ã¹ãã 飿ºã®ããŠããŠãããŒãããŒãäžè¶³
Success Markã§è§£æ±ºïŒïŒ
-
çµå¶ææšãæ¥æ¬¡ã»é±æ¬¡ã»ææ¬¡ã§èªåæŽæ°ã
-
KPIïŒæé軞ãéšéå¥ãååŒå å¥ãªã©ïŒã®å¯èŠåãèŠä»¶ã«å¿ããŠãã«ã«ã¹ã¿ã ã
-
éçšå®çãšç¶ç¶çãªæ¹åãå¯èœã«ãªããå°å ¥ããéçšã®å®å¿äŒŽèµ°ãµããŒã
ã·ã¹ãã éã®ãå£ããçµå¶å€æã®
ã¹ããŒããæ¢ããŠããïŒïŒ
ãããã課é¡
äŒèšã»äººäºã»è³Œè²·ãªã©ã®ã·ã¹ãã ãåæãããŠãããšãããŒã¿åéã»çªåã»éèšã«æéãããããå¿ èŠãªæ å ±ãé å»¶ãçµæãšããŠçµå¶å€æã®ã¹ããŒããèœã¡ãæ©äŒæå€±ã«ã€ãªãããŸãã

ã¯ã¬ãªã®ETLããŠããŠãããç¹ãã§ååšããããŒã¿ããç·ããããé¢ããžãšã€ãªãã
å€åããäŒæ¥æŠç¥ããŒãºã«æç¶çã«å¿ããçµå¶è
ã®æææ±ºå®ãæ¯æŽããŸãã

æè¡äžèЧ

ãµãŒãã¹å°å ¥ã®æµã
åãªããããã·ã¥ããŒãåãã§ã¯ãªãã
æææ±ºå®ãå éããããäŒèšããŒã¿å šèªååæã€ã³ãã©ãã
æç2ã¶æã§ã¹ã¢ãŒã«ã¹ã¿ãŒãå¯èœãªã¢ãžã£ã€ã«æ§ç¯ã§ãæäŸããŸãã

01ïŒèŠä»¶ãã¢ãªã³ã°ïŒèŠä»¶å®çŸ©
çŸç¶ã®èª²é¡ããåžæã確èªããããŒã¿ç¶æ³ã確èªãããŠããã ããèŠä»¶å®çŸ©ãè¡ããŸãã
02ïŒããŒã¿æ¥ç¶
æ§ã ãªã·ã¹ãã ãšèªå飿ºãè¡ããããå¿ èŠãªã·ã¹ãã ãšã®API飿ºãSQLæ¥ç¶ãè¡ããŸãã
03ïŒããŒã¿ããŒãæ§ç¯ïŒããŒã¿å å·¥ïŒ
Tableau PrepãçšããŠèšå€§ãªããŒã¿ã®å å·¥ãè¡ããããŒã¿ãœãŒã¹ã®ãããã³ã°ãšã¯ã¬ã³ãžã³ã°ãè¡ããŸãã
04ïŒããã·ã¥ããŒãæ§ç¯
KPIèšèšãšã€ã³ã¿ã©ã¯ãã£ããªããã·ã¥ããŒãæ§ç¯ã¯ãã¡ãããéçšããã¥ã¢ã«ãäœæããŸãã
05ïŒéçšã»ãµããŒã
å®çæ¯æŽã»éçšãã©ããŒãªã©ããã现ããªãµããŒãããçŽæããŸãã
å©çšæé
âïŒã«ã¹ã¿ãã€ãºäŸ¡æ ŒäŸïŒ

ããã·ã¥ããŒãäœæã®å Žå
ïŒ äœæã€ã¡ãŒãžïŒUse Case3 åçæ§é ã®è§£å床ãäžãã ïŒ
ã»èŠä»¶å®çŸ©ïŒ2人æ¥
ã»ããŒã¿ããŒãæ§ç¯ïŒ2人æ¥
ã»ããã·ã¥ããŒãæ§ç¯ïŒ2人æ¥
ã»ã¬ãã¥ãŒåŸä¿®æ£ïŒ1人æ¥ã
ãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒ
åèšïŒ56äžåïŒ1人æ¥8äžåïŒ
ïŒå¥éTableauã©ã€ã»ã³ã¹è²»çšãå¿ èŠã«ãªããŸãã

















