01 / What happened?
P&L actual
Budget
Previous month
Previous year
P&L
Intelligence
Understanding profitability
to support better decisions.
Executive P&LIllustrative
Net revenue€6.84M
Gross margin57.2%
EBIT6.0%
JANAPRJULOCTDEC
A profitability intelligence system designed to explain what changed, why it changed, and what the business should do next.
02 / Why?
Revenue & mix
COGS
Operations
Marketing & structure
03 / What next?
Short-term corrections
Medium-term improvements
Long-term profitability
Executive P&L
Actual · FY2026 · Synthetic reconstruction
LineValue% NR
Gross revenue€7.48M100.0%
Discounts−€0.47M−6.3%
Returns & cancellations−€0.17M−2.3%
Net revenue€6.84M91.4%
Product cost / COGS−€2.93M−42.8%
Gross margin€3.91M57.2%
Logistics−€0.47M−6.9%
Incidences / recovery−€0.11M−1.6%
Marketing−€0.60M−8.8%
Contribution margin€2.73M39.9%
Payroll−€1.74M−25.4%
Fixed costs−€0.58M−8.5%
EBIT€0.41M6.0%
Project statusCurrent stage — Power BI reconstruction
The analytical logic is reconstructed from a real business problem. All figures shown are synthetic to avoid exposing confidential company data.
Next → Data model · DAX · Executive dashboardVolume · Price · Discount · Channel mix
COGS · Supplier changes · Category mix
Logistics · Returns · Incidences · Recovery
Marketing · Payroll · Fixed costs · Productivity
Questions explored
- 01
Is the business generating sustainable profit?
- 02
Which drivers explain month-to-month changes in EBIT?
- 03
What should each business area do next?
Data & methodology
Inputs
Sales & discounts
COGS
Logistics & incidences
Marketing
Payroll & fixed costs
Analysis
P&L modelling
Variance analysis
Margin decomposition
Budget comparisons
Tools
Power BI · DAX
SQL thinking
Data modelling
Synthetic data
From insight to action
Reporting profitability is only useful if it changes decisions. The goal is to connect financial outcomes with the commercial, operational and structural levers that can improve them.
Understand the result.
Find the driver.
Decide what to change.
This project demonstrates
← Back to projectsBusiness Intelligence · P&L Analysis · Data Modelling · DAX · Business Strategy