Trillium Software System Online / Corporate Training

[postsandhra]

Day1 Content: Prepare Data Load

1.Preapare Data load

• Examine TSS Features
• To Login to TSS

2.Create an Entity from a Delimited Source

• To start Create Entity wizard &describe source
• To add a column during Entity creation
• To remove a column during Entity creation
• To specify which rows to load
• To monitor Entity creation progress

3.Verify Entity creation

• To show a summary of Entity metadata
• To view all rows for an Entity
• To show a summary of Attribute metadata
• To find the shortest/longest Attribute length
• To view values matching the shortest/longest Attribute length
• To view metadata for all Attributes in an Entity

4.Organize your workspace-Discovery Project

• To Create a Discovery project
• To examine a Discovery project

5.Create another Entity from a Delimited Source

• To start Create Entity wizard&Describe source
• To filter data at load time

6.Loading Data from an ODBC sources

• To start Create Entity wizard& Describe source
• To rename an Entity
• To delete an Entity from Met abase

7.Loading Data from flat file sources

Day2 Content: Investigate Data content

1.Examine TSS Feature

2.Value Ranges-Minimum/Maximum values

• To find Minimum/Maximum values
• To find how often the Min/Max values
• To view rows containing the Min/Max values

3.Document Findings

• Bookmarks:Private and Public Bookmarks
• To create a Public Book marks
• To view Public Book marks
• Notes:To add notes to an Attribute,To view a list of all notes for a single Attribute

4.Examine Data types

• To examine data types of an Attributes

5.Examine Nulls

• To view number of nulls in an Attribute
• To view rows in an Entity that contains nulls
• To generate a list of Attributes that  contains nulls
• To view a list of Notes for all Objects in Metabase

6.Misspellings and Data Entry Issues: Soundex,Metaphones

• To list Soundexes for an Attribute
• To examine suspicious Soundexes
• To list Metaphones for an Attribute
• To examine suspicious Metaphones

7.Format Deviations:Masks,Patterns

To list  Masks for an Attribute

• To examine suspicious Masks
• To list Patterns for an Attribute
• To examine suspicious Patterns

8.Numerical Statistics for an Attribute

• To find the average or sum of an Attribute

9.Examine Value Sets and Duplicates Values

• To list a set of values for an attribute
• To examine potential data duplication

Day3 Content: Define Standards&Recode Values

1.Define Standards&Recode values

• Analyze Phrases to Help Standardize Values
• To perform Phrase Analysis on Attribute

2.Recode values

• To recode values

3.Generate a Recode  Value look up Table

• To generate a recode value look up table

Day4 Content: Investigate Relationships-Keys &Dependencies

1.Keys

• To review Potential Keys(found during import)
• To save a Discovered Key
• To validate expected Keys
• To identify duplicate values within a Key
• 2.Dependencies
• To review potential Dependencies (found during data load)
• To resolve Dependency conflicts
• To list corrections made to Dependency conflicts
• To validate expected Dependencies

Day5 Content: Investigate Relationships -Joins

1.Finding Potential Joins

• To find  Potential Joins
• To review Join analysis results

Contact US: 201-905-1656/201-210-8616