Module 4. Assignment: Time Series Visualization with Tableau

Because the end goal is to create a time-series, I decided to keep the variables that would show a change over time. And so I decided to keep the following variables: Year, Month, Service Area Population, Vehicle Revenue Miles, Vehicle Revenue Hours, Total Events, and Total Injuries. From these variables, the following time series visual was created. 


(Please click image for better clarity)

In this time series visualization of transit operations and safety from 2014–2025, several clear patterns emerge. Vehicle Revenue Miles and Hours remain steady until 2020, when they drop sharply due to COVID-19, before partially recovering in later years. Total Injuries follow a similar trend but rise again after 2022, suggesting that safety risks grew as service levels came back. Also could be due to an influx in people coming outside and using public transit. Interestingly, Total Security Events remain flat until 2022, then spike sharply, raising questions about reporting changes or new security challenges. The population measure looks odd because it suddenly falls near the end, which might be a data issue and I cannot think of other reasons for the dip. Overall, the chart shows how major events can affect both service and safety over time, and it makes me think it would be useful to look at rates (like injuries per mile) instead of just raw totals to get a clearer picture, which could be the next step!



Comments

Post a Comment

Popular posts from this blog

Final Project Diamond Database

Image
 Problem Description:  I have always been interested in diamonds—their value, how they are traded, and the global network behind them. Growing up in India, where diamond buying is culturally significant and cities like Surat serve as major worldwide centers for diamond cutting and polishing, I was frequently exposed to discussions about diamond quality, pricing, and craftsmanship. I also enjoy watching documentaries about diamond grading and international trading, which deepened my curiosity about how specific characteristics influence market value. Although my personal experience is rooted in the Indian diamond market, the dataset used in this project—the well-known diamonds dataset—reflects U.S. retail pricing. This creates an interesting opportunity to compare my personal understanding with patterns observed in a different but well-established market. Importantly, many of the attributes used to evaluate diamonds—carat weight, cut quality, clarity, and color—are universal gr...
Read more

Module 6. basic data visualization using R

Image
I created a boxplot using the mtcars dataset to compare miles per gallon (MPG) among vehicles with different numbers of cylinders. A boxplot is useful for showing the distribution and variability of data across categories, highlighting the median, quartiles, and outliers. I chose this chart because it provides a clear summary of how fuel efficiency changes as engine size (cylinders) increases, without too much intricate detail. To add, the visualization did reveal clear differences between the groups. Cars with four cylinders had noticeably higher MPG values, showing that they are generally more fuel-efficient. In contrast, vehicles with six or eight cylinders had lower MPG values, suggesting that as engine size increases, fuel efficiency tends to decrease. This pattern shows a strong inverse relationship between the number of cylinders and miles per gallon. In terms of deviations in the data, the chart mostly confirmed the expected trend that larger engines consume more fuel. Howe...
Read more

Module 5. Assignment: Create Your Own Visualizations assignment Plotly vs. Datawrapper

Image
The dataset can be seen below: Ranking Chart using an ordered bar chart: Part-to-Whole Chart using a donut chart: Why you chose this dataset. I chose this dataset because it has two straightforward but meaningful variables: Time on the x-axis and Average Position on the y-axis. This setup is applicable in many real-world contexts. For example, “Time” could represent days, months, or trials in an experiment, while “Average Position” could represent a performance ranking, a score, or some measure of quality. Many real datasets look like this: something is being tracked over time to see whether it improves or declines. Practicing with this data can assist in getting used to analyzing patterns that are very relevant in fields like business (tracking customer satisfaction), sports (tracking performance stats), or technology (tracking algorithm accuracy).  The story or insights your visualizations tell. The ordered bar chart revealed that as Time increased, the Average Position steadily ...
Read more