About Me
Data Analyst/ Business Analyst with experience in SQL, Python, R Programming, Excel, Tableau, and data analysis projects. Completed a Bachelor of Electrical Engineering from El Shrouk Academy and holds multiple data anal…
Data Analyst/ Business Analyst with experience in SQL, Python, R Programming, Excel, Tableau, and data analysis projects. Completed a Bachelor of Electrical Engineering from El Shrouk Academy and holds multiple data analytics certificates, including Google Data Analytics Professional Certificate and Datacamp certifications.
Experience
Shipping Company RMF Sales Analysis
<p>Utilized SQL to analyze 2824 shipping orders through three consecutive years producing RMF analysis on customers’ orders.<br>
Transformed the data using CTE and subqueries and text manipulation.<br>
Loaded the data on Tableau to produce detailed dashboards for visual analysis.</p>
Cyclistic Bike Share Company Analysis
<p>Utilized R Studio to perform customer’s behavior analysis to increase the annual revenue of the company.<br>
Used dplyr to create summarize and ggplot2 to visualize variables available in the tidyverse package.<br>
Performed data cleaning using janitor.<br>
Worked with time data using lubridate.</p>
Customer Retention Analysis
<p>Utilized SQL to analyze 406829 records to analyze customer retention rate through 13 months.<br>
Transformed the data and cleaned it using text analysis and grouping and creating useful data using pivot tables.<br>
Loaded the data on Tableau to produce visual analysis for retention rate by customers.</p>