8 IT 5.  DATA MINING AND WAREHOUSING

LAB

The objective of the lab exercises is to use data mining techniques to  use standard databases available to understand

DM processes using  any  DM tool)

1.

Gain insight for running pre- defined decision trees and explore results using MS OLAP Analytics.

2.

Using IBM OLAP Miner – Understand the use of data mining for evaluating the content of

multidimensional cubes.

3.

Using Teradata Warehouse Miner – Create mining models that are executed in SQL.

(

Portal work : The objective of this  lab exercises is to integrate pre-built reports into a portal application )

4.

Publish and analyze a  business intelligence portal.

Metadata & ETL Lab: The objective of this lab exercises is to implement metadata import agents to pull metadata from

leading business intelligence tools and populate a metadata repository. To understand ETL processes

5.

Import metadata from specific business intelligence tools and populate a meta data repository.

6.

Publish metadata stored in the repository.

7.

Load data from heterogeneous sources including text files into a pre-defined warehouse schema.

Case study

1.

Design a data mart from scratch to store the credit history of customers of a bank. Use this credit

profiling to process future loan applications.

2.