Sustainable Corrugated & Containerboard — one board from OCC bale to consolidated P&L
Bales in on the left, finished tons on the right. Every figure follows the filters above.
Selected period is shaded. Top: tons shipped per month. Bottom: gross margin % on one axis of its own — never two scales on one plot.
One statement per business unit or one consolidated view — the same DB2 general-ledger rows, mapped once to a conformed chart of accounts.
Ranked cost lines for the selected entity and period, with the share of net sales each consumes.
About ten DB2 tables from the custom ERP and about ten SQL Server tables, landed nightly into a small warehouse (well under 1 TB, ten-year retention) and modelled once. Table names are illustrative.
The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.
Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min