Learn Data Skills
Shady Nasrat

Shady Nasrat

Sr. Data Analyst

Assembly Global | Egypt


My Portfolio Highlights

My New Course

Introduction to Python

My New Track

Spreadsheet Fundamentals

Analytical daredevil, fearlessly diving into the abyss of data complexity.

My Work

Take a look at my latest work.


Introduction to SQL


Introduction to R


Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

LinkedIn Learning Google Analytics 4 GA4 Essential Training

Google Foundation: Data, data, everywhere

Google Introduction to Data Studio

HackerRank SQL (Basic)

DataCamp Data science for everyone

LinkedIn Learning Data fluency: Exploring and describing data

LinkedIn Learning Learning data analytics

Information Technology Institiue (ITI) Database fundamentals

LinkedIn Learning Power BI essential training

DataCamp Data manipulation with dplyr

DataCamp Introduction to the Tidyverse

DataCamp Intermediate R

DataCamp Data analysis in Excel

Coursera Essential design principles for Tableau

SoloLearn SQL fundamentals

Udacity Data analysis track (1MAC)

Coursera Fundamentals of visualization with Tableau

Coursera Business statistics and analysis specialization (5 courses)

Coursera R programming

Coursera Practical time series analysis

DataCamp Introduction to Git for data science

Coursera The data scientist’s toolbox

DataCamp Data analysis with spreadsheets

DataCamp Intro to Python for data science

DataCamp Spreadsheet basics

Google The fundamentals of digital marketing

Udacity Data analyst track

DataCamp Introduction to R

DataCamp Intro to SQL for data science

Coursera Data science math skills

Coursera Learning how to learn: powerful mental tools to help you master tough subjects

LinkedIn Learning Learning R

Coursera Basic statistics

Coursera Programming for everybody (getting started with Python)

Coursera Write professional emails in English

Google Digital Academy (Skillshop) Google Analytics Certification

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Assembly Global | May 2023 - Present

Sr. Data Analyst

• Leading the reporting for the MENA SEO department. • Mentoring new team members in the data department, fostering a culture of continuous learning and development. • Innovating solutions to overcome limitations in tools such as Looker Studio and Google Sheets, resulting in improved efficiency and advanced data analysis capabilities.
Show More

Assembly Global | Jan 2022 - Apr 2023

SEO Data Analyst

• Manage and respond to datasets requests. • Setting up technical SEO dashboards in Looker Studio (GDS). • Assisting the SEO team with in-depth analysis and weekly performance reports. • Setting up interactive SEO performance reports allowing for data manipulation and segmentation. • Ensuring that dashboards are up to date, helping the team in regular quality checks by backdating reports and additional data pulls. • Automating Looker Studio (GDS) reports, SQL queries, and Google Sheets.

Caritas Internationalis | Nov 2018 - Dec 2021

Data Manager

• Designed project’s interactive dashboards. • Created databases, and automated reports using MS Access and MS Excel for social and medical teams. • Cleaned, analyzed, and visualized data received from various departments in the project. • Generated monthly, quarterly, semi-annually, and annually reports internally, and externally. • Focal point between the EU project and Fawry Plus for Banking Services. Here are some of what I contributed to the EU project during my time there: • Created an Access database for the medical department with features: 1. Simple. 2. User-friendly. 3. Instant search. 4. Duplicates-free. 5. Cutomised search. 6. Auto-complete. • Created an automated Excel report for the medical department with the features: 1. In-depth detail. 2. Customised periodic report; where they can choose the period they want and the numbers would update accordingly. • Created an automated info desk for the social, medical, and reception departments to register daily activities with features: 1. Cloud and offline access. 2. Separate periodic report for each; where they can choose the period they want and the numbers would update accordingly. 3. Auto-complete. • Created three (3) automated, interactive dashboards reflecting the social, medical, and assistance sections, to find patterns, and make data-driven decisions. • Identified and removed duplicate profiles. • Managed the delivery of EGP 3.5+ M of cash assistance to the most vulnerable families through the partnership with Fawry Plus for Banking Services. • Trained colleagues on using Excel from the same and other projects within Caritas Alex.

My Education

Take a look at my formal education

Bachelor’s Degree, Applied StatisticsAlexandria University | 2017

About Me

Shady Nasrat

Skilled data analyst with 5+ years of extensive analytical roles. Committed to elevating the reporting standards of any department or industry I join; I consistently implement innovative strategies that have proven to enhance efficiency and accuracy.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free