The Tutorial Story
HypoStores Corporation is a national retail organization with headquarters in Boston and stores in several states. It integrates operational data from stores nationwide with the data store at headquarters on regular basis. It recently opened a store in Los Angeles.
The headquarters includes a central ICC team of administrators, developers, and architects responsible for providing a common data services layer for all composite and BI applications. The BI applications include a CRM system that contains the master customer data files used for billing and marketing.
HypoStores Corporation must perform the following tasks to integrate data from the Los Angeles operation with data at the Boston headquarters:
- •Examine the Boston and Los Angeles data for data quality issues.
- •Parse information from the Los Angeles data.
- •Standardize address information across the Boston and Los Angeles data.
- •Validate the accuracy of the postal address information in the data for CRM purposes.