Ryan Houghton

Data Analyst With 3+ Years of Professional Experience

Email: ryanhoughton51@ryanhoughton51

Building exterior in Toronto, Canada

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!