æçµæŽæ°: 2023/02/12
æçµæŽæ°æã®ããŒãžã§ã³: Tableau Cloud 2022.4
Tableau 2021.4ã§ä»®æ³æ¥ç¶ (Virtual Connections)ããªãªãŒã¹ãããŸããã
ä»®æ³æ¥ç¶ãšåãããŠäžå åãããè¡ã¬ãã«ã®ã»ãã¥ãªãã£(Data Policy)ããªãªãŒã¹ãããŸããã
äž¡æ©èœãšãåºæ¬çã«ã¯åDatasourceãŸãã¯Workbookã«é¢ããŠ
åã蟌ãŸããèªèšŒæ å ±
åå¥ã«äœãããŠããæœåº
ããã3ã€ãçµ±å管çãçŸå®çã«ã¯åå¥ã³ã³ãã³ããããå°ãªããªãç®æã§ç®¡çããããšããæå³ã§çšæãããŠãããã®ãšç解ããŠããŸãã
ãã ãæ©èœçŽ¹ä»ã(çŸç¶ãããŸã§å€ããªã)è³æãèŠãã«ãå®åã«èœãšã蟌ãäžã§èããäºé ãå€ãããã«æããåŠç¿ã®ããã«ããã°ã«è«žã æžãèµ·ãããŠã¿ãŸãã
å人ã®Tableau Cloudç°å¢ãå©çšããŠãããå·çæç¹ã§ã®ææ°ããŒãžã§ã³ã䜿çšããããšããäºæ¿ãã ããã
èšäºåé ã«ããŒãžã§ã³ãèšèŒããŠããŸãã
ä»®æ³æ¥ç¶ã®æŠèŠãšå©ç¹
äžèšããªãªãŒã¹ããŒããšäœµããŠåèã«ãã€ã€ãä»®æ³æ¥ç¶ã®æŠèŠãè¿°ã¹ãŸãã
ãŸãåæãšããŠãä»®æ³æ¥ç¶ã¯Tableau Server/Cloudäžã§ã®ã¿äœæã§ããã³ã³ãã³ãã§ãã
ïŒãã ãData Management Add-onãå¿ èŠïŒ
ä»®æ³æ¥ç¶ãäœãç®æãããšããã®ã¯ä»¥äžã®å³ã§èª¬æãããŸãã
ïŒåºå ž: Tableau 2021.4 ãªãªãŒã¹èšå¿µ æ°æ©èœãŸãšãïŒ
ä»®æ³æ¥ç¶ã䜿çšããªãåŸæ¥ã®æ§æ
ä»®æ³æ¥ç¶ãå©çšããå Žåã®æ§æ
å®éã«ã¯èªèšŒæ å ±ãšäœµããŠRLSãä»®æ³æ¥ç¶ã«éäžãã圢ã§ãããèŠã¯ãåã³ã³ãã³ãã«åã蟌ãŸãããåŸãªãã£ãèªèšŒæ å ±/RLSããä»®æ³æ¥ç¶ã²ãšã€ã«éäžããããããã®æ©èœã§ãã
ãã®æ©èœã§äœãå¬ããããè³æããã³çµéšããŒã¹ã§åæããŸãã
èªèšŒæ å ±ãç¥ã人æ°ãæžããã åŸæ¥ã§ã¯èªèšŒæ å ±ãå¿ èŠãªæ¥ç¶å (äžè¬çãªããŒã¿ããŒã¹ãªã©)ã䜿çšããã³ã³ãã³ãäœæã«ã¯ãäœæè ãèªèšŒæ å ±ãç¥ãå¿ èŠããããŸããã ä»®æ³æ¥ç¶ã䜿çšããã°ãä»®æ³æ¥ç¶ãäœæãã人éã®ã¿èªèšŒæ å ±ãç¥ãã°è¯ã圢ãšãªããŸããä»®æ³æ¥ç¶ã䜿çšããã³ã³ãã³ãäœæè ã«ã¯èªèšŒæ å ±ãå ±æããå¿ èŠããããŸããã
èªèšŒæ å ±ã管çããç®æãæžã
äžçªæ©æµã倧ããã®ã¯ãéè·ãªã©ã§ã³ã³ãã³ãææè å€æŽãè¡ãå Žåã ãšæããŸããTableauã¯ã³ã³ãã³ãææè å€æŽã®éã«ãåã蟌ãŸããèªèšŒæ å ±ãåé€ããŸããå人çã«äœåºŠãçãç®èŠãŸããã
ä»®æ³æ¥ç¶ã䜿çšãèªèšŒæ å ±ãåã蟌ãŸããã³ã³ãã³ãæ°ãæžããããšã§ãäžèšã®å¯Ÿå¿ç¯å²ãçããããšãã§ããŸãã
ææè å€æŽã«ããããããèªèšŒæ å ±ãæ¥ç¶æ å ±ãäžå 管çã§ããã¬ã€ã€ãŒãå¢ããããšã¯ãç¹ã«ç®¡çåŽãŠãŒã¶ãŒã«ãšã£ãŠã¯å¥œãŸããã®ã§ã¯ãªãã§ããããã
RLSãèšå®ã管çããã³ã³ãã³ãæ°ãæžã
RLSã¯DatasourceãŸãã¯Workbookå ã§èšå®ãããã®ã§ãèšãæããã°ã³ã³ãã³ãã®æ°ã ã管çããªããã°ãªããªãéèŠãªãã£ã«ã¿ãŒãäœæãããããšã«ãªããŸãã
RLSã䜿çšãããŒã¿è¡šç€ºå¶åŸ¡ãè¡ãèšèšã䜿çšãããŠããå Žåã«ã¯ããã¡ãã¯æ©æµã倧ããã®ã§ã¯ãªãã§ããããã
Published Data Sourceæ°ãæžãå¯èœæ§ããã
詳ããã¯åŸè¿°ããŸãããä»®æ³æ¥ç¶ã®äœ¿çšã«ãã£ãŠé¡äŒŒDatasourceãçµ±åããããšãã§ãããã§ãã
ãŸãä»®æ³æ¥ç¶èªäœãæœåºãå å ã§ããã®ã§ãæœåºæ°ãæœåºæŽæ°ã¹ã±ãžã¥ãŒã«æ°ãæžãããå¯èœæ§ããããŸããã
ïŒãã ãå®åäžã®å¶éã¯ããã€ãæãã€ããšããâŠãã¡ãã¯æ¬¡å以éã®èšäºã§ïŒ
ãšããããšã§ä»®æ³æ¥ç¶ã¯ç¹ã«ç®¡çè ãŠãŒã¶ãŒã«å¬ããæ©èœã§ãããä»®æ³æ¥ç¶ãæšé²ããããšã«ãã£ãŠå¹ççãã€å®å šã«Tableauã䜿ããç¶æ ãäœããããã«æããŸãã
æŠèŠã¯ä»¥äžãšããŠãå®éã®ç»é¢ãèŠãŠã¿ãŸãããã
ä»®æ³æ¥ç¶ã®ç»é¢
ã²ãšã€ä»®æ³æ¥ç¶ãäœæããŠã¿ãŸããã
Google Bigqueryã«æ ŒçŽããSuperstoreããŒã¿ã䜿çšããŠããŸãã
Tablesã«ã¯Bigqueryå ã®ããŒãã«ãã®ãŸãŸå ¥ããŸããããã«ã¹ã¿ã SQLã䜿çšå¯èœã§ãã
ä»®æ³æ¥ç¶ã®äžã§ã¯åºæ¬çã«çµåãå®çŸ©ããŸããã
äŸå€çã«Data Policyèšå®æã«ã¯Relationãå®çŸ©ããŸãããä»åã¯æ·±ãæ±ããŸããã
ãŸãä»®æ³æ¥ç¶ã®äžã§ãã£ãŒã«ãã®ãªããŒã ããã³é€å€ãèšå®å¯èœã§ãã
ãã®èŸºãã¯DatasourceãšäŒŒãŠããŸããã
2021.4 - 2022.3ãŸã§ã®ä»®æ³æ¥ç¶ã¯åäžã®æ¥ç¶å å©çšã®ã¿ããµããŒãããŠããŸãããã2022.4以éã§ã¯è€æ°ã®æ¥ç¶å å©çšãå¯èœã§ãã
以äžã®äŸã§ã¯BigQueryãšGoogle Driveã®äž¡æ¹ã«æ¥ç¶ããŠããŸãã
åè: ä»®æ³æ¥ç¶ã®äœæ
ã¡ãªã¿ã«ä»®æ³æ¥ç¶ã䜿çšããããŒã¿ãœãŒã¹ã¯(Published Data Sourceãšç°ãªã)ä»ã®ããŒã¿ãœãŒã¹ããã®ããŒã¿ã䜿çšããããšãã§ããŸãã
以äžã®äŸã§ã¯ä»®æ³æ¥ç¶ã®ããŒã¿ãšãExcelã®ããŒã¿ãåäžDatasourceå ã§äœ¿çšããŠããŸãã
ãããã£ãŠåäžã®ä»®æ³æ¥ç¶ã«è€æ°æ¥ç¶å ããã®ããŒã¿ãæ ŒçŽããªããšããå¥ã®ä»®æ³æ¥ç¶ã«å¥æ¥ç¶å ããã®ããŒã¿ãæ ŒçŽããDatasourceäžã§çµã¿åãããããšãã圢ãå¯èœã§ãã
ãã®èŸºãã¯èŠä»¶ãéçšæ¬¡ç¬¬ã ãšæããŸãã®ã§ã䜿ãæ¹ã®æ£è§£ãšããã®ã¯ç¡ãã®ã§ã¯ãšããå°è±¡ãæã¡ã€ã€...
ããŠä»®æ³æ¥ç¶ã®ç»é¢ã«æ»ããšãä»®æ³æ¥ç¶ã§ã¯LiveãExtractããéžæããå¿ èŠããããŸãã
2022.4以éã®ããŒãžã§ã³ã§ã¯ä»®æ³æ¥ç¶å šäœã§LiveãExtractããéžæããã®ã§ã¯ãªããããŒãã«åäœã§LiveãšExtractãéžã¹ãããã«ãªããŸããã
以äžã§ã¯2022.2以åã®ç»é¢ãšã2022.4以éã®ç»é¢ã䜵èšããŸãã (2022.3ã§åå€æŽãé©çšãããŠããå¯èœæ§ããããŸããããªãªãŒã¹ããŒãã«ãªãæ å ±ãã€Tableau Cloudã¯åžžã«ææ°ããŒãžã§ã³å©çšãšãªãã®ã§ç¢ºèªã§ãã...æ å ±ãæã¡ã®æ¹ã¯ãç¥ããããã ããã°å¹žãã§ã)
(2022.2以åã®å Žå)
ä»®æ³æ¥ç¶åäœã§LiveãExtractããéžæããŸãã
ã€ãŸããªã¢ã«ã¿ã€ã æ§ãæ±ããåæçšã®ä»®æ³æ¥ç¶(Live)ãšãããŒã¿ã®ã¹ãããã·ã§ãããããã°ããä»®æ³æ¥ç¶(Extract)ããèŠä»¶ã«åãããŠäœæããå¿ èŠã¯ããããã§ãã
ãã®èŸºãã¯Datasourceãšåãã§ããã
(2022.4以éã®å Žå)
ä»®æ³æ¥ç¶å ã®ããŒãã«åäœã§LiveãExtractãéžæããŸãã
ä»®æ³æ¥ç¶ã®äžã«LiveãšExtractãåæã«æã€åœ¢ã«ãªããŸãã
ããã¯Datasourceãšã¯å€§ããç°ãªããŸãã
ã¡ãªã¿ã«å¢åæŽæ°ããããŸããã®ã§ãããŒã¿ãµã€ãºã«ã¯æ°ãä»ããæ¹ãããããã§ãã
äœæãããExtractãå«ãä»®æ³æ¥ç¶ãèŠãŠã¿ãŸãããã
æåæŽæ°ã¯ããŒãã«éžæããŠåå¥ã«æŽæ°ããããšããå šéžæããŠãŸãšããŠæŽæ°ããããšãå¯èœã§ãããã¡ããã¹ã±ãžã¥ãŒã«èšå®ãã§ããŸãã
RLSã«ã€ããŠã¯åèè³æã«ä»»ãããšããŠâŠä»®æ³æ¥ç¶ã«ã€ããŠãŸãšããŸãã
è€æ°ã®æ¥ç¶å ãä»®æ³æ¥ç¶ã«äœ¿çšã§ãã (2022.4以é)
ä»®æ³æ¥ç¶ã«ã¯ããŒãã«ãè€æ°æ ŒçŽããDatasourceåŽã§çµåãªã©å®çŸ©ãããéçšãå¯èœ
äžèŠã«ã©ã ãªã©ã¯ããã£ãŒã«ãåé€ãŸãã¯ã«ã¹ã¿ã SQLã§é€å€å¯èœ
ä»®æ³æ¥ç¶ãçšããŠãèªèšŒæ å ±ããã³RLSãéäžç®¡çããéçšãå¯èœ
ä»®æ³æ¥ç¶ã«ã¯LiveãšExtractäž¡æ¹ã®ããŒãã«ãå«ãããã (2022.4以é)
ä»®æ³æ¥ç¶ã§æœåºæŽæ°ãããã°ãDatasourceãWorkbookã§æœåºäœæãããå¿ èŠã¯ãªã
äžèšã«ãšããªããç·æœåºå®¹éãæŽæ°ã¹ã±ãžã¥ãŒã«æ°ãæžããã
æåŸã«
ä»®æ³æ¥ç¶ã®æ©èœãšå®éã®ç»é¢ã玹ä»ããŸããã
ããŸã䜿ãã°ç®¡çäžã®æ©æµã倧ãããã§ããããããSelf-serviceããŒã¿åæãæšé²ããäžã§ã¬ããã³ã¹ãã©ã®ããã«å©ããããã®è°è«ã¯é¿ããããªãããã«æããŸãããä»®æ³æ¥ç¶ã¯ãã®äžå©ãšãªãã®ã§ã¯ãªãã§ããããã
äžæ¹ã§å人çã«ã¯...å®åã«èœãšã蟌ã¿ãŠãŒã¶ãŒã«ã©ã®ããã«äœ¿ã£ãŠããããããšããç¹ã§ææ¡ãããšãããå®ã¯å€§ããã§ãã
ãã®ãããã®æžå¿µã¯æ¬¡ã®èšäºã§çŽ¹ä»ãã€ã€ãæããã«æ©æµã®å€§ããæ©èœãªã®ã§ãèªåãèœãšãã©ãããé©åãªéçšã«ã€ããŠèããŠããããæåã§ãã
質åãªã©ãããŸãããTwitterãLinkedinã§ãé¡ãããŸããããã§ã¯ã