Kevin Capule

Welcome in. You look great. Iā€™m Kevin, currently in Boston. I love using technology to solve problems, build cool projects, and keep learning along the way.

Outside of work, Iā€™m usually looking for my golf ball, playing volleyball or basketball, biking, or just enjoying time outdoors.

šŸ“– Currently reading: The Illiad (Graphic Novel) by Gareth Hinds

šŸ› ļø Hobbies in progress: baking baguettes and dialing in the moka pot šŸ‘Øā€šŸ³šŸ„–ā˜•

Education

Python SQL Tableau Database Design SQLite Data Analysis Data Visualization
Portfolio

Projects in Python, SQL, Tableau, and Database Design

Allias Megastore Project

End-to-end retail analytics project covering data cleaning, statistical testing, and market basket analysis.


Tools: Python, Pandas, NumPy, Matplotlib, Seaborn, mlxtend.

Data Preparation & Exploration

Comprehensive retail data project demonstrating exploratory data analysis, hypothesis testing, and market basket analysis to uncover customer purchasing patterns.

View Project
MongoDB Project

It involves designing and implementing a NoSQL database solution for HealthFit Innovations.


Tools: MongoDB, mongosh shell, and JSON datasets.

Non-Relational Database (MongoDB)

NoSQL database solution for HealthFit Innovations with comprehensive data modeling and implementation.

View Project
PostgreSQL Database

It involves designing and implementing a relational database solution for EcoMart, a fictional online marketplace focused on sustainable and eco-friendly products.


Tools: pgAdmin4, PostgreSQL, and CSV dataset (100k records).

Relational Database (PostgreSQL)

Complete database solution for EcoMart with 100k+ records, ERD design, and optimized queries.

View Project
Programming Diary

Programming Diary that captures what you've learned and when, using Python and storing in a SQLite DB.


Tools: Python and SQLite.

Programming Diary

Python application for tracking learning progress with SQLite database integration.

View Project
Movie Watch List

Movie List application that captures a list of users, movies, and which movies each user has watched using Python and storing in a SQLite DB.


Tools: Python and SQLite.

Movie Watch List

User management system for tracking movie watch lists with relational data structure.

View Project
Sales Agent Analytics

Interactive Dashboard looking at Sales Agent's Performance Results.


Tools: Tableau Public.

Sales Agent Performance Dashboard

Interactive Tableau dashboard analyzing sales performance metrics and KPIs.

View Dashboard
Shipping Analytics

Interactive Dashboard looking at Shipping Analytics.


Tools: Tableau Public.

Northwind Shipping Analytics

Comprehensive shipping analysis dashboard with logistics and performance insights.

View Dashboard
Company Financials

Interactive Dashboard looking at a company's financial results.


Tools: Tableau Public.

SHC Company Financial Analysis

Financial performance dashboard with revenue, profit, and trend analysis.

View Dashboard
Accounts Receivable

Interactive Dashboard looking at a company's accounts receivable results.


Tools: Tableau Public.

MyPaper Accounts Receivable

Financial dashboard tracking accounts receivable, aging analysis, and collection metrics.

View Dashboard
HR Analytics

Interactive Dashboard looking at a company's HR Analytics.


Tools: Tableau Public.

Green Destination HR Analytics

Human resources dashboard analyzing employee metrics, retention, and performance data.

View Dashboard
Discount Mart

Interactive Dashboard looking at a company's Sales Analytics.


Tools: Tableau Public.

Discount Mart Sales Analytics

Retail sales analysis dashboard with product performance and customer insights.

View Dashboard
Khan Academy SQL

SQL Projects done in Khan Academy.

Khan Academy SQL Projects

Collection of SQL projects and exercises demonstrating query optimization and data analysis.

View Projects