C04 Business Intelligence, Dashboards and Scorecards: Driving Business Performance Tuesday, November

1
C04 Business Intelligence, Dashboards and
Scorecards Driving Business PerformanceTuesday,
November 11th, 230 345
2
CO4 BI, Dashboards Scorecards

• Carolee Dagenais, Principal, Business Development
  St. Nick Media Services
• Carolee Dagenais has more than 10 years of
  professional experience in marketing, sales and
  alliance management with a strong concentration
  in the insurance industry. Her work has
  contributed to the success and promotion of
  companies including Allenbrook, ImageRight, SAP
  and Skywire Software. Carolee has managed
  corporate marketing, lead generation, branding,
  public relations, event planning and overall
  relationship management. Her connections within
  the insurance community combined with broad
  product knowledge and insight make a powerful
  combination for supporting research, branding and
  PR for the vendor community. She is a member of
  the American Marketing Association, Association
  of Strategic Alliance Professionals and an active
  member of IASA. .

3
CO4 BI, Dashboards Scorecards

• Housekeeping items
• Turn off cell phones, beepers, pagers, etc.
• Please fill out the survey
• Moderated QA at the end of the session save
  your questions
• Topic introduction Business Intelligence,
  Dashboards Scorecards Driving Business
  Performance
• No question insurers have more data than ever
  before
• Being able to understand data is key to knowing
  what is going on with your business
• Its important to you!

4
CO4 BI, Dashboards Scorecards

• Moderator
• Carolee Dagenais, Principal, Business Development
  St. Nick Media Services
• Todays Speakers
• Chad Hersh, Principal Novarica
• Mark Sadowski, Information Technology Data
  Manager Scottsdale Insurance Group
• Mark Chen, Principal Business Intelligence
  Architect Moore Stephens Business Solutions

5
CO4 BI, Dashboards Scorecards

• Chad Hersh, Principal - Novarica
• Chad Hersh is a leading authority on insurer
  technology strategy, with a focus on core systems
  and the policy administration system marketplace
  in particular. He has been the primary author of
  the market leading industry reports on policy
  administration systems for the past five years,
  and has advised dozens of CIOs and project teams
  on core systems replacement strategy and vendor
  selection. He has presented his research at
  conferences sponsored by ACORD, LOMA, IASA,
  Insurance Networking News, and others, and is a
  frequent source for the mainstream and trade
  media on industry issues. Prior to joining
  Novarica, he worked for five years with Matthew
  Josefowicz in the insurance practice at Celent, a
  previously independent analyst firm recently
  acquired by Oliver Wyman (part of MMC). He has
  also served as e-business director at AIG and
  American General, and as an IT consultant at
  Ernst Young and CSC. He graduated from Rice
  University with a BA and an Master of Accounting
  degree with an MIS concentration. He has also
  served as part-time faculty at Rice teaching
  courses in e-business and consulting.

6
Business Intelligence Overview
CO4 BI, Dashboards Scorecards
7
CO4 BI, Dashboards Scorecards
Importance
8
CO4 BI, Dashboards Scorecards
Infrastructure Reporting
9
CO4 BI, Dashboards Scorecards
Infrastructure Asynchronous Repositories
10
CO4 BI, Dashboards Scorecards
Infrastructure Synchronous Repositories
11
CO4 BI, Dashboards Scorecards
Effectiveness
12
CO4 BI, Dashboards Scorecards
Impact
13
CO4 BI, Dashboards Scorecards
Challenges
14
CO4 BI, Dashboards Scorecards
Four Key Changes in the Data Landscape
15
CO4 BI, Dashboards Scorecards
Looking Forward
Quality and Amount of External Data
Analytic Power Available To Insurers
Missed Opportunity
Insurers Internal Data Quality
16
CO4 BI, Dashboards Scorecards
Summary

• Only about half of participating insurers
  currently had excellent or acceptable business
  intelligence capabilities in place according to
  their own estimates.
• Only about one-third reported significant
  business impact from their business intelligence
  investments, but roughly an additional third
  expected impact over the next 12 months.
• Underwriting and new business lag other areas in
  leveraging the value of business intelligence.
