ðãããŸããTableauã䜿ã£ãŠå ±éã®èªç±åºŠã©ã³ãã³ã°ã®äžçå°å³ã¢ãã¡ãŒã·ã§ã³ãäœã
ååããã®ç¶ãã®ããŸãèšäºã§ãã詳ããã¯äžã®ãªã³ã¯ããã¢ã¯ã»ã¹ããŠã¿ãŠãã ããã
ä»åã¯å ±éã®èªç±åºŠã©ã³ãã³ã°ã®äžçå°å³ã¢ãã¡ãŒã·ã§ã³ãäœã£ãŠãéå»ïŒïŒå¹Žéååœã®èªç±åºŠãã©ã®ããã«å€åããŠãã£ãã®ããå¯èŠåããŠããããšæããŸãã
äœæéçš
ããŒã¿ã®ååŸ
å ±éã®èªç±åºŠäžçã©ã³ãã³ã°ã®ããŒã¿ãååŸã§ãããœãŒã¹ãïŒã€ãããŸãã
ãŸãäžã€ç®ã¯åœå¢ãªãèšè
å£ã®å
¬åŒãŠã§ããµã€ãã§å
¬éãããŠããCSVãã¡ã€ã«ããŒã¿ã幎æ¯ã«ããŠã³ããŒãããæ¹æ³ã§ãã
ãããŠããäžã€ãKaggle.comäžã§å ¬éãããŠããïŒïŒïŒïŒå¹ŽããïŒïŒïŒïŒå¹ŽãŸã§ã®ããŒã¿ã§ããã¡ãªã¿ã«ãã®ããŒã¿ãœãŒã¹ã¯å ¬åŒã§ã¯ãªãã®ã§ããããã®ããŒã¿ãœãŒã¹ã®ã¡ã€ã³ãããŒã¯å ¬åŒããŒã¿ãåã蟌ã¿ãæäœéã®ããŒã¿ã¯ãªãŒãã³ã°ãç·šéãå ããŠKaggle.comã«å ¬éããŠããããã§ãã
ããŒã¿ã®æºå
ã¡ãªã¿ã«ç§ã¯ãå ¬åŒããŒã¿ãçŽæ¥ããŒã¿ãããŒãžã¡ã³ãããŒã«ïŒPower BIãšPostgreSQLïŒã«åã蟌ã¿ã¯ãªãŒãã³ã°ãå«ããç·åçãªååŠçãæœããŸããããã®ååŠçãå šãŠçµãã£ãŠããããŒã¿ãTableauã«åã蟌ã¿ãŸãã
ð¡ã¡ãªã¿ã«ããŒã¿ããžã¥ã¢ã«ããŒã«ã¯äž»ã«TableauãšPower BIããããŸããTableauã¯Salesforceãå»å¹Žè²·åããããšã話é¡ã«ãªããŸãããPower BIã¯ãã€ã¯ããœããã®ããŒã«ã§ããããããã«é·æãšçæããããã¿ã¹ã¯ã«ãã£ãŠã¯äœ¿ãåãããªããã°ãªããªãå Žé¢ãå€ã åºãŠãããšæããŸãããã®ïŒã€ã®ããŒã«ã®éãã¯ãŸãå¥ã®èšäºã§ãŸãšããŠæžãããšèããŠããŸãããã ä»ããã§èšãã¹ãäºãäžã€ãTableauã§ã¯Power BIãšæ¯ã¹ãŠãããŒã¿æŽçãããŒã¿åŠçãå«ããç·åçãªåæ§ç¯ã¿ã¹ã¯ã«ã¯åããŠããªããšããçæããããŸãã
ããŒã¿ãååŠçãã段éã§äžçªæ°ãä»ããäºã¯ããŒã¿ã¹ãã©ã¯ãã£ãŒã§ãããã®å Žåãããããæ©èœã䜿ãããTimeãAttributeãValueãã®ïŒã€ã®ã³ã©ã ã«çºããŠåæ§ç¯ããå¿ èŠããããŸãã
TimeïŒæéãŒãã®å Žåã§ã¯ïŒïŒïŒïŒå¹ŽããïŒïŒïŒïŒå¹ŽãŸã§ã®å¹Žã§ãã
AttributeïŒå±æ§ãŒãã®å Žåã§ã¯åœã§ãã
ValueïŒæ°å€ãŒãã®å Žåã§ã¯èªç±åºŠãè¡šãã¹ã³ã¢ã§ãã
ãã®ïŒã€ã®ã³ã©ã ã軞ã«ããŠããŒã¿ãåæ§ç¯ããªããšã¬ãŒã·ã³ã°ããŒãã£ãŒãã¯äœããŸããã
äžçå°å³ã¢ãã¡ãŒã·ã§ã³ãäœã£ãŠã¿ã
ãŸãæåã«æ°ããã¯ãŒã¯ã·ãŒãããªãŒãã³ããŸããçã£æ°ãªã·ãŒããçŸããŸããããã«ããžã¥ã¢ã«ãäœã£ãŠãããŸãã
ïŒïŒæåã®ã¿ã¹ã¯ã¯ãã©ã³ãã³ã°ãè¡šãã³ã©ã ãäœããŸããããã·ã¥ããŒãã®äžã«ããã¡ãã¥ãŒãããã¯ãŒã¯ã·ãŒã㧠[åæ] > [èšç®ãã£ãŒã«ãã®äœæ]ãã¯ãªãã¯ããŠãšãã£ã¿ãŒãéããŸãã
åœããšã«èªç±åºŠãè¡šãæ°å€ãã©ã³ãã³ã°ãšããŠè¡šç€ºããã«ã¯
RANK_UNIQUE(SUM([Score])
äžã®ã³ãŒããèšç®ãã£ãŒã«ãã«å ¥åããŠèšå®ããŸãããããããšã©ã³ãã³ã°ã®ã³ã©ã ãæ°ããäœãããŸãã
ïŒïŒæ¬¡ã«Columnsã«LongitudeïŒçµåºŠïŒãRowsã«LatitudeïŒç·¯åºŠïŒããã©ãã°ïŒããããããŠèšå®ããŸããäžçå°å³ãã¯ãŒã¯ã·ãŒãã«æµ®ãã³äžãããŸãã
ïŒïŒãã®æ¬¡ã«ãåœããšã«ã¹ã³ã¢ãéžå¥ããŠã©ã³ãã³ã°ããã®ã§ãCountriesãDetailã«ãŒãã«ãã©ãã°ïŒããããããŸãã
ïŒïŒãããããã¹ã³ã¢ã®æ°å€ã«ãã£ãŠè²ãå€åããããã«ãããã®ã§ãSUMïŒScoreïŒãColorã«ãŒãã«ãã©ãã°ïŒããããããŠè²ãèšå®ããŸãã
ïŒïŒæåŸã«ã幎æ¯ã«ååœã®è²ãå€ããããã«ãããã®ã§ãPagesã«Yearãå ¥ããŸãã
èµ€ãè²ã«è¿ã¥ãã«ã€ããŠå ±éã®èªç±åºŠãäœããéãè²ã«è¿ã¥ãã«ã€ããŠèªç±åºŠãé«ããªãããã«ã«ã©ãŒãã§ã€ã¹ãããŸããã
ð¡ã¢ãã¡ãŒã·ã§ã³ã®èšå®ããããå Žå㯠[Format > Animations] ã«è¡ããšèšå®ç»é¢ãçŸããŸããããã§ã¢ãã¡ãŒã·ã§ã³ã®é床ã調æŽã§ããŸãã
â¶ïž å³äžã«ããå°ããªåçãã¿ã³ãã¯ãªãã¯ãããšå°å³ã®è²ãåãåºããŸãã
å®éã«åããŠããæ§åã¯ä»¥äžã®ãªã³ã¯ããã€ã³ã¹ã¿ã°ã©ã ã«é£ãã§èŠãŠã¿ãŠãã ãããâ¬ïžâ¬ïž
ðïžäœãæ°ã¥ããããšããæèŠãªã©ãããã°ã³ã¡ã³ãæ¬ãããé¡ãããŸãããã£ã³ãã«ãã©ããŒããããããé¡ãããŸãã
ð çåã«æã£ãäºã¯ããŒã¿åããŠèªåãªãã®çããæ¢ããŠããããšæããŸãããããŠãã®çããã©ããã«ãã誰ãã®çºã«ãªãäºãé¡ã£ãŠããŸãã
ãã®èšäºãæ°ã«å ¥ã£ãããµããŒããããŠã¿ãŸãããïŒ