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
- Dynamic Ship records shipments, packages, carriers, and freight costs in Business Central as your team ships.
- 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.
- A logistics or finance user opens the Shipping Overview page in Power BI.
- They filter by year, location, or another field and review spend by month and by location.
- 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.
Related Dynamic Ship Analysis features
All Dynamic Ship Analysis features →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.

