Objectives
Audience and Prerequisite

8:30 Module 1 : Overview

• HP ZLE Solutions Initiative
• Importance of Data Mining Technology
• Role of DMSK : Integrated Workbench of HP/Genus Data Mining Tools
• Data Preparation Tool

9:00 Module 2 : Architectural Framework
Details

• Diagram : 2-Tiered Data Preparation Tool Architecture
• Client Workstation: Client Workstation running data preparation client built using VB
• Himalaya NonStop SQL/MX/MP Data Store

9:15 Module 3 : Design Considerations

• Easy to use GUI
• based on the MicroStrategy (MSI) Business Intelligence toolset, leverages GUI, logical data model support, SQL generation, etc.
• uses NonStop SQL/MX/MP DBMS, leverages sampling, TRANSPOSE, statistical functions, …
• custom tool developed by Genus using MSI SDK for NonStop SQL operations and functionality not supported by MSI tools
  

9:30 Module 4 : Interface
Logon

• SQL/MP Logon
• SQL/MX Logon
• MicroStrategy Project Logon

Logon Requirements

• NSK Logon Id
• ODBC Data Source Name

10:00 Break

10:15 Module 5 : Table Information

• How to Access
• Screen Details
• Column Information
• Constraint Information
• Partition Information
• Exporting Table Specifications

10:45 Module 6 : View Information

• How to Access
• Screen Details
• Column Information
• Exporting View Specifications

11:00 Module 7 : Create Table

• How to Access
• Screen Details
• Column Information
• Importing from MicroStrategy Datamart Report
• Key Information
• Partition Information
• Reduce Partitioning
• Script Text
• Create Like Existing Table
• Import from Saved Table Specifications

11:30 Module 8 : Create View

• How to Access
• Screen Details
• Column Information
• Script Text
• Create Like Existing View
• Import from Saved View Specifications

12:00 Lunch

1:00 Module 9 : Subset Creation

• How to Access
• Step 1 (Identify Source)
• Step 2 (Subset Query Details)
• Step 3 (Subset Target Details 1)
• Step 4 (Subset Target Details 2)
• Step 5 (Review)
• Step 6 (Execute)

1:30 Module 10 : Generate Table Overview Data

• How to Access
• Screen Details

1:45 Module 11 : Table Overview Report

• How to Access
• Screen Details
  

2:00 Break
2:15 Lab/Hands On
4:00 Recap/Q & A
5:00 Conclusion