Built with datascienceportfol.io

Bassam El-Shoraa

Data Analyst || Data Analysis Instructor || Data Analysis Trainer || Reporting Analyst || Data researcher || Data Scientist || Excel || SQL || Python || Power BI || Tableau

Based in Cairo, Egypt

About

Detail-oriented Data Analyst with expertise in SQL, Excel, Power BI, and Python, dedicated to translating complex datasets into clear, impactful insights. Skilled in data visualization, simplifying technical findings for diverse audiences, and uncovering hidden patterns beyond raw numbers. Adept at storytelling with data, crafting compelling narratives that drive informed decision-making. Experienced in designing interactive dashboards, conducting training sessions, and collaborating across teams to enhance data-driven strategies. Passionate about delivering actionable insights that bridge the gap between data and decision-makers.

Skills

Projects

Experience

2017 - 2018

Junior Data Analyst and Researcher

- Analyzed 5 social dataset projects using Excel and Power BI with 95% accuracy, totaling 5,000 data points. - Conducted exploratory studies and literature reviews to support project objectives. - Authored and prepared 20+ technical, research, and evaluation papers and reports, achieving an average rating of 4.5 out of 5 from project stakeholders.

Senior Data Analyst and Researcher

- Managed 19 social dataset projects utilizing Excel and Power BI to collect and analyze over 10,000 data points, resulting in accurate information indicators and forecasts. - Established and oversaw the "Modern Egypt program," which launched databases for modern Egypt's social history. - Led and trained a team of 3 members, increasing their technical capabilities and improving project efficiency by 15%. - Conducted multiple workshops on advanced Excel skills, dataset building, and analysis, resulting in a 50% increase in participants' data analysis abilities.

2023

Freelancer Data Analyst

- Conducted quantitative data analysis for research projects at Collective Routes, utilizing Excel and Power BI. - Analyzed research data to generate statistical reports and extract valuable insights. - Designed interactive dashboards using Power BI to visually communicate research findings effectively. - Provided training sessions on Power BI usage, empowering researchers to analyze and present data proficiently.

2023

Part time Data Analyst at Collective Routes

- Conducted quantitative data analysis for research projects at Collective Routes, utilizing Excel and Power BI. - Analyzed research data to generate statistical reports and extract valuable insights. - Designed interactive dashboards using Power BI to visually communicate research findings effectively. - Provided training sessions on Power BI usage, empowering researchers to analyze and present data proficiently.

Dec 2024 - Dec 2025

Data Analysis Instructor at NeuroTech

• Taught key data analysis tools and techniques, including Python, statistics, SQL, Power BI, and Excel, to students in the diploma. • Designed and delivered instructional materials for each module, ensuring a deep understanding of both theoretical concepts and practical applications. • Guided students in building real-world projects, focusing on data collection, cleaning, and visualization to develop their skills. • Provided one-on-one mentoring and support to students, helping them apply data science methods to solve real-world challenges. • Developed assessment materials and graded assignments to track students' progress and mastery of the course content.

October 2025 – Present

Data Analysis Instructor at Institute of Management Professionals

• Delivered advanced Excel training on Power Query, Power Pivot, and DAX language for data modeling. • Conducted Power BI sessions covering DAX time intelligence, calculated columns, and performance optimization techniques. • Mentored students in complex data modeling, relationship management, and Microsoft Power BI certification preparation. • Provided supplementary training on SQL for data analysis, Python data manipulation with Pandas, and Power Automate workflow automation.

December 2025 – Present

Data Analytics Instructor at CLS – Digital Egypt Pioneers Initiative (DEPI)

• Delivered training on data analytics fundamentals, data-driven decision-making, and Excel-based visualizations for DEPI participants. • Taught Power BI end-to-end: data extraction, Power Query cleaning, data modeling, DAX, and interactive dashboard/report development. • Introduced Azure data services, Tableau visualization, and data governance concepts, and supervised capstone projects using real-world datasets.

May 2025 – present

Data Analyst at Shiny White Dental Centers

• Develop forecasting models using Python (Pandas, Statsmodels) to predict, enabling proactive planning and optimized scheduling. • Collaborate with the finance team to analyze and manage monthly budgets and financial statements, ensuring data accuracy and supporting cost-reduction initiatives. • Design dynamic dashboards in Power BI to track KPIs. • Automated financial and operational reporting workflows using Power BI and Python. • Provided data-driven recommendations that improved budget allocation and enhanced visibility for senior management.

Education

2021

Data analysis challenger track - Udacity

2021

Data analysis professional track - Udacity

2022

Intro to Descriptive Statistics - Udacity

2023

ExploreAI Academy Data science Program