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