1. What was unified
This version combines two strengths: the executive and prescriptive analysis from the report, with operational rules, impact estimates and an implementation plan; and the portfolio experience, with an interactive dashboard, visual narrative, semantic assistant, simulations and web publication.
The result is no longer just a report or just a dashboard. It becomes an executive analytical product, capable of explaining the problem, prioritizing actions and demonstrating technical depth to recruiters, clients, professors and managers.
2. Consolidated diagnosis
The problem is not a lack of sales. The company generated BRL 14,915,600.82 in revenue, BRL 1,521,767.96 in profit and a total margin of 10.20%. However, a relevant portion of growth came from low-margin combinations, especially Furniture, Tables, Bookcases, Home Office and unfavorable logistics.
The most critical point is the commercial stop-loss: 2,651 orders, or 48.24% of the total, show negative profit. These orders generated BRL 4,187,972.73 in revenue, but produced BRL -919,889.80 in net losses. This proves that part of the revenue does not merely contribute little; it actively destroys profit.
3. Embedded prescriptive plan
- Commercial stop-loss: create an order-level profitability check, with blocking rules, logistics surcharge, discount reduction or manual approval for orders below minimum margin.
- Discount policy: apply Category × Segment caps, with a maximum estimated potential of BRL 203,042.36 and projected margin of 11.41%, assuming constant volume.
- Selective repricing: Tables require an estimated 10.76% increase and Bookcases 9.56% to reach a minimum 5% margin, with a combined potential gain of BRL 282,713.34.
- Margin-oriented logistics: minimum order value, logistics surcharge and preferred shipping mode for bulky products and low-profitability combinations.
4. Implementation roadmap
0–30 days
Profitability check, weekly margin dashboard, discount caps, minimum order value and logistics surcharge for Furniture in Home Office.
31–60 days
Reorganize commercial mix, review logistics and run a controlled repricing pilot for Tables and Bookcases.
61–90 days
Scale validated rules, review the product portfolio and consolidate monthly governance with senior management.
5. Privacy, anonymization and LGPD/GDPR
For portfolio publication, the data is presented in aggregated and anonymized form. The objective is to demonstrate methodology, managerial reasoning and an analytical product without exposing personally identifiable information.
The publication follows data minimization and privacy protection principles under Brazil’s General Data Protection Law — LGPD, Law No. 13,709/2018 — and broadly aligns with GDPR-style privacy expectations.
6. Conclusion
The company does not only need to sell more; it needs to sell better. The executive report shows where margin is leaking, and the dashboard shows how that decision can be monitored, simulated and communicated.
The unified version delivers the best of both worlds: executive depth for decision-making and interactive experience for portfolio presentation.