Hafsa EL ATOUANI

Data Analyst & BI Engineer

Transforming complex data into actionable insights through advanced analytics, interactive dashboards, and business intelligence solutions. Specialized in Power BI, Tableau, and data-driven decision making.

5+
Major Projects
10+
Certifications
4
Languages
Get In Touch Download CV
Avatar illustration at computer

Academic background and qualifications

  1. 09/2022 – 11/2023

    Master's in Applied Computer Methods for Business Management (MIAGE)

    • Côte d'Azur University
  2. 09/2020 – 09/2023

    Engineering program in Applied Computer Methods for Business Management

    • Moroccan School of Engineering Sciences
  3. 09/2018 – 09/2020

    Degree in Information Systems Development

    • IBN SINA (BTS)
  4. 09/2015 – 09/2018

    Bachelor's in Mathematical Sciences and Computer Science

    • IBN TOFAIL University

Professional Experience

  1. Sep 2024 – Present

    Data Analyst — Dawamaghreb

    • Design and automate Power BI dashboards to monitor sales, stock levels, and regional demand trends.
    • Analyze medical and sales data to identify prescribing patterns and market insights, supporting strategic planning.
    • Enable data-driven decisions for supply optimization and marketing initiatives.
    Power BI SQL Server Data Analysis ETL Sales Analytics Medical Data
  2. Oct 2024 – Present

    Data Analyst — Freelance

    • Design interactive BI dashboards (Power BI/Tableau) to support decision‑making.
    • Model and transform data, integrate SQL Server and ETL workflows.
    Tableau Power BI SQL Server Pentaho Talend Data Marts
  3. Aug 2024 – Sep 2024

    Official Surveyor — High Commission for Planning, Morocco

    • Collect accurate and reliable information from citizens.
    • Ensure the confidentiality and accuracy of collected data.
    Data Collection Confidentiality Survey Analysis
  4. Mar 2024 – Sep 2024

    Cybersecurity Analyst — JOBINTECH

    • Monitored and analyzed security threats and vulnerabilities.
    • Implemented security protocols and incident response procedures.
    Security Analysis Threat Detection Security Protocols
  5. Mar 2023 – Sep 2023

    BI Consultant Intern — D&A Technologies

    • Built Tableau dashboards; processed data with Talend; modeled with sqlserver.
    • Contributed to data marts, multidimensional models, and KPI frameworks.
    Tableau Talend MySQL Data Marts
  6. Jul 2022 – Sep 2022

    Data Analyst Intern — OCP Group

    • Manipulated data using Python, R, SQL Server.
    • Used Matplotlib and Seaborn for exploratory analysis and reporting.
    Python SQL Server Matplotlib Seaborn
  7. Jun 2018 – Aug 2018

    Full‑Stack Developer Intern — DEJLA FER

    • Developed a sales website with PHP, HTML, javaScript , MySQL; handled concept to delivery.
    PHP javaScript HTML/CSS MySQL

BI & Analytics

SQL Server

SQL Server

MySQL

MySQL

Power BI

Power BI

Tableau

Tableau

Excel

Excel

Google Analytics

Google Analytics

Looker

Looker

Talend

Talend

Programming

Python

Python

R

R

JavaScript

JavaScript

Java

Java

Spring Boot

Spring Boot

React

React

Angular

Angular

SQL

Platforms

Azure

Azure

Docker

Docker

Git

Git

Jenkins

Jenkins

Red Hat

Red Hat

Windows

Windows

Professional Certifications

Power BI Data Analyst Associate PL300
Google Data Analytics
AWS Cloud Security Foundations
Oracle Analytics Cloud Professional
Red Hat System Administration

Soft Skills

Critical Thinking
Leadership (GDSC)
Collaboration (JLM)

Projects

Dalkia Dashboard 1 Dalkia Dashboard 2

Dalkia Dashboard - EDF Group

Tableau SQL Server Pentaho

Comprehensive energy management dashboard tracking annual obligations, energy consumption (MWhc/kWhc), and regional performance metrics for sustainable energy initiatives.

KPIs:

  • Annual obligation margins by account
  • MWhc consumption by precarious obligation
  • Regional vs obligation performance analysis
  • Classic and precarious amount tracking
Farmer Analytics

Farmer Analytics Dashboard- OCP Africa

Tableau SQL Server Pentaho Tableau Prep

Multi-country agricultural analytics platform covering farmer demographics, crop analysis, and fertilizer usage across 5 African countries with interactive country selection and comprehensive KPI tracking.

KPIs:

  • 5 Countries: Senegal, Nigeria, Kenya, Côte d'Ivoire, Ghana
  • Farmer demographics and gender analysis
  • Fertilizer usage patterns and brand analysis
  • Crop distribution and intercropping insights
Supply Chain

Supply Chain Dashboard - OCP Africa

Tableau SQL Server Pentaho Tableau Prep

Comprehensive supply chain optimization dashboard tracking logistics costs, inventory management, and delivery performance across multiple countries and warehouses.

KPIS:

  • Country-wise cost and delivery analysis
  • Warehouse stock volume optimization
  • Stock turnover and sales volume tracking
  • Logistics and storage cost management
Marketing 1 Marketing 2 Marketing 3 Marketing 4 Marketing 5 Marketing 6

Marketing Campaign Analysis Dashboard - Sopriam

Tableau SQL Server Pentaho Tableau Prep

Multi-dashboard marketing analytics suite featuring engagement tracking, cost analysis, performance monitoring, and conversion optimization across multiple campaign channels.

KPIs:

  • Engagement and interaction analytics
  • Campaign cost analysis and optimization
  • Marketing performance reporting
  • Conversion and performance tracking
ITSM Dashboard

ITSM Dashboard - OCP Group

Tableau SQL Server Pentaho Tableau Prep

IT Service Management dashboard providing comprehensive incident tracking, resolution analytics, and performance monitoring across multiple subsidiaries.

KPIs:

  • Total incidents and resolution tracking
  • Average resolution time analysis
  • Incident categorization and priority management
  • Backlog production responsibility monitoring
IT Dashboard 1 IT Dashboard 2 IT Dashboard 3 IT Dashboard 4 IT Dashboard 5

IT Dashboard - OCP Group

Tableau SQL Server Pentaho Tableau Prep

Comprehensive IT operations dashboard tracking SAP system usage, license management, training activities, and transaction monitoring across the organization.

KPIs:

  • SAP modules usage and adoption tracking
  • Data integration and system connectivity monitoring
  • License allocation and utilization analysis
  • Training completion and transaction volume tracking
Coming Soon

Power BI Dashboard Projects

Power BI DAX SQL Server

Exciting Power BI dashboard projects featuring advanced analytics, interactive visualizations, and comprehensive business intelligence solutions are currently in development and will be available soon.

Coming Soon

Oracle Analytics Cloud Projects

Oracle Analytics OAC Cloud

Oracle Analytics Cloud dashboard projects showcasing data visualization, predictive analytics, and enterprise-level reporting solutions are under development and coming soon.

Get In Touch

Email

hafsaelatouani@gmail.com

Phone

+212 651-209484

Location

Rabat , Morocco