Summary
Xentity Corporation supported the Bureau of Transportation Statistics (BTS) under federal task orders focused on transportation data management, freight analysis, statistical reporting, and public-facing data products. Support included the Port Performance Freight Statistics Annual Report (PPFSAR), Online Port Profiles, and Port Activity Dashboards. All of which was used to communicate nationally consistent measures of port capacity, throughput, and freight system performance.
Xentity assisted BTS in collecting, managing, validating, analyzing, and presenting transportation data for use by Congress, federal decision-makers, industry stakeholders, researchers, and the public. The work supported BTS’s statutory reporting responsibilities under 49 U.S.C. §6314. It also contributed to the development of annual transportation statistics products and supporting online data resources.
Problem and Solution
BTS required support to manage complex transportation datasets and produce accurate, accessible, publication-ready reporting products. The Port Performance Freight Statistics Annual Report required rigorous data validation, statistical analysis, narrative development, editorial review, visualization updates, accessibility compliance, and publication support. Because the report is delivered to Congress and other senior federal stakeholders, maintaining data quality, consistency, and accuracy throughout multiple review cycles was critical.
To address these needs, Xentity provided a multidisciplinary team with expertise in transportation analysis, freight statistics, data science, reporting, visualization, quality assurance, and project management. The team supported the development of transportation data products by building and maintaining ETL workflows. They used Python, SQL, JavaScript, Docker, and related technologies to process transportation datasets, manage metadata, and support Socrata-based reporting platforms.
Xentity analyzed transportation and freight data associated with port activity, cargo throughput, freight movement, and related transportation system performance measures. The team developed and updated statistical tables, figures, graphics, metadata, and supporting documentation. All of which are used in both print and online reporting products. Xentity also authored and edited narrative content, statistical interpretations, technical appendices, and supporting documentation required for publication-ready reports.
The team managed production schedules, stakeholder review cycles, version control, and milestone-based deliverables to support timely publication. Quality control activities included fact-checking, editorial reviews, structured document reviews, version tracking, and validation of statistical calculations and source data.
Xentity also supported Section 508 accessibility compliance by reviewing document structure, alternative text, tables, figures, graphics, and publication layouts. This ensured federal accessibility requirements were met for both print and online products.
Outcome and Benefits
Xentity supported the successful delivery of publication-ready reports, dashboard updates, visualizations, statistical analyses, and transportation data products for BTS freight and port performance programs.
The work improved the quality, accessibility, and usability of BTS transportation reporting products. It does this by strengthening data processing, metadata management, statistical validation, editorial quality, and publication workflows. Through transportation data analysis, visualization development, and reporting support, Xentity helped BTS communicate complex freight and port performance information in a clear, consistent, and actionable manner.
The project supported BTS’s annual reporting responsibilities to Congress by providing accurate, timely, and accessible transportation statistics, analyses, and visualizations. These efforts enhanced the value of BTS data products for policymakers, transportation stakeholders, researchers, and the public. They do this while improving the findability, accessibility, interoperability, and reusability of transportation information over time.