CHAPTER 8: ACCESSING ORGANIZATIONAL INFORMATION-DATA WAREHOUSE

Accessing Organizational Information-Data Warehouse

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.
  • Extraction, information, 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 mart - contains a subset of data warehouse information. 
Image result for data warehouse fundamentals

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
Image result for multidimensional data analysis and data mining

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

Image result for information cleansing or scrubbing


Image result for information cleansing or scrubbing


Image result for information cleansing or scrubbing


Image result for information cleansing or scrubbing


Business Intelligence:
  • Business Intelligence - information that people use to support their decision-making efforts.
  • principle BI enablers include:
    • technology
    • people
    • culture



10 NOVEMBER 2017
FRIDAY















    Comments

    Post a Comment

    Popular posts from this blog

    CHAPTER 14: CREATING COLLABORATIVE PARTNERSHIPS

    Image
    Creating Collaborative Partnerships Teams, Partnerships, and Alliances: organizations create and use teams, partnerships, and alliances to: undertake new initiatives address both minor and major problems capitalize on significant opportunities organizations create teams, partnerships, and alliances both internally with employees and externally with other organizations collaboration system -   supports the work of teams by facilitating the sharing and flow of information. organizations from alliances and partnerships with other organizations based on their core competency core competency - an organization's key strength, a business function that it does better than any of its competitors  core competency strategy - organization chooses to focus specifically on its core competency and forms partnerships with other organizations to handle nonstrategic business processes information technology can make a business partnership easier to establish and manage inform
    Read more

    CHAPTER 10: EXTENDING THE ORGANIZATION-SUPPLY CHAIN MANAGEMENT

    Image
    Extending The Organization-Supply Chain Management Supply Chain Management: the average company spends nearly half of every dollar that if it earns on production. in the past, companies focused primarily on manufacturing and quality improvements to influence their supply chains. Basic of Supply Chain: the supply chain has three main links: material 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: it's primary role is to create integrations or tight process and information linkages between functions within a firm factors driving SCM Visibility: supply ch
    Read more

    CHAPTER 12: INTEGRATING THE ORGANIZATION FROM END TO END-ENTERPRISE RESOURCE PLANNING

    Image
    Chapter 12:  Integrating The Organization From End To End-Enterprise Resources Planning Enterprise Resource Planning (ERP): at the heart of all ERP systems is a database, when a user enters or updates information in one module, it is immediately and automatically updated throughout the entire system  ERP systems automate business processes Bringing the organization together: ERP - the organization before ERP ERP - bringing the organization together Integrating SCM, CRM, and ERP: SCM, CRM, and ERP are the backbone of e-business. integration of these applications is the key to success for many companies. integration allows the unlocking of information to make it available to any user, anywhere, anytime. Integration Tools: many companies purchase modules from an ERP vendor, an SCM vendor, and a CRM vendor, and must integrate the different modules together middleware - several different types of software which sit in the middle of and pr
    Read more