Chapter 9 : Enabling the Organization - Decision Making

Making Business Decisions

  • Decision making process - plays a crucial role in communication and leadership for operational, managerial, and strategic projects
  • Decision making essentials (managerial decision making challenges)
    • Managers need to analyze large amounts of information
      • Innovation in communication and globalization have resulted in a dramatic increase in the variables and dimensions people need to consider when making a decision, problem solving or appraising an opportunity
    • Managers must take decisions quickly
      • Time is of the essence and people simply don not have time to sift through all the information manually
    • Manager must apply sophisticated analysis technique, such as Porter's strategies or forecasting, to make strategic decisions
      • Due to the intensely competitive global business environment, companies must offer far more than just a great product to succeed
  • Operational (decision making process)
    • Problem identification - Define the problem as clearly and precisely as possible
    • Data collection - Gather problem-related data, including who, what, where, when,why, and how. Be sure to gather facts, not rumours or opinions about the problem
    • Solution generation - Detail every solution possible, including ideas that seem fart etched
    • Solution test - Evaluate solutions in terms of feasibility (can it be completed?), suitability (is it permanent or a temporary fix?), and acceptability (can all participants from a consensus?)
    • Solution selection - Select the solution that best solution that best solves the problem and meets the needs of the business
    • Solution implementation - If the solution solves the problems, then the decisions made were correct. If not, then the decisions were incorrect and the process begins again
  • Managerial
    • At this level, employees are continuously evaluating company operations to hone the firm's abilities to identify, adapt to, and leverage change
    • These types of decisions are considered semi-structured decisions they occur in situations in which few established processes help to evaluate potential solutions, but not enough to lead to a definite recommended decisions
  • Strategic
    • At this level, managers develop overall business strategies, goals, and objectives as part of the company's strategic plan
    • Strategic decisions are highly unstructured decisions, occurring in situations in which no procedures or rules exist to guide decision makers toward the correct choice
Enhancing Decision Making with MIS
  • Operational support systems
    • Transactional information encompasses all the information contained within a single business process or unit of work, and its primary purpose is to support the performance of daily operational or structured decisions
    • Online transaction processing (OLTP) is the capture of transaction and event information using technology to 
      • process the information according to defined business rules
      • store the information
      • update existing information to reflect the new information
  • Managerial support systems
    • Analytical information encompasses all organizational information, and its primary purpose is to support the performance of managerial analysis or semi-structured decisions
    • Online analytical processing (OLAP) is the manipulation of information to create business intelligence in support of strategic decision making
    • Decision support systems (DSSs) model information using OLAP which provides assistance in evaluating and choosing among different courses of action
  • Strategic support systems
    • Executive information system (EIS) is a specialized DSS that supports senior-level executives and unstructured, long term, non routine decisions requiring judgement, evaluation, and insight
Interaction between TPS and DSS to Support Semi-structured Decisions
The Future : Artificial Intelligence
  • Artificial intelligence (AI) simulates human thinking and behaviour, such as the ability to reason and learn
  • Intelligence systems are various commercial applications of artificial intelligence
  • Expert systems are computerized advisory programs that imitate the reasoning processes of experts in solving difficult problems
  • Neural networks (artificial neural network) is a category of AI that attempts to emulate the way the human brain works
    • Learning and adjusting to new circumstances on their own
    • Lending themselves to massive parallel processing
    • Functioning without complete or well-structured information
    • Coping with huge volumes of information with many dependent variables
    • Analyzing non linear relationships in information (they have been called fancy regression analysis systems)
    • Fuzzy logic is a mathematical method of handling imprecise or subjective information
  • Genetic algorithms is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem
  • Intelligent agents is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users
  • Virtual reality is a computer-stimulated environment that can be a simulation of the real world or an imaginary world

Chapter 8 : Accessing Organizational Information - Data Warehouse

