Ashraf Aboalyazid
Data Engineer | Data Analyst
I build practical data solutions with SQL, Python, Excel, Power BI, and modern data workflows. My background in analysis helps me turn raw data into trusted insights, while my engineering focus pushes me toward cleaner pipelines, stronger models, and more reliable reporting systems.
Current Focus
Building scalable data foundations with an educator's mindset
I am growing from a strong analytics background into data engineering by improving ETL thinking, data modeling, workflow design, and the clarity of the systems I build and explain.
About Me
From analytics to engineering, with practical data thinking
I built my foundation in data analysis, where I learned how to explore datasets, build dashboards, and turn business questions into useful insight. Today, I'm building on that experience as I grow into Data Engineering with a stronger focus on structure, reliability, and practical data workflows.
Analytics foundation
My background in data analysis strengthened how I work with SQL, Excel, Power BI, and business-focused reporting to turn raw information into clearer decisions.
Engineering direction
I am actively growing toward Data Engineering by focusing on ETL thinking, data modeling, data cleaning, and building more dependable workflows with Python and modern data tools.
Teaching and mentoring
I teach programming and technical concepts, supporting students through structured learning. This teaching mindset helps me simplify complexity and communicate clearly with both technical and non-technical audiences.
Skills
Technical strengths across data, engineering, and communication
My toolkit reflects both analytical precision and a continuous-learning mindset, with practical experience in data preparation, reporting, automation, version control, and workflow design.
Data Engineering
Data Analysis & BI
Programming
Tools & Workflow
Projects
Projects that showcase practical analytics and engineering thinking
These portfolio pieces reflect the kind of work I enjoy most: solving business problems with clean data, thoughtful analysis, structured reporting, and scalable data practices across SQL, Python, and BI tools.
SQL Data Cleaning Project
Cleaned and standardized raw records using SQL techniques for null handling, duplicate removal, formatting consistency, and improved downstream usability.
Customer Churn Analysis Dashboard
Built an interactive churn dashboard to uncover customer retention trends, highlight risk segments, and support better decision-making with clear KPI tracking.
ETL / Data Pipeline Project
Created a simple ETL workflow that extracts data, transforms it into a cleaner structure, and loads it for reporting and operational use with repeatable steps.
Services
Practical data services for reporting, workflow clarity, and usable results.
I focus on practical data work that turns messy tasks into clearer workflows and more reliable reporting.
Dashboard & Reporting Support
Building clean Excel and Power BI dashboards that highlight KPIs, trends, and business insights in a way stakeholders can use quickly.
Excel Cleanup & Automation
Improving spreadsheet structure, reducing repetitive work, and turning manual reporting tasks into cleaner, more maintainable workflows.
SQL Data Cleaning & Validation
Cleaning raw tables, validating data quality, and creating reusable SQL logic that supports analysis, reporting, and more reliable decision-making.
Technical Guidance & Mentoring
Explaining SQL, Python, Excel, and core data concepts in a clear, structured way that helps learners build confidence and understanding faster.
Certifications
Learning milestones that support my transition into stronger data work
Verified credentials and public learning milestones connected to my professional development in data analysis and engineering.
ALX Africa
Data Analytics Certificate
Data Analysis
Excel
SQL
Python
Data Cleaning
Data Visualization
Analytical Thinking
Problem Solving
View Certificate
DataCamp
SQL Associate
SQL
Joins
Aggregations
Filtering
Query Writing
Relational DBs
Data Extraction
Data Manipulation
View Certificate
McKinsey & Company
Forward Program
Communication
Problem Solving
Adaptability
Leadership
Critical Thinking
Teamwork
Productivity
Decision Making
View Certificate
DataCamp
Data Engineer Associate
Data Engineering
ETL
SQL
Python
Data Pipelines
Data Transformation
Data Modeling
Workflow Thinking
View Certificate
Journey
From analysis to engineering with a focus on clarity and impact
My journey is shaped by curiosity, steady technical growth, and a genuine interest in making data work better for people.
Started with data analysis
Built a strong foundation in reporting, dashboards, KPI tracking, and business insight generation through hands-on work with structured datasets.
Strengthened technical depth
Expanded my toolkit with SQL, Python, Pandas, NumPy, and better data cleaning practices to move beyond reporting into more scalable problem solving.
Shifted toward data engineering
My focus is now on ETL, data modeling, workflow design, and building reliable data systems that support decision-making with consistency and confidence.
Continued teaching and simplifying
Alongside technical growth, I continue teaching programming, mentoring students, and breaking down technical concepts into approachable explanations.
Contact
Let's connect around data, engineering, and meaningful problem-solving
I am open to opportunities where I can contribute as a Data Engineer or Data Analyst, keep learning through meaningful projects, and help teams turn complex data into clear and useful outcomes.