Tableau Desktop — Analytics_Report_2023-2025.twbx
Undo
Redo
Dashboard
Refresh
📊 Show marks card
🔍 Show legends
Data
📐 Fields
Project IDAbc
ClientAbc
Service TypeAbc
Project LeadAbc
StatusAbc
Start Date📅
Year📅
Quarter📅
📏 Measures
Budget excl. VAT#
Billed Revenue#
Net Margin#
Duration Days#
NPS Score#
Nb Projects#
Margin Rate %#
⚙️ Parameters
Min margin threshold
Reference year
🖥️ Dashboard — Creative Agency Analytics Overview 2023–2025 ✓ Cleaned data · 869 projects
📐 Commercial Performance — Creative & Digital Agency
Design & Digital Agency · London · Analysis 2023–2025 · Last updated: Feb 12, 2026
████████████
869 projects analysed
✓ Verified source
Total Billed Revenue
4.82M€
▲ +22.4% vs 2024
Avg. Net Margin
31.4%
▲ +4.2 pts
Closed Projects
869
▲ +31.8% vs 2024
Avg. NPS
8.3/10
▲ +0.9 pts
📈 Monthly Billed Revenue by Service Type (2023–2025)
0 50k 100k 150k Jan'23 May'23 Jan'23 Mar'24 2023 2024 2025 Mobile App UI/UX Branding Jun 2024 Mobile App : 112 400€ UI/UX : 98 700€
🧊 Client Revenue Breakdown (treemap)
CLIENT-002 892k€ CLIENT-008 612k€ CLIENT-047 398k€ CLIENT-006 CLIENT-043 CLIENT-021 CLIENT-028 CLIENT-031 Others (n=861) CA faible CA élevé Size = Revenue · Color = service type
📊 Net Margin by Service Type
Mobile App 34.8% Design System 30.7% UI/UX 28.5% Motion Design 25.6% Branding 23.1% Obj 25%
🔵 Duration vs Margin (by Project Lead)
Duration (days) Marge % Lead A Lead B Lead C Leroy
⭐ NPS Score by Year
0 5 10 7.5 2023 8.1 2024 8.3 2025 📈 +0.8 pts sur 3 ans
📅 Project Duration by Type (box plot)
Mobile App Design sys. UI/UX Branding 0 50j 100j 150j 💡 Design System = longest duration but highest margin
📋 KPIs by Project Lead
Chef projet Projets CA Marge NPS
████████ 284 1.72M€ 34.8% 8.7
████████ 231 1.41M€ 32.1% 8.2
████████ 218 1.22M€ 29.8% 8.0
███████ 136 0.47M€ 24.3% 7.8
💡 Recommendation: Lead #4 below margin threshold (25%). Consider coaching or reassignment to shorter projects.
🔽 Filters
Year 3 sel.
2023
2024
2025
Service Type Tout
Mobile App
UI/UX
Branding
Design System
Motion Design design
Project Lead 4 sel.
████████
████████
████████
███████
Status
Completed ✓
In Progress
Cancelled
🔍 Filtered results
869 projects · 4.82M€ revenue
✓ Validated data
Sheet 1
Sheet 2
Marge × prestation
NPS Trend
📊 Dashboard
+ New Sheet
● Connecté — Analytics_Report_2023-2025.xlsx | 869 lignes · 11 champs | Last updated: Feb 12, 2026 · 10:18 Tableau Desktop 2024.3
🔒 Données fictives — reconstituées à partir de missions réelles · NDA client