Analítica de Información la base para una buena

Analítica de Información, la base para una buena toma de dececisiones Juan Carlos Rendón Tecnical Sales Manager Business Analytics, Industry and Collaboration

Better outcomes Smarter decisions Actionable insights Relevant information

Finance’s Enterprise-focused activities are increasing over time Importance of Finance’s Enterprise Focused Activities Over Time Source: IBM Institute for Business Value, The Global CFO Study 2010

Those that invest in Finance Efficiency and Business Insight outperform - we call them Value Integrators Source: 2010 IBM Global CFO study 4

Follow the Value Integrators Drive data and process standards Automate production of metrics Drive common planning and corporate and management reporting 5 Advance analytics Source: 2010 IBM Global CFO study Manage Risk

The more you infuse analytics into all areas of your business, the more your business can outperform its competitors.

Addressing critical processes in finance Planning, Analysis and Forecasting Profitability Modeling and Optimization Close, Consolidation, and Reporting Performance Reporting and Scorecarding Governance, Risk, and Compliance

IBM Business Analytics – Committed to Finance

Business Analytics Maturity Model Reactive, to Prescriptive, to Predictive Predict / Prescribe Best that can happen? What if theses trends continue? Forecasting Why is this happening? Statistical Analysis Alerts What actions are needed? Drilldown Query Ad Hoc Reports Dash/KPI Exact root cause and ID of the problem? How many, how often, who, & where? What just happened and why? Business Analytics Predictive Modelling Access & Reporting Competitive Advantage Views of What will happen next? Optimization

Unified FPM System Solutions Delivery Common User Experience Enterprise Planning Web Rich Client Financial Analytics Web Thin Client Excel / Office Business Intelligence Business Modeling Process Management Universal Capability • Dimension Management • Data Orchestration • Cube Building • Business Rules • Delegation & Workflow • Deployment Controls • Contribution & Signoff • Event Management • Reporting, Analysis & Dashboards • Portal & Content Mgmt • Security • Data & Metadata Access Extensible Program Interface FPM Open API Services OLAP Repository – TM 1 Data Infrastructure Strategy & Performance Reporting Financial Management & Control • • Multi-dimensional Complex business logic High data scalability In-memory architecture, real-time calculation and reporting • Unicode Relational Repository RDBMS • • • Deployment Management Transactional Data Audit functions Model & Object persistence Application Content Cognos Performance Management Services Product Direction is subject to change. All forward-looking statements are subject to the IBM Cognos Safe Harbor Statement.

Delivering on Roadmap - Enabling Full Financial Transformation Budgeting & Target Setting Bottom-up, high participation, workflow) Forecast & Estimate (Iterative, scenarios, sandboxing) Group and Country Financial Planning “The Last Mile” External Reporting Process (Top-down, driver-based, collaborative) d ate lid ed so on ish r c publ lle letro on trick C ta Da Close, Consolidation & Reporting TM 1 OLAP 64 -bit in-Memory High Performance Analytic & Planning Server

IBM’s Integrated Solution IBM Cognos Financial Performance & Strategy Management Performance Reporting and Scorecarding Business Drivers Close, Consolidate, Report, File • Account Analysis • Close Analytics • Financial Consolidation • Corporate Reporting • Regulatory Filing (e. g. XBRL) Analyze & Optimize • Financial Analytics • Spend Analytics • Profitability Analytics • Product, Market, Channel Analysis • Scenario (what-if) modelling • Personal sandboxes Plan, Forecast, and Control • Strategic Finance • Revenue Planning and Forecasting • Expense Planning & Control • Workforce Planning • Capital and Initiative Planning

Enterprise Planning: A Distinctive IBM Advantage Financial Performance and Strategy Management Business Drivers Close, Consolidate, Report, File IBM Strength Plan based on business drivers Easily implement Rolling Forecasts Connect financial and operational planning Connect plans to strategic goals Address both high participation and deeply analytic planning Real-time scenario modelling/ sandboxing Leverage best practices - over 75 performance blueprints to accelerate success Analyze & Optimize MARKETING PRODUCTION AND DISTRIBUTION CUSTOMER SERVICE Plan, Forecast, and Control EXECUTIVE MANAGEMENT SALES FINANCE PURCHASING TECHNOLOGY IT/R&D HUMAN RESOURCES FINANCE

Planning, Analysis, & Profitability Modeling Powerful User Experiences • Enables a NEW class of user Excel Based Collaboration Managed Collaboration who are NOT spreadsheet centric • Reduces “shadow “ planning and analysis systems • Supports personal, workgroup Finance and enterprise collaboration • Extends centralized and distributed enterprise planning and analysis solutions Human Resources Operations Drives alignment, dynamic decision-making Sales Marketing

User Experience Explore/analyze data and build a plan Perform Analysis on Personal Data • Prototype situations, plans • Work with existing or pull in new data • Perform what-if scenarios, associative analysis, write-back • Customise View and Explore Points Build A Plan • Create New Version • Shortcuts, Multiple Views, charts • Create or add to dashboards • Add Instructions Demo - Profitability Improved planning involvement across the enterprise

Share or Expand on the Plan Operations Human Resources Teaming Promote finds in a tailored dashboard Easily publish findings, reports to TM 1 (BI) Share new planning application on Web for teams to take action IT Customer Service Sales Finance Marketing Expand the plan Move plan to Performance Modeler for enhancement, contribution No dead-end street for individual analysis and plans Product Development Demo – CI Expand on Plan

