Business Intelligence - A Practical Perspective

1
Business Intelligence -A Practical Perspective

• Team Computers MAIA Intelligence

2
Gartner BI is 1 priority for CIOs
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

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 gt BI Tools and Techniques!
5
What does Business Intelligence Software
Actually include?

• Data mining Software
• End-User Query
• Reporting Software
• Analytics Software
• Packaged Data Mart / Datawarehouse
• ETL Tools

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!
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

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

9
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
10
The BI Audience
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
12
BI Traditional Models
Non-OLAP Data Models (Programming, Visual Query
Tools, In-Memory, etc)
Real time Reporting
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

14
Todays 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

15
Todays 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
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

17
BI Next Generation BI Flow
Operational Business Intelligence Easy-to-use
Front-end for Business users
Supporting Business Activity Monitoring (BAM)
18
Navigable Reports - Interactive
19
Navigable Reports Slice Dice
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 -gtProducts -gt Sales Person -gt Other
  Products -gt Other Customers -gt Geography -gt Best
  Selling Product -gt
• Think-as-you-analyse and Analyse-as-you-think

Benefits of Navigable Reports
21
Graphical AnalyticsNon-hierarchical Slice Dice
22
Dashboards Interactive
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

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?
25
Business Challenges
TECHNOLOGY
Market Volatility
Competition
Customer Management
Consolidation
Manpower
Transaction Volume
Suppliers
Government Reforms
26
Todays Business Pressures
Plan Model
Marketing
Sales
Risk
Credit
Execute
Service
Finance
Report Analyze
HumanResources
Project Mgmt
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)
28
CPM Framework


C3 Communication, Comprehension, Control
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

30
Enterprise Information The Framework
Rudder
Propeller
Unification of Data from Multiple Systems (ETL
and Common Data Model)
White Space Applications
31

• Business Intelligence
• Is the Purpose of IT.