Integrated Data Environment and Global Transportation Network Convergence (IGC)

1. Integrated Data Environment and Global Transportation Network Convergence(IGC) AS OF 4 OCT 2011

2. AGENDA • Vision • Background • Interfaces • BI COE • New Requirements • Rapid Development • Education and Training • Summary

3. IGC Vision • Vision: Provide fully integrated data and application services enabling cohesive distribution solutions for DOD • Enables: • Common logistics picture • Distribution visibility • Material asset & ITV • Conveyance visibility • Benefits: • Enhanced delivery of forces • & sustainment • Improved situational • understanding • Near real-time Enterprise • Access to logistics and • transportation data • Improved trust & confidence IDE / GTN Convergence Unity Of Effort • Business Application Tools • Logistics Visibility • Transportation C2 and ITV Services DLA Data Integrated Data Environment PM USTRANSCOM Data IGC PM

4. IGC • DOD ITV System of Record • Single Source of integrated ITV Data • Brings data from multiple systems into a single data warehouse • Customers have ability to review: • Raw data • Data by transport mode • Integrated data

5. IGC • Allows Customers to build operational pictures easier • Use of Business Intelligence tools • Customizable reports and dashboards created for individual access, based on information requirements • Customers have the ability to use standard queries or create customizable queries and dashboards • Instead of a customer accessing 5 (or more) different systems for data, and hand-manipulating the information, they go to one source -- IGC

6. Source System Interfaces • DAAS - Supply Data • DOD/Commercial EDI - 214: air, motor, & rail; 315: • motor, & ocean; 858: Bill of Lading • GDSS & MDSS II - Air schedules, messages and cargo • information • AMS-TAC, GATES, & MDSS II - DOD air cargo and • passenger information • CMOS, GATES, & GFM - DOD motor cargo and • passenger information • IBS, IBS-CSS, MDSS II, & WPS - DOD ocean cargo • and passenger information • COMPASS, CMOS, GATES, & WPS - Unit/cargo • movement data & ATCMD • MTMS and RF TAG - Munitions movement data • RF ITV and IRRIS - Electronic cargo data, i.e. RF tag • DLIS, TRMD, & DAAS - Master/reference data

7. Integrated View - Multiple Sources • Supply/Requisition Data – materiel ordering, processing, • customer inquiries - DAAS. • Commercial Movement Reporting - : air, motor, & rail; • EDI 214, 315, 858. • Conveyance Schedules and Events – Air and Ocean - • GDSS & IC3 – event and location information • DOD Air Cargo and Passenger Information - GATES, • CMOS, MDSS II • DOD Motor Cargo and Passenger information • CMOS, MDSS II, TC AIMS II, GATES, & GFM • Ocean Cargo and Passenger information - IBS, IBS- • CSS, MDSS II, GATES & WPS • Unit Movement Passenger and Cargo Data - • COMPASS, CMOS, GATES, & WPS • Electronic Cargo Location Data - RFITV and IRRIS • Master/Reference data – DLIS & TRMD

8. IGC Interfaces WPS MDSS II GATES GDSS IC3 DAAS COMPASS CEDI GFM EX-GDSS TCAIMS II IBS IGC High Side Broker EX-JDLM DTTS/IRRIS IBS-CSS IGC Low Side Broker CMOS EX-JFAST AMS-TAC MTMS RMDE IGC High Side Enterprise Data Warehouse JOPES SMS IGC Low Side Enterprise Data Warehouse RFITV TRDM TRDM GCSS-J COP MRV TACC Navy LOGCOP AV SMS BCS3-NM CDDOC GCCS-J COP TMAS/BIRDTRACK SMS TRAC2ES JOPES BCS3 BCS3 AV ES-S JFP CBP GDSS GCSS-J COP EFTS AF NWRM PIC DAASC/LMARS AMC FUSION CELL

9. BI COE • Business Intelligence Center of Excellence • Single Face to the Customer • Initial entry point to IGC for: • Training Requests • New Requirements • Business Intelligence Tools: Customized Reports, Dashboards, and Alerts • Works with Customer to Implement required Capability • Customer can be a COCOM, Service, or Agency • Work with client from “Cradle to Grave”

10. New Requirements • Customer completes Requirement Summary Form and submits to BI COE • Develop/negotiate User Requirements Document jointly with BI COE Functional • Customer provides MIPR to IGC PMO • Receives development effort status reports

11. Rapid Development • In-house ability to deliver capabilities quickly • Rapid production! Two weeks or less to develop • Dashboards, Web Services, Reports, Universe Development, Alerts • Already developed dashboards, alerts, and reports for EUCOM, TCJ3, TCJ5/4, NOLSC, NAVSUPSYSCOM, NAVSUP

12. Education and Training • Multiple training delivery methods • Mobile Training Team (hands-on) • Computer Based Training • Defense Connect On-Line (DCO) • BI COE • MTT schedule and instructions for requesting training on IGC front page • Long-term focus maximizing the power of IGC • Level 200 & 300 training projected for FY-12 • IGC Newsletter • Currently published monthly (migrating soon to bi-monthly) • Source of IGC updates, new capabilities, & enterprise issues

13. Education and Training

14. Summary • USTRANSCOM ITV System of Record • Data from multiple system brought into a single data warehouse • Integrates data • Data resident in IGC for 5 years • Business Intelligence tools • Customized Queries and Dashboards

15. Questions? • For more information, please contact the BI COE at: • DSN 576-2591 • Commercial 618-256-2591 • USTCJ6-P-BICOE@USTRANSCOM.MIL • https://www.igc.ustranscom.mil/igc/

16. Dashboard Examples

17. Business Intelligence Dashboards • Provides at a glance data quality monitoring of critical data IGC data feeds • Primary data elements monitored for accuracy, consistency, and validity • User selectable time period allows comparison of current and past performance • Detailed dashboards and reports support root cause analysis Note: The graphics shown do NOT represent operational data. Test data was used to populate these dashboards