This dashboard is modelled after a dashboard I created for the Austin Saxophone Ensemble to track enrollment in our summer camp. Student records for the current year 2023 flowed into a Google Sheet automatically as students submitted enrollment forms through our website. I then performed various data cleaning and transformation steps to combine previous years data with the current year. Finally the data was connect to a Looker Studio Dashboard.
For this project I created fake records that followed the same structure and mimicked the "messy" attributes of the original data set, while removing real names and obscuring the actual enrollment numbers.
Maintain the $225 tuition as the increase in tuition helped boost revenue and did not adversely affect enrollment
Send payment reminder to those that have not paid
Send promotional email to students who enrolled last year but have not yet this year (listed on page 2 of dashboard)
Reach out to private teachers Gunter, Bull, and McFly who have soprano students attending, and ask for help recruiting more middle school soprano players. And have at least one middle school student who listed baritone as a secondary instrument play baritone for the camp
Focus future recruiting efforts on Austin, Lake Travis, and Pflugerville ISDs
Use the list of schools sending students for the first time to send thank you notes to teachers at those schools in order to foster a continued relationship with them
Drop Down Filter and Cross Filters (as seen in the pics above of instrumentation tables)
The data for the current year 2023 signups flows into the 2023 Raw tab dynamically from the an online enrollment form. The historical data for 2022 is copied over from a seperate spreadsheet with a different structure to 2023. Payment status and scholarship offers were kept on separate tabs.
I performed multiple steps to clean and transform the raw 2023 enrollment records into a clean 2023 Signups data set, then further combine the 2022 and 2023 data along with the payment and scholarship info into the Total Signups dat set
To create fake records to fill the 2022 data and 2023 raw data, I used a combination of Numpy and Faker in Python, as well as altering some records by hand to preserve specific "messy" aspects of the original data