Instant Warehouse: Know Your Source Data

Process your source data directly, and identify problems at the earliest stages
Apply advanced data quality tools and techniques directly to the source data
Pre-test your conversion, mapping and cleansing rules against the source data

Process your source data directly, and identify problems at the earliest stages

Typically a plan of action is developed based on a thorough review of the system documentation. Sadly, this documentation is often incomplete or out of date, and in the worst cases, wrong. This is particularly true for the oldest legacy systems, for which the documentation standards may have been lower, and for which there has been an extended period of time for them to grow out of date.

With agile modeling and Instant Warehouse, you directly access and work with the source data at the very earliest stages. Rather than relying on (possibly incomplete) documentation, you can actually see:

• data transformations that are required
• data quality issues
• actual data contents

Apply advanced data quality tools and techniques directly to the source data

In addition, you can apply modern data quality and profiling tools directly to even the oldest legacy data. This provides you a level of confidence in your results which you could never achieve without access to the data.

Pre-test your conversion, mapping and cleansing rules against the source data

Far too often, conversion, mapping and cleansing rules are implemented that are later discovered to be incomplete or inappropriate. Avoid this problem, and the extensive re-work that often results, by using Instant Warehouse's agile technologies to pre-test and clarify the required conversion, mapping and cleansing rules prior to implementation. By applying agile technologies directly to source data, the resulting conversion, mapping and cleansing rules will be more accurate and thorough, and will be achieved in a fraction of the time, and at a fraction of the cost, it would take using traditional tools.