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
8. 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.
9. Design and build a Data Warehouse using bottom up approach titled 'Citizen Information System'.