Saltar al contenido principal
Los detalles del producto se muestran en inglés. Próximamente traducciones.
Manufacturing Power BI Analytics Pack — Pre-built Power BI dashboards for production throughput, work-center utilization, sch — 1/1Vista previa ilustrativa

Pre-built Power BI dashboards for production throughput,

work-center utilization, schedule adherence, scrap and on-time delivery — built on your Business Central data and installed by

ECOSIRE as a per-tenant AL extension.

¿Qué es Manufacturing Power BI Analytics Pack?

Pre-built Power BI dashboards for production throughput, work-center utilization, schedule adherence, scrap and on-time delivery — built on your Business Central data and installed by ECOSIRE as a per-tenant AL extension. Built to order by ECOSIRE for Dynamics 365 BC (build-to-order) — indicative price from $999.00 USD; request a quote for a scoped proposal.

Características clave

Work-center and machine-center utilization dashboard — current load vs. registered capacity plus historical trend, sourced from Capacity Ledger Entry and Calendar Absence data
Finished production order breakdown with average production times, computed from Prod. Order Routing Line setup/run time vs. actual posted Capacity Ledger Entries
Schedule adherence and on-time-to-promise measures comparing Prod. Order due dates and finished dates against original promise
Scrap, yield and rework KPIs derived from Item Ledger Entry output, scrap quantities and consumption variances
Subcontract cost and capacity views from subcontract Purchase Lines and routing operations flagged as subcontracted
Per-tenant AL extension that publishes read-optimized API/OData query pages — no direct SQL, update-safe across BC releases
Power BI semantic model with documented DAX measures, a date dimension, and drill-through from KPI to individual production order
Scheduled refresh wired through the Business Central OData v4 connector, with Microsoft On-premises Data Gateway only for on-prem sources
Respects your Business Central permission sets — the extension ships its own permission set so the BI service account sees only what it should
Optional Dataverse / Power Platform path using Business Central virtual tables when your tenant already runs the Power Platform connection
Row-level security option in Power BI to scope dashboards by plant, work center, or responsibility center
Handover of the .pbix file and full AL extension source so your team is never locked in

Hecho a medida, listo para ti

Sin configuración por tu cuenta: una app funcional creada, instalada y con soporte de ECOSIRE.

  1. 1

    Haces el pedido

    Empieza con un precio único de desarrollo. Definimos el alcance contigo en el arranque.

  2. 2

    Creamos e instalamos

    ECOSIRE la crea, la configura y la instala en tu Dynamics 365 Business Central.

  3. 3

    En marcha + soporte

    Sales en vivo en aproximadamente una semana laboral, con dos semanas de soporte tras la puesta en marcha. Los defectos en el código que entregamos se corrigen sin coste.

Sobre este producto

The Manufacturing Power BI Analytics Pack gives operations analysts and plant managers a ready-made KPI layer over Dynamics 365 Business Central manufacturing data — without waiting months for a custom BI project or stitching exports together by hand.

This is a build-to-order product. After purchase, ECOSIRE builds a small per-tenant AL extension on your Business Central environment that exposes clean, report-ready API pages over your production data: production orders, prod. order routing lines, capacity ledger entries, work/machine centers, item ledger entries and subcontract purchase lines. We then connect a Power BI model to those endpoints over the Business Central OData v4 / REST API (or via the Dataverse virtual tables when your tenant uses the Power Platform connection), publish the dashboards, and wire scheduled refresh.

You receive dashboards for work-center utilization (current and historical load vs. capacity), finished-order breakdown with average production times, schedule adherence and on-time-to-promise, scrap, yield and rework, and subcontract cost and capacity. Every measure is documented so your team can extend it.

Because the data layer is shipped as an AL extension (not direct SQL into the BC database, which Microsoft prohibits online), it survives Business Central updates, respects your permission sets, and runs refresh through a Microsoft On-premises Data Gateway only where an on-prem source requires it. ECOSIRE installs it, validates the numbers against your standard BC manufacturing reports, hands over the .pbix and the extension source, and supports it. It is delivered and supported by ECOSIRE — not an instant AppSource download.

lo que obtienes

  • Per-tenant Business Central AL extension (page extensions and dedicated API/OData query pages) installed on your environment
  • Power BI .pbix file with the semantic model, documented DAX measures, and all five dashboard pages
  • Scheduled refresh configured against your BC OData v4 endpoints, including On-premises Data Gateway setup if an on-prem source is involved
  • Dedicated permission set shipped with the extension for the BI integration service account
  • A short validation report reconciling the dashboard KPIs against your standard BC manufacturing reports
  • Handover documentation: measure dictionary, refresh runbook, and AL source repository access

¿Para quién es esto?

Operations Analyst

