Introduction to Business Intelligence & Data Warehousing

1. Introduction to Business Intelligence & Data Warehousing TCS Public Feb 2009 By - Amit Shukla TCS Limited

2. Agenda • Introduction • Definitions • Business Intelligence Products • Pain Points • Driving Factors for Business Intelligence • Benefits • Business Intelligence Solutions’ Journey

3. Introduction Databases are used for following 2 broad functions: • Operational • To support day to day data needs of business processes, for example – Orders data, Invoices data, Payments data etc • Used by front line employees, like Store Keepers, Sales Executives etc • Main purpose is Record Keeping • Actions performed by users are Adding, Removing or Changing records • Called as Online Transaction Processing (OLTP) databases • Example - ERP Database • Informational • To support Decision Making • Typically Used by Managers, Analysts etc • Main Purpose is Information Retrieval and Analysis • Action performed by users is mainly Querying records • Called as Online Analytical Processing (OLAP) databases • Example – Reporting Database

4. Overview • Information Systems • Data Warehouse • Way of storing the data and creating information in such a way to facilitate Information delivery to Business • More relevant to Information Technology dept • Accumulates data from disparate data sources for querying purposes • Separates reporting and analysis operations from transaction systems to maximize the performance of both • Business Intelligence • Set of Tools and Technology to convert Data to Information and Information to Intelligence • More relevant to Business Users • Allow users to view the data from all levels of the enterprise • Provide users with information necessary to make timely, well-informed business decisions

5. Business Intelligence - Definitions Data Warehouse • Data Warehouse is an Integrated Store of High quality structured data for analysis and decision making. It provides a consistent, Single version of truth to Users. It is created by extracting the data from corporate, operational and external databases Data Mart • Data Mart is a Function Oriented Data Warehouse, for example Sales Data Mart, typically created out of an Enterprise Data Warehouse OLAP (Online Analytical Processing) • Set of tools which allow users to view the enterprise data along multiple dimensions, provides following features: • Reporting Applications • Adhoc Query (Self Service Reporting) • Statistical Analysis • Chart / Graphs • Drill Down / Roll up

6. Business Intelligence - Definitions Data Mining • Also known as Knowledge discovery in Databases. • Application of various software techniques like Artificial Intelligence, Statistical Algorithms to find patterns and regularities in sets of data • Makes possible to find patterns not previously discernable or so obvious that no one noticed them before • Typical Commercial Applications of Data Mining are

7. Business Intelligence - Definitions • Analytics • Use of statistical and mathematical techniques on data to discover strategic trends and opportunities and enable business analysts and executive managers to make faster and better data based decisions to improve business • Customer Analytics – churn, cross-sell/up-sell, campaign management • Industry-focused Analytics – manufacturing, insurance, financial services, health care, retail etc. • Financial Analytics – consolidated financial statements, regulatory compliance • Performance Analytics – planning & budgeting, strategy management

8. Business Intelligence - Products • Oracle Business Intelligence • Oracle Hyperion • SAP Business Objects • IBM Cognos Business Intelligence • Microsoft SQL Server Integration & Reporting Services • MicroStrategy • Informatica • SAS Inc

9. Information Acquisition – Pain Points • Data is all over the organization but no information • Delays and tedious ways to access data • Business user spends too much time on IT tasks e.g. creating report, formatting, etc. • Low productivity from IT department due to repetitive, non-standardized tasks • Zero or very low reusability of reports High cycle times, poorer decision making abilities, frustration

10. How can Business Intelligence help • Profitability Analysis:Need to crunch data regularly from various IT systems all over the company to assess profitability • Competitive Edge:Need to constantly know about the company’s performance to be ahead of competitors • Adapting rapidly to Market Changes:Be able to detect and react to changes in sales, production costs and customer buying patterns faster to keep ahead of competition • Cost Control:Be able to detect and reduce production and other operative costs in a timely manner and thus increase the net profit • Process Improvement:Be able to detect and increase employee productivity and reduce sales and other process cycle times to improve organizational efficiency • Customer Centricity:Be able to detect, analyze and improve customer service before, during and after doing business with them (customers) • Risk Management:Be able to detect, analyze and take timely action to reduce various risks in a timely manner Utilize Data as an asset to gain knowledge and information

11. User Benefits • Reliable Information Base for Knowledge Discovery • Focus on Information Analysis • Quality & Completeness of Data • Flexible Information Access • High Availability • Ease of Use

12. Evolution of Business Intelligence Systems Analytics BPO Risk Solutions 2008 Agility, Adaptability and Efficiency- More actions to be taken - Less time left to take the actions - More information to be analyzed - More certainty needed in prediction CPM 2006 2005 Analytics Competency Center 2004 Operational BI, Real-Time DW 2003 2002 Data Mining OLAP, Ad-hoc Reports Enterprise Reporting 2001 2000 1999 1998 Mid 90

13. Business Intelligence – Current Trends • Pervasive • Single Version of Truth • Pre-packaged Analytics • Real time / Near Real Time Information Access • Strategic and Operation Decision Making • Information Push rather than Pull • Service Orientation (Information Acquisition and Delivery) • SaaS mode of service delivery

14. TCS’ Business Intelligence - Solution Focus Areas Reporting • Enterprise Reports • OLAP Reports • Ad-Hoc Reports • Dashboards/Scorecards • GIS RealTime BI • Operational BI • Rules Engine Access Management • Information Portal • Search Engine High-end Analytics • Data/Text Mining • What-if Analysis • Forecasting Corporate Performance Management • Enterprise Planning • Financial Consolidation • Strategy Management Pre-packaged Analytics • CRM, Marketing, Supply Chain, Risk Management etc.

15. Strategic Tactical Operational TCS Business Intelligence - Offerings • Strategic Offerings • Blueprint • Business Case Modeling • Maturity Assessment • Balanced Scorecard • Strategy Management • Enterprise Planning • Financial Consolidation • Tool Evaluation • Tactical Offerings • Industry Analytics • Dashboard Management • Operational BI • Data Mining TCS Range of Services • Operational Offerings • Analytics Competency Centre • Lifecycle Services • Sustenance Services • Change Management • Migration and Upgrade Services • Analytics BPO

16. Thank you