MGT 300 CHAPTER 8 : ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

LEARNING OUTCOMES : 

  1. Describe the roles and purposes of data warehouse and data marts in an organization
  2. Compare the multidimensional nature of data warehouses with the two-dimensional nature of databases
  3. Identify the importance of ensuring the cleanliness of information throughout an organization
  4. Explain the relationship between business intelligence and a data warehouse

  • HISTORY of  DATA WAREHOUSING
          - Data warehouses extend the transformation of data into information. In the 1990's executive 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 to gathered from many different operational databases that can supports business analysis activities and decision-making tasks.

        - Extraction transformation, and loading (ETL) : is a process that extract information from external and internal databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse
   
        - Data mart : contains a subset of data warehouse information



Related image


  • MULTIDIMENSIONAL ANALYSIS AND DATA MINING 
       - CUBE : is a common term for the representation of multidimensional information


Image result for Cube in multidimensional analysis and data mining

        -Data mining : is the process of analyzing data to extract information not offered by the raw data alone.
       * Data mining tools: 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

  • INFORMATION CLEANSING or SCRUBBING 
        - Information cleansing and scrubbing is a process that weeds outs and fixes or discards inconsistent, incorrect or incomplete information.
  • Contact information in an operational system

Image result for information cleansing or scrubbing


  • Standardizing Customers name from Operational Systems
Image result for standardizing customer name from operational system


  • Information cleansing activities
Image result for information cleansing activities



  • Accurate and complete information
Image result for accurate and complete information

  • BUSINESS INTELLIGENCE 
       - Business intelligence is information that people use to support their decision making efforts.

  • Principle of BUSINESS INTELLIGENCE enablers include : 
  1. TECHNOLOGY :
        - The largest company today can create enterprisewide BI systems that compute and monitor metrics on virtually every variable important for managing the compony.

      2. PEOPLE :
       
        - Understanding the role of people in BI allows organizations to systematically create insight and turn these insights into actions

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


Image result for thank you



Comments

Post a Comment

Popular posts from this blog

MGT 300 CHAPTER 11 : CUSTOMER RELATIONSHIP MANAGEMENT

Image
LEARNING OUTCOMES : Compare operational and analytical customer relationship management Identify the primary forces driving the explosive growth of the customers relationship management Define the relationship between decision making and analytical customers relationship management Summarize the best practice for implementing a successful customer relationship management system CUSTOMER RELATIONSHIP MANAGEMENT (SCM) -CRM enables a organization to :  *provide better customer service  *make call centers more efficient  *cross sell products more effectively  *simply marketing and sales processes  *discover new customers RECENCY, FREQUENCY, and, MONETARY VALUE -Organization can find their most valuable customers through 'RFM' stand for Recency, Frequency, and Monetary value.    *How recently a customers purchased items (Recency)    *How frequently a customers purchased items (Frequency)    *How much a customer spends on each purchase (Monetary)
Read more

MGT 300 CHAPTER 10 : EXTENDING THE ORGANIZATION SUPPLY CHAIN MANAGEMENT

Image
LEARNING OUTCOMES : List and describe the components of a typical supply chain Define the relationship between decision making and supply chains management  Describe the four changes resulting from advance in IT that are driving supply chains Summarize the best practices for implementing a successful supply chain management system BASICS OF SUPPLY CHAIN -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 -Organizations must embrace technologies that can effectively manage supply chains INFORMATION TECHNOLOGY'S ROLE IN THE SUPPLY CHAIN VISIBILITY  -Supply chain visibility is the ability to view all areas up and down the supply chain. Changing supply chains requires a comprehens
Read more

MGT 300 CHAPTER 6 : VALUING ORGANIZATIONAL INFORMATION

Image
LEARNING OUTCOMES : Describe the broad levels, formats, and granularities of information. Differentiate between transactional and analytical information. List, describe of each the five characteristics of high quality information Impact of low quality information on an organization and the benefits. ORGANIZATIONAL INFORMATION LEVELS, FORMATS, AND GRANULARITIES OF ORGANIZATIONAL INFORMATION. TRANSACTIONAL INFORMATION VERSES ANALYTICAL INFORMATION THE VALUE OF QUALITY INFORMATION - CHARACTERISTIC OF HIGH QUALITY INFORMATION ACCURACY : Measurements is their quality og being true or correct, event in small details. COMPLETENESS : The information must have being complete. For example is the address complete including street, city and state. CONSISTENCY : is aggregate or summary information in agreement with detaile d information. UNIQUENESS : is each information must have their own uniqueness to ensure the customer easy to remember this information. TI
Read more