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?.
Bjarne Berg and Ben Perego
March 20th, 2006
SynchronizeThe Target Enterprise Decision Support System Architecture
Data Resource Management and Quality Assurance
Source: Bjarne Berg, “Introduction to Data Warehousing”,
Price Waterhouse Global System solution Center, 1997
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
The data warehouse is the source of the data for all these integrated analytical applications (iAnalytics)
Source: SAP AG 2004
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
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
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
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
Source: Bjarne Berg, “How to pick JAD, RAD, XP or a SDLC Methodology for your project“, Nov. 2005,
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.
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
KPI & Scorecard methodology. Formatted
PUSH Vs. PULL
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?