06/28/2026 updated
YF
100 % available
Junior Data Analyst | Python, SQL, Tableau & Power BI
Cairo, Egypt
Only remote
Bachelor of Agricultural Biotechnology (Expected 2027) - Data Analysis ScholarshipAbout me
Results-driven data analyst focused on analyzing data, building dashboards and delivering real doable insights using Excel, SQL, Python, Tableau and Power BI with projects on data cleaning, analysis, and visualization. Seeking part-time or freelance opportunities in data analysis, reporting, and BI.
Data AnalysisData CleansingDatabase AnalysisExcel FormulasExcel Pivot TablesPython (Programming Language)Microsoft Business IntelligenceMicrosoft Power BISalesforce TableauVisual AnalyticsJupyter NotebookpandasMatplotlibData Analytics
Python & Data Analysis Libraries
Solid knowledge of Python with the Pandas, NumPy, Matplotlib, and Seaborn libraries for data cleansing, exploratory data analysis, and the creation of publication-ready visualizations.
SQL & Database Queries
Application of SQL with Window Functions, CTEs, and aggregations for data quality assurance, duplicate detection, and multidimensional business analytics evaluations.
BI & Visualization Tools (Tableau & Power BI)
Creation of interactive dashboards with Tableau and Power BI to visualize market trends, key performance indicators, and analytical insights for stakeholders.
Microsoft Excel
Use of pivot tables, charts, and slicers in Excel for data classification, business data analysis, and deriving actionable conclusions.
Data Cleansing & Data Quality
Systematic cleaning and standardization of large datasets, correction of missing values, anomalies, and inconsistent fields for reliable further processing.
Exploratory Data Analysis (EDA)
Conducting exploratory analyses on real datasets, identifying patterns, hotspots, and statistical anomalies to support data-driven decision-making.
Jupyter Notebook & Google Colab
Using Jupyter Notebook and Google Colab as development environments for data analysis projects and interactive code documentation.
Descriptive & Inferential Statistics
Applying statistical methods such as descriptive statistics, regression analysis, and probability theory to interpret and communicate data insights.
Languages
ArabicNative speakerEnglishFluent
Project history
Verwaltung und Organisation von Vorlesungs- und Kursaufzeichnungen zu Themen wie mikrobielle Gesamtgenomsequenzierung, Primerdesign, Wirkstoffdesign und angewandte Bioinformatik-Workflows. Erstellung und Veroeffentlichung von Social-Media-Inhalten fuer Genotechs Facebook- und LinkedIn-Seiten sowie Koordination von Lernmaterialien fuer Forscher und Studierende.
Exploratory analysis of LAPD crime data using Python and Jupyter Notebook. Identification of 12:00 PM as the peak hour and Friday as the day with the most incidents (28,625 incidents). Creation of a crosstab heatmap of the top 10 crime types and 8 publication-ready visualizations using Matplotlib and Seaborn.
Detection and removal of duplicate orders using self-join and ROW_NUMBER(). Validation of data quality and development of multidimensional business analytics on category performance, shipping mode, and geographic sales distribution using SQL Window Functions.