The result of these solutions often follows months of pre-production work involving: 1) designing a master data schema to represent the union of the information in the disparate data sources; 2) designing a process to attempt to normalize the data internally; and then 3) creating a means with which to expose that composite data to portals, web pages, or other devices.