About Me
I’m Kyle Lawrence, a Business Analytics and Information Systems student at the University of Iowa focused on analytics, digital products, and operations.
Featured Work
-
Job Market Analytics – Relational Database & SQL Analysis
Designed and implemented a normalized relational database in Oracle APEX to analyze job listings across industries, experience levels, locations, and salaries. Built ERDs, created tables with primary/foreign keys, loaded structured data, and developed SQL queries to identify trends such as in-demand skills, industry salaries, geographic patterns, and job market growth.
Download Report → -
Python Data Cleaning & Visualization – Alternative Fuel Stations
Analyzed a nationwide dataset of alternative fuel stations using Python. Built reusable functions for data loading and cleaning, removed invalid categories, generated pie charts, bar charts, time-series plots, and geospatial scatterplots using Matplotlib, and explored trends across fuel types, states, and years.
Download Python Notebook → -
College Football Win Prediction – Regression Modeling
Built a multi-linear regression model using ESPN’s 2023 team statistics to identify key predictors of team wins. Performed feature selection, removed insignificant variables using p-values, analyzed collinearity with correlation matrices, reviewed residual diagnostics, and produced a final parsimonious model with clear interpretability.
View Project →