A logistics analyst is the person who turns messy shipment, inventory, and cost data into decisions: which carrier to use, why deliveries are late, where money is leaking. You will spend your days in Excel, SQL, and a dashboard tool, tracking freight from origin to final delivery, talking to carriers and warehouses, and writing short reports that say what happened and what to do next. You do not need a license. Most people in this job have a bachelor's (64%) or an associate's degree (23%), but a strong portfolio of real analyses can make up for gaps. The path is simple: learn how freight moves
See the full roadmap free
Every stage from beginner to expert, with lessons, practice drills, projects, interview questions and free resources. Free with a Rolearch account.
Stage 1 of 4 · about 8 weeks
Understand how goods move and how to measure it. Learn the modes (truckload, LTL, ocean, air, rail, parcel), Incoterms, and the core KPIs: on-time delivery (OTD), order fill rate, inventory turnover, cost per mile, cost per unit, and dwell time. Get comfortable in Excel: formulas, XLOOKUP, PivotTables, charts, and cleaning data. Practice: take a free sample shipment dataset and calculate cost per mile and OTD by carrier. Check yourself: can you explain to a friend why a late truck raises cost?
How freight moves: modes, players and documents
Every number you will analyze comes from a physical shipment. If you do not know why an ocean container takes 30 days and a parcel takes 2, you cannot tell a real problem from normal behavior. Logistics analysts spend their days tracking product from origin to final delivery and talking to carriers, forwarders and brokers, so you need their vocabulary first.
Incoterms 2020 and the cost of moving goods
When a shipment is late or damaged, someone pays. Incoterms decide who. Logistics analysts monitor ocean carriers, forwarders and customs brokers, so you must know where responsibility, risk and cost move from seller to buyer. It also explains why two quotes for the same goods are not comparable.
The core logistics KPIs
Your job is to interpret data and report performance measures. Managers do not ask for raw data; they ask whether delivery is getting better or worse and what it costs. Each KPI is a simple ratio, and the skill is knowing what to put on top, what to put on the bottom, and what the result means.
Excel for logistics data
Excel is the tool you will use every day: it appears in the O*NET software list and in almost every job posting for this role. Shipment data arrives messy, and your first value to a team is turning it into clean, correct numbers fast.
Then 3 more stages (about 46 weeks in all) with lessons, drills, projects, 10 interview questions with strong answers and free resources.