1 / 11

BUSINESS DRIVEN TECHNOLOGY Data Warehouses, OLAP and Data Mining

BUSINESS DRIVEN TECHNOLOGY Data Warehouses, OLAP and Data Mining. 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

clifton
Download Presentation

BUSINESS DRIVEN TECHNOLOGY Data Warehouses, OLAP and Data Mining

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BUSINESS DRIVEN TECHNOLOGY Data Warehouses, OLAP and Data Mining

  2. 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

  3. DATA WAREHOUSE FUNDAMENTALS • 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

  4. Data Warehouses What Is a Data Warehouse?

  5. DATA WAREHOUSE FUNDAMENTALS • Data Warehouse Model

  6. MULTIDIMENSIONAL ANALYSIS AND DATA MINING • Databases 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

  7. MULTIDIMENSIONAL ANALYSIS AND DATA MINING • Cube – common term for the representation of multidimensional information

  8. Data Warehouses and Data MiningData Marts – Smaller Data Warehouses • Data mart - a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

  9. MULTIDIMENSIONAL ANALYSIS AND DATA MINING • Data mining – the process of analyzing data to extract information not offered by the raw data alone • To perform data mining users need data-mining tools • Data-mining tools – use a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making • Include query tools, reporting tools, multidimensional analysis tools, statistical tools, and intelligent agents

  10. OLAP & Data Mining Tools

  11. Data Mining Applications

More Related