Decision support what is new an overview presentation university of north carolina at charlotte
Download
1 / 20

Bjarne Berg and Ben Perego March 20 th , 2006 - PowerPoint PPT Presentation


  • 114 Views
  • Uploaded on

Decision Support - What is new? An overview presentation University of North Carolina at Charlotte. Bjarne Berg and Ben Perego March 20 th , 2006. What We will cover. Enterprise Decision Support Systems (DSS) Presentation Tool trends Building the Enterprise DSS. What Do Users Really Want?.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Bjarne Berg and Ben Perego March 20 th , 2006' - khanh


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Decision support what is new an overview presentation university of north carolina at charlotte

Decision Support - What is new?An overview presentation University of North Carolina at Charlotte

Bjarne Berg and Ben Perego

March 20th, 2006


What we will cover
What We will cover

  • Enterprise Decision Support Systems (DSS)

  • Presentation Tool trends

  • Building the Enterprise DSS



The target enterprise decision support system architecture

Functional Area

Custom

Developed

Applications

InvoicingSystems

Purchasing

Data

ExtractionIntegration

and

Cleansing

Processes

Marketingand Sales

PurchasingSystems

Data

Mining

Translate

CorporateInformation

SegmentedData Subsets

GeneralLedger

Attribute

Statistical

Programs

Summation

Calculate

Other InternalSystems

Product Line

Derive

SummarizedData

Query Access

Tools

Summarize

External DataSources

Location

Synchronize

The Target Enterprise Decision Support System Architecture

Metadata

OperationalData Store

DataWarehouse

Source Data

Extract

Transform

Applications

Data Resource Management and Quality Assurance

Source: Bjarne Berg, “Introduction to Data Warehousing”,

Price Waterhouse Global System solution Center, 1997


New trend standard content off the shelf
New Trend - Standard Content “off-the-shelf”

Companies are now buying “packaged” DSS from their ERP vendors.

Since the software companies also built the transactions systems, they are in a good position to create the needed components of an enterprise decision support systems.

An example from a large manufacturing company

Source: SAP, Sdn BW 2005


All major ERP vendors have packaged DSS solutions

  • SAP, Baan, PeopleSoft, Oracle, JD Edwards and others have all packaged Data warehouse solutions. This is commonly known as Business Intelligence (BI) products.

  • There are many types of BI products:

    • Data Warehouses (DW)

    • Strategic Enterprise management (SEM)

      • Corporate Performance mgmt (CPM)

      • Business planning & simulation (BPS)

      • Business Consolidation services (BCS)

      • Stakeholder relationship mgmt (SRM)

    • Data Mining

    • Advanced Planning and Optimization (APO)

    • Supply Chain Event Manager (SCEM)

    • Customer Relationship Manager (CRM)

The data warehouse is the source of the data for all these integrated analytical applications (iAnalytics)



Evolution of Enterprise Decision Support Systems

Complex (score cards, budgeting, planning, KPI)

Horizontal approach (2nd generation)

Integrated analytical (3rd generation)

Level of Embedded Analytics

Emerging (1st generation)

Vertical approach (2nd generation)

Interactive Mgmt. reporting (OLAP, MQE)

Toolsets & accelerators

Level of Pre-delivered Content

Analytical applications

for specific industries

Source: Mike Schroeck, David Zinn and Bjarne Berg, “Integrated Analytics – Getting Increased Value from Enterprise Resource Planning Systems”, Data Management Review, May, 2002;

Adapted: Bjarne Berg “How to Manage a BW Project”, BW & Portals Conference, 2004, Orlando


What we will cover1
What We will cover

  • Enterprise Decision Support Systems (DSS)

  • Presentation Tool trends

  • Building the Enterprise DSS


New trend users are more sophisticated and olap is everywhere
New trend – Users are more sophisticated and OLAP is everywhere

Statistical software and On-line Analytical processing (OLAP) tools are becoming a “must-have” technology.

Increased information needs (less data) leads to adaptation of more sophisticated DSS tools


What we will cover2
What We will cover everywhere

  • Enterprise Decision Support Systems (DSS)

  • Presentation Tool trends

  • Building the Enterprise DSS


New trend data hubs for moving data no code
New trend – Data hubs for moving data – no code everywhere

Due to new tools, a typical DSS project will spend only 30-50% of project effort will be spent on data integration (previously it was much higher).

Tools such as MicroSoft’s BizTalk, SAP’s Exchange Infrastructure (XI), and the Informatica tool suite is replacing old stand-alone programs for data movement

Source: Bjarne Berg, “An A to Z Guide in Managing SAP NetWeaver Projects” - SAP NetWeaver and Portals Conference, March. 2006, Las Vegas


New trend building dss using extreme programming as a methodology
New Trend – building DSS using Extreme Programming as a methodology.

Source: Bjarne Berg, “How to pick JAD, RAD, XP or a SDLC Methodology for your project“, Nov. 2005,


New trends web cockpits and dashboards
New Trends - Web cockpits and Dashboards methodology.

Web cockpits and dashboards are no longer “sci-fi”.

Technology has led to better integrated decision support systems and the scale of companies now makes it cost effective to implement these tools.


New trends more data visualization
New trends – more Data Visualization methodology.

Due to high volumes of data, the user need visualized information that can be accessed and explored in a non-numerical presentation format.

New tools are addressing

these needs and

providing built-in

interactivity.


New trends exception reporting using broadcaster tools

KPI & Scorecard methodology. Formatted

  • Simple

  • Easy to view

  • Limited nav

  • Aggregates

Flat Reporting

  • Formatted

  • Print

  • Form based

  • Static

  • Predictable access

OLAP Reporting

  • Drill Down

  • Slice and Dice

  • Analyse

  • Data Mining

  • Search and discover

New trends – exception reporting using Broadcaster Tools

PUSH Vs. PULL

Reporting needs

No more “pulling” of reports. Now users can set up exceptions to “business as usual” and see the exceptions without having to log-on


What are some possible advantages of "packaged" DSS? methodology.

Can you think of any disadvantages


Have you experienced the effects of dashboard-based decision-making in your company?


How might this access to real-time information change the behavior of managers, workers?

….For better or worse?


Your turn
Your Turn!!! behavior of managers, workers?

Questions?


ad