Freelancer profile translated to English.

Description

Data Analyst | Expert Power BI & Fabric | 5 years of experience

Hello, I'm Dylan, an expert Data Analyst in **Power BI & Fabric**. I help companies, from CAC 40 to SMEs, steer their business and profitability by designing **custom dashboards**.

My intervention covers the entire value chain of your Data projects:

🎯 1. Scoping & Needs Analysis

I don't start coding without understanding your business. I qualify your challenges (Finance, Commerce, Operations) to define the truly relevant indicators (KPIs).

⚙️ 2. Architecture & Data Engineering (The Engine)

Reliable data is the essential prerequisite. I design robust and automated architectures:

- Data Warehouse Modeling (Star Schemas).

- Complex ETL development (Azure, Microsoft Fabric, Python, SQL).

- Data cleaning and structuring.

🎨 3. Dataviz & Design (The Rendering)

A useful report is a used report. I combine the power of Power BI with Figma design to deliver ergonomic, aesthetic, and intuitive dashboards for your users.

🏆 RECENT PROJECTS & RESULTS

🔹 Ratp (Strategy): Creation of a dashboard for the COMEX. Complex Finance/Jira reconciliation to steer project portfolio profitability.

🔹 Goron (Finance): Centralization of management control. Automation of margin calculation per site and identification of loss areas.

🔹 Hutchinson (Purchasing): Data Quality & MDM. Mass cleaning (Python/SQL) to transform Ivalua into a Master Supplier Database.

🔹 Creditsafe: Complete overhaul of the BI architecture and data flow optimization (+40% processing speed).

💻 TECHNICAL STACK

- Viz: Power BI, Figma (Design System)

- Data: SQL (Expert), Microsoft Fabric, Azure, Python (Pandas)

- Tools: Git, Jira, Semarchy

Need to structure your data or create impactful dashboards?

Let's discuss your project. Response within 2 hours.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km), Marseille (up to 50km), Lyon (up to 50km), Bordeaux (up to 50km), Lille (up to 50km)

RATP
Data Analyst Power BI
TRANSPORTATION
December 2025 - January 2026 (1 month)
Paris, France
Situation: At RATP, the Executive Committee (COMEX) lacked a consolidated view to manage its strategic project portfolio, struggling to correlate operational progress (tracked in Jira) with actual budget consumption and team capacity.
Task: Develop a centralized Executive Dashboard allowing management to oversee global delivery, control costs, and optimize human and financial resource allocation.
Action: Design of an ergonomic user interface prototyped on Figma to ensure Data Storytelling suitable for decision-makers, coupled with advanced data engineering on Power Query (M) to reconcile heterogeneous sources (Jira, Finance) and complex DAX modeling to project workload plans and precisely measure variances between planned and actual consumption.
Result: Deployment of a strategic management tool offering a 360° view of project portfolio health, facilitating COMEX budget decisions and ensuring reliable enterprise-wide delivery cycles.
Microsoft Power BI Reporting Business intelligence Power Query DAX
CEVA Logistics
Data Analyst Power BI
LOGISTICS AND SUPPLY CHAIN
December 2025 - December 2025
Paris, France
Situation: The group faced a need to rationalize costs within its application portfolio, in a context where financial data was scattered across multiple heterogeneous systems.
Task: Design a centralized solution to provide clear visibility into expenses and offer budget optimization levers to IT management.
Action: Development of a comprehensive Power BI report ensuring connection and aggregation of data from various sources, as well as modeling indicators to isolate critical expenditure items.
Result: Successful identification of the most costly applications and provision of a decision-making dashboard enabling concrete optimization of the group's IT expenses.
Microsoft Power BI Reporting Business intelligence
Goron
Data Analyst Power BI
PUBLIC SAFETY
November 2025 - January 2026 (2 months)
Paris, France
Situation: The financial management of the group's 5 entities relied on heterogeneous manual reports, making a reliable consolidated view impossible and preventing accurate calculation of operational profitability on a "site-by-site" basis.
Task: Design a centralized BI solution for General Management and Management Control, aiming to automate margin tracking and provide decision-support indicators to rationalize operating costs.
Action: Construction of a unified data model integrating multiple sources, complex management of financial business rules, and development of Power BI dashboards focused on analyzing revenue and direct cost variances.
Result: Provision of a clear view of profitability per site, enabling management to quickly identify loss areas (Top/Flop) and proactively manage corrective actions to optimize the group's gross margin.
Microsoft Power BI Reporting Business intelligence SQL