Data Panda brings your Microsoft Dynamics 365 Business Central data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.
Business Central is Microsoft's cloud ERP for small and mid-sized businesses, evolved from the Navision lineage that grew into Dynamics NAV and then into the Dynamics 365 family. It covers finance, sales orders, purchasing, inventory, warehouse operations, manufacturing and service, with tight hooks into Outlook, Excel, Teams and Power BI.
The point of pulling Business Central into a warehouse is not that Business Central lacks reports. It is that organisations running Business Central usually also run Salesforce for the commercial motion, HubSpot for marketing, Shopify for DTC or Stripe for payments. The questions that leadership cares about sit in between those systems. In a warehouse, Business Central becomes the spine, and the numbers from the rest of the stack line up against it without another monthly export from the Business Central tenant.
Business Central numbers next to the systems that sit around it, not ten Power BI reports chasing each other.
Keep Business Central in sync with the systems it has to talk to, without relying on another AppSource add-on.
Use Business Central history to forecast stock, demand and customer risk without waiting for the next Copilot feature.
Small tools on top of Business Central data for people who should not need a Business Central licence.
A list of concrete reports, automations and AI features we have built on MS Dynamics 365 Business Central data. Pick the one that matches your situation.
Which dimensions are driving this quarter's P&L?
Profit and loss broken out by Business Central dimensions, with drill-through to the underlying journal entries. Shows which cost centre or project moved the quarterly number, instead of a summary row that leaves the question open.
Where is working capital leaking?
AR aging, inventory days and AP aging on the same twelve-month trend, with the cash position layered on top. Identifies the customer segment, SKU group or supplier cluster that is quietly tying up cash, not just the total that moved.
How does a deal in Salesforce become revenue in Business Central?
Closed-won Salesforce opportunity tracked to Business Central sales order, shipment, invoice and cash collection, with elapsed days at each hop. The handoff where the cycle lengthens, or where revenue leaks, becomes visible by rep, by region and by product.
Dimension-level P&L, working capital and multi-entity consolidation without the monthly intercompany export. Month-end closes on the data that was already booked, not on a pile of Excel adjustments on top of Business Central.
Pipeline-to-order-to-revenue timing per rep and product line, tied back to Salesforce, HubSpot or Pipedrive. Forecast accuracy is checked against Business Central invoices, not against optimistic CRM stages.
Fulfilment SLA, purchase-to-pay cycle, supplier reliability and production throughput in one view. The handoffs between sales, warehouse and manufacturing show up as data, not as Monday-morning phone calls.
Closed-won Salesforce opportunities drop into Business Central as sales orders, with customer, item and pricing mapped. Order status, shipment and invoice flow back to the opportunity, so sales and finance see the same cycle instead of arguing with two reports.
Marketing-qualified HubSpot deals that reach closed-won create a Business Central quote or sales order with the right contact and deal line items. Invoice and payment status updates flow back to HubSpot, so campaign ROI is measured against booked revenue rather than pipeline value.
Shopify orders land in Business Central as sales orders with items, pricing and tax treatment handled, and refunds push back as credit notes. Stock levels, shipment status and invoice state stay in one ERP so the DTC channel is in the same P&L as the rest of the business.
Stripe payouts are booked in Business Central as bank journal entries with fees split out and the underlying charges linked to the Business Central invoices they paid. Month-end reconciliation between Stripe, the bank statement and the ledger stops being a manual merge.
These are the 31 tables we currently pull from MS Dynamics 365 Business Central into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.
Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.
You keep the reporting tool you already have. We connect it to the warehouse where your MS Dynamics 365 Business Central data lives.
OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.
Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.
We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.
We set up the foundation. Your team builds on top.
Best fit Teams that already have a BI analyst or data engineer and want to own the build.
We build the whole thing, end to end.
Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.
You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.
Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.
No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.
Cloud Business Central is the primary path, using the published OData and Web Services APIs. For groups still running older on-prem NAV or Business Central on-prem, we connect at the SQL layer or through the extensions API, depending on what's available, so historical data can come along without forcing a version upgrade.
Yes. Global and shortcut dimensions, plus dimension sets on each entry, come across as first-class columns in the warehouse tables. Dimension-level P&L, margin per project or cost-centre-level analysis works directly against the same splits your accountants set up in Business Central.
We review your MS Dynamics 365 Business Central setup and the systems around it. Together we pick the first thing worth building.