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