Freelancer profile translated to English.
Back to original languageAbout Pierre
Data Analyst & Power BI Expert
I transform your data into a lever for decision-making and performance
Do you have data everywhere but little clear visibility to steer?
I help companies structure, centralize, and leverage their data to make better decisions, faster — with reliable, automated tools that are actually used by teams.
1. Data Structuring & Architecture (Microsoft Fabric / Azure)
- Audit of your existing data (sources, quality, flows)
- Implementation of Lakehouse / Data Warehouse (Fabric, Azure SQL)
- Multi-source centralization (ERP, CRM, API, Excel files…)
- Design of automated and robust ETL pipelines
- Data modeling oriented towards performance & business usage
- Implementation of a “single source of truth”
2. Visualization & Reporting (Power BI)
- Creation of custom Power BI dashboards (management, ops, finance…)
- UX design focused on rapid decision-making
- Implementation of truly actionable business KPIs
- Access security (RLS, user role management)
- Power BI Service or Embedded deployment
3. Data Portals & Business Applications
- Creation of secure web portals (clients, partners, teams)
- Access to dashboards without a Power BI Pro license
- Development of “Business Apps” (data entry, validation, tracking)
- Custom interfaces adapted to your business processes
4. Automation & Operational Performance
- Workflow automation (alerts, reporting, document generation)
- Tool integration (n8n, Power Automate)
- System synchronization (CRM, ERP, internal tools)
- Implementation of intelligent alerting logic
5. Maintenance & Continuous Improvement (TMA)
- Pipeline and flow monitoring
- Proactive correction before business impact
- Performance optimization (load times, costs)
- Support for evolving needs
Do you have a data project? Let's talk about it
French
Native or bilingual
English
Conversational
Can work on-site
Paris (up to 50km), Toulouse (up to 50km), Bordeaux (up to 50km), Paris (up to 50km), Bayonne (up to 50km)
Experience
- SafranPower BI ConsultantAVIATION AND AEROSPACEAugust 2025 - Today (1 year)Pau, FranceMission:Stabilize and industrialize operational & planning reporting, while providing close Power BI support to managers (scoping workshops, targeted small developments, TMA). Ensure performance and multi-subsidiary access security for broad distribution.Objectives:
- Speed up slow reports (DirectQuery → Import), stabilize refreshes.
- Secure access (RLS) by subsidiary/site/scope.
- Provide workload vs. capacity visibility (Planisware ↔ SAP) to PMO and operations teams.
- Standardize KPIs & definitions (management steering → unified reading).
- Reduce dependency on manual exports / Excel.
Implementation:- Quick audit of workspaces / datasets / DAX, prioritize quick wins.
- Migration from DirectQuery → Import models + star schema, DAX measure optimization (patterns, variables, contexts).
- Granular RLS (entities/subsidiaries/countries) + hardening of roles and groups.
- Cross-referencing Planisware – SAP (planning, orders, resources) via Power Query/SQL; reference tables & business calendars.
- Design of Management views (summary indicators) and operational views (actionable details).
- Manager workshops (needs gathering, KPI validation), mini-rapid developments (adding indicators / filters / pages) and TMA.
Key Results:- Significantly reduced display time (target <5s on critical pages) → adoption in meetings.
- Secure distribution by subsidiary/site (sharing without sensitive info leaks).
- Readable workload vs. capacity steering for PMO and managers (less Excel reprocessing).
- Reduced PBI report evolution time by -70%.
- Consolidated base for future KPIs (punctuality, delays, resource saturation).
Stack:Power BI (Desktop/Service), DAX, Power Query, SQL Server, Gateway, RLS, Planisware, SAP - CdiscountAnalytics EngineerE-COMMERCEOctober 2024 - September 2025 (11 months)Bordeaux, FranceMission:Provide data to other group teams. Enable sales representatives to analyze their sales data and the positioning of their online offers.Objectives:- Encourage sales representatives to be more competitive on the site- Improve the overall quality of offers on the marketplace- Make life easier for sales representatives to retain them on the platform- Enable other teams to analyze data to propose Business Use CasesImplementation:- Development of Power BI embedded directly on the marketplace seller portal- Development of data flows to feed the group's Snowflake platform- Optimization of these reports to encourage sales representatives to use them- Data refinement to facilitate the work of downstream teams
- CritBI ConsultantHUMAN RESOURCESMarch 2024 - June 2024 (3 months)Paris, FranceMission:Enable CRIT to track the career of its temporary workers.Objectives:- Automate monthly reporting to Key Account clients- Target high ROI training funded by the group for temporary workers- Alert Key Account clients when they have not spent their training budgetImplementation:- Training of key users- Development of the Power BI dashboard- Linking data from the training software and the CRIT ERP- Design relevant indicators to calculate the ROI of training paid to temporary workers- Creation of a map on QGIS to classify group agencies by geographical area
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Professional Bachelor's Degree, Data EngineeringUniversity of Pau and Pays de l'Adour2022
- Bachelor's Degree in Economics - Banking & InsuranceUniversity of Pau and Pays de l'Adour2021