R/ Rstudio projects

Bank Marketing Analysis

In this projected, using different mode to best identify whether a customer would subscribe to a long-term deposit offered by a Portuguese bank during a call campaign. For the analysis, I reviewed variations of the logistic model and the linear discriminant analysis (LDA) model. In summary, a simple logistic regression model proved to be the best overall model with high accuracy and sensitivity. The LDA model did not prove to have comparable accuracy because the underlying predictor data did not have a normal distribution...

Employee Attrition in Healthcare

The increase in attrition rate experienced in healthcare sector due to the advent of the covid-19 pandemic have forced decision makers, like managers, director, human resource persons in the healthcare industry to think about better ways to increase retention among healthcare workers. This project with guiding specific questions contributes to the this study...

Stock Price Prediction

The focus of this case study is to find a model that best predict the stock price of the Dow Jones Index stock and also evaluate the risks of each stock. The models also shows that price of the stock at the beginning of the week and the price of the stock at the end of the week are great predictors....

Other R projects

In R, I have tackled a variety of projects that showcase its versatility.I've also worked on text mining projects, extracting valuable information from large datasets of unstructured text. Furthermore, I've utilized R for spatial analysis, mapping and analyzing geographical data to uncover spatial patterns. Finally, I have employed R for time series analysis, forecasting future trends.

Python projects

Car Accidents Analysis

Despite the increasing technological advancement in the United States, car accidents continue to grow. Using data from the 2016 to 2023 countrywide traffic accident dataset, this study examines the factors associated with car accidents in the United States and whether these accidents vary by geographical location. The result indicates that factors such as weather and year are related to the occurrence of an accident...

Equity in the Distribution of Govt. Contract

This project analyzes internal and public procurement data to help the State of Illinois Committee on Equity and Inclusion (CEI) raise awareness of racial and socioeconomic disparities within state contracting.

Home Price Prediction

This projects explores the factors associated with home price and the best money with the highest prediction value with the test data set. I also test the model assumptions to see that the estimates are reliable...

Others Python Projects

In Python, I've tackled a variety of projects across different sectors In the healthcare sector, I've developed machine learning models to predict patient outcomes and improve treatment plans. I've worked on automated trading algorithms that analyze market data in real-time and execute trades based on predefined strategies.

SQL Projects

Event Management

This project analyzed the users and cards of an event and how to proper manage the event in the future.

Library Management System

This project involves designing a schema, writing queries for various operations, and implementing constraints and triggers for libary management..

Financial Data Analysis

This project involves writing complex queries for data aggregation, using window functions for time-series analysis, and creating views for financial reporting..

Other SQL Projects

Other SQL projects done include HR management system, hosptial management database, e-commerce projects, inventoory management system. This was done with MySQL and used different SQL snytaxes/p>

Other Projects

Sales Performance Dashboard

I created an interactive sales performance dashboard in Tableau that visualizes key metrics such as revenue, profit margins, and sales growth across different regions and products. The dashboard includes drill-down capabilities, allowing stakeholders to analyze trends and identify top-performing products and sales representatives...

Customer Segmentation Analysis

In Power BI, I created a detailed customer segmentation analysis to identify and profile different customer groups based on purchasing behavior and demographics. The interactive report includes segmentation metrics, demographic breakdowns, and purchasing patterns, enabling the marketing team to tailor their strategies to target specific customer segments effectively...

Inventory Management System

I created an inventory management system in Excel to track and manage stock levels, reorder points, and supplier information for a retail business. The system includes automated alerts for low stock levels, inventory turnover analysis, and supplier performance tracking...

Others

Other projects I have embarked upon include COVID-19 impact analysis, employee performance dashboard, sales funnel analysis, customer retention analysis and many more