SAMPLE AND DEMONSTRATION ONLY. Illustrative analysis of publicly available information, prepared by BI Consulting Services. Not affiliated with, endorsed by or produced for any company shown.

Sample data, not your figures

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.

    1. Production payrollMap ADP departments to lines, agree the cost-per-case rules with accounting, first version live.
    2. Costco forecastConfirm the Costco file and fields, agree the projection method with sales, first version live.
    3. Shortage finder and alertSit with the production manager, rebuild her daily view, turn on the morning email.
    4. 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.