Freelancer profile translated to English.
Back to original languageAbout Jean-Francis
đ Hello, I'm Jean-Francis, Data Analyst & Power BI & Excel consultant with over 5 years of experience. I help companies better leverage their data.
đ„ Power BI & Excel Expert
đ +10 reporting projects using Power BI & Excel
đč What we will build together
- Useful and elegant dashboards (Power BI & Excel), tailored to your needs.
- Your raw data transformed into simple messages that guide your decisions.
- You'll identify at a glance your performance drivers, what's blocking progress, and what needs to evolve.
- I simplify complex analyses so that everyone, from the field to management, can use them.
đč My expertise (with you, step by step)
Power BI
đŻ Interactive and intuitive dashboards to monitor your activities in real-time.
đ No need to redo everything, we'll improve your existing tools to make them faster and clearer.
đĄ I highlight the trends and opportunities that impact your results.
đ Your information is reliable and protected.
đ€ Your teams understand, adopt, and become autonomous.
Excel
đ§č Readable and immediately usable files.
⥠Your reports update automatically, saving you time every week.
đč Why work together?
â Data Analyst (insights, simplification) & BI Consultant (tools, automation).
â +20 successful projects in SMEs, mid-sized companies, and large corporations.
â Your teams easily understand and adopt the implemented solutions.
â Clear and responsive support, from launch to long-term.
đč How does it work? (simple & stress-free)
1ïžâŁ We discuss your context and your needs.
2ïžâŁ We review your existing files/reports (or your goals if you're starting from scratch).
3ïžâŁ You'll know exactly what can be improved, within what timeframe, and what benefits it brings.
4ïžâŁ Progressive implementation with full transparency.
5ïžâŁ I remain available for training, adjustments, and improvements.
Feel free to contact me!
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 20km), Nice (up to 30km)
Experience
- BNP-ParibasData Analyst - Power BI DeveloperBANKING AND INSURANCEJune 2025 - September 2025 (3 months)Paris, FranceTechnical Stack: Power BI, DAX, Power Query (M), Excel, Internal ERP, SQL, GitLab**Objective**: Project management for the implementation of Power BI reporting for the HR Department and General Inspectorate, aiming to automate monitoring processes, strengthen regulatory compliance (European Central Bank), and improve the reliability of data used for internal management.**The overall project objective was twofold**: automate key reporting and increase the autonomy of business teams in producing and analyzing their indicators.**Work Process**:Business workshops were organized with HR and General Inspectorate managers to:
- Gather functional and operational needs.
- Identify Key Performance Indicators (KPIs) necessary for business activity monitoring.
- Define business rules, common definitions, and KPI calculation methods.
- Prioritize needs and plan deliverables.
These workshops led to the creation of a shared KPI repository among teams, ensuring data consistency and traceability.**Results**:- Automation of 5 business processes previously done manually.
- Time savings of 3 hours per day in report production and validation.
- Increased data reliability and harmonization of indicators across departments.
- Improved compliance with European Central Bank audits.
- Successful adoption of Power BI tools by teams through post-project training and support.
- ESG-MBA Stratégie DigitaleInstructor - Power BI Trainer x Data VizCONSULTING AND AUDITSMarch 2025 - June 2025 (4 months)Paris, France**Technical Stack**: Power BI, DAX Studio, DAX, Power Query**Objective**: Transfer immediately applicable skills in a business context, develop a business-oriented analytical approach, and master Power BI as a decision-support tool.As part of the MBA Digital Strategy program at ESG Paris, I designed and delivered a complete module focused on data visualization and Power BI.**The objective was twofold**: transfer immediately deployable skills in a business setting and train students in a results-oriented analytical approach, linked to companies' marketing and operational challenges.The module alternated between foundational theoretical input and guided practical workshops, inspired by real company case studies. The teachings covered the entire process of creating a Power BI dashboard:Understanding the fundamentals of data visualization (Gestalt principles, choosing visualizations based on data types, readability, and visual impact)Mastering the Power BI environment: Power Query, data cleaning and transformation, relational modeling, creating DAX measures, calculated columns, security management (RLS)Applying skills in practical cases: modeling datasets, creating interactive reports, structuring dashboards tailored to business needsThe final assessment was based on professional simulations: each student had to design a Power BI dashboard using marketing data (analyzing campaign and communication channel performance), accompanied by a strategic analysis report.This intervention strengthened my ability to clearly and pragmatically convey technical tools, adapt content to operational audiences, and orient pedagogy towards real-world data usage in businesses.
- VINCI SA
On Malt
Power BI Developer / Data VisualizationTECHFebruary 2024 - October 2024 (8 months)Paris, FranceStack:Power BI, Python, DAX Studio, DAX, Power Query, PostgreSQL, M, GitObjective:Deployment, maintenance, and optimization of Power BI dashboards for the management control and QHSE (Quality, Hygiene, Safety, and Environment) teams.Management Control:Development of 3 reports to meet the specific needs of employees, managers, and project managers. The reports aim to allow users to analyze time spent and valuations of employees on all company projects.QHSE Managers & Directorate:Development, maintenance, and optimization of 12 reports enabling users to track key QHSE indicators (severity rate, frequency rate, etc.).Technical Process:Data is extracted from PostgreSQL databases into the Power Query editor. Most transformations are performed in this editor (M Language). The data is then loaded into Power BI Desktop where the main calculations are performed (DAX, measures, calculated columns, RLS, Modeling). The reports are then published on the Power BI service in a test environment (Workspace) before going into production.The different reports:- Report for Employees: The dashboard allows employees to simplify individual time management on projects and provides more precise tracking of their activities.
- Report for Managers: This report gives managers a comprehensive view of their teams' activity across different projects. It optimizes resource management and project tracking.
- Report for Project Managers: Intended for project managers, this dashboard tracks project progress in terms of allocated budget versus forecasts and actual expenses to anticipate financial discrepancies.
Reviews
Recommendations
+3
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 Degree in Statistical and Stochastic Modeling / Data ScienceUniversity of Bordeaux2020Machine learning Deep Learning Big Data Time Series Data Mining Scoring