Data Analyst

Youssef Fatohy

Focused on cleaning messy data, building dashboards, and delivering insights that actually matter. Skilled in Excel, SQL, Python, Tableau, and Power BI.

youssefmohamedfatohy@gmail.com linkedin.com/in/youssef-m-fatohy/ github.com/Youssef-Mohamed-Fatohy Tableau Portfolio

Skills & Tools

SQL Python Pandas Matplotlib Seaborn Jupyter Notebook Google Colab Microsoft Excel Tableau Power BI Data Cleaning Data Visualization Dashboard Design Window Functions Exploratory Analysis

Practical Experience

Deloitte Australia — Data Analytics Job Simulation

Forage · April 2026

Completed
  • →Completed a Deloitte job simulation involving data analysis and forensic technology, gaining exposure to real-world consulting workflows.
  • →Built a data dashboard in Tableau and used Excel to classify data and draw actionable business conclusions.
  • →Skills applied: data analysis, data modeling, data visualization, spreadsheet skills, formal communication, and planning.

Projects

Los Angeles Crime Analysis (2020)

Python

Exploratory analysis & visualization of LAPD crime records

View on GitHub
12 PM
Peak Crime Hour
28,625
Friday Incidents
40 yrs
Avg Victim Age
Central
Highest-Crime Area
  • →Extracted hour-of-occurrence from military time and aggregated crime counts; identified 12:00 PM as the single highest-frequency hour.
  • →Built crosstab heatmap of top 10 crime types across all patrol areas to reveal concentration patterns.
  • →Calculated reporting lag categories and identified hotspot addresses (e.g. 600 S Broadway) for targeted patrol planning.
  • →Produced 8 publication-quality visualizations: line charts, bar charts, heatmap, and histogram using Matplotlib & Seaborn.
Pandas Matplotlib Seaborn Jupyter

Superstore Sales — SQL Cleaning & Analysis

SQL

End-to-end data validation, cleaning, and business analytics in SQL

View on GitHub
  • →Detected and removed duplicate order/product combinations using both self-join and ROW_NUMBER() window function methods.
  • →Validated data quality: identified missing values, zero/negative sales anomalies, and inconsistent categorical fields — applied targeted fixes.
  • →Built multi-dimensional analysis covering category/sub-category performance, shipping mode comparison, segment breakdown, and geographic revenue distribution.
  • →Used SUM() OVER PARTITION BY to calculate each category's percentage of regional total without subqueries, and PERCENT_RANK() to identify top-decile transactions.
  • →Parsed raw DD/MM/YYYY date strings in SQL to derive year and calendar quarter for time-based trend analysis.
SQL Window Functions CTEs Aggregations

Superstore Sales — Python Data Cleaning

Python

Transforming raw retail data into an analysis-ready dataset

View on GitHub
~10K
Rows Cleaned
18
Columns
0
Missing Values
100%
Type Correct
  • →Identified a missing postal code for Burlington, VT and resolved it with the correct ZIP (05401) based on city/state lookup.
  • →Standardized postal codes to zero-padded 5-digit strings to preserve leading zeros; converted date columns to proper datetime objects.
  • →Stripped whitespace from all string columns and normalized column names to lowercase with underscores for consistent downstream coding.
  • →Verified final output: zero remaining missing values and correct data types across all 18 columns.
Python Pandas Jupyter

Interactive Tableau Dashboards

Tableau

Multiple dashboards and stories analyzing business trends

Tableau Public
  • →Built interactive dashboards analyzing monthly rates and market trends in Egypt with drill-down capabilities.
  • →Created a gaming market share analysis comparing platforms such as Xbox and Nintendo with visual storytelling.
Tableau Dashboard Design Visual Storytelling

Excel Dashboard Project

Planned

Pivot-table dashboard with slicers, KPI cards, and charts — coming soon.

Education

Data Analytics Scholarship Program

DEPI · 2025 - 2026

  • →Completed intensive training in Excel, SQL, Python (Jupyter Notebook & Google Colab), Tableau, and Power BI.
  • →Worked on multiple hands-on projects covering data cleaning, exploratory analysis, and dashboard creation.

Get in touch

Let's solve a data problem together.

Open to freelance opportunities in data analysis, dashboard creation, reporting, and visualization.

Send Email LinkedIn GitHub