MGT 300 - Chapter 8

CHAPTER 8 - Accessing Organizational Information - Data Warehouse
What is DATA WAREHOUSE ? 

DATA WAREHOUSE FUNDAMENTALS
  
- a logical collection of information
- gathered from many different operational databases
- that supports 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 extracts 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 the information to data mart

 ~ Data mart - contains a subset of data warehouse information

data warehouse model


MULTIDIMENSIONAL ANALYSIS AND DATA MINING

 ~ Relational Database 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


~ Cube - common term for the representation of multidimensional information




~ Once a cube of information is created, users can begin to slice and dice the cube to drill down into the information

~ Users can analyze information in a number of different ways and with number of different dimension

MULTIDIMENSIONAL ANALYSIS AND DATA MINING 

~ Data Mining - a process of analyzing data to extract information to extract information not offered by the raw data alone. Also known as "Knowledge discovery" - computer assisted tools and techniques for sitting through and analyzing vast data stores in order to find trends, patterns, and correlation that can guide decision making and increase understanding

~ To perform data mining users need data-mining tools
  • Data-mining tool - users a variety of techniques to find patterns and relationships in large volumes in information.
  • Eg : retailers can use knowledge of these patterns to improve the placement of items in the layout of a mail-order catalog page or Web page

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

~ Occur during ETL process and second on the information once if is in the data warehouse



contact information in an operational system



Standardizing customer name from operational systems




Information cleansing or scrubbing




Accurate and complete information






BUSINESS INTELLIGENCE

 ~ Business intelligence - refers to applications 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 customer profiling, customer support, market research, market segmentation, product profitability, statistical analysis, and inventory and distribution analysis to name a few

 ~ Eg : Excel, Access



 ❤❤❤

Comments

Post a Comment

Popular posts from this blog

MGT 300 - Chapter 9

Image
Chapter 9 - Enabling the Organization - Decision Making                                                         DECISION MAKING ~ Reasons for the growth of decision - making information systems : People need to analyze large amounts of information People must make decisions quickly People must apply sophisticated analysis techniques, such as modeling                                     and forecasting to make good decisions. People must protect the corporate asset of organizational information    ~  Model  - 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 information to analytical information.                                                                                      ~  Transaction processing syste
Read more

MGT 300 - Chapter 13

Image
Chapter 13 - 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 E-COMMERCE & E-BUSINESS ~ 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 transactions, serving customers and collaborating with business partner)                      E-BUSINESS MODELS        ~ E- Business Model  - An approach to conducting electronic business on the Internet. E - BUSINESS MODELS BUSINESS-TO-BUSINESS (B2B) ~ Electronic marketplace (e-marketplace) - Interactive business communities providing a                  central market where multiple
Read more

MGT 300 - Chapter 4

Image
CHAPTER 4 - Measuring The Success of Strategic Initiative MEASURING INFORMATION TECHNOLOGY'S SUCCESS Key performance indicator - measures that are tied to business drivers Metric - detailed measured that feed KPIs EFFICIENCY AND EFFECTIVENESS Efficiency IT Metric - measures the performance of the IT system itself including throughput, speed, and availability Effectiveness IT Metric - measures the impact IT has on business processes and activities including customer satisfaction, conversion rates, and sell-through increases BENCHMARKING - BASE LINING METRICS   ~ Benchmarking - a process of continuously measuring system system results, comparing those    results to optimal system performance (benchmark values), and identifying steps and procedures    to improve system performance E-government benchmarks EFFICIENCY IT METRICS ~ Efficiency IT metrics focus on technology and include :  Throughput - The amount of information that
Read more