Project
UK Road Safety Analysis, Aston University

Keywords:
Pandas
Numpy
EDA
Scikit-learn
I developed predictive models to classify accident severity using UK Road Safety data, aiming to enhance risk profiling for insurance premium assessments. The project involved cleaning and preprocessing over one million records using Python libraries such as Pandas and NumPy, resulting in 99% data accuracy and the successful removal of key outliers. I conducted exploratory data analysis (EDA) with Matplotlib and Seaborn to uncover meaningful patterns related to accident severity, including factors like vehicle type, driver age, and weather conditions. To build the predictive models, I applied several machine learning algorithms—Logistic Regression, Decision Trees, K-Nearest Neighbours, and Random Forest—using Scikit-learn. By implementing Random Undersampling with Cluster Centroids, I achieved an 82% accuracy rate in classifying minority ‘Fatal’ accident cases, significantly reducing misclassifications compared to models trained on unbalanced data.
Bank Marketing Campaign Analysis

Keywords:
ETL
DAX
Power BI
I conducted a project aimed at identifying the key factors influencing a customer's likelihood to subscribe to a bank term deposit, while also evaluating the effectiveness of current and past direct marketing campaigns for a Portuguese banking institution. Throughout the project, I enhanced my ability to load, clean, and transform data using Power BI (Power Query). I leveraged DAX tools to calculate core performance metrics such as conversion rate and total clients, which supported the development of customer segmentation models for more targeted marketing efforts. Using Power BI, I built comprehensive and visually engaging reports to communicate insights and define optimal strategies for future marketing campaigns. The project presentation was well-received and earned the highest grade of 9 out of 10.
HR Analytics - Employee Attrition Analysis

Keywords:
ETL
DAX
Power BI
HR Analytics
I conducted an in-depth analysis of employee attrition for a company with 4,000 employees, focusing on understanding the key factors driving the 15% annual turnover rate. As part of the project, I developed interactive Power BI dashboards that visualized attrition trends, employee demographics, job satisfaction, work environment, and compensation, helping to identify critical drivers of employee retention. I processed and cleaned HR data to compute essential metrics such as total employees, attrition rate, and average monthly income. Using DAX, I calculated key indicators including the impact of tenure, job role distribution, and the influence of salary on retention. Through this analysis, I identified significant factors contributing to attrition—such as work-life balance, compensation levels, and satisfaction with the working environment. Based on these insights, I provided actionable, data-driven recommendations to support workforce planning, improve employee retention, and refine HR policies.