BC Observatoryunofficial, made by waldo
topic hubManufacturingofficial - Microsoftreviewed - checked by Opus

Power BI manufacturing app

The Power BI Manufacturing app section describes the app's reports, its semantic model and its KPIs and measures. It answers questions about capacity utilization, work center and machine center load, production order status and cost, WIP, scrap, and variances.

Open in Claudepower-bi-manufacturing-app.md

Path: Business functionality > Manufacturing > Manufacturing analytics > Power BI manufacturing app · tier official · system manufacturing · narrative reviewed (checked by Opus)

Overview

The Power BI Manufacturing app gives manufacturing managers, supervisors and business leaders analytics on manufacturing activity. Most pages each cover one report, such as utilization, load, production orders, WIP, scrap or variances. Together they help spot overloaded or underused resources, delays and cost overruns.

Start with the Power BI Manufacturing app page for an overview of the included reports. Then use the report pages for the specific question. Capacity reports include Current Utilization, Historical Utilization, Allocated Hours, Work Center Load, Machine Center Load and Expected Capacity Need. Production order reports include Prod. Order List, Production Order Overview, Released Production Orders, Finished Production Order Breakdown, Production Order WIP, Average Production Times and the Routing Gantt. Production Scrap, Capacity Variance and Consumption Variance cover waste and cost differences.

For building or checking measures, use the semantic model page, which describes the star schema of fact and dimension tables. The KPIs and measures page lists the measures for capacity, production order costs, work centers, scrap, machine center load and routing lines.

Key points

  • Capacity reports: Current Utilization (gauges, thresholds), Historical Utilization (downtime, busy periods, bottlenecks), Allocated Hours (over- and underutilized work centers) and Expected Capacity Need (by work center).
  • Load reports: Work Center Load and Machine Center Load show capacity, allocated time, availability after orders and load, so centers are not overloaded.
  • Statistics reports for work centers and machine centers combine Scrap % and Load KPI cards, an efficiency chart and a Statistics Details table.
  • Scrap and variance: Production Scrap analyzes scrap rates by work center, machine center and production order. Capacity Variance and Consumption Variance track expected versus actual cost each month.
  • Production order reports: Prod. Order List, Production Order Overview, Released Production Orders and Finished Production Order Breakdown cover status, expected versus finished quantities and cost variances. Average Production Times shows average production time per item to find delays.
  • Production Order WIP shows the Ending Balance Value trend, an Inventory Valuation table, and KPIs for Beginning Balance, Consumption, Output and Capacity value.
  • Prod. Order Routing Gantt shows a Gantt chart with routing line details, task durations, machine versus work center and non-working days.
  • The semantic model uses a star schema with fact tables for capacity, production and value entries, and dimensions for items, routing, work centers and machine centers. A separate page lists all KPIs and measures.

Learn pages

  • Allocated Hours: The Allocated Hours report provides an overview of the allocated time, in hours, for each work center.
  • Average Production Times: The Average Production Times report shows the detailed average production times for each item.
  • Capacity Variance: The Capacity Variance report shows the variance between expected and actual capacity costs on a monthly basis.
  • Consumption Variance (Power BI report): The Consumption Variance report highlights the variance between expected and actual consumption costs on a monthly basis.
  • Current Utilization: The Current Utilization report provides insights into the manufacturing capacity use and helps with capacity planning.
  • Expected Capacity Need (Power BI report): The Expected Capacity Need report provides insights into the capacity you expect to require for each work center.
  • Finished Production Order Breakdown (Power BI report): The Finished Production Order Breakdown report provides insights into the expected quantity versus the finished quantity of production orders.
  • Historical Utilization: The Historical Utilization report provides insights into the historical utilization of manufacturing resources and machinery equipment over time.
  • Machine Center Load: The Machine Center Load report shows the load and the allocated capacity of each machine center.
  • Machine Center Statistics: The Machine Center Statistics report shows key performance indicators for each machine center.
  • Manufacturing KPIs and measures (Power BI): Get an overview of all the KPIs and measures in the semantic model for the Manufacturing Power BI app.
  • Power BI Manufacturing app: The Power BI Manufacturing app provides insights into your manufacturing activities.
  • Power BI Manufacturing app semantic model: Get an overview of the Power BI Manufacturing app semantic model, including its business fact and dimension tables and visible fields.
  • Prod. Order List: Learn about how to benefit from using the Prod. Order List report.
  • Prod.Order Routing Gantt: Learn how to benefit from using the Prod. Order Routing Gantt report.
  • Production Order Overview: The Production Order Overview report provides a high-level summary of your organization’s production order activities.
  • Production Order WIP: Learn how to benefit from using the Production Order WIP report.
  • Production Scrap (Power BI report): The Production Scrap report shows the quantity of capacity scrap each month, with a breakdown by code, location, and item category.
  • Released Production Orders: The Released Production Orders report shows information about all released production orders, including expected versus finished quantities and the variance.
  • Work Center Load: The Work Center Load report shows the load and the allocated capacity of each work center.
  • Work Center Statistics: The Work Center Statistics report shows key performance indicators for each work center.

Videos and posts

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.

What Learn documents here 8 of 21 Learn pages

Show 13 more