Business Intelligence - A Practical Perspective

1. Business Intelligence -A Practical Perspective Team Computers & MAIA Intelligence Team Computers & MAIA Intelligence

2. Gartner: BI is #1 priority for CIOs Team Computers & MAIA Intelligence

3. Business Intelligence Software Market in India • Indian market for Business Intelligence (BI) is growing at a CAGR of 27 percent and is expected to be $ 17 million market by end-2007 – An IDC Report Team Computers & MAIA Intelligence

4. What is Business Intelligence? • Business Intelligence is a Business Management term! - Wikipedia • BI : Info on factors affecting business – • Metrics on Sales, Production, Internal operations • Trends of Metrics • This Info helps makes better decisions BI => BI Tools and Techniques! Team Computers & MAIA Intelligence

5. What does Business Intelligence Software Actually include? • Data mining Software • End-User Query • Reporting Software • Analytics Software • Packaged Data Mart / Datawarehouse • ETL Tools Team Computers & MAIA Intelligence

6. What Tool / Technology is good? • What tools are available? • What works for us? • What is required for us? • How much of D.A.R can be handled by various tools? The Maze! Team Computers & MAIA Intelligence

7. The Maze! BI Tools Business Analysis Enterprise Application Integration Predictive Modeling Web Enabling ERP Ad Hoc Reporting Work Flow Isolated Point Solutions Distributed Data Integration CRM Reporting Data Accuracy Training Team Computers & MAIA Intelligence

8. Any Map for the Territory? • A model for understanding the IT and BI Space would help • Data Collection from Transactions and Reporting requirements are two axes of the IT initiatives • Budget, Time, Business Needs, Technology Available and Skilled Manpower all influence decisions taken Team Computers & MAIA Intelligence

9. Interactive Adhoc Visual reporting Business Intelligence Operational Statutory Data Integration Data Warehouse Accounting Full Fledged ERP Initial Stages of Operational Establishment Isolated Systems For Few Areas The IT-BI Space Accurate Business Insight for Decision Making and Improvement Reporting More Flexible and Strategic More Accurate, More Cleaner and Internally Consistent Data Collection Team Computers & MAIA Intelligence

10. Requires Dashboards Requires Analytics Requires Reporting The BI Audience Team Computers & MAIA Intelligence

11. The BI Value Proposition IntelligentInteractions (Data Mining) Predictive Forecasting Fact-Based Actions (OLAP/In-Memory, Statistics ) Analysis PerformanceManagement (KPI, Guided Analytics) Are there any potential out-of-stock situations region warehouse wise? Reporting Increasing Value Slice/Dice Ad-hoc Query, BI Tools How is the business doing compared to last year? Compared to plan? Can I understand my gross margin return on space? Transactional Reporting How are my export and domestic sales doing Generational Step Team Computers & MAIA Intelligence

12. BI – Traditional Models Non-OLAP Data Models (Programming, Visual Query Tools, In-Memory, etc) Real time Reporting Team Computers & MAIA Intelligence

13. BI – User Perspective • Reporting • Regular Mass Information Dissemination in a standard format • Analytics • Slicing and Dicing with visual feedback and interactivity. • Mainly for the Middle Management – for Tactical Decisions and to guide Strategic Decisions • Dashboards • Quick Distilled Snapshots, highlighting the key Indices, for Instant Decision Making • D.A.R. - Perfect combination of Data Distribution and Understanding of Information Team Computers & MAIA Intelligence

14. Today’s Reporting facts… • Limited standard reports in applications like ERP, CRM, SCM etc – Time consuming scripting for additional reports • Availability of only Static reports – No analysis possible • For analysis & intelligence, export to Excel – Chances of data corruption and data manipulation Team Computers & MAIA Intelligence

15. Today’s Reporting FactsContd… • Multiple Data sources – Single view not possible • Tactical & Strategic Business Intelligence for top management – After-the-fact reports and analysis • Adhoc and enhancement requests from business users – Productivity loss of IT resources Solution : Operational Business Intelligence & Reporting Team Computers & MAIA Intelligence

16. Reporting – Considerations • Reporting technologies • Designed for information distribution • Ad-Hoc or Pre-Defined? • During-The-Fact (Real-Time) or After-The-Fact • Transactional (or) Past Data • Presentation • Graphical or Tabular / Textual • Navigability Across Reports • Drill Through, Drill Across Team Computers & MAIA Intelligence

17. BI – Next Generation BI Flow Operational Business Intelligence Easy-to-use Front-end for Business users Supporting Business Activity Monitoring (BAM) Team Computers & MAIA Intelligence

18. Navigable Reports - Interactive Team Computers & MAIA Intelligence

19. Navigable Reports – Slice & Dice Team Computers & MAIA Intelligence

20. AnalyticsDesigned for Understanding • Analytics needs to facilitate: • Inspection • Exploration and • Question/Answer Probing that coincide with the human process of assimilating data. • Explore Freely • Observe – Identify new relationships/dependencies/patterns – New Understanding – New Decisions/Actions • Swim Freely in the Multi-Dimensional DataSpace: • Customer ->Products -> Sales Person -> Other Products -> Other Customers -> Geography -> Best Selling Product -> … • Think-as-you-analyse and Analyse-as-you-think Benefits of Navigable Reports Team Computers & MAIA Intelligence

21. Graphical AnalyticsNon-hierarchical Slice & Dice Team Computers & MAIA Intelligence

22. Dashboards – Interactive Team Computers & MAIA Intelligence

23. Advanced Analytics – Mining & Models • Modeling • Descriptive and Predictive Models • Famous Examples • Beer and Nappies – Market Basket Analysis • Chrysler – Identification of new patterns • Typical Requirements • Model to predict Attrition • Model to decide credit limits for a credit card applicant • Needed for a small percentage of Research users • Models developed here are used in Operation Control • Risk Models • Cash Flow Models • Queuing Models • Stochastic Models … etc Team Computers & MAIA Intelligence

24. So What is Business Intelligence? • It includes everything : • Ad Hoc, Interactive, Visual Reporting • Interactive Analysis • What-if Analysis • Descriptive and Predictive Modeling • Need to define ways of inducting BI • Every company needs a customized approach Well where BI can help? Team Computers & MAIA Intelligence

25. Business Challenges TECHNOLOGY Competition Market Volatility Customer Management Manpower Consolidation Transaction Volume Suppliers Government Reforms Team Computers & MAIA Intelligence

26. Rapidly Changing Conditions • How can I accelerate my planning and decision cycles? • How do I monitor conditions and take early corrective action? • Accountability, Transparency • How do I comply with corporate governance requirements? • How can I ensure accurate, timely reporting? • Efficiency & Cost Control • How can I sustain / improve profitability? • How do I keep information current? • Ineffective Decision Support • How do I filter extraneous dataand focus on relevant information? • How can I access and rationalize disparate, fragmented data? Today’s Business Pressures Plan & Model Sales Marketing Credit Risk Execute Finance Service Report & Analyze HumanResources Project Mgmt Team Computers & MAIA Intelligence

27. Corporate Performance Management ‘Corporate Performance Management (CPM) is using right tools of Business Intelligence (BI)for monitoring and managingan organization's performance, using appropriateKey Performance Indicators (KPIs) Team Computers & MAIA Intelligence

28. CPM Framework C3 : Communication, Comprehension, Control Team Computers & MAIA Intelligence

29. Initiating CPM • Integrate and take advantage of existing IT assets • Identify the data integration strategy • Identify a Business Intelligence strategy (Operational + Tactical) • Blending Business Intelligence with elements of planning, budgeting and appropriate-time monitoring • Identify measurable Business Performance Parameters (BPP) • Peg operational data with BPP • Improve and simplify pegging continuously Team Computers & MAIA Intelligence

30. External Data Live Feeds Peer Data Market Data Research Reports Extranet Board, Investor and Shareholder View of Enterprise External Guidance Users Disclosure, Compliance, Guidance, Profitability, Corporate Affairs Enterprise Activity Synchronization and Monitoring Everyday Collaborative For Managers Tasks, Workflow, Common Calendar & Issue Log Dashboards (KRA/KPI) Balanced Scorecards Strategy Map Review Actions Performance Management For All Users Unified View of Enterprise New Process Creation Tactical Reporting & Unified View for All Compliance Reporting Performance Analysis Business Analysis Market Analysis External Data ERP SCM CRM HR FA SFA Other Industry Specific Transaction System Transaction & Operational Reporting for Line Managers Unified or Disparate Transaction Systems Enterprise Information The Framework Rudder Propeller Unification of Data from Multiple Systems (ETL and Common Data Model) White Space Applications Team Computers & MAIA Intelligence

31. Business Intelligence Is the Purpose of IT. Team Computers & MAIA Intelligence