Project Goal: Power data and visualizations for our annual report with the SFIA

SFIAPickleheadsReport.pdf

Start with 2024 working file:

Pickleheads - SFIA 2024 Working File.xlsx

Create all data cuts, graphs and tables as the final 2023 version:

SFIA Court Data 2023 - Sanitized.xlsx

<aside> 💡 A good number of the columns and graphs have already been created. Make sure the files match closely

</aside>

This involves:

1. Adding columns to compute indoor, outdoor and indoor + outdoor counts (Columns H-J, R-U) DONE
2. Adding columns for population and city_slug (Columns AN, AD) DONE
3. Adding tabs for pivot tables (mostly done)
4. Adding graphs
5. Adding tables

<aside> ☝

If you encounter unknown, (blank), etc data, we need to proportionally attribute those to the other attributes for reporting. Check out my examples in the working file on the Outdoor vs Indoor Facilities tab

</aside>

<aside> 🚧

You will see many blank cells under Population in the City Data (this is raw from our data base). Any ideas on how to fill that data?

</aside>

Be sure to follow our color palette and font families for styling all graphs: