In this case study, read how a Chemical Manufacturer gained real-time insights with Velosio Insights for Business Central and Power BI.
Table of Content
An international chemical manufacturer was successfully using Microsoft Dynamics 365 Business Central but felt that they could get more out of their reporting. They learned that they could further unlock the potential of their Microsoft Dynamics 365 Business Central data with Velosio Insights for Business Central.
Velosio Insights includes pre-built multi-dimensional data models and Power BI reports. These interactive reports transform raw data from Business Central into clear, actionable visuals that help you monitor business performance.
Velosio was the manufacturer’s partner for Business Central, so it was an easy transition to add Velosio Insights to their system. The client was looking to gain more insights from their sales and finance data, purchasing and inventory, and eventually accounts receivable and accounts payable. Velosio implemented 13 reports for sales and finance, and over 20 reports for purchasing and inventory.
The team is happy with the insights they now see from their data. “The sales reports are valuable and provide good insights, says the Finance and IT Manager. “The data is represented in a way that I can get some quick insights into it. The numbers generally look in line with my expectations,” they continue.
Now that they are getting their feet wet using Insights, the manufacturer is looking to tweak and add more reports. “One thing we get asked about often is orders in a month,” says the Finance and IT Manager. “It would be cool to see a visual on orders received by product line by month and see where most of those are coming from. Additionally, something related to a run rate on our book and ship within the month could be useful for helping us to understand what we would expect to come in each month, potentially with some sort of seasonality or trend as well. We are also often asked about product costing over time. Are we spending more on our materials this month than we did last month or last year? That could be a useful insight for us which would be related to margin by product line,” the client continues.
The manufacturer also reports: “It would be interesting to see what is driving some of the most important balance sheet categories. For example, AR and AP, what customers and vendors make up our balance? Is that trending up or down? How much is it changing month after month? Inventory as well. For the finance information, I have reports on what the numbers are already, but what I need to know is what are the key drivers behind the increase in AR or AP, etc.”
The manufacturer is also looking to add functionality around warehousing. “Potentially a dashboard which shows shipments expected to go out in the next week, and receipts we are expecting to come in within the week would be useful. Another thing we measure related to this is on delivery time. Did we get the shipment out when we said we would? Did we get it out when the customer requested it? Purchasing could also be interesting to see where we see price increases on our inventory materials. The percentage increase in costs for items or product lines, where are we seeing savings and how much”.
Velosio offers a strategic partnership to help you navigate business challenges and prepare for the future. As a trusted partner, we provide technology, services, and guidance tailored to your needs. With deep expertise in Microsoft solutions, we bring fresh ideas and practical knowledge to support your success. Learn how you can work with us to optimize your business solution. Give Velosio a call.
Talk to us about how Velosio can help you realize business value faster with end-to-end solutions and cloud services.