Sohila Khaled Abbas
BI Developer | Data Analyst | Analytics Engineer · Damietta, Egypt
sohila.k.data@gmail.com · linkedin.com/in/sohilakabbas · github.com/Sohila-Khaled-Abbas
Profile
BI Developer | Data Analyst | Analytics Engineer
BI Developer with nearly two years of freelance experience building Power BI dashboards and decision-ready reporting. My work spans sales and retail, churn, supply chain, e-commerce, customer satisfaction, marketing, HR, and healthcare, with a focus on data preparation, validation, SQL and Power Query, dimensional modeling, and KPI design. I also hold a BSc and build analytics projects, explore Python-based model evaluation, streamline reporting with Excel and VBA, and share practical learning through The Data Tea.
Professional experience
Excel Skills Job Simulation
- Reviewed and organized account sales data, using conditional formatting to surface data-quality issues and meaningful patterns.
- Applied SUM, AVERAGE, IF, COUNTIF, SUMIF, and IFERROR to calculate, summarize, and classify sales information.
- Built PivotTables and charts to examine account performance and annual sales trends, then brought key metrics together in an Excel dashboard.
- Recorded and tested VBA sorting macros, assigning them to Form Control buttons to make repeatable workbook operations easier to run.
Data Labeling Analyst — Job Simulation
- Reviewed simulated customer-support messages and classified intent, sentiment, and personally identifiable information (PII) using a consistent labeling schema.
- Evaluated ambiguous edge cases and documented concise rationales for final labeling decisions.
- Reviewed peer labeling, identified inconsistencies, and proposed an improvement to the team's labeling guidelines.
- Applied clear definitions and privacy-aware practices to support consistent, reliable labeled data.
- Practiced human–AI collaboration concepts relevant to AI operations, trust and safety, and machine-learning data support.
Machine Learning Engineer Intern
- Queried an approximately 79-million-row search-performance warehouse with DuckDB and SQL, aggregating Parquet data for analysis.
- Developed Python-based feature-preparation workflows and machine-learning experiments using anonymized search-performance data.
- Explored temporal and client-grouped validation approaches to assess model generalization and identify potential data-leakage risks.
- Completed a capstone project that was independently reviewed and approved.
Freelance BI Developer
- Deliver confidential BI engagements, translating business questions into Power BI reports, KPI definitions, semantic models, and DAX measures.
- Shape source data with Power Query and SQL, and document metric definitions, transformation logic, and reporting handover.
Freelancing Coach
- Coached aspiring freelancers on professional positioning, portfolio and CV development, freelance-platform profiles, proposal writing, and client communication.
- Reviewed learner portfolios, CVs, and freelance profiles, providing practical feedback and structured weekly development challenges.
- Analyzed freelance project listings to identify recurring skill requirements and help learners position practical services.
Data Analysis Mentor
- Mentored learners in Excel formulas and functions, data cleaning, PivotTables, charts, dashboards, Power Query, Power Pivot, and DAX.
- Taught data transformation with Power Query and data modeling with Power Pivot, including DAX calculations in Excel’s Data Model.
- Designed practical exercises and reviewed learner work to strengthen analytical reporting and dashboard skills.
Technical skills
Data & analytics engineering
Platforms & orchestration
Machine learning & modeling
Business intelligence & automation
Analytics applications & visualization
Statistical analysis & experimentation
Selected projects
Egyptian Cosmetics Analytics
An Egypt-focused retail portfolio project connecting operational data to a dimensional warehouse and Power BI reporting.
Python · SQL Server 2022 · Power Query M · Power BI · DAXPixelFed, from raw to ready
A reproducible social-content analytics project built around a relational schema, mixed-format landing files, and a galaxy semantic model.
Python · Power Query M · Power BI · TMDL · SQL · GitHub ActionsKickstarter Analytics Engineering Platform
A Power BI analytics-engineering project designed to reconcile campaign history across public Kickstarter data sources.
Power Query M · Power BI · DAX · PBIP · TMDL · PythonAutomation with a backbone
A documented Docker Compose stack for queue-mode n8n workflows, with Redis, PostgreSQL, and worker-oriented execution.
n8n · Docker Compose · Python · Redis · PostgreSQL · QdrantPwC Switzerland virtual case
An Excel and Power BI modeling portfolio based on the PwC Switzerland virtual case experience hosted on Forage.
Excel · Power Query · Power Pivot · DAX · VBACustomer 360 banking ETL
A banking integration capstone combining relational customer data with ATM and credit-card files using Informatica Cloud Data Integration.
Informatica IICS · Oracle · CSV · ETL · Data qualityTraining & certificates
Introduction to Excel
365 Data ScienceRevisited Excel fundamentals and passed the course exam on a second attempt. First taken during the 2025 free-access period; retaken in 2026 as structured revision.
n8n Foundations Professional Certificate
n8n AcademyEssentials, Integrations, and In Practice: AI, Testing & Best Practices.
Fundamentals of Networking for Effective Backend Design
UdemyCompleted course with practical networking labs.
Data Analytics Diploma
Ahmed Ali · Friendly Analysis28 sessions covering data analytics.
Build with AI: Masr Edition
Information Technology Institute (ITI)AI-focused training.
Python, APIs & data-platform foundations
365 Data ScienceWeb Scraping and API Fundamentals in Python; Introduction to Jupyter, Data Warehousing, and Databricks.
Power BI Desktop & Power BI Service
Maven AnalyticsBusiness intelligence training.
SQL, Python, Excel & data foundations
IBM · edXSQL for Data Science; Relational Database Basics; Python Basics for Data Science; Analyzing Data with Excel; Data Engineering Basics for Everyone; Data Analytics Basics for Everyone.
Enrolled coursework
Continuing study in dbt, Airflow, Excel VBA, cloud data engineering, Docker, operating systems, and database engineering. Enrollment is separate from completion and certification.
View all seven enrolled coursesLanguages
Arabic · Native · English · Excellent, written and spoken