{"id":11052,"date":"2019-08-06T20:04:19","date_gmt":"2019-08-07T00:04:19","guid":{"rendered":"https:\/\/www.rochester.edu\/provost\/?p=11052"},"modified":"2022-11-14T11:19:43","modified_gmt":"2022-11-14T16:19:43","slug":"data-questions-to-consider","status":"publish","type":"post","link":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/","title":{"rendered":"Data Questions to Consider"},"content":{"rendered":"\n<p>Before doing an IT implementation or, even better, before going out for proposals, the Data Governance and Support Office would like to suggest the following questions to consider.  Think of these as the &#8220;data requirements&#8221; to complement the &#8220;functional requirements&#8221; and &#8220;technical requirements&#8221; that are usually gathered as part of a project. It will be very helpful to be able to assess whether an application will meet your data needs aside from the business requirements.  <\/p>\n\n\n\n<p>Questions?  Suggestions?  <a href=\"mailto:datagovernanceoffice@rochester.edu\">Let us know. <\/a><\/p>\n\n\n<table class=\"wp-block-table\">\n<thead>\n<tr>\n<td>&nbsp;<\/td>\n<td><strong>Title<\/strong><\/td>\n<td><strong>Question<\/strong><\/td>\n<td><strong>Category<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Data capture<\/td>\n<td>Does a central repository exist for this type of data? Or are the data captured in spreadsheets or shadow systems?<\/td>\n<td>Data collection<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Data entry<\/td>\n<td>How do data need to be entered\/updated?&nbsp; Bulk upload? Integration? User entry?<\/td>\n<td>Data collection<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Duplicate values<\/td>\n<td>Is there a potential for duplicate data entries? How do you reconcile duplicates?<\/td>\n<td>Data integrity<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Data Cleanup<\/td>\n<td>Does the data have to be evaluated or cleansed for accuracy? How does that need to be done?<\/td>\n<td>Data integrity<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Data validation<\/td>\n<td>Is there a data validation process? Will a data validation process be necessary?<\/td>\n<td>Data Integrity<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Data Retention<\/td>\n<td>Does data ever get archived or removed from the system? How long must you keep the data?<\/td>\n<td>Data Integrity<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Unique IDs<\/td>\n<td>What unique identifiers exist for these data? How is this unique identifier generated? (Is it a sequential reference ID or combination of data attributes? Is there a naming convention or logic associated?)<\/td>\n<td>Data Integrity<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>Unique ID reuse<\/td>\n<td>Are unique identifiers ever reused? Why?<\/td>\n<td>Data Integrity<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>Error handling<\/td>\n<td>Do you have\/will you require a process for handling data errors? If so, describe the process?<\/td>\n<td>Data Integrity<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>Updating the data<\/td>\n<td>Do you have \/ will you require a data update control process?<\/td>\n<td>Data integrity<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>Data migration<\/td>\n<td>If adopting a new system, what data will migrate into the new system? <p><\/p>\n<ol type=\"a\">\n<li>Historical Data<\/li>\n<li>Current Data<\/li>\n<li>New Data<\/li>\n<li>All of the above<\/li>\n<\/ol>\n<\/td>\n<td>Data Migration<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>Data permissions<\/td>\n<td>Do you have \/ will you require a data sharing control process? What workflow is necessary to support that process?<\/td>\n<td>Access Management<\/td>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>Data Structure<\/td>\n<td>How does the data need to be structured and presented for analysis (longitudinal, cross sectional, fiscal snapshot)?<\/td>\n<td>Analytics<\/td>\n<\/tr>\n<tr>\n<td>14<\/td>\n<td>Frequency\/ Timing<\/td>\n<td>How readily available does the data need to be to meet the needs of the business (e.g. real-time, end of period, once a year)?<\/td>\n<td>Analytics<\/td>\n<\/tr>\n<tr>\n<td>15<\/td>\n<td>Basis of observation<\/td>\n<td>What is the basis of observation (person, object, task)? What is the focal point of the data?<\/td>\n<td>Data structure<\/td>\n<\/tr>\n<tr>\n<td>16<\/td>\n<td>Missing Values<\/td>\n<td>How do you treat missing values?<\/td>\n<td>Data structure<\/td>\n<\/tr>\n<tr>\n<td>17<\/td>\n<td>Metadata requirements<\/td>\n<td>What information about the data do you have or want? Descriptive (such as keywords, helps people find things), structural (such as relationships, helps people understand how things are organized) or administrative (such as update dates, helps people understand how things are processed)?<\/td>\n<td>Data structure<\/td>\n<\/tr>\n<tr>\n<td>18<\/td>\n<td>Data harmonization<\/td>\n<td>Is there data manipulation required to make the data compatible across systems? Where can\/should that be done?<\/td>\n<td>System Requirements<\/td>\n<\/tr>\n<tr>\n<td>19<\/td>\n<td>System Restrictions<\/td>\n<td>Are there any system restriction for downstream systems that we will have to accommodate?<\/td>\n<td>System Requirements<\/td>\n<\/tr>\n<tr>\n<td>20<\/td>\n<td>Definitions<\/td>\n<td>Do you have documented definitions?<\/td>\n<td>Data quality<\/td>\n<\/tr>\n<tr>\n<td>21<\/td>\n<td>Quality dimensions<\/td>\n<td>What components of data quality are most important to you?<p><\/p>\n<ul>\n<li><a href=\"http:\/\/www.rochester.edu\/it\/UR-Data-Glossary-lookup\/?action=term&amp;termsearch=187183\">Accuracy<\/a><\/li>\n<li><a href=\"http:\/\/www.rochester.edu\/it\/UR-Data-Glossary-lookup\/?termsearch=completeness&amp;action=term\">Completeness<\/a><\/li>\n<li><a href=\"http:\/\/www.rochester.edu\/it\/UR-Data-Glossary-lookup\/?termsearch=timeliness&amp;action=term\">Timeliness<\/a><\/li>\n<li><a href=\"http:\/\/www.rochester.edu\/it\/UR-Data-Glossary-lookup\/?termsearch=consistency&amp;action=term\">Consistency<\/a><\/li>\n<li>Availability<\/li>\n<li>Uniqueness<\/li>\n<\/ul>\n<\/td>\n<td>Data Quality<\/td>\n<\/tr>\n<tr>\n<td>22<\/td>\n<td>Provenance<\/td>\n<td>Are these data the authoritative source for the information?&nbsp; For all elements or a subset? If not, what is the authoritative source?<\/td>\n<td>Data Quality<\/td>\n<\/tr>\n<tr>\n<td>23<\/td>\n<td>Data Familiarity<\/td>\n<td>What is the level of data familiarity of our end users? Do they use spreadsheets? Are they comfortable with having access to the database and creating queries? Do they have experience with ad hoc reporting and selecting criteria to create custom reports? Does the user just want to push a button that extracts the data in the necessary format?<\/td>\n<td>Use<\/td>\n<\/tr>\n<\/tbody>\n<\/table>","protected":false},"excerpt":{"rendered":"<p>Before doing an IT implementation or, even better, before going out for proposals, the Data Governance and Support Office would like to suggest the following questions to consider. Think of&hellip;<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[116],"tags":[],"class_list":["post-11052","post","type-post","status-publish","format-standard","hentry","category-data-governance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Questions to Consider - Office of the Provost<\/title>\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\/data-questions-to-consider\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Questions to Consider - Office of the Provost\" \/>\n<meta property=\"og:description\" content=\"Before doing an IT implementation or, even better, before going out for proposals, the Data Governance and Support Office would like to suggest the following questions to consider. Think of&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/\" \/>\n<meta property=\"og:site_name\" content=\"Office of the Provost\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-07T00:04:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-14T16:19: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=\"author\" content=\"webhelp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhelp\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/\"},\"author\":{\"name\":\"webhelp\",\"@id\":\"https:\/\/www.rochester.edu\/provost\/#\/schema\/person\/25bf4d004691e86f13a38ea5ed76d893\"},\"headline\":\"Data Questions to Consider\",\"datePublished\":\"2019-08-07T00:04:19+00:00\",\"dateModified\":\"2022-11-14T16:19:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/\"},\"wordCount\":623,\"articleSection\":[\"Data Governance\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/\",\"url\":\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/\",\"name\":\"Data Questions to Consider - Office of the Provost\",\"isPartOf\":{\"@id\":\"https:\/\/www.rochester.edu\/provost\/#website\"},\"datePublished\":\"2019-08-07T00:04:19+00:00\",\"dateModified\":\"2022-11-14T16:19:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.rochester.edu\/provost\/#\/schema\/person\/25bf4d004691e86f13a38ea5ed76d893\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rochester.edu\/provost\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Questions to Consider\"}]},{\"@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\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rochester.edu\/provost\/#\/schema\/person\/25bf4d004691e86f13a38ea5ed76d893\",\"name\":\"webhelp\",\"url\":\"https:\/\/www.rochester.edu\/provost\/author\/webhelp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Questions to Consider - Office of the Provost","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\/data-questions-to-consider\/","og_locale":"en_US","og_type":"article","og_title":"Data Questions to Consider - Office of the Provost","og_description":"Before doing an IT implementation or, even better, before going out for proposals, the Data Governance and Support Office would like to suggest the following questions to consider. Think of&hellip;","og_url":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/","og_site_name":"Office of the Provost","article_published_time":"2019-08-07T00:04:19+00:00","article_modified_time":"2022-11-14T16:19: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"}],"author":"webhelp","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webhelp","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/#article","isPartOf":{"@id":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/"},"author":{"name":"webhelp","@id":"https:\/\/www.rochester.edu\/provost\/#\/schema\/person\/25bf4d004691e86f13a38ea5ed76d893"},"headline":"Data Questions to Consider","datePublished":"2019-08-07T00:04:19+00:00","dateModified":"2022-11-14T16:19:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/"},"wordCount":623,"articleSection":["Data Governance"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/","url":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/","name":"Data Questions to Consider - Office of the Provost","isPartOf":{"@id":"https:\/\/www.rochester.edu\/provost\/#website"},"datePublished":"2019-08-07T00:04:19+00:00","dateModified":"2022-11-14T16:19:43+00:00","author":{"@id":"https:\/\/www.rochester.edu\/provost\/#\/schema\/person\/25bf4d004691e86f13a38ea5ed76d893"},"breadcrumb":{"@id":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.rochester.edu\/provost\/data-questions-to-consider\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rochester.edu\/provost\/"},{"@type":"ListItem","position":2,"name":"Data Questions to Consider"}]},{"@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"},{"@type":"Person","@id":"https:\/\/www.rochester.edu\/provost\/#\/schema\/person\/25bf4d004691e86f13a38ea5ed76d893","name":"webhelp","url":"https:\/\/www.rochester.edu\/provost\/author\/webhelp\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/posts\/11052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/types\/post"}],"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=11052"}],"version-history":[{"count":11,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/posts\/11052\/revisions"}],"predecessor-version":[{"id":15122,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/posts\/11052\/revisions\/15122"}],"wp:attachment":[{"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/media?parent=11052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/categories?post=11052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rochester.edu\/provost\/wp-json\/wp\/v2\/tags?post=11052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}