Projects
![S&P 500 Database](/_next/image?url=%2Fimg%2Fdatabase-pipeline.png&w=3840&q=75)
S&P 500 Database
Python
This notebook enables users to analyze SPY options trading data based on a specified expiration date. It calculates SPY's trading range for the selected date and retrieves all options that traded at the money (ATM) on that day and expire on the given date. Subsequently, it uploads both the underlying stock data and options data to a locally hosted PostgreSQL database.
View S&P 500 Database![Marketing Analysis: Term Deposit Campaign](/_next/image?url=%2Fimg%2Fterm-deposit-campaign.png&w=3840&q=75)
Marketing Analysis: Term Deposit Campaign
Tableau
This storyboard is designed to compare the success of the current term deposit marketing campaign with the previous one, as well as to identify the demographic groups that responded best to the current campaign.
View Marketing Analysis: Term Deposit Campaign![Bike Store Sales Analysis](/_next/image?url=%2Fimg%2Fbiker-store-analysis.png&w=3840&q=75)
Bike Store Sales Analysis
SQL
A SQL file with queries providing insights into order processing, revenue analysis, customer behavior, inventory management, and employee performance.
View Bike Store Sales Analysis![2022 Milwaukee Property Sales](/_next/image?url=%2Fimg%2Fmilwaukee-property-sales.png&w=3840&q=75)
2022 Milwaukee Property Sales
Excel
An Excel dashboard analyzing residential property sales in Milwaukee.
View 2022 Milwaukee Property Sales![Employee Churn Prediction](/_next/image?url=%2Fimg%2Fsalifort-motors.png&w=3840&q=75)
Employee Churn Prediction
Python
A Jupyter Notebook where I used a logistic regression to predict whether an employee will churn.
View Employee Churn Prediction![Adidas Sales Dashboard](/_next/image?url=%2Fimg%2Fadidas-sales-dashboard.png&w=3840&q=75)
Adidas Sales Dashboard
Tableau
A Tableau dashboard visualizing how operating margins charge based on the year, store locations, and product sales.
View Adidas Sales Dashboard