• The two greatest impediments to leveraging
  business intelligence to create value are the
  lack of data models, and the difficulty of
  changing business user behavior based on
  analytics.
• Business Intelligence and control over internal
  data is a foundation for predictive analytics.

17
CO4 BI, Dashboards Scorecards

• If you have questions specifically regarding this
  portion of the presentation, please contact
• Chad Hersh, Principal
• Novarica
• [phone]
• Email chersh_at_novarica.com
• And now, our next speaker, Mark Sadowski of
  Scottsdale Insurance Group.

18
CO4 BI, Dashboards Scorecards

• Mark Sadowski, Information Technology Data
  Manager Scottsdale Insurance Group
• Mark Sadowski is the Information Technology Data
  Manager for Scottsdale Insurance Group, a 2
  billion leader in the excess and surplus lines
  market. Scottsdale Insurance, a wholly-owned
  subsidiary of Nationwide, has over 1,350
  associates on their main campus in Scottsdale AZ.
  Sadowski has over 22 years of information
  technology experience, including roles in
  business and systems analysis, application
  development, and data management, and 16 years of
  insurance experience. His career has centered on
  delivery of data-related projects highlighted by
  an actuarial data warehouse, a self-service
  web-based customer reporting data mart, and a
  cube-based multidimensional premium and loss data
  mart. He holds a BS in Computer Science from
  California State University.

19
CO4 BI, Dashboards Scorecards

• The Evolution of Business Intelligence
• at Scottsdale Insurance Group
• Case Study

20
CO4 BI, Dashboards Scorecards

• Agenda
• Where We Were
• Where We Are
• Where Were Going

21
CO4 BI, Dashboards Scorecards

• Where We Were (Pre 2006)
• Custom Reports
• 1,300 in use
• 100 Requests Monthly
• Multiple Versions
• Inconsistency
• Limited Business Intelligence
• Outdated Technology
• Expensive to Maintain

22
CO4 BI, Dashboards Scorecards
23
CO4 BI, Dashboards Scorecards

• Step 1 Data Express
• (Aug 2006)
• Business Objects Implementation
• 6 Reports
• True Ad-hoc Capabilities
• Enhance Report Delivery Process
• 1st Step into Business Intelligence
• Built for Future Expansion

24
CO4 BI, Dashboards Scorecards
25
CO4 BI, Dashboards Scorecards
26
CO4 BI, Dashboards Scorecards

• Step 2 Data Surfer
• (March 2008)
• OLAP Cube
• 75 Measures
• 60 Dimensions
• 250 Million Rows of Data
• Moore Stephens
• Data and Insurance Experts
• Accelerated Information Delivery
• Single Source of Data
• Quantifiable ROI

27
CO4 BI, Dashboards Scorecards
28
CO4 BI, Dashboards Scorecards

• Step 3 Dashboards
• (August 2008)
• Executive Analysis
• Daily Snapshots of Business
• Right Time BI
• Consistent Information
• Interactive Views
• Multiple Reports
• Single View

29
CO4 BI, Dashboards Scorecards
30
CO4 BI, Dashboards Scorecards

• Where Were Going
• Enhanced Cubes
• Additional Dimensions
• Additional Measures
• Additional Scottsdale Companies
• Western Heritage
• Freedom Specialty
• Dashboard Maturation
• Deeper Sophistication

31
CO4 BI, Dashboards Scorecards

• If you have questions specifically regarding this
  portion of the presentation, please contact
• Mark Sadowski, Information Technology Data
  Manager
• Scottsdale Insurance Group
• 8877 N. Gainey Center Drive
• Scottsdale AZ 85258
• Phone [phone]
• Email sadowsm1_at_scottsdaleins.com
• And now, our next speaker, Mark Chen of Moore
  Stephens.

32
CO4 BI, Dashboards Scorecards

• Mark Chen, Principal Business Intelligence
  Architect Moore Stephens Business Solutions
