Armstrong Transport Group
Logistics provider reduced data consolidation time by 98% and empowered 300+ employees with self-service analytics.
ビジネス目標
Armstrong Transport Group, a major non-asset-based logistics provider with a nationwide agent network, needed to modernize how it managed and accessed data within its proprietary TMS. To stay competitive, Armstrong aimed to automate manual data processes, expand data access beyond finance to teams like marketing, and reduce the data team’s workload by streamlining extraction and consolidation. The company also sought a scalable, automated data infrastructure to support faster, data-driven decision-making across the organization.
連携における課題
Armstrong’s Power Automate and Power BI setup created major inefficiencies. Senior analysts spent 1,500 hours annually manually extracting and consolidating Sage ERP data for month-end close. Data access was limited to finance, leaving other teams without insights. Integrating key sources like DAT’s freight marketplace was difficult due to outdated technology and missing connectors. Marketing teams also lacked campaign ROI visibility across Facebook, LinkedIn, Google, and Instagram because complex API integrations kept data siloed.
Boomiによる解決
After evaluating six vendors against 94 requirements, Armstrong selected Boomi Data Integration. Boomi enabled connections to 37+ data sources within minutes, including niche freight apps, using serverless Python and pre-built kits. The team migrated its warehouse by moving SQL Server application data into Snowflake via CDC and SQL queries. Intuitive pipelines allowed fast rebuilding without heavy coding, accelerating deployment and reducing reliance on senior analysts while streamlining ingestion from all key platforms.
成果
Boomi modernized Armstrong’s data architecture, enabling rapid integration and data access across the business. Data extraction cycles dropped from 10 hours to 8 minutes, saving 1,500 analyst hours annually. Data democratization expanded from finance to over 300 users through Sigma. Marketing gained full campaign ROI visibility across major platforms using Boomi’s pre-built kits, eliminating months of manual integration and empowering faster, more informed decision-making organization-wide.
