Tuesday 14 November 2017

CHAPTER 9 : ENABLING THE ORGANIZATION – DECISION MAKING



Reasons for the growth of decision-making information systems;

People need to analyze large amounts of information


People must make decisions quickly


People must apply sophisticated analysis 
techniques, such as modeling and forecasting, to make good decisions

People must protect the corporate asset of 
organizational information


Model

↪ a simplified representation or abstraction of reality
↪ IT systems in an enterprise







TRANSACTION PROCESSING SYSTEMS 

Moving up through the organizational pyramid users move from requiring transactional information to analytical information.





Transaction processing system - the basic business system that serves the operational level (analysts) in an organization


Online transaction processing (OLTP)
the capturing of transaction and event information using technology to;

(1) process the information according to defined business
rules
(2) store the information 
(3) update existing information to reflect the new information


Online analytical processing (OLAP) – the manipulation of information to create business intelligence in support of strategic decision making






Decision Support Systems
Models information to support managers and business professionals during the decision-making process


THREE QUANTITAVE MODELS USED BY DSSs INCLUDE;

1.Sensitivity analysis – the study of the impact that changes in one (or more) parts of the model have on other parts of the model. Eg: What will happen to the supply chain if a tsunami in Sabah reduces holding inventory from 30% to 10%?


2.What-if analysis – checks the impact of a change in an assumption on the proposed solution. 
Eg: Repeatedly changing revenue in small increments to determine it effects on other variables.


3.Goal-seeking analysis – finds the inputs necessary to achieve a goal such as a desired level of output. 
Eg:Determine how many customers must purchase a new product to increase gross profits to $5 million.




Executive Information Systems
A specialized DSS that supports senior level executives within the organization


MOST EISs OFFERING THE FOLLOWING CAPABILITIES;


Consolidationinvolves the aggregation of information and features simple roll-ups to complex groupings of interrelated information. Eg:
Data for different sales representatives can be rolled up to an office level. Then state level, then a regional sales level.


Drill-down enables users to get details, and details of details, of information. 
Eg:
From regional sales data then drill down to each sales representatives at each office.


Slice-and-dice looks at information from different
perspectives.
Eg: 
One slice of information could display all product sales during a given promotion, another slice could display a single product’s sales for all promotions.

Digital dashboard – integrates information from multiple components and presents it in a unified display









Artificial Intelligence (AI)

Intelligent system
various commercial applications of artificial intelligence

Artificial intelligence (AI)
↪simulates human intelligence such as the ability to reason and learn

↪Advantages: can check info on competitor

↪The ultimate goal of AI is the ability to build a
system that can mimic human intelligence




FOUR MOST COMMON CATEGORIES OF AI INCLUDE;


1.Expert system – computerized advisory programs that imitate the reasoning processes of experts in solving difficult problems.
Eg:
Playing Chess.

2.Neural Network – attempts to emulate the way the human brain works. 
Eg: Finance industry uses neural network to review loan applications and create patterns or profiles of applications that fall into two categories – approved or denied.


Fuzzy logic – a mathematical method of handling imprecise or subjective information.
Eg:
Washing machines that determine by themselves how much water to use or how long to wash.


Genetic algorithm – an artificial intelligent system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem.
Eg:
Business executives use genetic algorithm to
help them decide which combination of projects
a firm should invest.

Intelligent agent – special-purposed knowledge-based information system that accomplishes specific tasks on behalf of its users


↪Multi-agent systems

↪Agent-based modeling

Eg:
Shopping bot: Software that will search several
retailer’s websites and provide a comparison of
each retailers’s offering including prive and
availability.


Data-mining software includes many forms of AI such as neural networks and expert systems






Common forms of data-mining analysis
capabilities include:

↪Cluster analysis

↪Association detection

↪Statistical analysis


Cluster analysis – a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible

↪CRM systems depend on cluster analysis to segment customer information and identify behavioral traits
Eg:
Consumer goods by content, brand loyalty or similarity


Association detection – reveals the degree to which variables are related and the nature and frequency of these relationships in the information


Market basket analysis – analyzes such items as Web sites and checkout scanner information to detect customers’ buying
behavior and predict future behavior by identifying affinities among customers’ choices of products and services
Eg: 
Maytag uses association detection to ensure that each generation of appliances is better than the previous generation.



Statistical analysis – performs such functions as information correlations, distributions, calculations, and variance analysis


Forecast – predictions made on the basis of time-series information


Time-series information – time-stamped information collected at a particular frequency
Eg: 
Kraft uses statistical analysis to assure consistent flavor, color, aroma, texture, and appearance for all of its lines of foods



Monday 13 November 2017

CHAPTER 8 : ACCESSING ORGANIZATIONAL INFORMATION - DATA


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 warehousea 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.

Extraction, transformation, and loading (ETL)
A process that extracts information from internal and external
databases, transforms the information using a common set
of enterprise definitions, and loads the information into a
data warehouse.


Data warehouse then send subsets of the information to data mart.
Data mart – contains a subset of data warehouse information







Data Warehouse Model





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 analyze information in a number of different ways and with number of different dimensions.


Data mining – the process of analyzing 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 analyzing
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.

 Eg: retailers can use knowledge of these patterns to improve the placement of items in the layout of a mail-order catalog 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 – 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


Monday 6 November 2017


CHAPTER 7 : STORING ORGANIZATIONAL INFORMATION


INFORMATION is is stored in databases.

DATA is maintains information about
various types of;
↪ objects (inventory) 
↪ events(transactions)
↪ people (employees)
↪ 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
EX: 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
EX: attributes for CUSTOMER include Customer ID,
Customer Name, Contact Name

Primary keys and foreign keys identify the

various entity classes (tables) in the database

Primary key – a field (or group of fields) that uniquely
identifies a given entity in a table


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



Potential relational database for Coca-Cola



Database advantages from a business
perspective include;

↪Increased flexibility

↪Increased scalability and performance

↪Reduced information redundancy

↪Increased information integrity (quality)

↪Increased information security


A well-designed database should:

↪Handle changes quickly and easily

↪Provide users with different views

↪Have only one physical view
Physical view – deals with the physical storage of information on a storage device


↪Have multiple logical views
Logical view – focuses on how users logically

access information

A database must scale to meet increased
demand, while maintaining acceptable

performance levels

Scalability – refers to how well a system can adapt to
increased demands

Performance – measures how quickly a system

performs a certain process or transaction


Databases 
↪reduce information redundancy

Redundancy – the duplication of information or

storing the same information in multiple places


Inconsistency 
↪one of the primary problems with redundant information

Information integrity – measures the quality of
information

Integrity constraint – rules that help ensure the
quality of information

↪Relational integrity constraint
↪Business-critical integrity constraint

Information is an organizational asset and must be
protected



Databases offer several security features including:


↪Password – provides authentication of the user
↪Access level – determines who has access to the different types
of information
↪Access control – determines types of user access, such as

read-only access

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 Business Advantages
Development;

↪Content Management

↪Future Expandability

↪Minimizing Human Error

↪Cutting Production and Update Costs

↪More Efficient

↪Improved Stability





BI in a data-driven Web site



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






Forward Integration






Backward Integration












Building a central repository specifically for

integrated information