• Mark Chen is a Principal and Business
  Intelligence Architect for Moore Stephens
  Business Solutions based in the companys New
  York City office. His responsibilities include
  managing the successful delivery of business
  intelligence projects for Moore Stephens clients
  from both a business and technical approach. Chen
  came to Moore Stephens in December 2006, with
  over 10 years experience in the insurance and
  insurance software industry. He began his
  insurance career as a consultant working on
  insurance class action lawsuit systems,
  demutualizations, marketing within the life
  insurance realm, and more recently focusing on
  property and casualty lines. Throughout his
  career, Chen has promoted the use of business
  intelligence as a key to success. He has a
  proven track record of success in the industry
  and is the co-author of the soon-to-be-released
  PerformancePoint Server for Dummies.

33
CO4 BI, Dashboards Scorecards

• Performance Management A Definition
• The ability to easily report, analyze,
  interrogate and manipulate any aspect of your
  business performance, when you want, how you
  want, where you want, irrespective of underlying
  systems technology.

34
CO4 BI, Dashboards Scorecards

• Transforming the Organization - Is your company
  ready?
• Lists ? Analysis
• Requesting ? Generating
• Gathering Data ? Analyzing Data
• Reactive ? Proactive

35
CO4 BI, Dashboards Scorecards

• Not all Business Intelligence is created equal
• Levels of Analysis
• Lists - Which claims are my large losses coming
  from?
• Totals, Averages, Counts - What products are
  performing best?
• KPIs - How quickly am I servicing my clients?
• Levels of Granularity
• Transactions
• Policy
• Products
• Corporate
• Levels of User Capability
• Summaries - Just show me the totals and averages
• Interaction - Let me build my own report
• Consolidation - KPIs, status, trends, and
  performance metrics all at once

36
CO4 BI, Dashboards Scorecards

• Different users, different requirements

37
CO4 BI, Dashboards Scorecards

• Logical Components

38
CO4 BI, Dashboards Scorecards

• Performance Management Requirements
• Accurate (1)
• Gold Copy Sourcing
• Shared Definitions MetaData
• Timing, timing, timing
• Available (2)
• Consumable across delivery channels tools
• Dynamic an answer begets a question
• Distributed beyond analysts to everyone
• Actionable (3)
• Integrated into business processes
• Connecting executive decisions with operational
  activity
• Real-time impact affecting how were doing, not
  showing how we did.

39
CO4 BI, Dashboards Scorecards

• Business Intelligence Architecture

40
CO4 BI, Dashboards Scorecards

• Consolidate and Streamline
• One Source for all Reporting Data
• Flexibility to service any level of user
• Reporting platform independence

41
CO4 BI, Dashboards Scorecards

• Dashboards and Scorecards

42
CO4 BI, Dashboards Scorecards

• Targets

43
CO4 BI, Dashboards Scorecards

• Analytics

44
CO4 BI, Dashboards Scorecards

• Standard Reporting

45
CO4 BI, Dashboards Scorecards

• Platform Independence

46
CO4 BI, Dashboards Scorecards

• Evolution
• One data source One source for the truth
• Multiple levels of granularity
• Multiple levels of analysis
• Multiple means of access
• The A-ha moment

47
CO4 BI, Dashboards Scorecards

• If you have questions specifically regarding this
  portion of the presentation, please contact
• Mark Chen
• Principal Business Intelligence Architect
• Moore Stephens Business Solutions
• 477 Madison Avenue, 10th Floor
• New York, NY 10022
• Phone [phone]
• Email mark.chen_at_moorestephens.com
• And now, back to our moderator, Carolee Dagenais,
  for the QA portion of our program.

48
CO4 BI, Dashboards Scorecards

• QA with Todays Presenters
• Moderator
• Carolee Dagenais, Principal, Business Development
  St. Nick Media Services
• Todays Speakers
• Chad Hersh, Principal Novarica
• Mark Sadowski, Information Technology Data
  Manager Scottsdale Insurance Group
• Mark Chen, Principal Business Intelligence
  Architect Moore Stephens Business Solutions

49
CO4 BI, Dashboards Scorecards

• Thank you for your time. If you have questions
  or comments, or if you would like a copy of this
  presentation sent to you via email, please
  contact
• Jennifer Overhulse-King, Principal Owner
• St. Nick Media Services
• 15695 Glencoe-Verona Road
• Verona, KY 41092
• [phone]
• Email jen_at_stnickmedia.com