Friday, 22 December 2017

CHAPTER 10: EXTENDING THE ORGANIZATION – SUPPLY CHAIN MANAGEMENT


Supply Chain Management

  • Supply chain are all parties involved directly or indirectly
  •  The average company spends nearly half of every dollar that it earns on production
  • Involves the management of such an exchange of information from one party to the other party
  • Ensure the profit and production increased
  •  In the past, companies focused primarily on manufacturing and quality improvements to influence their supply chains
  • Before this, buy the product with supplies then sell. But now, the transfer of information in the supplier chain.
  • Example : supplier, manufacture, retailer, distributor, and customer



Basic of Supply Chain.

  • The supply chain has three main links :
    • Materials flow from suppliers and their “upstream” suppliers at all levels
    • Transformation of materials into semi finished and finished products through the organization’s own production process
    •  Distribution of products to customers and their “downstream” customers at all levels




  •  plan
    •   to make customer demand
  • source
    • build relationship with the supplier
      • easy to negotiate
      • get discount
      • the price of product is cheapest
      • before sent the product, must pay first
  • make
    • make a product, get the materials, start with manufacturing
  • deliver
    • deliver to customers using fast and safe transportation
  • return
    • If the product are damage, how to solve.



Information Technology’s Role In The Supply Chain




  • Visibility
    • Supply chain visibility
      • The ability to view all areas up and down the supply chain. When we do the SCM system, we can see the visibility
    • Bullwhip effect
      • Occurs when distorted product demand information passes from one entity to the next throughout the supply chain. Example, the sugar. In the shop, we want buy the sugar. When the dealers see the sugar already is out of stock, the dealer call suppliers. When the suppliers also already are out of stock, he continues to call the retailer.


  • Consumer Behavior
    • Companies can respond faster and more effectively to consumer demands through supply chain enhances. Companies also can do forecasting customers behaviors. The SCM can do easy to consumer behavior system.
    • Demand planning software – generates demand forecasts using statistical tools and forecasting techniques


  • Competition
    • Supply chain planning (SCP) software
      • Uses advanced mathematical algorithms to improve the flow and efficiency of the supply chain
    •  Supply chain execution (SCE) software
      • Automates the different steps and stages of the supply chain





  • Implementation
    • Focus on what is happening in the supply chain.
    • Payment involved can know with SCE.


  • Speed
    • three factors fostering speed



Supply Chain Management Success Factors





  •  SCM industry best practices include :
W      Make the sale to suppliers. (easy to suppliers)
W      Wean employees off traditional business practices. (no need to call the suppliers. Direct use the SCM)
W      Ensure the SCM system support the organizational goals. (must parallel)
W      Deploy in incremental phases and measure and communicate success. (with the SCM system, to success, must do progressively)
W      Be future oriented. (use SCM to do forecasting. Anticipated profit increased by using the SCM system)


SCM Success Stories

  • Numerous decision support systems (DSSs) are being built to assist decision makers in the design and operation of integrated supply chains
  • DSSs allow managers to examine performance and relationships over the supply chain and among:
    • Suppliers
    • Manufacturers
    • Distributors
    • Other factors that optimize supply chain performance

Thursday, 21 December 2017

CHAPTER 9 : ENABLING THE ORGANIZATION - DECISION MAKING

Decision making
  • Reason 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 system is an enterprise
Transaction Processing Systems
  • Moving up through the organizational pyramid users move from requiring transaction information to analytically 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. more to save the information
  • Online analytically processing (OLAP) - the manipulation of information to create business intelligence in support of strategic decision making. do the information for decision making. more to analysis
Decision support systems
  • Decision support system (DSS) - models information to support managers and business professionals during the decision-making process
  • Three quantitative models used by DSSs include:
    • sensitivity analysis
    • what-if analysis
    • goal-seeking analysis
Executive Information Systems
  • a specialized DSS that supports senior level executives within the organization
  • most EISs offering the following capabilities :
    • consolidation
    • drill-down
    • slice-and-dice
  • Digital dashboard - integrates information from multiple components and present 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
  • Four most common categories of Al include:
    • expert system
    • neural network
    • genetic algorithm
    • intelligent agent
Data Mining
  • data-mining software includes many forms of AI such neural network and expert systems
  • common forms of data-mining analysis capabilities include:
    • cluster analysis
    • association detection
    • statistical analysis

Tuesday, 19 December 2017

Chapter 8 : Accessing Organizational Information – Data Warehouse

