Trillium Software System Online / Corporate Training

July 3, 2015

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

2.Validating Expected Joins

To validate Expected Joins
To review Expected Join analysis results

3.Entity Relationship Diagram

To view an ERD for a single join
To view ERD for multiple joins
To format ERD

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

Sign In

Trillium Software System Online / Corporate Training

Recommended Posts

iandhrapost

Join the conversation

Tell a friend

Most viewed in last 30 days

Activity