Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    DSS

    Uploaded by

    Kumara55

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd

    DSS

    Uploaded by

    Kumara55
    11 views14 pages

    Original Title

    DSS.ppt

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    11 views14 pages

    DSS

    Uploaded by

    Kumara55

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    You are on page 1of 14

    Introduction to DSS

    Decision Support Systems (DSS) Agenda

    1 Why do we need Decision Support?

    2 What is a Decision Support System (DSS)?

    3 How does OLTP compare with DSS?

    4 Transition from Data Processing to Information and Knowledge!

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 2
    Why DSS: How does one answer these business questions?

    How are my Health Products How did my revenue improve in the


    performing region wise? past 5 years?

    What is the growth of


    members for different plans? Which plans costs me more
    and pays less?

    Which of my Business Segments


    are doing better?
    Currency Risk, Interest
    Rate Risk, Liquidity Risk

    What is premium and claims


    per member per month? Which providers cost me more?

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 3
    Driving Forces for DSS

    Profitability Analysis: Need to crunch data regularly from various IT systems all
    over the company to assess profitability
    Competitive Edge: Need to constantly know about the companys performance to
    be ahead of competitors
    Adapting rapidly to Market Changes: Be able to detect and react to changes in
    sales, production costs and customer buying patterns faster to keep ahead of
    competition
    Cost Control: Be able to detect and reduce production and other operative costs
    in a timely manner and thus increase the net profit
    Process Improvement: Be able to detect and increase employee productivity and
    reduce sales and other process cycle times to improve organizational efficiency
    Customer Centricity: Be able to detect, analyze and improve customer service
    before, during and after doing business with them (customers)
    Risk Management: Be able to detect, analyze and take timely action to reduce
    various risks in a timely manner

    Utilize Data as an asset to gain knowledge and information

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 4
    What is DSS?

    Decision Support Systems (DSS) are interactive computer-


    based systems intended to help decision makers utilize data to
    identify and solve problems and make faster and better decisions.
    Data Warehouse is the foundation of DSS process.

    Enable users to get a Business View of data

    Facilitate Data based Decision Making that would drive and


    improve the Business

    Discover Hidden Trends

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 5
    Why DSS?: What happens if there was no DSS?

    Data is all over the organization


    Delays and tedious ways to access data
    Business user spends too much time on IT tasks e.g. creating
    report, formatting, etc.
    Low productivity from IT department due to repetitive, non-
    standardized tasks
    Zero or very low reusability of reports

    High cycle times, poorer decision making abilities, frustration

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 6
    Why DSS? Why not OLTP?

    DSS queries hit OLTP performance adversely


    OLTP system data is dynamic: A DSS report run for the same
    conditions at different points in time will yield different results
    End-users must write queries manually to access OLTP data (ad-
    hoc analysis)
    Data in OLTP systems rarely have quality good enough to perform
    complex analyses
    OLTP systems may not store adequate history

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 7
    OLTP vs DSS: A comparison

    OLTP Environment DSS Environment


    get data IN get information OUT
    large volumes of simple small number of diverse queries
    transaction queries periodic updates only
    continuous data changes high processing time
    low processing time mode of discovery
    mode of processing subject oriented - summaries
    transaction details data consistency
    data inconsistency historical data is relevant
    mostly current data low concurrent usage
    high concurrent usage fewer tables, but more columns per
    highly normalized data structure table
    static applications Dynamic (ad-hoc) applications
    automates routines facilitates creativity

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 8
    Transition from Data Processing to Knowledge Processing

    BI TOOL
    BUSINESS ELEMENTS
    Ad-hoc Reports Standard Reports Analytics Data Mining
    TRACEABILITY

    EDW DATA MART ROLAP Tools Mining Tools

    ODS CUBES MOLAP tools Web-Infrastructure

    EXTRACT, TRANSPORT, TRANSFORM & LOAD

    DATA E LE M E N T S Management Decision: Value Chain

    Heterogeneous Data Sources Data Processing


    Information Processing
    Knowledge Processing

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 9
    Who are the Business Users?

    Executives/Managers
    Multi-dimensional analysis, reporting tools
    Knowledge Worker
    Ad hoc queries, detail & summary data, application focus
    Power-Analyst
    Ad hoc queries, Data Analysis & Data Mining
    Customer Contacts
    Detail Data at specific levels

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 10
    How do the Business Users benefit from DSS?

    Reliable Information Base for Knowledge Discovery


    Focus on Information Processing
    Quality & Completeness of Data
    Flexible Information Access
    High Availability
    Ease of Use

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 11
    What does DSS achieve for the Business?

    Profitability Analysis (Analytics)


    Competitive Edge (Analytics)
    Adapting rapidly to Market Changes (Data Mining)
    Cost Control (Analytics, Reporting)
    Process Improvement (Reporting)
    Customer Centricity (Analytics)
    Risk Management (Reporting)

    Utilize Data as an asset to gain knowledge and information


    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 12
    Different Projects using DSS in UHGIS

    PRDS
    GALAXY
    OXFORD
    OVATIONS
    FINANCE REPORTING
    OPTUM HEALTH

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 13
    Thank you

    Any use, copying or distribution without written permission from UnitedHealth Group is prohibited. 14

    You might also like