Precinct Evaluation Dashboard

Problem to Solve

When it comes to determining targeting plans for campaigns, many campaigns just use “feelings”. Instead of using data, they go off of the theory of “my friend told me (X)”. Therefore, a lot of political campaigns are uninformed about the layout of the land, and really have no idea about voting trends. This dashboard provides campaigns with a tool so that they can make data-driven decisions instead of decisions based on ‘feelings”. 

Collection/Wrangling Data

This dashboard consists of two datasets. The first set are the election results from the 2022 general election. The second set of results are the bookclosing statistics for the general election. Bookclosing is a report of the number of registered voters who are eligible to vote in a particular election. In this case, we are only looking at those who can vote in the 2022 general election.

How to collect the data depends on which state, county, or city that you need to gather the data from. In the case of the election results, the data was downloaded through the Pinellas County Supervisor of Elections (since the dashboard looks at Pinellas Count). The election results also break down the overall results by voting method (Vote-by-Mail, Early Voting, Election Day). For the bookclosing statistics, the data was downloaded from the Florida Division of Elections. 

If multiple counties/cities are gathered, quite of bit of data cleaning might need to be done. In many cases, cleaning the data to be uniformed would be conducted in Excel (because the data isn’t necessarily large), but unions through SQL works if data cleaning is done on each individual sheet.

Once the data is cleaned, then a number of formulas are put into the spreadsheet to determine percentages, as well as calculating standard deviations, which then creates confidence intervals for the likelihood of maximum votes are a particular party. Here is a link the the final Excel spreadsheet that will be uploaded into the dashboard.

Dashboard Features

The final result of the data is presented in the dashboard below (which might be easier to see in Tableau Public due to sizing issues). As you can see, the dashboard provides precinct-level data, which gives campaigns the ability to make data-driven decisions regarding their targeting plans. 

In addition to this dashboard, there are two buttons on the bottom right that present additional statistic at the district-wide level, so that they can further posit additional information regarding the electorate.