Ryan Houghton
Data Analyst With 3+ Years of Professional Experience
Email: ryanhoughton51@gmail.com
Portfolio
Below is a comprehensive list of personal and professional projects that demonstrate my analytical capabilities and technical skills.
Competitive Pricing Web Scrape
2023: Utilized Python and the Selenium library to scrape pricing data off of Lowes, Home Depot, and Grainger. Successfully used Power BI to visualize this data and compare it to our prices at GMS.
Cyclistic Case Study
2022: Performed an analysis to discover insights on how different customer types within the Cyclistic Bike Share company use their services differently. Utilized SQL, Excel, and Tableau.
Determinants to Winning Baseball Games
2021: Used an econometric approach to perform a data analysis and discover insights on what statistical categories play the most important role when it comes to winning Major League Baseball games
Data Governance Web Scrape
2024 (on going): Utilized Python and the Selenium library to scrape descriptive data off of manufacturers websites to greatly increase our data cleaning efficiency process at GMS. Used SQL to query GMS data and used Excel to convert data to new format.
My Tools
Below are the tools I have utilized in my 3+ year professional career as well as my education.
Tools:
- SQL
- Microsoft Excel
- Python
- Power BI
- Tableau
About Me
- GMS Data Analyst 2021-2024
- Boise State University 2017-2021
- Google Data Analytics Certified
- Bachelor of Science in Business and Economic Analysis
- Minor in Applied Mathematics
- Seattle Local
- Massive Baseball Fan!