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 13: CREATING COLLABORATIVE PARTNERSHIPS THROUGH E-BUSINESS

    Image
    Creating Collaborative Partnerships Through E-Business E-Business: the internet is a powerful channel that presents new opportunities for an organization to: touch customers enrich products and services with information reduce costs how do e-commerce and e-business differ? e-commerce - the buying and selling of goods and services over the internet e-business - the conducting of business on the internet including, not only buying and selling, but also serving customers and collaborating with business partners E-Business Model: E-business model - an approach to conducting electronic business on the internet Business-to-Business (B2B): Electronic marketplace (e-marketplace) - interactive business communities providing a central market where multiple buyers and sellers can engage in e-business activities Business-to-Consumer (B2C): common B2C e-business models include: e-shop - a version of a retail store where customers ca
    Read more

    chapter 1: Business Driven Technology

    Image
    BUSINESS DRIVEN TECHNOLOGY Learning Outcomes compare management information system (MIS) and information technology (IT) describe the relationship among people, information technology, and information identify four different departments in a typical business and explain how technology helps them to work together compare the four different types of organizational information cultures and decide which culture appilies to your school Information Technology's Role in Business information technology is everywhere in business Information Technology's Impact on Business Operations INFORMATION TECHNOLOGY BASICS information technology (IT): a field concerned with the use of technology in managing and processing information information technology is an important enabler of business success and innovation management information systems (MIS): a general name for the business function and academic discipline covering the applica
    Read more