Close, Consolidate, and Report Performance Reporting and Scorecarding Business Drivers Close, Consolidate, Report, File • Account Analysis • Close Analytics • Financial Consolidation • Corporate Reporting • Regulatory Filing (e. g. XBRL) Analyze & Optimize CLOSE CONSOLIDATE Plan, Forecast, and Control REPORT IBM Advantage From fragmented, first generation consolidation products to functional rich, purpose-built systems Cementing key financial process

Close, Consolidate, Report: Key Requirements • Single controlled environment • Application configuration • Audit tracking • Internal controls • Finance owned – ease of use • IT infrastructure compliance • Out-of-the-box functionality IMPACT: Cost efficient and effective compliance and faster cycles of close process execution. Confidence in consolidating financial results accurately and sharing with internal and external stakeholders • Consolidation workflow • Security & access control

Close, Consolidate, Report: Collect & Certify Process quality process & control in data preparation • Multiple data entry options – users and systems • Import from source systems with data lineage • Workflow to manage data collection • Data reconciliation and approval IMPACT: Quality data input, accountability and controls ensuring effective collection of all financial data for the close process • Internal controls & audit checklist

Close, Consolidate, Report: Consolidate Centralized system for fast consolidation of results • Multiple entity rollups & structures, multiple versions • Extended business segments • Apply automated and manual adjustments • Sophisticated currency accounting • Intercompany eliminations IMPACT: Controlled procedures and rules in a auditable application deliver consolidated financial results for all global and local demands • Complex ownership adjustments, joint ventures • Automate and schedule

Close, Consolidate, Report: Prepare Execute accounting and financial policy adjustments for external stakeholders • Automated and manual adjustments • Text commentary and other supporting documents • In-process reporting to certify financial results • Deliver multiple GAAP accounts e. g. IFRS, local GAAP, in a visible, easy-to-use environment IMPACT: Deliver financial results from a single, controlled data source • Track and audit different report adjustments

Close, Consolidate, Report: Report & Analyze Finance led reporting and analysis for decision making • Real-time in-process close accounting reports • Complex accounting reports for inter-company, investments, journal entries, etc. • Direct access via Excel • Leverage financial information for financial & management reports, ad-hoc analysis – inbuilt TM 1 OLAP (FAP) Cube IMPACT: Certified financial results supporting office of finance reporting mandates and providing insight to all business holders • World-class reporting (internal, external and electronic), dashboard, scorecard capabilities

Manual processes dominate financial close Accounting close Enterprise resource planning (ERP) Financial consolidations External reporting Output requirements ERP Edgar-ready Risk of errors, late filing, insider leaks, noncompliance

Internal Report Process Automation Collect Collaborate/Edit/Approve Report Driven from a central, secure database Efficiency: Consolidations Compliance Checklists CDM Report ERP Report Consumers Business Rules OLAP Data Warehouse Security 25 Reviewers Contributors Document Managers Business Insight: Leveragestemplates already in use: Use web the tools to automate data Increase time for analysis in the Microsoft Word and Excel through collection from anywhere reduced data collection cycle times world Direct access to source data Harness team insights through a multi Create/update content once and author environment updated in reports Changes dynamically automatically update that content across multiple reports Guarantee consistency of data through Powerful, collaborative environment integration with a single source of the Workflow and task management truth Workflow and task management tools provide greater visibility into Deliverstep controls, security & validation every the latest information through Embedded of the process real-timeoutputupdates Multiple data formats

Integrated Document Design & Production Process Data Sources ERP Consolidations Clarity FSR Relational Content Control Tagging OLAP End User Edits SEC Electronic (XML) Design Layout Batch Update Amendments Document Administration Team Proof 1, 2, 3… FINAL

Sharing Information Across the Organization Performance Reporting and Scorecarding Business Drivers Close, Consolidate, and Report Analyze & Optimize Risk of Errors Plan, Forecast, and Control Risk of Late Filing Feature Benefit Integration to source data No re-keying of data Variables in text Consistency across the report User prior report as a template for the next period No need to re-apply formatting Validation Rules Numbers always tie-out Automatically load new data No need to re-key data Start reviewing the final report sooner One version of the truth Feature Benefit Security to view or edit each object Users only see the data they are supposed to see Compliance Checklists To ensure that the right steps are being followed Workflow controls access throughout the process Users only see data when they are allowed to see it Audit Trail To track who did what, and when they did it Access to information is controlled Risk of Insider Leaks Increased confidence in the final report Risk of Non-Compliance

© Copyright IBM Corporation 2008 All rights reserved. The information contained in these materials is provided for informational purposes only, and is provided AS IS without warranty of any kind, express or implied. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, these materials. Nothing contained in these materials is intended to, nor shall have the effect of, creating any warranties or representations from IBM or its suppliers or licensors, or altering the terms and conditions of the applicable license agreement governing the use of IBM software. References in these materials to IBM products, programs, or services do not imply that they will be available in all countries in which IBM operates. Product release dates and/or capabilities referenced in these materials may change at any time at IBM’s sole discretion based on market opportunities or other factors, and are not intended to be a commitment to future product or feature availability in any way. IBM, the IBM logo, Cognos, the Cognos logo, and other IBM products and services are trademarks of the International Business Machines Corporation, in the United States, other countries or both. Other company, product, or service names may be trademarks or service marks of others.