Skip to content
Dynamic Ship Analysis app iconDynamic Ship AnalysisFeature

Shipping Spend Metrics for Microsoft Dynamics 365 Business Central

Shipping spend is easy to record one shipment at a time and hard to see as a whole, so questions like which month or which warehouse cost the most go unanswered. Dynamic Ship Analysis turns the shipment data that Dynamic Ship records into Power BI reports, starting with total shipping spend by month and by location. This is a completely free app from Insight Works for Business Central.

Dynamic Ship Analysis is a separate app that works with Dynamic Ship, Insight Works' shipping app for Business Central. It works with Business Central online, and with Business Central on-premises when the network and Power BI are configured for it.

How Shipping spend metrics works in Dynamic Ship Analysis

  1. Dynamic Ship records shipments, packages, carriers, and freight costs in Business Central as your team ships.
  2. An administrator installs the Business Central extension that supplies the report data, then installs the Dynamic Ship Analysis Power BI app from Microsoft Marketplace and connects it to the same Business Central environment.
  3. A logistics or finance user opens the Shipping Overview page in Power BI.
  4. They filter by year, location, or another field and review spend by month and by location.
  5. They drill down for more detail, or move to the Overview Trends page to see each location month by month.

Key capabilities

Spend by month

A monthly chart of total shipping spend shows how costs move through the year.

Spend by location

Total spend for each Business Central location shows which site ships the most, by cost.

Location over time

The Overview Trends page breaks spend by location down by month, so a change at one site is visible against the others.

Shipments against spend

A combined chart shows the number of shipments and total spend for each month, so a rise in cost can be read against a rise in volume.

Summary statistics

Total spend, average spend per shipment, average spend per package, average spend per pound, total shipments, and total packages for the filtered period.

Filters on every page

Narrow every page by date, year, quarter, month, customer, location, shipping agent, and service level.

See Shipping spend metrics on screen

Real screens from Dynamic Ship Analysis, shown with demo data.

Details that matter on the floor

Built on shipments you already record

Dynamic Ship Analysis reports on the data Dynamic Ship captures at shipping time, so there is no separate data entry for reporting.

The same filters everywhere

Because the filters apply on all pages, a manager looking at one location sees that location on every page of the report.

Who uses Shipping spend metrics

Logistics managers

Track shipping spend by month and location and spot sites with rising costs.

Financial analysts and controllers

Follow shipping costs for expense monitoring and budgeting.

Operations managers

Compare shipping activity between locations when planning.

Questions about Shipping spend metrics

What does Dynamic Ship Analysis show about shipping spend?

Total shipping spend by month and by location, with summary statistics such as average spend per shipment and per package, from the shipments Dynamic Ship records.

Does Dynamic Ship Analysis work without Dynamic Ship?

No. Dynamic Ship Analysis reports on Dynamic Ship data and needs Dynamic Ship, which is licensed separately.

Does it work with Business Central on premises?

Yes, when the network and Power BI are configured so the reports can reach your on-premises data. Your Microsoft Partner can set this up.

Do I need a Power BI license?

Licensing depends on your setup. See the licensing FAQ.

Dynamic Ship Analysis app icon

Part of Dynamic Ship Analysis

Analyze your Dynamic Ship shipping costs and trends in Power BI.

Have a question about Shipping spend metrics?

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

Ask a product question

Product Questions