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

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 organization processes and be
Read more

MGT 300 - CHAPTER 13

Image
                                              E- Business Ø   The internet is a powerful channel that presents new opportunities for an organization to : *Touch customer *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 (online transactions) *E-business – the conducting of business on the Internet including, not only buying and selling, but also serving customers and collaborating with business partners (online transaction, serving customers and collaborating with business partner )   Ø   Electronic marketplace (e-marketplace) *Electronic marketplaces, or e-marketplaces, present structures for conducting commercial exchange, consolidating supply chains, and creating new sales channels *Their primary goal is to increase market efficiency by tightening and automating the relationship between buyers and sellers
Read more

MGT300 CHAPTER 3

Image
CHAPTER 3 : STRATEGIC INITIATIVES FOR IMPLEMENTING COMPETITIVE            ADVANTAGES.   Strategic Intiatives    Organizations can undertake high-profile strategic intiative including :          -Supply chain management (SCM)          - Customer relationship management (CRM)          - Business process reengineering (BPR)          - Enterprise resource planning (ERP)     Supply Chain Management (SCM)           - Supply Chain Management (SCM) : involves the management of information flows between and among stages in a supply chain to maximize total supply chain effectiveness and profitability.            -Four basic component of supply chain management include : supply chain strategy - strategy for managing all resources to meet customer demand supply change partner - partner throughout the supply chain that deliver finished products, raw material and services supply chain operation - schedule for production activitities supply chain logis
Read more