{"id":1245,"date":"2021-08-23T11:11:12","date_gmt":"2021-08-23T15:11:12","guid":{"rendered":"https:\/\/myapps.northcarolina.edu\/insight\/?p=1245"},"modified":"2022-12-13T12:54:58","modified_gmt":"2022-12-13T17:54:58","slug":"dyk-data-catalog","status":"publish","type":"post","link":"https:\/\/myapps.northcarolina.edu\/insight\/2021\/08\/23\/dyk-data-catalog\/","title":{"rendered":"Did You Know: Data Catalog is now available to understand where fields are used"},"content":{"rendered":"<p>A Data Catalog is now available to any authorized Insight user to assist you in understanding where fields are used among Tableau sites, projects, workbooks, and data sources. You can understand each field&#8217;s name, role, and whether it&#8217;s native or calculated. If it&#8217;s calculated, you can hover over the formula and see the fields used and the derivation code, for example for the Admission High School GPA Bins in this screenshot of the Data Catalog. <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1246\" src=\"https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2021\/08\/data-catalog.png\" alt=\"data catalog screenshot\" width=\"1386\" height=\"661\" srcset=\"https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2021\/08\/data-catalog.png 1386w, https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2021\/08\/data-catalog-1280x610.png 1280w, https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2021\/08\/data-catalog-980x467.png 980w, https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2021\/08\/data-catalog-480x229.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) and (max-width: 1280px) 1280px, (min-width: 1281px) 1386px, 100vw\" \/><\/p>\n<p>You can navigate top-down, for example by choosing a project or workbook of interest at the top-center. Then, explore the various fields and their role, native column name or calculated field code and logic. Or you can navigate bottom-up, by choosing one or more of the formula\/source fields of interest at the top-right, and see where it is used among data sources, workbooks, projects or sites that you are permitted to access. You can also view all fields, or filter on calculated fields, or native columns. The scope of what you can view matches the workbooks that you can view on the Insight Tableau Server &#8212; workbooks are limited to the workbooks available in the production Insight projects. A Level 2 campus user also has access to workbooks in the campus&#8217; project folders, that he or she is authorized to view. As it states under the title, the data are refreshed around 5pm daily.<\/p>\n<p>You&#8217;ll find the <a href=\"https:\/\/insight.northcarolina.edu\/#\/workbooks\/1393\/views\">Data Catalog<\/a> in the <a href=\"https:\/\/insight.northcarolina.edu\/#\/projects\/341\">Campus Admin folder<\/a> on the <a href=\"https:\/\/insight.northcarolina.edu\/\">Insight Tableau Server<\/a>. A demo of the Data Catalog was recorded during the Insight monthly community call on August 13, 2021. You can view the replay using the link available <a href=\"https:\/\/myapps.northcarolina.edu\/insight\/resources\/?table_filter=replay\">in the meeting notes<\/a>.<\/p>\n<p>Enjoy this new Insight data exploration tool, and as always, your questions, and feedback are welcome via email to <a href=\"mailto:insight@northcarolina.edu\">insight@northcarolina.edu<\/a>.<\/p>\n<p>The Insight Team<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-844\" src=\"https:\/\/myapps.northcarolina.edu\/insight\/wp-content\/uploads\/sites\/19\/2019\/11\/insight-logo.png\" alt=\"UNC Insight logo\" width=\"260\" height=\"84\" \/><\/p>\n<p>You can\u00a0<a href=\"https:\/\/lists.northcarolina.edu\/postorius\/lists\/insight-info.lists.northcarolina.edu\/\">subscribe directly<\/a>\u00a0to receive email notices about Insight and Did You Know. Past DYK posts are available on\u00a0<a href=\"https:\/\/myapps.northcarolina.edu\/insight\/did-you-know\/\">a blog here<\/a>. If you have Insight access issues or dashboard content questions or concerns, please email\u00a0<a href=\"mailto:insight@northcarolina.edu\">insight@northcarolina.edu<\/a>\u00a0to open a ticket.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Data Catalog is now available to any authorized Insight user to assist you in understanding where fields are used among Tableau sites, projects, workbooks, and data sources. You can understand each field&#8217;s name, role, and whether it&#8217;s native or calculated. If it&#8217;s calculated, you can hover over the formula and see the fields used [&hellip;]<\/p>\n","protected":false},"author":6221,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[28,40],"tags":[60],"class_list":["post-1245","post","type-post","status-publish","format-standard","hentry","category-accouncement","category-did-you-know","tag-data-catalog"],"acf":[],"_links":{"self":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/users\/6221"}],"replies":[{"embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/comments?post=1245"}],"version-history":[{"count":7,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1245\/revisions"}],"predecessor-version":[{"id":1342,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/posts\/1245\/revisions\/1342"}],"wp:attachment":[{"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/media?parent=1245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/categories?post=1245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myapps.northcarolina.edu\/insight\/wp-json\/wp\/v2\/tags?post=1245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}