Ready Access to Your Shipping and Transportation Carrier Data
Preserving and actually getting data from your system is perhaps the primary obstacle to having valuable decision-support information. Often, history is not stored consistently or is not stored at all; data and field definitions are often murky at best. The IT time and programming costs associated with pulling together correct data, to be able generate just a few simple reports, can be very high (up to person-weeks or person-months and many thousands of dollars!).
Varsity's TransData datamart economically overcomes these problems and provides open, easy access to rich, organized and well-defined historical data--all without costly programming.
- TransData maintains daily history for nearly 100 crucial data fields, most representing significant shipping and transportation performance parameters (see PDF Download on right).
- Data is automatically extracted nightly from transaction files on the IBM i and is processed and then stored in the TransData database files (also residing on the reliable, secure IBM i)
- Historical data preserved in TransData can be accessed using the TransData file/field layout (data dictionary) and a range of different tools as preferred within your organization. These include: iSeries Query®, DB2 Web Query®,
Microsoft Access®, NGS-IQ®—virtually any tool capable of
ODBC/JDBC access).
TransData enables access to detailed historical data that was not available before. With such access, queries can be written against the data (using your preferred query tool)and the extracted data can be processed into decision-support information using your own preferred analysis/reporting tools (Excel®, Crystal Reports®, Cognos®, NGS-IQ® etc.). Alternatively, ShipView Plus (the analytic tool-set designed specifically for use with TransData) provides a complete shipping and transportation analytics package (including pre-written queries, dashboards, and analytic views).
|