Mahmoud Ali
Data Analyst
I'm a junior data analyst passionate about turning data into insights. I specialize in sales performance analysis, using tools like SQL, Excel and Power BI to uncover trends and support strategic decision
About Me
My data analytics journey reflects a unique blend of customer service experience and technical prowess. I honed my skills in Excel, Power BI, SQL, and business analytics through a Micro Data Analytics Diploma at ALX Academy, earning multiple certifications, including the prestigious Data Competition Presentation Badge.
My analytical journey began at the ALX Africa Academy when I embarked on my data analysis learning journey, benefiting from the collaborative work of the great ALX Africa community. Now, as a data analyst, I apply this collaborative spirit to interpret complex data, ensuring actionable insights that contribute to informed business decisions.
My Certifications
Professional Foundations
Data Analytics
Power BI
Google Sheets
presentation Skills
Introduction SQL
Intermediate SQL
Introduction To Excel
Data Preparation in Excel
Data Analysis in Excel
Data Visualization
Basics Data Analytics
Al Mentor
My Skills
Excel
Expert (92%)
Power BI
Highly Proficient (90%)
SQL
Proficient (85%)
Visualization and reports
Expert (96%)
Projects Overview
Latest Projects
1
Employee Attrition Analysis and Job Satisfaction Measurement
Analyzed employee attrition rate (16%) and job satisfaction using data analysis tools to understand reasons for leaving, improve the work environment, and enhance employee retention
2
Sales Performance Analysis to Identify Top-Performing Cities and States in the United States
Analyzed sales data for a technology product company to identify top-performing and underperforming regions across the United States, using Excel, Power BI, and SQL
Employee Attrition Analysis
Data Collection
Gathered data on employee attrition (e.g., reasons for leaving, most affected departments, and tenure before departure) and conducted surveys to measure job satisfaction across different departments
Data Analysis
Used tools like Excel and Power BI to analyze the data and identify patterns, creating reports and dashboards to visualize the analysis results
Employee Attrition Analysis: Findings
High Attrition Rates
High attrition rates were observed in certain departments due to workload and poor work-life balance
Job Satisfaction
Survey analysis showed an overall satisfaction rate of 72%, with significant variation between departments
Employee Attrition Analysis: Recommendations

1

2

3

1
Flexible Work Policies
Implement flexible work policies to reduce workload pressures.
2
Training Opportunities
Increase training opportunities to support professional development.
3
Communication
Strengthen communication between management and employees to foster a better work environment.
Contact Me
Email
Phone Number
01110995893-01024252107
LinkedIn
WhatsApp
If you want me to contact you
Made with