MGT300-CHAPTER 8

                 
                ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE 

 History of Data Warehousing

  • In the 1990's executives became less concerned with the day-to-day business operatios and with more concerned with overall business functions.
  • The data warehouse provided the ability to support decision making without disrupting the day-to-day operations because :
          - Operational information is mainly current -does not include the history for better decision making
          - Issue of quality information
          - Without information history, it is difficult to say how and why things change over time

Data Warehouse Fundamentals

  • Data Warehouse - a logical collection of information - gathered from many different operational databases - that support business analysis activities and decision-making tasks
  • The primary purpose of data warehouse is to combined information throughout an organization into a single repository for decision-making purposes - data warehouse support only analytical processing
Data Warehouse Model
  • Extraction, transformation and loading (ETL) - A process that extract information from internal and external databases, transform the information using a common set of enterprise definitions, and loads the information into a data warehouse
  • Data warehouse then send subsets of information to data mart
  • Data mart - contains a subsets of data warehouse information




  • Once a cube of information is created, users can begin to slice and dice the cube to drill down the information
  • Users can analyze information in a number of different ways and with number of different dimensions
  • Data mining - the process of analyzing data to extract information not offered by the raw data alone. also known as "knowledge discovery" - compute assisted tools and techniques for sitting through and analyzing vast data stores in order to find trends, patterns and correlations that can guide decision making and increase understanding.
  • To perform data mining users need data-mining tools
          - Data-mining tool - uses a variety of techniques to find pattern and relationship in large volume of information. eg, retailers can use knowledge of these pattern to improve the placement of items in the layout of a mail-order catalog page or webpage.

Business Intelligence
  • Refer to application and technologies that are used to gather, provide access, analyze data and information to support decision making effort
  • These systems will illustrate business intelligence in the areas of customers profiling, customers support, market research, market segmentation, product profitability,satistical analysis, and inventory and distribution analysis to name a few
  • Eg, excel,access
Information Cleansing and Scrubbing
  • An organization must maintain high-quality data in the data warehouse 
  • Information cleansing and scrubbing - a process that weeds out and fixes or discards inconsistent, incorrect or incomplete information
  • Occur during ETL process and second on the information once it is in the data warehouse




Comments

Post a Comment

Popular posts from this blog

MGT300 - CHAPTER 15

Image
                              Outsourcing in the 21 st Century Outsourcing Projects Ø   Insourcing (in-house development) – a common approach using the professional expertise within an organization to develop and maintain the organization’s information technology system Ø   Outsourcing – an arrangement by which one organization provides a service or services for another organization that choose not to perform them-in-house Ø   Factors driving outsourcing growth include : * Core competencies – many companies have recently begun to consider outsourcing as a means to fuel revenue growth rather just a cost-cutting measure * Financial saving – it is typically cheaper to hire workers in China and India than similar workers in the United States * Rapid growth – an organization is able to acquire best-p...
Read more

MGT 300 - CHAPTER 12

Image
Integrating the organization from end-to-end – Enterprise Resource Planning (ERP) Ø   Integrating SCM, CRM and ERP *SCM,CRM and ERP are the backbone of e-business *Integration of this 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 ,and a CRM  vendor and must integrate the different modules together - Middleware : several different types of software which sits in the middle of and provide connectivity between two or more software applications - Enterprise application integration (EAI ) : packages together commonly used functionality which reduced the time necessarily to develop solutions that integrate applications from multiples vendors Ø   ERP  system must integrate various ...
Read more