Dashboards
The report behind each engagement.
Every project opens into the dashboard it delivered: the KPIs that matter for the sector, the cross-cuts, and the detail line down to the item. Client names and figures are illustrative and under NDA; the structure is what actually shipped.
Platform Migration
Migration Cockpit · QlikView → Power BI
Business Intelligence
Migration Cockpit · QlikView → Power BIctl_migracao · ImportRefreshed 07/08 06:12Illustrative data
Report pages
Filters
Wave
Waves 1 to 8▼
Status
All▼
Criticality
High and medium▼
Hierarchy
Business unit
Area
Report
Business unit · consolidated
Reports migrated+96 this wave
1,247
of 1,312 after rationalization
Parity validated+1.4 p.p.
98.6%
checked number by number
Current waveon track
6 of 8
phased cutover, no blackout
Cumulative effort-12% vs plan
4,180 h
Our team + client squad
Reports retired
65
DAX measures created
3,412
Active users/month
1,860
Average load time
4.2 min
Reports migrated per month
Cumulative by wave, against contracted target
MigratedPlan
34124414955
JanFebMarAprMayJunJulAugSepOctNovDec
Reports by business unit
Click to drill down the hierarchy
Rationalization retired 65 reports unused over the last 12 months.
Reports in scope
One row per report rebuilt in Power BI
Report
Area
Wave
DAX measures
Parity
Effort
Status
RPT-1241 · Cash flowAccounting
Finance
8
58
99.2%
88 h
In validation
RPT-1235 · Management P&LAccounting
Finance
6
21
99.9%
76 h
Approved
RPT-1151 · Taxes assessedSales
Sales
5
45
99.6%
68 h
Approved
RPT-1282 · Service levelSales
Sales
5
21
99.8%
55 h
Approved
RPT-1111 · Productivity by shiftProduction
Operations
8
20
98.4%
26 h
In validation
RPT-1442 · Maintenance backlogProduction
Operations
7
18
97.8%
16 h
In progress
RPT-1752 · Discount grantedPurchasing
Procurement
6
25
98.1%
79 h
In validation
RPT-1457 · Service levelPurchasing
Procurement
8
44
98.8%
22 h
In validation
Data Platform
Commercial Results · Omnichannel Network
Retail
Commercial Results · Omnichannel Networkgold_vendas_v3 · Direct LakeRefreshed 07/08 06:12Illustrative data
Report pages
Filters
Period
MTD · Aug/2026▼
Channel
All channels▼
Banner
All▼
Hierarchy
Region
Store
SKU
Region · consolidated
Net sales+6.2% LY
$18.42M
MTD, net of returns
Gross margin-0.4 p.p.
27.8%
with logistics allocation
Stockout-1.3 p.p.
4.1%
SKU-store out of stock at the POS
Average ticket+2.8%
$84.20
consolidated omnichannel receipt
Receipts in period
218.4K
Items per receipt
6.4
Returns
1.8%
Stock cover
22 days
Daily net sales
Brick-and-mortar, app, marketplace and telesales consolidated
20262025
$803K$686K$573K$460K
0104071013161922252831
Net sales by region
Click to open store by store
Southeast concentrates 44% of sales and 51% of perishable stockouts.
SKUs in the slice
SKU-store-day granularity, served over Direct Lake
SKU
Category
Net sales
Margin
Stockout
Turnover
Stock
78925655 · Mozzarella cheese kgSP · Store 042 Morumbi
Perishables
$25K
34.9%
8.5%
26 d
1,684
78907417 · Fabric softener 2LSP · Store 042 Morumbi
Cleaning
$27K
30.9%
1.2%
15 d
354
78995511 · Soda 2LPR · Store 311 Batel
Beverages
$10K
32.7%
1.2%
13 d
1,324
78937676 · Frozen chicken kgPR · Store 311 Batel
Perishables
$10K
20.6%
4.1%
14 d
230
78914527 · Frozen chicken kgPE · Store 412 Boa Viagem
Perishables
$4K
36.3%
1.0%
4 d
732
78969142 · Fabric softener 2LPE · Store 412 Boa Viagem
Cleaning
$9K
18.6%
8.5%
24 d
1,434
78906695 · Mozzarella cheese kgDF · Store 501 Asa Sul
Perishables
$5K
29.5%
6.1%
29 d
781
78941373 · Diapers M 40ctDF · Store 501 Asa Sul
Personal care
$6K
21.1%
5.1%
17 d
983
Executive BI
OEE and Manufacturing Cost · Multi-plant
Manufacturing
OEE and Manufacturing Cost · Multi-plantfato_producao · MES + ERPRefreshed 07/08 05:48Illustrative data
Report pages
Filters
Period
Last 30 days▼
Shift
A, B and C▼
Family
All▼
Hierarchy
Plant
Line
Production order
Plant · consolidated
Consolidated OEE+2.1 p.p.
74.3%
corporate target 80%
Availability+1.4 p.p.
88.1%
planned downtime excluded
Performance-0.6 p.p.
91.4%
actual cycle vs standard cycle
Quality+0.9 p.p.
92.3%
2.7% scrap in the period
Scrap in period
2.7%
Unplanned downtime
412 h
Cost per unit
$3.42
Average setup
38 min
Consolidated daily OEE
All plants, against the 80% target
Actual OEETarget
84.8%78.5%72.5%66.4%
0104071013161922252830
OEE by plant
Click to open line by line
Betim drags the consolidated figure down: 61% availability on the extrusion line.
Orders in the slice
One row per closed production order
Order
Product
Good parts
Scrap
OEE
Downtime
Cost/unit
OP-26-92231Line 01 · Extrusion · Shift C
PP coil 800mm
3,287
3.3%
52.3%
69 min
$3.28
OP-26-60798Line 01 · Extrusion · Shift B
HDPE pipe 110mm
18,051
2.1%
54.5%
149 min
$3.26
OP-26-66048Line 11 · Extrusion · Shift B
PVC profile 60mm
12,036
4.5%
57.9%
67 min
$3.14
OP-26-35617Line 11 · Extrusion · Shift B
Laminated sheet 2mm
15,721
3.3%
63.3%
147 min
$2.92
OP-26-96550Line 21 · Injection · Shift A
Laminated sheet 2mm
3,864
1.8%
71.5%
103 min
$1.98
OP-26-76549Line 21 · Injection · Shift C
HDPE pipe 110mm
5,274
6.1%
76.5%
201 min
$2.64
OP-26-26930Line 31 · Extrusion · Shift B
Laminated sheet 2mm
19,111
5.5%
63.5%
152 min
$4.11
OP-26-67647Line 31 · Extrusion · Shift B
Composite batten
11,264
1.6%
85.8%
92 min
$2.40
Power Platform
Purchasing and Approvals · End-to-end cycle
Corporate Processes
Purchasing and Approvals · End-to-end cycledataverse_compras · ImportRefreshed 07/08 07:05Illustrative data
Report pages
Filters
Period
Last 90 days▼
Stage
All stages▼
Approval tier
All▼
Hierarchy
Business unit
Cost center
Request
Business unit · consolidated
Open-18% this month
312
requests live in the flow
Cycle timewas 9.1 d
2.4 d
from request to ERP posting
SLA on time+22 p.p.
91.3%
with automatic escalation
Amount in approval+$410K
$6.84M
sum of open requests
Requests per month
1,316
Active automations
24
Hours saved/month
310 h
Rejection rate
7.4%
Requests completed per week
Since the go-live of the Power Apps app
CompletedOpen
88735944
W1W3W5W7W9W11W13W15W17W19W21
Requests by business unit
Click to open by cost center
Facilities accounts for 28% of requests and 6% of value: high volume, low ticket.
Requests in the slice
One row per request, with the stage and the SLA clock
Request
Supplier
Stage
Amount
Age
Approver
SLA
SC-2026-6629CC 1042 · Maintenance
Horizonte Materiais
Tier 1
$11K
1 d
L. Aguiar
On time
SC-2026-5427CC 1042 · Maintenance
Gama Consultoria
Triage
$89K
21 d
A. Ribeiro
Overdue
SC-2026-8215CC 2010 · Building
Alfa Serviços
Tier 1
$7K
6 d
P. Sanches
Warning
SC-2026-7667CC 2010 · Building
Fênix Logística
Tier 2
$137K
11 d
M. Tavares
Overdue
SC-2026-4834CC 3011 · Sales SP
Fênix Logística
Tier 2
$86K
14 d
C. Nunes
Overdue
SC-2026-8658CC 3011 · Sales SP
Alfa Serviços
Triage
$145K
11 d
P. Sanches
Overdue
SC-2026-6797CC 4008 · Infrastructure
Horizonte Materiais
Tier 2
$28K
1 d
C. Nunes
On time
SC-2026-6902CC 4008 · Infrastructure
Fênix Logística
Tier 1
$35K
20 d
R. Beltrão
Overdue
Analytics & AI
Credit Risk · Predictive score and collections ladder
Financial Services
Credit Risk · Predictive score and collections laddermart_credito · Azure ML scoringRefreshed 07/08 04:30Illustrative data
Report pages
Filters
Period
Position Aug/2026▼
Portfolio
All▼
PD band
All bands▼
Hierarchy
Portfolio
Cohort
Contract
Portfolio · consolidated
Average 12m PD-0.7 p.p.
6.8%
probability predicted by the model
90+ delinquency-1.1 p.p.
4.2%
realized on balance
Active portfolio+3.4%
$412M
total outstanding balance
Model KSstable
0.52
monitored at each retraining
Gini
0.61
Contracts scored
84.2K
Recovered this month
$12.4M
PSI (drift)
0.03
Delinquency predicted vs realized
The model anticipates by three months what the old ladder only saw later
RealizedPredicted
6.2%5.6%5.0%4.4%
SepOctNovDecJanFebMarAprMayJunJul
Balance at risk by portfolio
Click to open by cohort
Auto financing concentrates 34% of the balance and the widest PD dispersion across cohorts.
Contracts in the slice
Score per contract, with the action the collections ladder triggers
Contract
Cohort
Balance
PD 12m
Aging
Score
Ladder action
CT-8526642Customer 6717 · masked
2025-Q1
$50K
26.3%
1-30
634
Renegotiation offer
CT-8938165Customer 3553 · masked
2025-Q1
$169K
14.3%
61-90
773
Specialized collection
CT-8876158Customer 2201 · masked
2025-Q1
$158K
9.0%
Current
852
Preventive negotiation
CT-8688645Customer 3127 · masked
2025-Q1
$176K
12.6%
1-30
814
Preventive negotiation
CT-8468165Customer 3106 · masked
2025-Q2
$51K
11.5%
1-30
828
Preventive negotiation
CT-8962829Customer 7078 · masked
2025-Q2
$251K
9.6%
1-30
844
Preventive negotiation
CT-8466739Customer 9282 · masked
2025-Q2
$202K
2.3%
Current
938
Automatic SMS
CT-8805621Customer 2179 · masked
2025-Q2
$100K
27.0%
Current
620
Renegotiation offer
S&OP and Planning
Demand and Supply Planning · S&OP cycle
Supply Chain
Demand and Supply Planning · S&OP cyclegold_sop · FabricRefreshed 07/08 05:20Illustrative data
Report pages
Filters
Cycle
S&OP Aug/2026▼
Horizon
M+1 to M+6▼
Curve
A, B and C▼
Hierarchy
Family
Supplier
Item
Family · consolidated
Forecast accuracy+6.2 p.p.
78.4%
1 - value-weighted MAPE
Average coverage-5 days
34 days
stock over forecast demand
Supplier OTIF+3.8 p.p.
91.2%
on time and in quantity
Inventory capital-$6.1M
$84.6M
all families
Class A items
1,284
Input stockout
3.4%
Obsolete stock
$4.2M
Average lead time
21 days
Forecast accuracy
1 - MAPE for the cycle, against the 80% target
AccuracyTarget
84.8%77.5%70.4%63.4%
SepOctNovDecJanFebMarAprMayJunJulAug
Inventory capital by family
Click to open by supplier
Imported inputs account for 5% of value and 31% of shortages: risk concentrated in lead time.
Items in the slice
One row per item planned in the cycle
Item
Supplier
Stock
Coverage
Accuracy
Lead time
Curve
IT-44030 · PBR palletQuímica Andrade
Química Andrade
$184K
53 d
56.9%
38 d
A
IT-33573 · Bearing 6205Química Andrade
Química Andrade
$172K
60 d
91.3%
7 d
B
IT-39732 · Gray epoxy paintDC Cajamar
DC Cajamar
$136K
44 d
85.5%
6 d
C
IT-88491 · Hydraulic oil ISO 68DC Cajamar
DC Cajamar
$124K
48 d
61.2%
45 d
C
IT-84707 · PP homopolymer resinCartonagem Vale
Cartonagem Vale
$76K
15 d
58.7%
49 d
A
IT-30910 · Bearing 6205Cartonagem Vale
Cartonagem Vale
$69K
28 d
84.6%
34 d
A
IT-57117 · Cardboard box 40x30Ferramentaria Norte
Ferramentaria Norte
$25K
72 d
77.1%
17 d
A
IT-64120 · Adhesive label 90mmFerramentaria Norte
Ferramentaria Norte
$33K
59 d
89.5%
40 d
C
Logistics BI
Freight Cost and Service Level · National Network
Transport and Distribution
Freight Cost and Service Level · National Networkgold_transporte · TMS + ERPRefreshed 07/08 06:40Illustrative data
Report pages
Filters
Period
Last 30 days▼
Mode
Road▼
Carrier
All▼
Hierarchy
Region
Route
Delivery
Region · consolidated
Freight cost-0.9 p.p.
6.8%
as a share of net revenue
OTIF+4.1 p.p.
92.4%
on time and complete
Vehicle utilization+5.2 p.p.
78.1%
weight and cube combined
Cost per delivery-$3.80
$41.20
total freight over deliveries
Deliveries in period
184.2K
Returns
2.1%
Redelivery
3.6%
Average lead time
2.8 days
Freight cost as a share of revenue
Daily percentage, against the 6.5% target
ActualTarget
8.0%7.3%6.7%6.0%
0104071013161922252830
Freight cost by region
Click to open route by route
North has 6% of deliveries and 14% of cost: distance and low utilization on the return leg.
Deliveries in the slice
One row per issued bill of lading
Delivery (BoL)
Route
Carrier
Freight
Weight
Lead time
Status
BoL 560229Southeast
SP metro · last mile
Rodoexpress
$3K
2,752 kg
1 d
On time
BoL 521272Southeast
SP metro · last mile
Meridiano Transportes
$4K
3,285 kg
3 d
On time
BoL 591724Northeast
PE · Recife and metro
Vetor Cargas
$10K
3,619 kg
7 d
Returned
BoL 580959Northeast
PE · Recife and metro
Cabral Distribuição
$5K
1,766 kg
5 d
Late
BoL 552822South
PR · Curitiba and coast
Meridiano Transportes
$3K
900 kg
5 d
Redelivery
BoL 561698South
PR · Curitiba and coast
Vetor Cargas
$2K
3,827 kg
7 d
On time
BoL 598355Midwest
DF · Brasília
Meridiano Transportes
$4K
346 kg
1 d
Returned
BoL 532032Midwest
DF · Brasília
Cabral Distribuição
$4K
598 kg
1 d
On time
Management P&L
Management P&L · Multi-entity
Finance
Management P&L · Multi-entitygold_financeiro · ERP + allocationRefreshed 07/08 07:20Illustrative data
Report pages
Filters
Period
Jul/2026 · closed▼
View
Management▼
Comparison
Budget▼
Hierarchy
Business unit
Cost center
GL account
Business unit · consolidated
Net revenue-1.7% vs budget
$248.6M
year to date
Gross margin+0.3 p.p.
38.4%
after COGS and COS
EBITDA margin-0.6 p.p.
14.2%
before D&A and financial
Net income-$2.3M
$18.9M
after income tax
Expense over revenue
24.2%
Close cycle
3 days
Allocated accounts
412
Budget adherence
97.9%
Monthly EBITDA margin
Actual against budget, as a percentage of net revenue
ActualBudget
16.1%14.6%13.2%11.7%
AugSepOctNovDecJanFebMarAprMayJunJul
Net revenue by business unit
Click to open by cost center
Services has 18% of revenue and 31% of EBITDA: margin the consolidated view was hiding.
Accounts in the slice
Actual against budget, account by account
GL account
Cost center
Actual
Budget
Variance
V%
Nature
6.1.01 Financial expensesCC 100 · Production
CC 100 · Production
$647K
$660K
-2.1%
10.2%
Financial
4.1.01 Raw materialCC 100 · Production
CC 100 · Production
$494K
$472K
+4.7%
10.2%
Cost
5.2.01 Technology and licensesCC 200 · Logistics
CC 200 · Logistics
$278K
$275K
+1.2%
10.2%
Expense
3.1.01 Product revenueCC 200 · Logistics
CC 200 · Logistics
$160K
$144K
+11.1%
10.2%
Revenue
3.2.01 Deductions and taxesCC 300 · Projects
CC 300 · Projects
$207K
$233K
-11.3%
10.2%
Revenue
5.1.02 Travel and entertainmentCC 300 · Projects
CC 300 · Projects
$202K
$183K
+10.2%
10.2%
Expense
5.2.01 Technology and licensesCC 400 · Stores SP
CC 400 · Stores SP
$125K
$144K
-13.4%
10.2%
Expense
5.1.04 Rent and occupancyCC 400 · Stores SP
CC 400 · Stores SP
$122K
$137K
-11.3%
10.2%
Expense
Education BI
Enrollment, Dropout and Result · Education Network
Education
Enrollment, Dropout and Result · Education Networkgold_academico · Academic ERPRefreshed 07/08 06:05Illustrative data
Report pages
Filters
Cycle
2026.2▼
Modality
All▼
Status
Active and on leave▼
Hierarchy
Campus
Program
Class
Campus · consolidated
Active enrollments+4.2% vs 2026.1
24,180
all modalities
Dropout in the semester-2.1 p.p.
11.4%
leave and abandonment
Delinquency-1.4 p.p.
8.7%
tuition overdue 30+
Class fill rate+3.6 p.p.
82.3%
enrolled over seats
Intake in the cycle
4,216
Average ticket
$892
Scholarships and discounts
21.4%
Student NPS
46
Active enrollments per month
Live base of the cycle, against the same period last year
20262025
27,06324,45421,92219,390
FebMarAprMayJunJulAugSepOctNovDec
Enrollments by campus
Click to open program by program
The digital campus grows 18% per cycle and already accounts for a quarter of the base.
Classes in the slice
One row per class opened in the cycle
Class
Program
Enrolled
Fill rate
Dropout
Delinquency
Revenue/mo
T-2026.2-644 · Full-timeDowntown Campus · Grad and MBA
Business Administration
40/40
100%
9.0%
21.2%
$33K
T-2026.2-803 · FlexibleDowntown Campus · Online
Business Administration
33/50
66%
15.8%
4.1%
$33K
T-2026.2-280 · FlexibleNorth Side Campus · Grad and MBA
Education
23/35
66%
10.5%
3.2%
$16K
T-2026.2-106 · EveningNorth Side Campus · On campus
Education
32/40
80%
2.5%
3.6%
$29K
T-2026.2-584 · EveningCoastal Campus · Hybrid
Tourism and Hospitality
23/40
57%
7.0%
7.6%
$20K
T-2026.2-698 · FlexibleCoastal Campus · On campus
Tourism and Hospitality
44/60
73%
24.9%
9.2%
$34K
T-2026.2-530 · MorningInland Campus · On campus
Agronomy
23/40
57%
11.7%
6.8%
$22K
T-2026.2-911 · EveningInland Campus · On campus
Agronomy
25/40
63%
2.2%
15.8%
$16K
Hospital BI
Clinical Operations and Billing · Hospital Network
Healthcare
Clinical Operations and Billing · Hospital Networkgold_assistencial · HIS + ERPRefreshed 07/08 05:35Illustrative data
Report pages
Filters
Period
Jul/2026▼
Payer
All▼
Acuity
Elective and urgent▼
Hierarchy
Unit
Specialty
Encounter
Unit · consolidated
Occupancy rate+2.4 p.p.
84.6%
operational beds
Average length of stay-0.6 day
4.2 days
all specialties
Claim denial-2.3 p.p.
6.8%
on billing submitted
Revenue per bed-day+$180
$2,140
net of claim denial
Admissions this month
3,482
Readmission within 30 days
7.1%
Bed turnover
6.2
Billed accounts
18.4K
Claim denial over billing
Monthly percentage, against the 5% target
Claim denialTarget
9.7%7.9%6.3%4.6%
AugSepOctNovDecJanFebMarAprMayJunJul
Billing by unit
Click to open by specialty
The South Side unit concentrates 34% of revenue and 41% of claim denials: account audit under review.
Encounters in the slice
One row per hospital account submitted
Encounter
Specialty
Payer
Billed
Claim denial
Length of stay
Account status
ATD-986841South Side Hospital · Ambulatory
Cardiology
SulAmérica
$38K
5.5%
-
Partial denial
ATD-976723South Side Hospital · ICU
Cardiology
Out-of-pocket
$32K
19.2%
2.6 d
In appeal
ATD-956018Central Hospital · ICU
Oncology
Amil
$26K
11.0%
4.4 d
In appeal
ATD-998895Central Hospital · Urgent
Oncology
Amil
$16K
11.7%
6.3 d
In appeal
ATD-962073North Hospital · Urgent
Internal medicine
Saúde Aliança
$21K
11.7%
14.1 d
In appeal
ATD-943914North Hospital · Ambulatory
Internal medicine
Saúde Aliança
$38K
4.5%
-
Partial denial
ATD-962656East Maternity · Urgent
Obstetrics
Unimed regional
$18K
8.9%
13.0 d
In appeal
ATD-969927East Maternity · Urgent
Obstetrics
Unimed regional
$13K
10.8%
6.5 d
In appeal
Want a dashboard like these on your data?
Tell us your scenario and get a diagnosis and a proposal with an investment range within a few business days.