Wants ready-made manufacturing KPIs over Business Central data instead of building Power BI models from scratch — needs documented DAX measures they can extend and trust against the standard BC reports.

Plant / Production Manager

Needs a daily view of work-center utilization, schedule adherence and on-time delivery to spot bottlenecks and missed promise dates without waiting for IT to pull exports.

Business Central Administrator / IT Lead

Cares that BI access uses a proper per-tenant AL extension with its own permission set and update-safe API pages — not ad-hoc SQL or fragile exports — and that refresh is governed through the data gateway.

Cómo se compara Manufacturing Power BI Analytics Pack

CriterioECOSIREConstrucción personalizadaCompetidorNativo de Dynamics 365 Business Central
Pre-built manufacturing KPIs (utilization, OTD, scrap, schedule adherence) ready on day oneIncluidoNo incluidoApoyo parcialNo incluido
Update-safe per-tenant AL extension (no direct SQL into the BC database)IncluidoApoyo parcialIncluidoIncluido
KPIs validated and reconciled against your standard BC manufacturing reportsIncluidoApoyo parcialNo incluidoApoyo parcial
Tailored to your routing, work centers and subcontract setupIncluidoIncluidoNo incluidoApoyo parcial
Power BI .pbix and full AL source handed over (no lock-in)IncluidoIncluidoNo incluidoNo incluido
Installed and supported on your environment by the vendorIncluidoApoyo parcialApoyo parcialNo incluido
Refresh governed via OData v4 connector / On-premises Data Gateway with a scoped permission setIncluidoApoyo parcialApoyo parcialApoyo parcial
Low cost and fast time-to-value vs. a full custom BI engagementIncluidoNo incluidoIncluidoApoyo parcial

Preguntas frecuentes sobre Manufacturing Power BI Analytics Pack

How long does delivery take after I purchase?

This is a build-to-order product, not an instant download. Typical delivery is 5 to 10 business days from the kickoff call. We need a Business Central user with extension-publish rights (or a sandbox plus production publish window) and a Power BI workspace. Most of the elapsed time is connecting to your tenant, validating the AL extension against your data, and reconciling KPIs with your standard BC manufacturing reports before handover.

What ongoing support and updates do I get?

ECOSIRE installs the extension, validates the numbers, and supports the delivered solution. Because the data layer is a per-tenant AL extension built against the supported Business Central API — not direct SQL — it survives BC monthly and major updates; if a future BC release changes a relevant table or API page, we patch the extension. You receive the .pbix and full AL source, so your team can extend measures independently. Larger changes (new dashboards, new KPI domains) are scoped as follow-on work.

Is this a Microsoft AppSource app I can install myself?

No. It is built, installed and supported by ECOSIRE directly on your Business Central environment as a per-tenant extension. There is no public AppSource listing and no self-service download — we deploy it to your tenant and hand over the source.

Does it read my Business Central database directly?

No. Direct SQL access to the Business Central database is not permitted online and is fragile on-prem. The pack ships an AL extension that exposes dedicated API/OData v4 query pages, and Power BI reads through those. This is update-safe and respects your permission sets.

Does it work with Business Central on-premises as well as online?

Yes. For Business Central online, Power BI connects to your OData v4 / API endpoints directly. For on-premises (or hybrid sources), refresh runs through a Microsoft On-premises Data Gateway, which we configure as part of delivery. The AL extension is the same in both cases.

Can the dashboards be scoped by plant or work center for different teams?

Yes. The Power BI model supports row-level security so you can scope dashboards by plant, work center, or responsibility center, and the extension's permission set keeps the BI service account limited to the manufacturing data it needs.

Solicitar presupuesto

Manufacturing Power BI Analytics Pack

Pre-built Power BI dashboards for production throughput, work-center utilization, schedule adherence, scrap and on-time delivery — built on your Business Central data and installed by ECOSIRE as a per-tenant AL extension.

  • Work-center and machine-center utilization dashboard — current load vs. registered capacity plus historical trend, sourced from Capacity Ledger Entry and Calendar Absence data
  • Finished production order breakdown with average production times, computed from Prod. Order Routing Line setup/run time vs. actual posted Capacity Ledger Entries
  • Schedule adherence and on-time-to-promise measures comparing Prod. Order due dates and finished dates against original promise
  • Scrap, yield and rework KPIs derived from Item Ledger Entry output, scrap quantities and consumption variances

Solicitar presupuesto

Cuéntanos tus necesidades de Manufacturing Power BI Analytics Pack y te enviaremos precios, opciones de licencia y una propuesta a medida, normalmente en un día hábil.

Sin pago ahora. Esto envía una solicitud de presupuesto a nuestro equipo; te responderemos por correo con precios y próximos pasos.