PETER STRAND

Data Analyst
Mountain biker
Coffee lover

ABOUT ME

I’m Peter, a Mechanical Engineer turned Data Analyst living in sunny Denver, Colorado. I love data, making things make sense, and all things biking. When I’m not making visualization, you can find me exploring the Rocky Mountains or at a brewery with my dog.

Resumé

peter.m.strand@gmail.com
617 968 3457

PORTFOLIO

I-70 TRAFFIC ANALYSIS

Explored past traffic data to gain insights into traffic patterns and identify peak traffic times for I-70.

  • Designed an interactive dashboard presentation using Tableau, providing viewers with a user-friendly interface to explore the data and visualize the insights gained from my analysis.

  • Utilized Python to clean and manipulate the data, ensuring that all datasets were relational and consistent.

BLUEbikes REDISTRIBUTION ANALYSIS

Analyzed BlueBike data to gain insights into bike usage patterns and station demand.

  • Designed and developed an interactive dashboard using Tableau to analyze bike traffic at over 200 stations, taking into account external factors such as weather and sporting events.

  • Utilized union, join, and blend functions to combine five tables containing over 3,000,000 rows of data into a single dataset for cohesive analysis.

AirBNB MARKET ANALYSIS

Evaluation of market and revenue opportunity of possible ski vacation rental unit. 

  • Utilized web scraping tools and techniques to extract data on over 400 potential rental properties from Zillow, including key property features such as location, size, amenities, and price.

  • Created compelling visualizations in PowerBI that effectively communicated the insights gained from the data analysis to potential stakeholders, highlighting the key drivers of success and the potential financial gains.

SKILLS

    • dbt

    • Python

    • Looker / LookML

    • Redshift

    • Github

    • Exploratory Data Analysis

    • CTEs

    • Pivot Tables

    • VLookUp

    • Tableau

    • PowerBI

    • Seaborn

    • Looker Studio

    • Excel

EDUCATION

GENERAL ASSEMBLY

APRIL 2023

Harnessed the tools in data analytics to acquire, analyze and visualize data sets in real-time using industry-standard tools such as SQL, Excel, Tableau, PowerBI, and Python. Solved real-world business problems through data-driven problem-solving, storytelling, and decision-making. Honed programming, modeling, and statistical skills through 480+ hours of data analytics-specific training

ENGINEERING MANAGEMENT CERTIFICATE

The Engineering Management Program (EMP) is a technically-based management and leadership program for the engineering and technical fields that prepares students for early to mid-career positions in a variety of industries. It’s designed for students who are looking to advance in management, successfully contribute to the overall business or venture, and develop their leadership skills. 

UNIVERSITY OF COLORADO AT BOULDER

MAY 2016

BS Mechanical Engineering

Earned a Bachelor of Science in Mechanical Engineering, gaining a comprehensive understanding of the principles of mechanics, thermodynamics, and materials science to design, develop, and test mechanical systems and devices.