Skip to content
Dynamic Ship app iconDynamic ShipIntegration and reporting

Shipping Analytics for Microsoft Dynamics 365 Business Central

Freight cost is half of the shipping question; the other half is whether what you charge customers covers it. Shipping analytics come from Dynamic Ship Analysis, Insight Works' free Power BI reporting app for Dynamic Ship, a separate companion app that requires Business Central online. This is a completely free app from Insight Works for Business Central.

Dynamic Ship Analysis reads the shipment data Dynamic Ship records in Microsoft Dynamics 365 Business Central and shows freight cost, freight recovered, and freight margin by carrier, customer, service, and region across four report views.

How Shipping analytics works in Dynamic Ship

  1. Install the Dynamic Ship Analysis extension in Business Central; it exposes the queries the Power BI report reads.
  2. Install the Dynamic Ship Analysis app in Power BI from Microsoft Marketplace.
  3. Enter your Business Central company name, environment, and fiscal year settings, then sign in with your Business Central credentials to connect the report to live data.
  4. Open the report, move between the four views, and filter any of them by period, customer, shipping location, carrier, service, or shipment method.
Video thumbnail: Shipping analytics with Dynamic Ship Analysis
Shipping analytics with Dynamic Ship Analysis A video on Dynamic Ship Analysis, the Power BI reporting app for Dynamic Ship.

Key capabilities

Margin Analysis view

Shows freight margin, freight recovered, freight cost, cost per shipment, and shipment count, each compared with the prior year, plus freight recovery by customer and by carrier.

Carrier Analysis view

Shows cost per shipment, carriers used, the carrier with the highest average margin, and the highest-cost and lowest-cost services, with a chart comparing freight charged, freight cost, and freight margin for each carrier.

Geo Summary view

Maps shipment destinations, with bubble size showing volume and shading showing freight cost. A region and city breakdown lists shipments, average cost per shipment, cost trend, total freight cost, freight recovered, and margin.

Data Explorer view

A shipment-level grid with tracking link, shipping label link, ship-to city and country, freight cost, freight recovered, freight margin, and weight, for detailed questions or as a base for your own reports.

Trends and weight bands

The Margin Analysis, Carrier Analysis, and Geo Summary views show shipment volume over time and shipments by weight band, so changes in volume or package size sit next to cost.

Carrier and method mix

See which carriers and shipment methods, such as parcel, less-than-truckload (LTL) freight, and third-party billed shipments, account for your volume, so you know where spend is concentrated.

See Shipping analytics on screen

Real screens from Dynamic Ship, shown with demo data.

Details that matter on the floor

Margin, not only cost

Freight recovered and freight margin are tracked alongside freight cost, so the report shows whether shipping makes or loses money by carrier, customer, service, and region.

Built on data already captured

The report runs on the cost and charge data Dynamic Ship records at the point of shipment, so there is no spreadsheet to build or keep current.

Room to extend

Because the report is built in Power BI and the Data Explorer view exposes shipment-level detail, your team can build its own reports on the same data.

Who uses Shipping analytics

Shipping managers

Use the Carrier Analysis view to spot carriers or service levels that are cutting into margin before the trend reaches quarterly results.

Controllers and finance teams

Use the Margin Analysis view to check that freight price rules, the Dynamic Ship settings for markups, discounts, and handling charges, are recovering costs as intended.

Operations managers

Use the Geo Summary view to see where shipment volume and cost concentrate by city and region.

Analysts and account teams

Use the Data Explorer view when a customer or carrier question needs shipment-level detail.

Questions about Shipping analytics

Is Dynamic Ship Analysis free?

Yes. There is no fee for the Dynamic Ship Analysis app or its report views. It needs Dynamic Ship on Business Central online and Power BI to view the report; for licensing questions, see the licensing FAQ.

Does Dynamic Ship Analysis automatically reconcile carrier invoices?

No. Dynamic Ship stores the freight cost, freight recovered, and freight margin for each shipment, and Dynamic Ship Analysis reports on them so your team can compare them with carrier invoices. It does not import carrier electronic invoices or audit individual charges.

Does Shipping Analytics work with Business Central on-premises?

No. Dynamic Ship Analysis requires Business Central online; on-premises environments are not supported.

Can I get shipment-level detail, not just summary charts?

Yes. Open the Data Explorer view to see one row per shipment with its links, destination, cost, recovery, margin, and weight. You can inspect individual shipments there or export the detail for further analysis.

Dynamic Ship app icon

Part of Dynamic Ship

Easily add carrier integration, real-time shipping rates, package management and shipment tracking to Business Central.

Have a question about Shipping analytics?

Send us a note and the Dynamic Ship team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions