{"id":281,"date":"2013-08-08T11:13:33","date_gmt":"2013-08-08T15:13:33","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=281"},"modified":"2018-03-21T16:57:14","modified_gmt":"2018-03-21T20:57:14","slug":"9-key-data-integration-questions-to-ask-a-hidden-how-to-guide","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/9-key-data-integration-questions-to-ask-a-hidden-how-to-guide\/","title":{"rendered":"9 Key Data Integration Questions to Ask: A Hidden How-To Guide"},"content":{"rendered":"

\"9Deep within the US Department of Transportation Federal Highway Adminstration Transportation Performance Management Resources Website (the USDoTFHWATPMRW) there is a remarkable and comprehensive primer of Data Integration<\/a>. This How-to-Integrate-Data Guide discusses a wide range of topics including everything from Requirements Analysis to Data and Process Flow Modeling as well as Data Models and Data Standards.<\/p>\n

It also contains a list of 9 Key Questions to ask when analyzing existing data and database systems within an organization might include:<\/p>\n

    \n
  1. Where do the data come from and who collects it?<\/li>\n
  2. How often, and how, are the data collected?<\/li>\n
  3. What reference system or systems are used?<\/li>\n
  4. What is the structure, format, and size of the data?<\/li>\n
  5. How are the data currently transmitted, processed and stored?<\/li>\n
  6. What is the general quality of the data? Is it accurate? Complete? Recent? Unique or redundant?<\/li>\n
  7. How are the data used-in what business processes?<\/li>\n
  8. What applications draw data from the databases (e.g., bridge management system, pavement management system)?<\/li>\n
  9. What types of reports are produced currently? What types are needed?<\/li>\n<\/ol>\n
    \t\t\t

    \"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n

    It concludes with the following summary: “This Primer describes requirements analysis, data and process flow modeling, alternatives evaluation, detailed database design, software development, and implementation. Application of each of these methodologies help ensure the most successful possible outcome for a data integration initiative. Within various stages of this complex process, a few general guidelines serve an agency well:”<\/p>\n