Project 9 | Data-driven Storytelling

^{Joel Lamonth’s YouTube Video, Transcript found in Description.}

What story did you identify in the data?

The main story that I identified right off the bat was how popular the Queens borough has been from 2017-2021. They have outperformed all the other boroughs, and it could be due to other factor but all we have is what we know which is the attendance from the following years. The weekday vs weekend attendance pattern is slightly evident when looking at the graphs, towards the middle of the week attendance is doing well but then it slightly goes down during the weekend. Some boroughs close down for some days which leads to them not having any data for that day which could be the result the that

How did the media that you choose support the data?

For this project, I decided to create a short video to present the story behind the data from the Summer Sports Experience in New York. I had graphs, and visuals things supporting me while I talk about the data because it helps to have stuff on the screen while narrating/ talking. It helped me point stuff out better and I feel like it supported the data I had really well.

What was the process of making your media? Including the equipment and software you used?

The camera and audio I used to make this project was the same that I used to make Project 7 and 8. The Canon SL3 DSLR Camera with a RODE VideoMicro Shotgun Microphone.

Credits/Attribution

The footer with the words was from the visual catalog in Capcut

The Graph and Pivot table is by Joel Lamonth, using Excel

All the drawings are from the visual catalog in Capcut

Transcript of Video

Hello! Hope you all are having a wonderful day. 
Today, we’re gonna be diving into the fascinating data from the Summer Sports Experience program out in New York, 
which provides sports instruction to kids from ages of 8 to 14. 
Let’s explore the trends and see what it has to reveal about attendance from 2017-2021 across the city’s boroughs.
First off, let’s talk about Queens. Queens consistently has the highest attendance compared to all other boroughs. 
Across all the days in the data, it is by far a clear favorite to go to, making it the most popular borough for this program.
But there’s more to the story. 
Look at this trend: attendance is relatively high in the middle of the week, but as the weekend approaches, especially on Saturdays, there’s a noticeable drop in numbers. This pattern is consistent across almost every borough. 
That’s very Interesting, right?, I would think that on weekends it would be a little bit higher because it’s the weekend and you want to go out and play, But I guess not.
Alright, Moving on. Now, you might have noticed some gaps in the data. That’s because certain locations were closed on specific days. These closures are reflected as missing data, but they help us understand why attendance numbers vary so much in some cases."
So, how did I uncover these trends you may ask? Well, It started with me, carefully observing the data, organizing it by days and boroughs by using pivot tables and graphs. I spotted the patterns, You know, Queens dominating in popularity, the midweek attendance peaks, and the weekend drop-offs. 
Thanks for joining me as I uncovered and analyzed some trends, and I hope this inspires you to look deeper into the data as well, Thank you