Robert Grantham - Data Analyst

Showcasing data analytics projects and skills.

Filter Projects

Search Projects

My Projects

Screenshot from the Advanced SQL Solutions project

Advanced SQL Solutions

Mastering Data Queries

This project showcases advanced SQL techniques through practical examples, highlighting my ability to extract and analyze data efficiently. From complex joins to optimization strategies, these examples demonstrate my proficiency in database management.

SQL Data Query Database
Explore on GitHub
Screenshot from the Fraud Detection System project

Fraud Detection System

AI-driven Fraud Prevention

Developed a comprehensive fraud detection system using machine learning algorithms to identify and prevent fraudulent activities. The project involved building predictive models that analyze transaction data to detect suspicious patterns, significantly reducing financial losses and enhancing security measures.

Machine Learning AI Fraud Prevention
View Project
Screenshot from the Forecasting Mini-Course Sales project

Forecasting Mini-Course Sales

Sales Prediction Analysis

Analyzed sales data from a mini-course using various forecasting techniques to predict future sales trends. This project involved data preprocessing, model building, and evaluation to provide accurate sales forecasts.

Forecasting Sales Analysis Kaggle
View Project
Screenshot from the Client Segmentation project

Client Segmentation

Market Analysis and Strategy Development

Performed client segmentation using clustering algorithms to identify distinct customer groups based on various attributes for an Austin investment firm. This involved analyzing synthetic client data, visualizing clusters, and developing targeted marketing strategies for each segment.

Clustering Market Analysis
View Project
Screenshot from the Predicting Credit Approval project

Predicting Credit Approval

Credit Risk Assessment

Built a predictive model to assess credit approval based on various applicant features. The project utilized machine learning algorithms to predict the likelihood of credit approval, aiding financial institutions in risk management.

Predictive Analytics Credit Risk Kaggle
View Project
Screenshot from the Austin Violent Crime Insights Dashboard project

Austin Violent Crime Insights Dashboard

Interactive Crime Data Visualization

Developed an interactive Tableau dashboard to analyze violent crime data in Austin, TX. The dashboard provides insights into crime patterns and helps in identifying high-risk areas, supporting law enforcement and community safety initiatives.

Data Visualization Crime Analysis Tableau
View Dashboard

Police Shootings Analysis

In-depth Data Examination

Conducted a thorough analysis of police shootings data to uncover trends and insights. This project involves data wrangling, statistical analysis, and visualization to provide a comprehensive overview of police shootings in the United States.

Data Analysis Statistical Analysis Visualization
View Project

Art Sales Pop-Up Tracker

Excel + Python EDA Companion

A field-ready Excel system for tracking pop-up and street-sale performance: one table per outing, one per transaction line item, with automatic KPI rollups (gross sales, net profit, transactions per outing) and dropdown-validated data entry. Includes a Python companion for CSV export and deeper EDA.

Excel KPI Dashboard Python
View Project