Portfolio

Basem Hamada

Data Analyst · Cairo, Egypt

Working across SQL, Python, Excel, Tableau and Power BI — from cleaning messy source tables to shipping dashboards people actually use.

-- what I actually do, most days
SELECT skill, years_practiced
FROM basem.toolkit
WHERE skill IN ('SQL', 'Python', 'Excel', 'Tableau', 'Power BI')
ORDER BY impact DESC;

-- 5 rows returned 
# cleaning + shaping the data
import pandas as pd

df = pd.read_csv('raw_sales.csv')
df = df.dropna().drop_duplicates()
df['revenue'] = df.price * df.qty

# ready for the dashboard 
' quick pivot before it goes to SQL
=SUMIFS(Sales[Revenue],
  Sales[Region], "Cairo",
  Sales[Month], "Aug")

=VLOOKUP(A2, Products!A:D, 3, FALSE)
=IFERROR(, "check source") 
Rows cleaned128k
Dashboards shipped6
Avg. query time-42%
scroll for the query results
SQL
Python
Tableau
Power BI
Excel
Basem Hamada
📍 Cairo, Egypt
open to data roles
SQL Python Tableau Power BI Excel SQL Server Pandas ETL
01

SELECT * FROM projects;

6 rows
Data Cleaning in SQL
#01

Data Cleaning in SQL

Raw housing data, transformed in SQL Server into something actually fit for analysis.

SQL ServerETL
View query →
COVID-19 Data Exploration
#02

COVID-19 Data Exploration

Exploring global COVID-19 case and vaccination data using SQL Server.

SQL ServerAnalysis
View query →
Tableau Dashboards
#03

Tableau Dashboards

Interactive Tableau dashboards built on top of the COVID-19 analysis.

TableauDashboard
View dashboard →
Movie Correlation with Python
#04

Movie Correlation with Python

Investigating which variables actually move the needle on box-office revenue.

PythonPandas
View notebook →
Amazon Price Scraper
#05

Amazon Price Scraper

Scraping live product data from Amazon to track and analyze pricing trends.

PythonWeb Scraping
View notebook →

Every dashboard here stands on a Computer Engineering foundation — the kind of grounding that turns analysis from a guess into an engineered decision.

02

SELECT * FROM contact;

1 row
Location
Cairo, Egypt
Phone
Email
Social