CHAPTER 8 : ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

HISTORY OF DATA WAREHOUSING
·               Data warehouses extend the transformation of data into information
·               In the 1990’s executives became less concerned with the day-to-day business operations and more concerned with overall business functions
·               The data warehouse provided the ability to support decision making without disrupting the day-to-day operations

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, transformation, 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
·              

MULTIDIMENSIONAL ANALYSIS AND DATA MINING
Databases contain information in a series of two-dimensional tables
In a data warehouse and data mart, information is multi-dimensional; it contains layers of columns and rows
·               Dimension – a particular attribute of information
·              
·               Cube – common term for the representation of multidimensional information
·              
·               Data mining – the process of analysing 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 behaviour 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
·         Contact  information  in an operational system

·         Standardizing Customer name from Operational Systems
 
·         Information cleansing activities
 
·         Accurate and complete information

 

BUSINESS INTELLIGENCE
-         Refers to applications and technologies that are used to gather, provide access, analize 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
Example: Excel, Access
- Principle BI enablers include:
·         Technology
·         People

·         Culture

Comments

Post a Comment

Popular posts from this blog

CHAPTER 14 : CREATING COLLABORATION PARTNERSHIP

Image
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 Information partnerships with other organizations ·          Organizations from alliance 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 no
Read more

CHAPTER 5 : ORGANIZATIONAL STRUCTURES THAT SUPPORT STRATEGIC INITIATIVES

Organizational Structures ·          Organizational employees must work closely together to develop strategic initiatives that create competitive advantages. IT Roles and Responsibilities Recent IT-related strategic positions: 1.      Chief information officer (cio) -           Oversees all uses of IT and ensures the strategic alignment of IT with business goals and objectives. 2.      Chief technology officer (cto) -           Responsible for ensuring the throughput, speed, accuracy, availability, and reliability of IT. 3.      Chief security officer (cso) -           Responsible for ensuring the security of IT systems. 4.      Chief privacy  officer (cpo) -           Responsible for ensuring the ethical and legal use of information. 5.      Chief knowledge officer (cko) -           Responsible for collecting, maintaining, and disturbing the organization’s knowledge. The Gap Between Business Personnel and IT Personnel ·          Business personnel po
Read more

CHAPTER 9 : ENABLING THE ORGANIZATION – DECISION MAKING

Image
DECISION MAKING ·          Reasons for the growth of decision-making information systems ·          ·          Model – a simplified representation or abstraction of reality ·          IT systems in an enterprise ·            TRANSACTION PROCESSING SYSTEM (TPS) ·          Moving up through the organizational pyramid users move from  requiring transactional information to analytical information ·          Transaction processing system - the basic business system that serves the operational level (analysts) in an organization ·          Online transaction processing (OLTP) – the capturing of transaction and event information using technology to (1) process the information according to defined business rules, (2) store the information, (3) update existing information to reflect the new information ·          Online analytical processing (OLAP) – the manipulation of information to create business intelligence in support of strategic decision making DE
Read more