{"id":5386,"date":"2019-03-27T19:39:53","date_gmt":"2019-03-27T19:39:53","guid":{"rendered":"http:\/\/www.rochester.edu\/provost-2019\/?page_id=5386"},"modified":"2021-10-28T17:45:43","modified_gmt":"2021-10-28T17:45:43","slug":"enterprise-data-warehouse","status":"publish","type":"page","link":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/","title":{"rendered":"Enterprise Data Warehouse"},"content":{"rendered":"\r\n<p>The University of Rochester\u2019s Enterprise Data Warehouse (EDW) aims to centralize administrative data from across the institution. Centralizing this information helps support data-driven decision-making and planning throughout the institution.<\/p>\r\n\r\n\r\n\r\n<p>EDW is a data repository that integrates data from the following systems:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Finance<\/li>\r\n<li>Grant Management<\/li>\r\n<li>Payroll<\/li>\r\n<li>Human Resources<\/li>\r\n<li>Advancement<\/li>\r\n<li>Faculty<\/li>\r\n<li>Student<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>As a result, EDW provides appropriate access to data across the organization at all levels. Users can easily find information in reports and dashboards. You can also leverage reporting and visualization tools from IBM Cognos and Tableau for self-service reporting and analysis.\u00a0<br \/><br \/>EDW continues to expand its catalog of information, reports, dashboards, and tools. In 2017, we added data from University Financials, Financial Aid, and Dun &amp; Bradstreet (a business data repository). We also introduced the UR Data Glossary for definitions and context.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>The University of Rochester\u2019s Enterprise Data Warehouse (EDW) aims to centralize administrative data from across the institution. Centralizing this information helps support data-driven decision-making and planning throughout the institution. EDW&hellip;<\/p>\n","protected":false},"author":6,"featured_media":0,"parent":5286,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"page-templates\/one-column.php","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-5386","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Enterprise Data Warehouse - University of Rochester Data Governance<\/title>\n<meta name=\"description\" content=\"Learn more about the Enterprise Data Warehouse (EDW) at the University of Rochester through the Office of Data Governance and Support.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enterprise Data Warehouse - University of Rochester Data Governance\" \/>\n<meta property=\"og:description\" content=\"Learn more about the Enterprise Data Warehouse (EDW) at the University of Rochester through the Office of Data Governance and Support.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Office of the Provost\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-28T17:45:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rochester.edu\/provost\/wp-content\/uploads\/2022\/02\/Link-Preview-Provost-1200x630.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/university-data\\\/data-governance-overview\\\/enterprise-data-warehouse\\\/\",\"url\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/university-data\\\/data-governance-overview\\\/enterprise-data-warehouse\\\/\",\"name\":\"Enterprise Data Warehouse - University of Rochester Data Governance\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/#website\"},\"datePublished\":\"2019-03-27T19:39:53+00:00\",\"dateModified\":\"2021-10-28T17:45:43+00:00\",\"description\":\"Learn more about the Enterprise Data Warehouse (EDW) at the University of Rochester through the Office of Data Governance and Support.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/university-data\\\/data-governance-overview\\\/enterprise-data-warehouse\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/university-data\\\/data-governance-overview\\\/enterprise-data-warehouse\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/university-data\\\/data-governance-overview\\\/enterprise-data-warehouse\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"University Data\",\"item\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/university-data\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Governance\",\"item\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/university-data\\\/data-governance-overview\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Enterprise Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/#website\",\"url\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/\",\"name\":\"Office of the Provost\",\"description\":\"University of Rochester\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rochester.edu\\\/provost\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Enterprise Data Warehouse - University of Rochester Data Governance","description":"Learn more about the Enterprise Data Warehouse (EDW) at the University of Rochester through the Office of Data Governance and Support.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Enterprise Data Warehouse - University of Rochester Data Governance","og_description":"Learn more about the Enterprise Data Warehouse (EDW) at the University of Rochester through the Office of Data Governance and Support.","og_url":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/","og_site_name":"Office of the Provost","article_modified_time":"2021-10-28T17:45:43+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.rochester.edu\/provost\/wp-content\/uploads\/2022\/02\/Link-Preview-Provost-1200x630.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/","url":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/","name":"Enterprise Data Warehouse - University of Rochester Data Governance","isPartOf":{"@id":"https:\/\/www.rochester.edu\/provost\/#website"},"datePublished":"2019-03-27T19:39:53+00:00","dateModified":"2021-10-28T17:45:43+00:00","description":"Learn more about the Enterprise Data Warehouse (EDW) at the University of Rochester through the Office of Data Governance and Support.","breadcrumb":{"@id":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/enterprise-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rochester.edu\/provost\/"},{"@type":"ListItem","position":2,"name":"University Data","item":"https:\/\/www.rochester.edu\/provost\/university-data\/"},{"@type":"ListItem","position":3,"name":"Data Governance","item":"https:\/\/www.rochester.edu\/provost\/university-data\/data-governance-overview\/"},{"@type":"ListItem","position":4,"name":"Enterprise Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/www.rochester.edu\/provost\/#website","url":"https:\/\/www.rochester.edu\/provost\/","name":"Office of the Provost","description":"University of Rochester","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rochester.edu\/provost\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/pages\/5386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/comments?post=5386"}],"version-history":[{"count":2,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/pages\/5386\/revisions"}],"predecessor-version":[{"id":31126,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/pages\/5386\/revisions\/31126"}],"up":[{"embeddable":true,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/pages\/5286"}],"wp:attachment":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/media?parent=5386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}