General/Class Projects
This page contains some more general projects from either a one-time analysis or class project.
On This Page:
Tableau
Identifying Unregistered Rental Units
Items Causing Issues With Alternates
SQL
CIA Country Information
Happy Shop Customers
Python
SMS Spam Message Tester
Utilizing SQL From Python
Tableau
Please note, these dashboards have been resized to make them more compatible with this website. As a result, this page does not load well on a phone. To view the full-size dashboards, along with more examples of my work, please visit:
This dashboard was created to assist an HOA with identifying the number of units being rented. The number of potential rental units identified was almost double what the HOA had registered.
Identifying Unregistered HOA Rentals
A project I was involved with at Grainger was running into issues identifying why a system was generating poor quality product alternates. I created this dashboard to identify what the cause was, and to show a potential solution. The cause was largely one product category, and the solution came down to fixing the information on a handful of items so they would stop connecting to the problem category.
Items Causing Issues with Alternates
SQL
CIA Country Information
This was a guided project to identify interesting information available in the CIA country factbook. The Final query at the end was not a part of the guided project.
Hobby Shop Customers
This was a guided project to assess hobby shop customer data. Including what customers were the most valuable and what items need to be prioritized for stocking, based on those customers.
Python
SMS Spam Message Tester
The below project is the process of building a Spam SMS Message tester.
SMS_Spam_Tester.pdfTo download the code so you can run the tool in python click: Here
Note: You will need to download the data file located at the top of the report and change the file location in the .py file
Utilizing SQL from Python
The below code was an assignment that went over interacting with a SQL database from Python.
Sql From Python.pdfTo download this program and can check the code in python click: Here
If you run this code without editing it the database should be created in your home folder.