InfoSphere Warehouse Components

Code: BI23
Duration: 5 days

Description:

This course is designed to give the student new in-depth knowledge of the components of InfoSphere Warehouse. The major focus will be on the SQL Warehouse Tool, InfoSphere Intelligent Miner, Cubing Services, and their common interface, the Design Studio. DB2 Workload Manager and the Database Partitioning Feature will be covered at a higher level. Exercises will mostly focus on the SQL Warehousing Tool, InfoSphere Intelligent Miner, and Cubing Services. However, IBM Alphablox will be used to access DB2 data stored in a star schema via Cubing Services.

Outcomes:

After completing this course, you should be able to:

• Describe the components of InfoSphere Edition
• Use the Design Studio to physically model tables that will be used as sources and targets for the SQL Warehouse Tool
• Use the Design Studio to create Data Flows in order to move data within DB2
• Combine Data Flows into Control Flows and deploy the Control Flows into the SQL Warehouse Tool runtime environment
• Describe the different data mining algorithms supported by InfoSphere Intelligent Miner
• Create Mining Flows that will create data mining models and score those models against new data
• Use Intelligent Miner Visualizers to view data mining results
• Use Cubing Services to create MQTs to enhance some OLAP tools’ performance
• Extract data from an unstructured text field in order to enhance a data mining run
• Use a MiningBlox to invoke a data mining run via an IBM AlphaBlox application

Audience:

Most intended for those who will be administering one or more of the components that come with InfoSphere Warehouse.

Prerequisites:

Familiarity with DB2.

Format:

Classroom and hands on lab exercises.