Prioritizing the integration

0

What do you integrate first? I got hit with that question from a client the other day. What a good question! I like to start the new year by doing the following prior to January 1:

  1. Review ALL existing projects for enhancements with integrated data. Analyze whether an integrated store of data could help this project make it to production faster, and smarter.
  2. Review ALL NEW projects for the next year, and look for low-hanging fruit ("low-hanging fruit" meaning projects that use the same subject areas or data sources). This allows you a more comprehensive look at the complexity of the data integration and quality required to be successful on these projects. As well as, STEP 1 in a master data management and data governance initiative.
  3. Make sure EACH and EVERY project plan (e.g. talking with project managers) addresses data quality and integration the SAME way. For example, make sure each project is not doing its own pull of data. Instead, create an interface environment where data gets pulled one time and then use it many times - OR, better yet, start governing this data and implementing an MDM initiative. The trick here is to implement without being the bottleneck of the project, and piggyback on these projects to get where you want to be – with organized, clean, integrated corporate data.

I wish you luck with this in 2013. I predicted that data integration and quality would still be an issue next year, and I think we have only touched the tip of the iceberg.

Tags
Share

About Author

Joyce Norris-Montanari

President of DBTech Solutions, Inc

Joyce Norris-Montanari, CBIP-CDMP, is president of DBTech Solutions, Inc. Joyce advises clients on all aspects of architectural integration, business intelligence and data management. Joyce advises clients about technology, including tools like ETL, profiling, database, quality and metadata. Joyce speaks frequently at data warehouse conferences and is a contributor to several trade publications. She co-authored Data Warehousing and E-Business (Wiley & Sons) with William H. Inmon and others. Joyce has managed and implemented data integrations, data warehouses and operational data stores in industries like education, pharmaceutical, restaurants, telecommunications, government, health care, financial, oil and gas, insurance, research and development and retail. She can be reached at jmontanari@earthlink.net.

Leave A Reply

Back to Top