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.
Demonstration · Illustrative data · BI Consulting Services
Print view — a clean income statement for the selected entity and period. Use your browser's print dialog to save as PDF.
Recycled Fibre → Income Statement · Interactive demonstration board
Jackson Paper (SCC)×BI Consulting Services
Sustainable Corrugated & Containerboard — one board from OCC bale to consolidated P&L
Four Southeast facilities · Sylva NC mill (100% recycled medium) · sheet plants in Morganton NC & Dalton GA · sources: custom ERP on IBM DB2 + SQL Server
Prepared for Quintin
September 2026
Signature view · Fibre balance
From OCC bale to reel: Sylva paper machine flow
Bales in on the left, finished tons on the right. Every figure follows the filters above.
Fibre / mediumCorrugated sheetsLoss & rejects
Trend · 24 months · Oct 2024 – Sep 2026
Tons shipped and gross margin
Selected period is shaded. Top: tons shipped per month. Bottom: gross margin % on one axis of its own — never two scales on one plot.
Multi-entity income statement · customizable & printable
Income statement
One statement per business unit or one consolidated view — the same DB2 general-ledger rows, mapped once to a conformed chart of accounts.
USD thousands · illustrative data
Breakdown · cost of goods per ton
Where each ton's cost goes
Ranked cost lines for the selected entity and period, with the share of net sales each consumes.
Data model · how the numbers get here
DB2 + SQL Server → one warehouse → Power BI
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.
Custom ERP · IBM DB2~10 tables
GLTRAN
GLACCT
ARINV
APINV
CUSTMST
VENDMST
PRODRUN
ROLLINV
SHIPHDR
COSTCTR
Change-data capture on journal date · no ERP code changes
Plant systems · SQL Server~10 tables
ScaleTicket
OccReceipt
BaleGrade
MachineEvent
Downtime
QualityTest
Corrugator
SheetOrder
FreightBOL
Payroll
Incremental loads by timestamp · 4-hourly for shipments
Warehouse · SQL Serverstar schema
stg_*
FactGL
FactShipments
FactIntake
FactMachine
DimEntity
DimAccount
DimDate
DimCustomer
DimProduct
One conformed chart of accounts across Mill, Morganton, Dalton · eliminations as their own entity
Power BIthis board
Income statement
Fibre balance
Operations
Paginated print
Nightly 02:00 ET refresh · shipments 4-hourly · row-level security by entity
Monthly
Close support
Statement tie-out to DB2 trial balance, mapping exceptions cleared, close checklist signed off — working day 1 to 5.
Weekly
Refresh health
Load logs reviewed, row-count reconciliation ERP → warehouse, failed refreshes fixed before anyone opens the report.
Continuous
DBA-as-a-service
Backups, index maintenance, patching and the ten-year retention policy on the warehouse — covered as part of the engagement, not a separate hire.
Quarterly
Model review
New accounts, new entities (an SCC integration, for example), new report pages — scoped, prioritised, delivered.
Demonstration · Illustrative data · BI Consulting Services
Also from BI Consulting Services
Private AI on your own server
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.
