Season Ticket Holder : Data Visualization

Product Designer

 

A group of Golden State Warriors season ticket holders expressed the need for a way to visualize the performance of their ticket sales throughout the season. I developed an excel spreadsheet to serve as a dashboard, allowing a quick overview of the season ticket holder's current status.

Dashboard Design:

The documents main function is to assess performance starting from the beginning of the season to the current date.

Vertically, the viewer can quickly assess current sales & purchase price between total for the year, regular season and the post season.

Horizontally, current performance is compared to purchase price for the year, regular season and the post season.

Graphs are used to get a more granular look at the regular and post season sales.

Data Entry:

The dashboard is driven by the data entry section of the spreadsheet. Over time, individual sales are entered by the user in the spreadsheet below.