DH

Doaa Hilal

Data Analyst

Data Analyst with hands-on experience in Power BI, Excel, SQL, Python, Databricks, and Web Scraping. Skilled in data cleaning, data modeling, reporting, ETL, KPI tracking, and Exploratory Data Analysis (EDA). Focused on building interactive dashboards and transforming raw data into actionable business insights.

Expertise

Data Analysis & Visualization

Expert in building interactive dashboards, tracking KPIs, and performing exploratory data analysis to transform raw data into actionable business insights.

Power BIData VisualizationKPI TrackingBusiness InsightsReporting

Data Cleaning & Transformation

Proficient in data cleaning, modeling, and ETL processes using various tools to ensure data integrity and prepare datasets for analysis.

Data CleaningETLData TransformationExcel Power QueryPython Pandas

Database & Scripting

Skilled in SQL for database querying and Python for data manipulation and web scraping, including working with large datasets in Databricks.

SQLPythonDatabricksWeb ScrapingData Extraction

Featured projects

Egyptian Cuisine Restaurants Project

Cleaned and analyzed a large dataset (+11 million rows) using Databricks to ensure data integrity. Built interactive Power BI dashboards covering sales, refunds, and customer behavior.

Impact: Created DAX measures for KPIs and presented recommendations to improve low-performing branches, increase digital payment usage, and promote top-selling products.

HR Dashboard

Cleaned and transformed HR data using Excel Power Query. Utilized Pivot Tables and calculated columns to support KPI tracking and business reporting.

Impact: Built an Excel dashboard to analyze employee status, exits, and HR trends, and fixed inconsistent gender values by creating a correction table.

Call Center Data Cleaning & Analysis

Cleaned and transformed a dataset of 10,000+ customer records using Pandas.

Impact: Removed duplicates and standardized data to prepare the dataset for analysis and reporting.

Career highlights

2026

Co-organized the 'Building with AI' event and coordinated communication between 15+ team members as a PR Trainee.

2024

Managed a high-volume workload of 100+ daily data entries with accuracy and improved cancer patient data processing using Excel formulas.

2024

Graduated with Medical Registration & Statistics from Alexandria Institute of Health Technology.