IBM Stockholm User Group April 2013

1. IBM Stockholm User Group April 2013

2. The Leader in IBM Information Management and Business Analytics Focused exclusivelyon IBM Information Management and Business Analytics solutions delivered through 5 primary practices: • Information Management Strategy – Governance and Business Strategy • Master Data Management – All MDM solutions • Enterprise Data Integration – Core Integration • Information Quality Management – Metadata, Governance & Quality • Enterprise Analytics – PureData(Netezza), Cognos, Tm1, SPSS, Big Data IBM Premier Partner Solutions consultancy in Europe – becoming a premier partner Over 220people in the company, all focused on IBM and the development and integration of IBM Solutions Worldwide Services Delivery • Offshore development centers in India, China & Russia

3. Agenda Overview for Information Governance, Policies & Data Quality Business Information Monitor Demonstration

4. Business Challenges Key Information Challenges Explosion of electronic information; Increasingly competitive and regulatory environment; Prohibitively expensive to take a reactive approach to governance issues; Dramatic growth in the use of electronic information within business processes requires governance standards within organisations; Requires new technology solutions that can fully address governance and the quality of data in an automated fashion.

5. Cost to Business of Poor Governance and Data Quality Problem – Marketing, Sales and Customer Service are operating with poor efficiency, relying on unknown data TDWI says dirty data costs US based businesses over $600B per year • Unknown data quality increases the cost of operations • Unknown data quality increases the cost of marketing and sales • Unknown data quality increases the cost of IT • Poor data quality causes customer churn The business doesn’t have visibility in the state of the data prior to use Taking the time out of day to day operations to remedy the problem is very expensive, complicated and time consuming

6. The Policy - Business Rule & Data Rule - is at the Heart of Data Governance and Compliance POLICIES Defined by a set of Business Rules BUSINESS RULES Defined by a set of Data Rules DATA RULES

7. Benefits of Business Information Management Metadata Management Benefits Metadata management refers to the activities associated with ensuring that meta data is created/captured at the point of the data’s creation and that the broadest possible portfolio of meta-information is collected, stored in a repository for use by multiple applications, controlled to remove inconsistencies and redundancies, and made available to business analysts and data stewards in an easily consumable manner. Key Activities • Creating and documenting the data definitions for the subject area’s entities and attributes; • Identifying the business and architectural relationships between objects; • Certifying the accuracy, completeness and timeliness of the content; • Establishing and documenting the context of the content (data heritage and lineage); • Providing a range of contextual understanding for an increasingly diverse range of data users, including trusted data for compliance, internal controls, and better decision-making; • Providing some of the information a technology professional might need for the physical implementation.

8. 2. Business Information Monitor & StreamClean Solution Stream’s Business Information Monitor delivers significant advancements in measuring, monitoring and managing your key business asset, your data. Creates the linkage between data policies and data rules Provides a near real-time view of the quality of your information Allows you to investigate problems before you invest in using the data • Provides performance metrics and information to: • help your business to measure, analyze and ensure accuracy and timeliness for your information • uses a well governed data policy based approach. • StreamCleanis a turnkey data remediation solution - fixes the data quality issues identified in B.I.M.

9. Benefits of Business Information (metadata) Management Metadata Management Benefits Business Information (metadata) Monitor provides the linkage between the business need or desire (policy) and the information or data value. The effective management of metadata is one of the essential activities of a data steward within a governance practice, thus enabling strategic (stakeholder) policy compliance and access to information. Key Elements Other Elements for 360 Information Governance • Data Quality Policy Management – with IBM Information Analyzer • Data Catalog Policy Management– with IBM Business Glossary • Data Provenance Policy Management – with IBM Metadata Workbench • Data Privacy Policy Management – with IBM Optim Data Masking • Data Retention Policy Management– with IBM Optim Lifecycle Management • Data Access Policy Management– with IBM Guardium Data Security

10. Appendices BIM Slide ware

11. Business Glossary – Policies

12. Business Policy

13. Policy’s Data Quality Results

14. Quality Manager

15. Quality Manager

16. Latest BIM Version Using New Cognos Reporting

17. Thank you For additional information, please contact ian.baxter@streamintelcom.com

18. APPENDICES

19. Architecture

20. Stream goes End-to-End with Big Data • Exploratory Server • SPSS Statistics • SPSS Modeler • ArcGIS • Cognos BI Raw Social Media Data • BigInsights • HDFS • MapReduce • PIG • Text Analytics Big Data is integrated into your Data Mart Cleaner data increases the accuracy of customer analytics Esri provides consumer expenditure measures Consumer and Market models are created using SPSS Data from traditional sources Cognos BI generates real-time mobile dashboards Customer data is piped from your EDW into the Data Mart MDM increases analytical value of data assets Data Warehouse IBM and ESRI Products Stream Solutions and Accelerators MDM Framework SC-360 Social Intelligence (SSI) Stream Consumer Analytics Social Media Analytics PureData System Integration Integration Framework StreamClean Quality Service Stream Spatial Binding Stream Media Connector