1 / 24

Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS

DBI310. Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS. Matt Masson Senior Program Manager Microsoft Corporation. Matthew Roche Senior Program Manager Microsoft Corporation. My Business Intelligence Project. One version of the truth!.

wood
Download Presentation

Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBI310 Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS Matt Masson Senior Program Manager Microsoft Corporation Matthew Roche Senior Program Manager Microsoft Corporation

  2. My Business Intelligence Project One version of the truth!

  3. My Business Intelligence Project • 70%

  4. It Can’t be That Bad… Or Can It? Top Barrier for BI Source: Information Week Reports, 2011

  5. And it’s Not Just About BI… Top 3 impediments Source: Information Week Reports, 2011

  6. Curating Data with SQL Server 2012A full suite of tools for Enterprise Information Management (EIM) • Data Quality Services • Knowledge-based Data Cleansing & Matching • Standalone & SSIS Integrated • Master Data Services • Excel UI to Manage Data & Dimensions • Rapid, Easy Data Loading • Produce accurate, trustworthy data • Deliver credible, consistent data to the right users with end-to-end data integration, cleansing & data management • Use SQL Server for all EIMneeds CLEANSE MANAGE Integrate • Integration Services • Integrated Deployment & Management • Improved User Experience

  7. Enterprise Information Management Creating a Consolidated Customer Sales Report

  8. Data is Rarely BI Ready

  9. The Technologies Data Movement SSIS Spell Checking DQS Reference Tables MDS

  10. Data Curation Process • Cleanse • Match • Manage • Integrate and Automate

  11. Using Data Quality Services

  12. Using Data Quality Services

  13. DQS Summary • Statistical and knowledge-based data correction • Common term correction using Term Based Relations • Reference Data Service (RDS) cleansing through Data Marketplace • Common examples include: • Address cleansing • Phone number verification

  14. Using Master Data Services

  15. Using Master Data Services

  16. MDS Summary • Quick and easy model creation in Excel – Democratizing master data management • Powerful MDM functionality, such as hierarchies, validation rules, and workflows • De-duplication and matching through integration with Data Quality Services

  17. Summary and Closing • EIM helps address problems in many different contexts • BI is the obvious low hanging fruit • Operational systems are also plagued by data problems • The SQL platform is about Managed Democratization • One version of the truth • Empowered business users • Reduced IT involvement • It’s not an all or nothing solution • Parts can be rolled out and integrated separately

  18. Related Content • Breakout Sessions • DBI322: Incremental ETL Using CDC for SQL and Oracle with SSIS 2012 • DBI329: Upgrading SSIS Packages to SQL Server 2012 • DBI207: BI Power Hour Hands-on Labs • DBI24-HOL: Exploring Microsoft SQL Server Integration Services Product Demo Stations Breakthrough Insights: Credible, Consistent Data Related Certification Exam Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 Find Me Later At… Breakthrough Insights: Credible, Consistent Data

  19. Contact mattmasson.com BI Polar mmasson@microsoft.com maroche@microsoft.com @mattmasson @SQLAllFather Matt Masson Matthew Roche

  20. Track Resources @sqlserver @TechEd_europe #msTechEd SQL Server 2012 Eval Copy Hands-On Labs Get Certified! mva • Microsoft Virtual Academy

  21. Resources Learning TechNet • Connect. Share. Discuss. • Microsoft Certification & Training Resources http://europe.msteched.com www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet http://microsoft.com/msdn

  22. Evaluations Submit your evals online http://europe.msteched.com/sessions

  23. © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related