IF YOU DONT GET IT YOU DONT GET IT

1
IF YOU DONT GET ITYOU DONT GET IT!

• A BI Perspective
• Sanjay Mehta
• CEO
• MAIA Intelligence

2
MAIA Intelligence Introduction1-Minute
3
Get One Single View
3 Blind Analyst a Data warehouse
4
Sales Revenue 1,383,593
What does this number reveal? Is this pretty
good, bad or ugly?
1,295,213 Q1
1,374,876 Q2
1,242,871 Q3
1,383,593 Q4
The Sales revenue for fourth Quarter is pretty
good as compared to earlier quarter
1,102,304 2004 Q4
1,395,478 2005 Q4
1,383,593 2006 Q4
The Sales revenue for 2006 Quarter IV is down as
compared to earlier years
1,598,604 Target 2006 Q4
1,383,593 Actual 2006 Q4
However in comparison to the targets, the actual
turnover appears ugly
5
Which region has the best sales in which month?
6
Changing role of CIO in BI space
7
CIO role in BI Decision Cycle
8
"If We Build It, They Will Come

• Flaw indicators
• Low usage of implemented BI
• No internal Business sponsor / owner for BI
• Pro-active measures
• Business User involvement from DAY 1
• Parameterize BI relevance, accuracy, consistency
• Plan BI support for business strategy evolution
• Engage in internal marketing of BI initiatives

9
Managers need to manipulate numbers

• Flaw Indicators
• Panic when number based reviews are due
• Poorly defined or complex business metrics
• Weak data accountability
• Pro-active Measures
• Building BI framework using factual business
  cases
• Propagate enterprise risks because of individual
  spreadsheet usage
• Managing hidden agendas of the dark horses

10
No Data Quality Problem

• Flaw Indicators
• Solve the data quality problem with a tool
• Eg Marketing campaign failed to launch
• Non-usage of BI because of data sanctity doubts
• Pro-active Measures
• Make Business Users understand GIGO
• Design processes and controls for data refinement
• Implement processes for data audition
  verification

11
Our Business Application vendor will deliver the
Best solution

• Flaw Indicators
• Heavy investments in OLTP applications, so why
  invest further in BI applications?
• Use the OLTP vendors data analysis tools as the
  licenses are free
• Pro-active Measures
• Differentiate OLTP from OLAP with a Business Case
• Propagate a BI strategy which can leverage the
  existing IT investments

12
Darwin was wrong There's no need for BI to
evolve

• Flaw indicators
• No single BI tool across departments
• Working on Solution simplicity, Problem
  Complexity principle
• Running multiple stand-alone small projects
  without identifying futuristic business value
• Pro-active Measures
• Define an Enterprise-wide BI Strategy (OTS
  Strategy)
• Continuous review during and after implementation

13
We can outsource

• Flaw Indicators
• BI is only report generation and can be
  outsourced
• Emphasis given to optimizing BI project costs
  without correlating Business Value Proposition
• Existing service vendors saying They can do it
  all
• Pro-Active Measures
• Identify the core elements which cannot be
  outsourced
• Define a futuristic outsourcing strategy with an
  eye on Business Strategy evolution

14
"Just Give Me a Dashboard"

• Flaw Indicators
• Business Users expecting a magic box to get short
  and simple data summarizations
• Creating departmental goals which do not explode
  from the Enterprise goals
• Insufficient thought time spent in defining
  measurable parameters
• Pro-Active Measures
• Have a comprehensive Data Aggregation strategy in
  place
• Peg Operation data with Business Performance
  Parameters

15
New Perspective to BI
16
Three Components of Latency
17
The Benefit of Reducing Latency
18
Strategic BI Requires Activism and Alignment

• IT-induced solutions mayor may not meet user
  requirements
• Users fail to use IT-provided solutions
• Tech. vendors prevail
• Limited or no business benefits realized

• Users and IT form teams
• BI core to strategic planning
• Business wins
• Right technology and products selected
• BI competencycenter emerges

• MIS reporting is the norm
• Inertia prevents any significant, new initiatives
• Business is runwithout the benefit of complete
  perspective

• Users source applications
• Infrastructure issues arise
• Scale, integrationand manageabilityare
  compromised
• Application vendorsprevail
• IT as a utility, not a partner

19
Methodology Strategic BI Applications
7. Develop Decision Alternatives
6. Access, Monitor, Analyze Facts
1. Definition
8. Share and Collaborate
Consume
2. Data Identification and Preparation
5. Discovery and Exploration
Construct
9. Effect Change
4. Develop, Implement, Train
3. Tool Evaluation/ Selection
20
1KEY BI Value Proposition5 Ps Video
Presentation3-Minutes
21
Business Intelligence Getting it Right
E N T E R P R I S E C U L T U R E
I T I N F R A S T R U C T U R E
22
Mr. Vikram Kole Head Marketing- Strategy
SpecialistMr. Piyush Mehta Director -
Finance Vertical Specialist Mr. Ashwin Dedhia
- Director - Solution Integration Specialist
MAIA Team
23

• Thank You!
• Sanjay Mehta
• CEO
• sanjaymehta_at_maia-intelligence.com