Ellis Hartley
Data analyst
Welcome to my Portfolio!
š Hi, Iām Ellis Hartleyā¼ B.S. of Environmental Studies, Biology minor - University of Central Florida
ā¼ Former HS Math and Science Teacher
ā¼ I enjoy building things with SQL, Python, AI, and Tableau. Always seeking the next coding challenge.
ā¼ Outside of work, I enjoy woodworking, hiking, and spending time with family.
Tableau
Higher Education Dashboard
Analyzed student data using the #RWFD dataset. Utilized more advanced Tableau features such as custom table calculations and dual-axis charts.
Google Trends Analysis
Created a python script to loop through large lists of items and used it to generate loads of Google Trends data for sandwich restaurant chains in the US. Utilized Python and SQL to wrangle and filter the data. Analyzed the final product in Tableau. Subway was by far the most googled sandwich chain (in case you were wondering)!
Python and SQL
FiveThirtyEight Vs Vegas
Backtested game predictions from FiveThirtyEight against Vegas opening spreads for basketball matchups across prior seasons.Key Finding: You will lose money betting against Vegas with FiveThirtyEight!
Exploring Covid Data with SQL and Tableau
Analyzed deaths and vaccination trends in countries over time.
Research and Leadership
Undergraduate Research Project: Worked with a group of undergraduate students under the Fall 2014 Office of Undergraduate Research Grant to discern the effects of nutrient additions and salinity on the cultivation of Spartina alterniflora for conservation purposes.IDEAS for UCF Team Leader - Waste Solutions Pillar: Helped organize campus cleanups and worked to increase recycling options for student housing complexes.Brainbowl Coach (2019): Worked with a school board member to put together a team of students to compete in the Florida Brainbowl Competition.Environmental Club Sponsor (2020-2021) Worked with another teacher to coordinate after-school environmental awareness projects.
Certificates/Additional Coursework
Google Data Analytics Professional Certificate (Excel, SQL, Tableau, R)
Excel for Finance - Online Course - Investopedia