shipping-data-analyst

Shipping data analysis involves loading exports from platforms like ShipStation or FreightClub, mapping columns to standard fields, auditing data quality, and calculating derived metrics such as billable weight and DIM weight. This produces Profile Summary, Weight Distribution, Zone Distribution, and DIM Exposure outputs that rate teams use to build accurate rate cards.

Weight band and zone analysis segments your prospect's shipment volume by weight ranges and geographic zones. The Skill processes address normalization and hub mapping to reveal distribution patterns, exposing which weight tiers and service areas drive costs and volume—critical for rate card design and identifying FirstMile optimization opportunities.

Column mapping and validation ensure weight fields are correctly identified and populated. DIM exposure analysis calculates billable weight by comparing actual weight against dimensional weight, revealing how often dimensional pricing applies—essential context before rate preparation.

Yes. The Skill accepts data exports from ShipStation and FreightClub, performs column mapping to standardize fields, runs data quality audits, and generates analysis sheets for rate team handoff. It handles the complete workflow from raw export to actionable rate-prep insights.

Data quality auditing validates column population, detects missing or malformed addresses for normalization, verifies weight field integrity, and confirms zone assignment accuracy. These checks prevent downstream errors in rate card creation and ensure the Profile Summary and distribution sheets are reliable for pricing decisions.