You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Lilia ZaouiLZ

Lilia Zaoui

Data Analyst | HR Data | Power BI Reporting 📊

€500/day
Lyon, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Lilia

HR Data Visualization: Dashboards & Reporting for SMEs


Business Leaders,do you already have HR data (absenteeism, turnover, payroll, etc.)? It's often scattered across Excel, HRIS, or accounting tools.

Result:Hard-to-read tracking sheets, a lot of manual reporting, and little visibility for decision-making.

I am an HR Data Visualization consultant, and I help companies createclear, visual, and actionable HR dashboards.

🎯 My Mission: Transform your data into management indicators.


📊 Services:
  • Creation of HR Dashboards & Social Reporting(headcount, payroll, gender equality, etc.) from Excel or HRIS for clear and regular management.
  • HR Data Visualization (Power BI / Excel):Transforming raw data into readable visuals ready to be shared with management.
  • Automation of HR Reporting:Reducing time spent on Excel with easy-to-update reports.
  • Pedagogical Support for Adoption:Short training sessions to understand indicators, read visuals, and become autonomous.

✨ Benefits:

  • Clear vision of the social situation
  • Support for strategic decision-making
  • Anticipation of HR risks
  • Sustainable time savings for management and HR

Tailored approach, designed for the constraints of VSEs and SMEs:simplicity, efficiency, controlled budget.

✅ Example Mission:


✖️ Scattered data and over a day per month spent on Excel reporting.
✔️ Creation of an automated HR dashboard from existing data.
🚀 Result: Reporting time divided by 8, -12% absenteeism in 6 months, management that steers faster and more confidently.

📩 I would be delighted to understand your context and support you in managing your human capital.
  • French

    Native or bilingual

  • English

    Conversational

Can work on-site
Lyon (up to 50km), Paris (up to 50km), Montpellier (up to 50km), Bordeaux (up to 50km), Genève (up to 50km)

Experience

  • DATALISIA - Votre partenaire en Datavisualisation
    Data Analyst
    December 2025 - Today (8 months)
    - Context and business needs audit
    - Data collection, cleaning, modeling (SQL, Python, Excel)
    - Design of Power BI dashboards (DAX, PowerQuery, PowerDesktop)
    - Interpretation, trend analysis, optimization
    - Documentation, user training, and support

    📊 Projects completed: Reporting (Turnover, Headcount Dynamics, Forecasts), HR POC Support (Data Consolidation Tool: Grist, Streamlit), ETL (Populating National Directory via Python)
    Microsoft Power BI HR Data HR Reporting Data Visualization
  • Projets professionnels Data Analyse
    Data Analyst
    May 2024 - December 2025 (1 year and 7 months)
    Lyon, France
    - Collection, cleaning, and manipulation of datasets: Excel, SQL, Python
    - Data visualization via Power BI
    - Interpretation, trend analysis, optimization

    📊 Projects: BI, Business Analysis, Activity Monitoring, Logistics, Human Resources
    Microsoft Power BI SQL Data Collection Data Visualization Data Analysis

Recommendations

Be the first to recommend Lilia

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Advanced Power BI
    FMC DIGITAL
    2026
    - Analyse et préparation de données (Power Query) - Modélisation et analyse avancée (Power BI Desktop) - Visualisation et reporting intéractifs - Publication et collaboration (Power BI service) - Gestion de projet BI - Préparation certification Microsoft PL300
  • Advanced Analytics: HR DATA UE
    CNAM
    2026
    - Récolter des données RH - Mener une enquête RH en ligne - Réaliser des traitements statistiques sous Excel (corrélation, Khi2, régression, analyse multidimensionnelle ...) - Interpréter les résultats pour éclairer les décisions RH

Certifications

Skill set

Categories