(C8) Data Warehouse

FUNDAMENTALS OF DATA WAREHOUSE

 Data Warehouse - a logical collection of information gathered from many different operational databases that supports business analysis activities and decision-making tasks

Extraction, transformation, and loading (ETL) - process that extracts information from internal and external databases, transforms the information using a common set of eneterprise definitions and loads the information into a data warehouse

 Data mart - contains a subset of data warehouse information


MULTIDIMENSIONAL ANALYSIS AND DATA MINING

Data Mining - the process of analyzing data to extract information not offered by the raw data alone 



INFORMATION CLEANSING OR SCRUBBING





Comments

Post a Comment

Popular posts from this blog

(C13) Creating Collaborative Partnership Through E-Business

Image
 E-commerce is the buying and selling of goods and services over the Internet. E-commerce refers to online transactions only. E-business is the conducting of business on the Internet, not only buying and selling, but also serving customers and collaborating with business partners. E-shops is a version of a retail store where customers can shop at any hour of the day without leaving their home or office. For example, Zara, Mango, Maybelline and Adidas. E-malls consists of a number of e-shops, it serves as a gateway. For example, Lazada, Trivago and Fashion Valet. An online auction is a place where buyers and sellers come together to auction items and prices are determined dynamically.
Read more

(C9) Streaming Business Operations

Image
Transaction Processing Systems (TPS) - Online Transaction Processing (OLTP) - Online Analytical Processing (OLAP) Decision Support System (DSS) 1. Sensitivity Analysis 2. What-if-Analysis 3. Goal-seeking Analysis Executive Information Systems (EIS) -Consolidation - Drill-down - Slice-and-dice Artificial Intelligence (AI) Categories of AI 1. Expert System 2. Neural Network 3. Generic algorithm 4. Intelligent agent Data Mining  Forms of Data Mining analysis capabilities: - Cluster Analysis Technique of dividing an information set into mutually exclusive groups - Association detection Reveals the degree to which variables are related and the nature and frequency of these relationships in the information - Statistical analysis Performs such functions as information correlations, distributions, calculations and variance analysis
Read more

(C10) Extending the Organization - Supply Chain Management

Image
What is Supply Chain Management (SCM)? Supply chain management (SCM) is the active management of supply chain activities to maximize customer value and achieve a sustainable competitive advantage. It represents a conscious effort by the supply chain firms to develop and run supply chains in the most effective & efficient ways possible. Supply chain activities cover everything from product development, sourcing, production, and logistics, as well as the information systems needed to coordinate these activities. The concept of Supply Chain Management (SCM) is based on two core ideas:  The first is that practically every product that reaches an end user represents the cumulative effort of multiple organizations. These organizations are referred to collectively as the supply chain. The second idea is that while supply chains have existed for a long time, most organizations have only paid attention to what was happening within their “four walls.” Few businesses understo...
Read more