نبذة عني
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.
الخبرة
Shipping Company RMF Sales Analysis
Utilized SQL to analyze 2824 shipping orders through three consecutive years producing RMF analysis on customers’ orders.
Transformed the data using CTE and subqueries and text manipulation.
Loaded the data on Tableau to produce detailed dashboards for visual analysis.
Cyclistic Bike Share Company Analysis
Utilized R Studio to perform customer’s behavior analysis to increase the annual revenue of the company.
Used dplyr to create summarize and ggplot2 to visualize variables available in the tidyverse package.
Performed data cleaning using janitor.
Worked with time data using lubridate.
Customer Retention Analysis
Utilized SQL to analyze 406829 records to analyze customer retention rate through 13 months.
Transformed the data and cleaned it using text analysis and grouping and creating useful data using pivot tables.
Loaded the data on Tableau to produce visual analysis for retention rate by customers.