My name is Garrett Collins
I am a passionate Data Analyst but more importantly I'm passionate about technology
Analysis On NFL Superbowl QB's and their college QB coaches
After web scraping 3 different data sources, I found that only 31.8% of the highest paid college qb coaches have produced a quarterback who has gone to an nfl superbowl. 84.4% of all Superbowl quarterbacks, were trained by a college qb coach, that was not in the top 22 highest paid college qb coaches. In conclusion, upcoming college quarterbacks that are most concerned with making it to an NFL superbowl in their future, should not base their college qb coach mentor, off of how much the coach is being paid.
SSIS Converting Flat Source to SSMS
This is an SSIS project where I converted the .csv file containing the web scraped data from the IMDB website(Using Python) to the table created in SSMS.
Academic project using SQL and PowerBI
This is a visual dashboard project for transactional data using PowerBI and SSMS.
Python Web Scraper
Used python's BeautifulSoup library to scrape data off of IMDB website into an excel file.
Work Macro Project
This is my proudest work accomplishment, where I built a VBA Macro to automate and increase my teams workflow. The Macro cleans and formats phone numbers, and converts Country names to two letter abbreviations. (You need latest Version of excel to run this macro!)
Daycare Website
Created a front-end web app to help daycare clients find and connect with this daycare provider through their Facebook.
To do list Web Application
Created a to-do-list with jquery and Javascript.
Weight Converter Web App
Created a to-do-list with jquery and Javascript.