Jump to content

Trillium Software System Online / Corporate Training


andhara_it

Recommended Posts

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

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...