HISTORY OF DATA WAREHOUSING
•          Data warehouses extend the transformation of data into information
•     In the 1990’s executives became less concerned with the day-to-day business operations and more    concerned with overall business functions
•     The data warehouse provided the ability to support decision making without disrupting the day-to-day operations

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 aggregate information throughout an organization into a single repository for decision-making purposes
  •   The primary difference between a database and a data warehouse is that a database stores information for a single application, whereas a data warehouse stores information from multiple databases, or multiple applications, and external information such as industry information           
  • This enables cross-functional analysis, industry analysis, market analysis, etc., all from a single repository
  •  Data warehouses support only analytical processing (OLAP)
  •  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.
  •   The ETL process gathers data from the internal and external databases and passes it to the data warehouse
  •  The ETL process also gathers data from the data warehouse and passes it to the data marts

Data mart – contains a subset of data warehouse information



•          The data warehouse modeled in the above figure compiles information from internal databases or transactional/operational databases and external databases through ETL
•          It then send subsets of information to the data marts through the ETL process

MULTIDIMENSIONAL ANALYSIS AND DATA MINING
•          Databases 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
•          Each layer in a data warehouse or data mart represents information according to an additional dimension

1. The ability to look at information from different dimensions can add tremendous business insigh

2. By slicing-and-dicing the information a business can uncover great unexpected insights

•          Cube – common term for the representation of multidimensional information




•          Users can slice and dice the cube to drill down into the information
•          Cube A represents store information (the layers), product information (the rows), and promotion information (the columns)
•          Cube B represents a slice of information displaying promotion II for all products at all stores
•          Cube C represents a slice of information displaying promotion III for product B at store 2
•          Data mining – the process of analyzing data to extract information not offered by the raw data alone
•          Data mining can begin at a summary information level (coarse granularity) and progress through increasing levels of detail (drilling down), or the reverse (drilling up)
•          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 and infers rules that predict future behavior and guide decision making
Data-mining tools include query tools, reporting tools, multidimensional analysis tools, statistical tools, and intelligent agents

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
•          Contact information in an operational system


Taking a look at customer information highlights why information cleansing and scrubbing is necessary
Customer information exists in several operational systems
In each system all details of this customer information could change form the customer ID to contact information
Determining which contact information is accurate and correct for this customer depends on the business process that is being executed


•          Standardizing Customer name from Operational Systems



•          Information cleansing activities


•          Accurate and complete information


•          Why do you think most businesses cannot achieve 100% accurate and complete information?
•          If they had to choose a percentage for acceptable information what would it be and why?
§  Some companies are willing to go as low as 20% complete just to find business intelligence
§  Few organizations will go below 50% accurate – the information is useless if it is not accurate
•          Achieving perfect information is almost impossible
§  The more complete and accurate an organization wants to get its information, the more it costs
§  The tradeoff between perfect information lies in accuracy verses completeness
§  Accurate information means it is correct, while complete information means there are no blanks
§  Most organizations determine a percentage high enough to make good decisions at a reasonable cost, such as 85% accurate and 65% complete

BUSINESS INTELLIGENCE
BI is information that people use to support their decision-making efforts
Principle BI enablers include:
•          Technology
•          Even the smallest company with BI software can do sophisticated analyses today that were unavailable to the largest organizations a generation ago. The largest companies today can create enterprisewide BI systems that compute and monitor metrics on virtually every variable important for managing the company. How is this possible? The answer is technology—the most significant enabler of business intelligence.
•          People
•          Understanding the role of people in BI allows organizations to systematically create insight and turn these insights into actions. Organizations can improve their decision making by having the right people making the decisions. This usually means a manager who is in the field and close to the customer rather than an analyst rich in data but poor in experience. In recent years “business intelligence for the masses” has been an important trend, and many organizations have made great strides in providing sophisticated yet simple analytical tools and information to a much larger user population than previously possible.
•          Culture
•          A key responsibility of executives is to shape and manage corporate culture. The extent to which the BI attitude flourishes in an organization depends in large part on the organization’s culture. Perhaps the most important step an organization can take to encourage BI is to measure the performance of the organization against a set of key indicators. The actions of publishing what the organization thinks are the most important indicators, measuring these indicators, and analyzing the results to guide improvement display a strong commitment to BI throughout the organization.

Chapter 7: Storing Organizational Information-Databases

RELATIONAL DATABASE FUNDAMENTALS
  • Database maintains information about various types of objects (inventory), events (transaction), people (employees) and place (warehouses).
  • Hierarchical database model is information is organized into tree-like structure that allows repeating information using parent/child relationships in such a way that it cannot have too many relationships
  • Network database model is a flexible way of representing objects and their relationships.
  • Relational database model is a type of database that stores information in the form of logically related two-dimensional tables.

ENTITIES AND ATTRIBUTES
  1.  A entity in the relational database model is a person, place, thing, transaction or event about which information is stored.
  2. Attributes called fields or columns are characteristics or properties of an entity class



KEYS AND RELATIONSHIPS
  • Primary key is a field (group/fields) that uniquely identifies a given entity in a table.
  • Foreign key is a primary key of one table that appears as an attributes in another table and acts to provide a logical relationships between the two tables.

