A Data Table is any display of information in tabular form, with rows and/or columns named.  Information stored in a series of logically grouped and integrated data tables in known as a database.  We use AMIGO to define all data tables that are associated to the current-state and future-state systems that are in scope or will be impacted by the scope of our Program(s) and/or Portfolio(s).  The categorical defining and logging of your data tables is tedious but essential in understanding the true nature of your data and the business processes that are truly applicable. Not to mention the security and governance that an organization is culpable for, if not regulated by governing bodies. The AMIGO platform allows for the definition, logging, and association of the tables within legible, usable formatting with governance at the forefront. 

A Data Field is the individual type of data that you want to store in your data table (e.g. column header in your spreadsheet).  Data fields are essential in the comprehension and development of complex systems within an organization. It will give insight into business processes, as well as potential overlap and inefficiencies that might be undetected. The AMIGO platform allows for a detailed environment for this to be logged, categorized, and associated with other variables such as:  

• The type of data (numeric, alphabetic, date, currency, etc.) 
• The field length of the data 
• A definition of the field 

AMIGO’s Data Cleansing Tracker represents the project tracking of current legacy data that cannot be corrected through data migration transformation and subsequently has to be manually corrected in the legacy environment or temporary staging environment.  This project-level module within the AMIGO platform is designed to track the data cleansing efforts to a granular level. Multiple trackers may be created and or used, based on the data cleansing process you wish to track. Defining the stakeholder groups, deliverables, timeline, and more, this toolset gives an auditable path for ensuring proper governance and documentation is accomplished. 

The Data Mapping Register is special functionality that is used in data migration and interface design to help a user document the transformation of data from one system to another.  Without proper mapping, data is just a confusing blip of digital ether. Within the AMIGO platform, this module allows for the detailed mapping for each specific information field that needs to move from one system to another. The essential associations throughout the data journey comprise this useful resource for any enterprise-scale initiative. 

What would mapping be without the rules to coincide or guide and direct? Here within the AMIGO platform, this module allows a user to create logic rules associated with each data mapping register record to instruct a program developer on how to transform field-level data from one system to another;  giving further insight and understanding of what your data truly is and its unrealized potential value. 

Data Migration Execution Statistic is special functionality that allows the user to create statistics for all of the data migration execution activities that took place during a data migration.  From extract and validation, transformation, and validation, the migration of an organization’s data is intrinsically evaluated within this AMIGO platform module. Pass, fail, it is all exceptionally well documented. 

The ability to define a data domain, with description, associate its owner, steward, and publisher is a value proposition many within enterprise digital transformation initiatives have yearned for, and now within the AMIGO platform, that yearning is realized. 

What is acceptable? What is not? Data cleansing and quality is a tricky, tedious, and oft difficult proposition. Set the rules and percentages within this module to ensure that program, project, and even organization-wide, there are standards to data quality. 

What is the business description, definition, number of tables, and other vital aspects tied to an organization’s data;  specifically, that data that drives business value? This module within the AMIGO platform is one source of truth that gives insight and value to your business driven data.