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

MGT 300 CHAPTER 9 : ENABLING THE ORGANIZATION DECISION MAKING

Image
LEARNING OUTCOMES : Define the systems organization use to make decisions and gain competitive advantages Describe the three quantitative models typically used by decision supports systems Describe the relationship between digital dashboards and executive information systems List and describe four types of artificial intelligence systems Describe three type of data-mining analysis capabilities DECISION MAKING * Reasons for the growth of decision-making information system People need to analyze large amounts of information People must make decision quickly  People must apply sophisticated analysis techniques, such as modeling and forecasting to make good decisions People must protect the corporate assets of organizational information * Model is 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 inf
Read more