History of Data Warehouse

  • The data warehouse provided the ability to support decision making without disrupting the day-to-day operations, because:
    • Operational information is mainly current – does not include the history for better decision making
    • Issue of quality information
    • Without information history, it is difficult to tell how and why things change over time

Data Warehouse Fundamentals
  • Data warehouse – a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
  • The primary purpose of a data warehouse is to combined information throughout an organization into a single repository for decision-making purposes – data warehouse support only analytical processing
  • Data warehouse models
  • Multidimensional Analysis and Data Mining - relational Database contain information in a series of two-dimensional tables




  • In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows
    • Dimension – a particular attribute of information

    • Cube – common term for the representation of multidimensional information
    • Once a cube of information is created, users can begin to slice and dice the cube to drill down into the information
    • Users can analyse information in a number of different ways and with number of different dimensions

Multidimensional Analysis and Data Mining
  • Data mining – the process of analysing data to extract information not offered by the raw data alone. Also known as "knowledge discovery" – computer-assisted tools and techniques for sifting through and analysing vast data stores in order to find trends, patterns, and correlations that can guide decision making and increase understanding
  • To perform data mining users need data-mining tools
  • Data-mining tool – uses a variety of techniques to find patterns and relationships in large volumes of information. Examples: retailers can use knowledge of these patterns to improve the placement of items in the layout of a mail-order catalogue page or Web page
Information Cleansing or Scrubbing
  • An organization must maintain high-quality data in the data warehouse
  • Information cleansing or scrubbing – a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
  • Occur during ETL process and second on the information once if is in the data warehouse
  • Contact information in an operational system


  • Standardizing Customer name from Operational Systems
  • Information cleansing activities

  • Accurate and complete information
Business Intelligence
  • Business intelligence – refers to applications and technologies that are used to gather, provide access, analyze data, and information to support decision making effort
  • these systems will illustrate business intelligence in the areas of customer profiling, customer support, market research, market segmentation, product profitability, statistical analysis, and inventory and distribution analysis to name a few
  • Eg: Excel, Access 

Chapter 7 : Storing Organizational Information - Database

Relational Database Fundamentals

  • Database – maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)
  • Database models include:
    • Hierarchical database model – information is organized into a tree-like structure (using parent/child relationships) in such a way that it cannot have too many relationships
    • Network database model – a flexible way of representing objects and their relationships
    • Relational database model – stores information in the form of logically related two-dimensional tables
  • Entity – a person, place, thing, transaction, or event about which information is stored
    • The rows in each table contain the entities
    • In Figure 7.1 CUSTOMER includes Dave’s Sub Shop and Pizza Palace entities
  • Attributes (fields & columns) - characteristics or properties of an entity class
    • The columns in each table contain the attributes
    • In Figure 7.1 attributes for CUSTOMER include Customer ID, Customer Name, Contact Name
  • Primary keys and foreign keys identify the various entity classes (tables) in the database
  • Foreign key – a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables
  • Primary key – a field (or group of fields) that uniquely identifies a given entity in a table
  • Potential Relational Database for Coca-Cola Bottling Company of Egypt
Relational Database Advantages
  • Increased flexibility
  • Increased scalability and performance
  • Reduced information redundancy
  • Increased information integrity (quality)
  • Increased information security

Database Management Systems (DBMS)

  • Database management systems (DBMS) – software through which users and application programs interact with a database 

  • Data-driven Web sites – an interactive Web site kept constantly updated and relevant to the needs of its customers through the use of a database

  • Data Driven Web Site Advantages
    • Development
    • Content Management
    • Future Expandability
    • Minimizing Human Error
    • Cutting Production and Update Costs
    • More Efficient
    • Improved Stability

  • Data-Driven Business Intelligence

Integrating Information among Multiple Devices
  • Integration – allows separate systems to communicate directly with each other
    • Forward integration – takes information entered into a given system and sends it automatically to all downstream systems and processes
    • Backward integration – takes information entered into a given system and sends it automatically to all upstream systems and processes

  • Building a central repository specifically for integrated information