Freelancer profile translated to English.

Description

# Business & Data Analyst | Power BI Specialist

Your data tells a story.

I help you read it.

Excel, ERP, business tools — it's all there, but nothing connects.

That's exactly where I come in.

I'm Aurélien, a Business & Data Analyst. I help companies transform their data into simple, reliable steering tools that are actually used by teams.

What I concretely build for you

My missions primarily revolve around Power BI and financial and operational data:

Financial Reporting: Revenue tracking (YOY/YTD), customer DSO and payment term analysis, external expenses & P&L tracking, securing accounting rules

Production Monitoring: Operational dashboards tailored to your business

Reporting Automation: No more Excel files to update manually every month

The result: dashboards that your teamsactually openon Monday morning.

What sets me apart

Before working with data, I spent over 10 years in sales and marketing roles. This background allows me to quickly understand your business challenges — and not deliver a technical tool disconnected from your reality.

I also work on structuring your data architecture (**SQL Server, Microsoft Fabric, Azure**) to lay solid, scalable foundations, not just patches.

Want to discuss it?

Tell me where you are — even if your situation is unclear, that's often where I'm most useful.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent
German
Conversational

Workplace preferences

Can work on-site

Bordeaux (up to 50km), Paris (up to 10km), Toulouse (up to 10km)

Ervent Aquitaine - Industrie - CVC
Business & Data Analyst BI - Freelance Mission
CIVIL ENGINEERING
February 2026 - March 2026 (1 month)
Bordeaux, France
Recalled by the client after the internship to enrich and validate the Power BI reports delivered. The mission significantly exceeded the initial scope.

What I accomplished:
Revenue Report— functional redesign of the Customer & Accounts Revenue tab with double complementary reading (fixed structural matrix + slicer-driven dynamic matrix), DAX safeguard logic, contextual dynamic titles. Complete harmonization of revenue breakdown on a single reference column.

CE & P&L Report— implementation of an N/N-1/N-2 temporal pattern via Calculation Group and disconnected slicer, correction of fake suppliers by business flag, robust propagation of suppliers by accounting entry (removal of FillDown), modeling consistent with SAGE accounting reality.
DSO & customer receivables — complete reconstruction of the Official_Payment_Date, secure bank parsing, disambiguation of netting via composite key (customer + fiscal year), integration of a business Excel file as the source of truth for customer payment terms, addition of source date traceability.

✅ Model validated and documented, reusable patterns formalized
✅ Reports approved by the financial department

Stack:Power BI · DAX · Power Query · Tabular Editor · SAGE 100 · Batigest · Excel
Power BI Dashboard Power BI DAX Sage 100 Accounting DSO
Ervent Aquitaine - Industrie - CVC
Business & Data Analyst BI
CIVIL ENGINEERING
April 2025 - October 2025 (6 months)
Bordeaux, France
Core Mission:structure ERP data and transform it into steering tools actually used by management, production, and sales teams.

What I built:

**Power BI Reports covering Revenue**, margins, inventory, quality, and operational efficiency. Complete Power Query pipelines — ERP data cleaning (HFSQL via ODBC), table merging (invoicing, production, components), price historization, anomaly management. Star schema data models with complex DAX measures and dynamic dashboards filterable by customer, period, and product.

Financial Reporting (CE & P&L):tracking of external expenses (6xx), detailed analysis of raw material and supply purchases (601/602/607), reporting consistent with Sage 100 accounting, N/N-1/N-2 tracking by date or full year, analysis by supplier and expense category.

Production Monitoring:daily batch monitoring dashboard (Gaine, Plenum) with actual progress rate calculation, identification of blocked batches, alerts on delays, automatic historization via daily snapshots, and workload tracking by workgroup.

Results:
✅ Reduction of reporting time from several hours to a few minutes
✅ Validation of key indicators (material cost, margin, forecast)
✅ Support towards a data-driven culture

Stack:Power BI · Power Query · DAX · SQL/HFSQL · Excel · Sage 100 · Scrum
Data Modeling / DAX Power Query (ETL) Power BI Dashboard Sage 100 SQL
EssilorLuxottica
Sales Representative
February 2022 - July 2024 (2 years and 5 months)
Management and development of a B2B customer portfolio in the optical sector.
Analysis of sales performance and product mix optimization.
Contribution to customer loyalty and revenue growth.
Results:
Revenue growth (+1.7%) and improved customer satisfaction.
Reduction of disputes related to billing follow-up and commercial operations.