Freelancer profile translated to English.
Back to original languageAbout Alice
💼 Power BI & Data Visualization Consultant - Luxury, Retail & Hospitality
⚡️ L'Oréal, Dior, Chanel, and Accor have trusted me
📊 +25 Power BI dashboards developed for large corporations
Why hire me?
I help large corporations leverage their data to make the best business decisions and track their performance.
- 📊 Design and develop your Power BI dashboards: retail, CRM, financial, hospitality, e-commerce
- 🎯 Consolidate and model your data using Power Query, SQL, and Snowflake
- 🔄 Automate your weekly and monthly reporting on Power BI Service
- 💡 Define your KPIs and guide you in reading and analyzing your performance
My skills
1️⃣ Data consolidation and transformation using Power Query, SQL, funnel.io, and Snowflake.
2️⃣ Definition of business needs (objectives and KPIs), definition of strategic and business challenges.
3️⃣ Implementation of dashboards using Power BI & Tableau.
4️⃣ Automation of weekly and monthly reporting using Power BI.
5️⃣ Training on performance analysis.
🙋 My references
- Parfums Christian Dior: European Luxury POS Tracking Dashboard - Sell-Out and Retail analysis (Power BI)
- L'Oréal Luxe: Retail, sell-out, headcount management dashboards (Power BI, Looker Studio)
- Chanel: CRM definition for top client engagement plan (Power Query)
- Barriere: Hotel & Casino Media Investment Tracking Dashboard (Power BI)
- Accor: Hotel E-commerce Tracking Dashboard (Power BI, Snowflake)
- Volkswagen: Dashboard consolidating web, CRM, leads & SEO data (Power BI)
- Marjane: Supplier customer knowledge dashboard (Power BI)
I respond in less than 1 hour, shall we discuss it? ➡️
Microsoft Power BI - Power BI - Power Query
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- DIORBI & Data Visualization Consultant - FreelanceLUXURY GOODSDecember 2025 - February 2026 (2 months)Paris, France
- Client Context: Parfums Christian Dior, Retail division, perfumes and cosmetics sector. The Retail management produced its point-of-sale performance reports on Excel, based on manual extractions from existing Power BI dashboards. A time-consuming, unreliable process that required up to a day per report each month.
- Mission Accomplished: Design and delivery of three Power BI dashboards connected to the Sell-Out and Retail semantic models. The 1st automates the global ranking of POS with N-1 comparison. The 2nd analyzes the performance of renovated POS against a configurable benchmark (size, market, region, period). The 3rd ensures tracking of the Private Collection with two confidentiality levels adapted to internal audiences (mix % for a BU, absolute values for management).
- Expertise and Tools: Power BI, advanced DAX (complex measures, calculated columns, cross-filter context management), semantic modeling, data cleaning in DAX, needs assessment with Retail teams, report automation, data quality, and reconciliation of heterogeneous sources.
- Results: 3 manual reporting processes eliminated, moving from 1 day of preparation per report to automatic monthly updates. The comparative analysis of renovated POS vs. benchmark, which previously required 3 hours of manipulation, is now done in a few clicks with output directly usable for presentations. The dashboards have been deployed to all Retail teams worldwide.
- CHANELBI & Data Visualization Consultant - FreelanceLUXURY GOODSOctober 2025 - November 2025 (1 month)Paris, France
- Client Context: A major luxury house, network of stores in France. The team responsible for the customer engagement plan had no centralized view of actions carried out in stores. Each point of sale maintained its own Excel file, with different structures and formats.
- Mission Accomplished: I defined the requirements with headquarters and pilot stores, then designed a system of connected files via Power Query. A master CRM file consolidates customer data and automatically distributes it to standardized store files. Automation covers the entire cycle: data refresh on click, structured quarterly archiving, code and column locking to protect the model from unintended modifications.
- Expertise and Tools Used: Power Query M (dynamic sources, automated consolidation, matching by unique identifier), advanced Excel (locking, validation, conditional formatting), needs assessment, workshop facilitation, update cycle automation, CRM data quality and standardization, SharePoint.
- Results Obtained: Quarterly reconciliation, which previously required several days of manual manipulation, is now replaced by an automated refresh at the click of a button. The headquarters team has a consolidated view of engagement actions by store and by customer segment.
- L'OréalBI & Data Visualization Consultant - FreelanceLUXURY GOODSJanuary 2025 - September 2025 (8 months)Paris, France
- Client Context: L'Oréal Luxe, Europe division. Teams relied on separate Excel files per country and per hub, with inconsistent structures and formats, lacking a consolidated view of omnichannel data (Sell-Out, Headcount, Beauty Tech) at a global level.
- Mission Accomplished: I led the requirements gathering, KPI definition, and workshop facilitation to scope the solution. I built a dataset centralizing several thousand points of sale, then automated the consolidation and reprocessing of country files via Power Query to feed a multi-page Power BI dashboard covering retail distribution, sell-out, field staff productivity, headcount, and retail design. Automating file processing replaced recurring manual reprocessing with each update.
- Expertise and Tools Used: Power BI, Power Query M, Looker Studio, GCP, automation of multi-country file consolidation, cleaning and reconciliation of heterogeneous data, needs assessment, data quality, Domo to Looker Studio migration.
- Results Obtained: A consolidated and automated Europe-wide view of the Luxe division's omnichannel data. The dashboard allows for identifying productivity per retailer, distinguishing mono-brand and multi-brand logic, and prioritizing commercial actions by axis on key points of sale.
Reviews
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
- Master's degreeAudencia2021Master's degree
Certifications
- Google Analytics Individual QualificationGoogle2022
- Looker StudioGoogle2022