Tyler Broderick

Data Analyst | Learning AI

About Me

I’m Tyler Broderick, a physics graduate (B.A., Clark University, 2024) deeply fascinated by AI’s transformative potential.My physics background brings with me an ability to approach difficult problems and persevere through them.I’m eager to join a team as a Junior Data Analyst or AI Intern, to combine by background with the world of AI and shape its future impact.

Skills

Python | SQL | Excel | Power BI | MATLAB

  • Statistical Analysis

  • Differential Equations

  • Linear Algebra

  • Team Leadership

  • Project Management

  • Communication

Projects

EXCEL
SNOWFALL ANALYSIS
DASHBOARD

Historical analysis and visualization of the last 136 years of snowfall data in Storrs, CT.

Thanks!

Thank you for taking the time to visit my portfolio!
If you'd like to chat about me joining your team, feel free to email me using the form below 👇

Contact Me

EXCEL | HISTORICAL SNOWFALL ANALYSIS

Dynamic analysis of historic snowfall in Storrs, CT, from 1889 to 2024.Curious about snowfall patterns in my home town so I developed this project to analyze and visualize trends, distributions, and probabilities.

I had the following questions in mind:

  1. How has annual snowfall trended over time?

  2. Which month typically has the highest snowfall?

  3. What is the most amount of snow ever in one day?

  4. What’s the probability of getting a certain amount of snow per year (e.g., >50 inches)?

  5. How does the actual snowfall distribution compare to a theoretical model?

I took the following actions to create the dashboard:

  1. Created a PivotTable with slicers for dynamic year and month selection.

  2. Built a line chart for annual snowfall trends (1889-2024).

  3. Added a column chart for average monthly snowfall, identifying January as the snowiest month.

  4. Created a pie chart for snowfall distribution across ranges (e.g., 0-10, >50 inches).

  5. Developed a probability calculator with a button to input thresholds and calculate P>X (e.g., P>50 inches: 17.04%).

  6. Plotted actual vs. theoretical CDF (normal distribution) to compare distributions.

  7. Formatted the dashboard for a clean, professional look with aligned charts and slicers.

Here are some key insights:

  1. January is the snowiest month, averaging 7.84" year.

  2. The most snow ever in a single day was 2/9/2013 with 26"

  3. The average annual snowfall is 29" per year.

  4. There’s a 17.04% chance of snowfall exceeding 50 inches annually, but only a 0.26% chance of exceeding 85 inches (theoretical).

  5. The actual distribution is right-skewed (skewness: 0.8), differing from the theoretical normal model.