RELATIONAL DATABASE ADVANTAGES
  1. Increased Flexibility
  2.  Increased Scalability and Performance
  3.  Reduced Information Redundancy
  4. Increased Information Integrity (Quality)
  5.  Increased Information Security    
Increased Flexibility
  • Database provide flexibility in allowing each user to access the information in whatever way best suits his or her needs.
  • The distinction between logical and physical views is important in understanding flexible database user views.
Physical views of information deals with the physical storage of information on a storage device such as a hard disk.
Logical views of information focuses on how users logically access information to meet their particular business. 

Increased Scalability and Performance
  • Only a database could 'scale' to handle the massive volumes of information and the large numbers of users required for the successful launch of the Ellis Island website.
Scalability refers to how well a system can adapt to increased demand.
Performance measures how quickly a system performs a certain process or transaction.

Reduced Information Redundancy
  • Redundancy is the duplication of information, or storing the same information in multiple places.
  • Redundant information occurs because organizations frequently capture and store the same information in multiple locations.
  • The primary problem with redundant information is that it is often inconsistent which make it difficult to determine which values are the most current or most accurate.

Increased Information Integrity (Quality)

Information integrity is a measures the quality of information

- Two types of integrity constraints are :
  • Relational integrity constraints- rules that enforce basic and fundamental information-based constraints
  • Business-critical integrity constraints- enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Increased Information Security
  1.  Information is an organizational asset.
  2. Database offer many security features such as
        *  Passwords - provide authentication of the user
        * Access levels - determines who has access to the different types of information                    * Access control - determines types of user access such as customer service                                                        representatives  might read-only access

-Database can increase personal security as well as information security
.
DATABASE MANAGEMENT SYSTEMS
- A database management systems (DBMS) is software through which users and application programs interact with a database.

Data-Driven Websites
- A data-driven website is an interactive website keep constantly updated and relevant to the needs of its costumer through the use of a database.


Data-Driven Website Advantages
  • Development : Allows the website owner to make changes any time
  • Content management : A static website requires a programmer to make updates.
  • Future expandability : Having a data-driven website enables the site to grow faster than would be possible with a static site.
  • Minimizing human error 
  • Cutting production and update costs
  • More efficient
  • Improved stability

INTEGRATING INFORMATION AMONG MULTIPLE DATABASE

- An integration allows separate systems to communicate directly with each other.
- A forward integration takes information entered into a given system and sends it automatically to all downstream processes.
- A backward integration - takes information entered into a given systems and sends it automatically to all upstream systems and processes

Chapter 6 : Valuing Organizational Information

ORGANIZATIONAL INFORMATION
•          Information is everywhere in an organization
•          Employees must be able to obtain and analyze the many different levels, formats, and granularities of organizational information to make decisions
•          Successfully collecting, compiling, sorting, and analyzing information can provide tremendous insight into how an organization is performing

•          Levels, formats, and granularities of organizational information

THE VALUE OF TRANSACTIONAL AND ANALYTICAL INFORMATION

Transactional information – encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks

Analytical information – encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks


THE VALUE OF TIMELY INFORMATION
·         Real-time information – immediate, up-to-date information
·         Real-time system – provides real-time information in response to query requests

THE VALUE OF QUALITY INFORMATION
Business decisions are only as good as the quality of the information used to make the decisions. You never want to find yourself using technology to help you make a bad decision faster

Characteristics of High Quality Information
·         Accuracy Are all the values correct? For example, is the name spelled correctly? Is the dollar amount recorded properly?
·         Completeness Are any of the values missing? For example, is the address complete including street, city, state, and zip code?
·         Consistency Is aggregate or summary information in agreement with detailed information?
·         For example, do all total fields equal the true total of the individual fields?
·         Uniqueness Is each transaction, entity, and event represented only once in the information?
·         For example, are there any duplicate customers?
·         Timeliness Is the information current with respect to the business requirements? For example, is information updated weekly, daily, or hourly?

Example of Low quality information :


Understanding the Costs of Poor Information
The four primary sources of low quality information include:
1.       Online customers intentionally enter inaccurate information to protect their privacy
2.       Information from different systems have different entry standards and formats
3.       Call center operators enter abbreviated or erroneous information by accident or to save time
4.       Third party and external information contains inconsistencies, inaccuracies, and errors

Potential business effects resulting from low quality information include:
·         Inability to accurately track customers
·         Difficulty identifying valuable customers
·         Inability to identify selling opportunities
·         Marketing to nonexistent customers
·         Difficulty tracking revenue due to inaccurate invoices
·         Inability to build strong customer relationships

Understanding the Benefits of Good Information
•          High quality information can significantly improve the chances of making a good decision
•          Good decisions can directly impact an organization's bottom line

Chapter 15 – Outsourcing in the 21st Century Insourcing (in-house-development)  – A common approach using the professional expertise w...