(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

(C12) Integrating the Organization from End-To-End: Enterprise Resource Planning

Image
Enterprise resource planning  ( ERP ) is business process management software that allows an organization to use a  system  of integrated applications to manage the business and automate many back office functions related to technology, services and human resources. ERP helps employees do their jobs more efficiently by breaking down barriers between business units. More specifically, an ERP solution: Gives a global, real-time view of data that can enable companies to address concerns proactively and drive improvements Improves financial compliance with regulatory standards and reduces risk Automates core business operations such as lead-to-cash, order-to-fulfillment, and procure-to-pay processes  Enhances customer service by providing one source for billing and relationship tracking. 
Read more

(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