One layout for every report
Title, filters, and headline numbers sit in the same place on every page, set once in a Power BI theme file.
What this preview covers
- The two priority reports from our call, built the way we would build them in Power BI.
- A rebuild of the daily inventory report so the production manager sees shortages first instead of scanning thousands of rows.
- An email alert for those shortages, so nobody has to go looking.
- A first look at executive and sales reporting.
Stacked column + line
Labor cost per case by line
Stacked bar
Hours by department
Table
Line detail
Loaded cost spreads sanitation, warehouse, maintenance, supervision, and packaging across lines by cases produced.
Table with icons
ADP file checks
Text box
For Tuesday's review
Costco data for Sep 14–20, received Mon Sep 21. Our shipments and production plan from Business Central, refreshed 6:00 AM today.
Clustered bar
Costco weeks of supply by item
Stacked column
Projected Costco orders, next 4 weeks
Table with conditional formatting
Item detail
Projection: average of the last 4 weeks of Costco sales, topped up to the target cover. We will confirm the method and Costco fields with your team.
Text box
For the weekly planning call
Starts from today's on-hand in Business Central, Tue Sep 22.
Table with conditional formatting
Lines that go negative
Power Automate flow
Morning alert email
Sent weekdays at 6:30 AM after the refresh, only when something goes negative.
How it works
- Same inputs as today's report: on hand, to produce, quality hold, shipping, transfers in and out.
- A measure rolls each item and location forward day by day, so the table shows only lines that go below zero.
- Suggested actions follow simple rules the production manager sets: cut small shortfalls, transfer when the other location has spare, pull a run forward when one is scheduled soon.
- Item ledger history did not come over in the migration. This report does not need it, since it starts from today's on-hand.
January through August 2026 vs the same months of 2025.
Stacked column
Net sales by month and channel
Table
Channel summary
Text box
What the numbers say
Where the data comes from
One shared model. The ADP file and the Costco file land in SharePoint; Business Central connects directly.
Weekly cadence
One working session with your users each week, and something new to review each week.
- Production payrollMap ADP departments to lines, agree the cost-per-case rules with accounting, first version live.
- Costco forecastConfirm the Costco file and fields, agree the projection method with sales, first version live.
- Shortage finder and alertSit with the production manager, rebuild her daily view, turn on the morning email.
- Standards and next reportsTheme file, navigation page, Excel export fixes on existing reports, then finance, sales, and executive views.
Report standard, set once
A theme file every report imports, so fonts, colors, and table styles match without anyone formatting by hand.
{
"name": "Company standard",
"dataColors": ["#0E7C86", "#C99A06", "#B4424B", "#8793A2"],
"foreground": "#1E2A38",
"background": "#FFFFFF",
"tableAccent": "#0E7C86",
"visualStyles": {
"*": { "*": {
"title": [{ "fontFamily": "Segoe UI", "fontSize": 12 }]
}}
}
}
Where Power BI works differently
- Data refreshes on a schedule: up to 8 times a day on Pro, 48 on Premium or Fabric capacity. Near-current, not live.
- Everyone viewing shared reports needs a Pro license, unless the reports sit on Fabric capacity at F64 or above.
- Excel exports have row limits. For large pulls, Analyze in Excel or a paginated report exports cleanly.
- Built-in alerts are basic. The shortage email runs in Power Automate against the model.
- Reports are read-only. Keying data back in needs Power Apps.
To confirm with your team
- Which Costco file and fields feed the forecast, and how often it arrives.
- How ADP departments map to production lines, and which departments count as overhead.
- Access to the current reports and the Business Central pages users check them against.