01SQL / DuckDBTableauPython
E-commerce Profit Leak Analysis
Business question
Where is margin being destroyed?
Key metric
€214,041
Profit
Margin leak is concentrated in Electronics / EU, and high discount levels systematically reduce margin.
Open to Data Analyst / BI Analyst alternanceParis / Île-de-France
Executive Analytics Portfolio
Zakaria Maachou
Data Analyst / BI Analyst
I turn raw data into dashboards, business diagnostics and actionable recommendations.
SQL, Tableau, Python, BI reporting
Profit Leak Analysis
Where is margin being destroyed?
Orders
12K
Revenue
EUR 2.05M
Margin
10.42%
Main insight
Margin leak is concentrated in Electronics / EU, and high discount levels systematically reduce margin.
Orders analyzed
12,000
Profitability model
Revenue analyzed
EUR 2.05M
E-commerce profit leak
Users in funnel
3M+
Conversion diagnosis
VIP revenue share
75.4%
RFM segmentation
Case studies
Business questions turned into measurable recommendations.
Each project keeps the line from raw data to stakeholder-ready output: SQL exploration, dashboarding, main insight, and a practical action plan.
02SQL / DuckDBTableauPython
E-commerce Funnel Analysis
Business question
Where do users drop before purchase?
Key metric
View-to-cart
Primary friction
Scope: More than 3M users
The main friction occurs before add-to-cart — users view products but fail to engage with the cart step, indicating a product-page or UX conversion gap.
03PythonpandasCRM analytics
Customer Segmentation RFM
Business question
Which customers should CRM prioritize?
Key metric
27.9% customers · 75.4% revenue
VIP share
Revenue is highly concentrated: VIP customers (27.9%) drive 75.4% of revenue, while Lost customers (23.62%) contribute only 2.95% — clear CRM prioritization signals.
Skill proof matrix
Tools are presented as evidence, not keyword lists.
01
Data & BI
Used across SQL exploration, DuckDB models, Tableau dashboards, and Python checks.
SQLDuckDBTableauExcelPython pandas
02
Business Analytics
Applied to profitability analysis, funnel drop-off diagnosis, and KPI reporting.
KPI trackingreportingdashboardsprofitability analysisfunnel analysis
03
Marketing / CRM Analytics
Connected to acquisition, CRM segmentation, conversion analysis, and stakeholder reports.
Google AnalyticsSearch ConsoleLooker StudioCRM segmentationconversion analysis
Analytics process
A repeatable path from question to action.
01
Question
Frame the business problem before touching the dashboard layer.
02
SQL model
Build reliable metrics with SQL, DuckDB, Python, and clear assumptions.
03
Dashboard
Turn the analysis into focused Tableau views and stakeholder-ready KPIs.
04
Recommendation
Translate the pattern into a decision: pricing, funnel, or CRM action.
Experience
Business, data & BI experience.
SideCare
Assistant Business Analyst
08/2025 - 08/2026
- Single Source of Truth, data quality and KPI structuring
- KPI automation: ARR, churn, NRR, claims/premiums
- Looker dashboards for Sales, Ops, CSM and management
- Data anomaly audits and corrective process recommendations
Biofa France
Assistant Marketing Digital & Reporting Data
09/2024 - 08/2025
- KPI tracking: traffic, acquisition, engagement, conversion, campaign performance
- Dashboards and reporting
- Channel performance analysis
- Actionable recommendations
Vapoa
Stagiaire Marketing Digital
05/2024 - 09/2024
- Contribution à la gestion et l’optimisation de campagnes de marketing digital
- Suivi des performances des actions marketing et préparation de reportings synthétiques
Contact
Available for Data Analyst / BI Analyst alternance.
Paris / Île-de-France