Posted Oct. 5, 2020, 9:28 p.m. by Vice Admiral Daniel Lerner (Procedures Guru / Personnel Director / Chief EGO) (Daniel Lerner)
So I’ve been told that while it is important that we record and report the stats, etc. in the PDept reports, it is hard for the average user not dealing with these numbers every day for over two year (have I been PDir that long?!) to appreciate what the numbers mean or the trends. I’ve decided to experiment with some charts to help visualize the trends.
I’ll start with the membership tracking charts. If people think these are useful, I’ll also add trends for which departments have the most requests/placements, and how we are doing with our processing times for placements.
Recruitment and Retention Chart
A big issue tracked by the PDept is how our membership numbers changing from month-to-month and why. I’ve decided to make a chart to help visualize that. Keep in the mind the following:
Here is the chart: https://docs.google.com/spreadsheets/d/1COfnHLY5VT1R5cy9a3-skFCV-GZoFCw41Efgd0rd91s/edit?usp=sharing. The different spreadsheets give you a 2-year snapshot, a 1-year snapshot, a 6-month snapshot and a 3-month snapshot.
Member Tracking Chart
So what is the trend of the number of new members placed per month, and how many of them actually stay active? Those numbers are in the report, but hard to see the trend if you aren’t following this all the time.
It’s a bit too difficult to have Google Sheets do a clustered stacked column graph with three stacked columns per month. So I instead give the overview of the new members’ activity within the 0-1 month range and then the 2-3 month range (skipping the 1-2 month range). Each month represents the new placements for that month that the PDept then tracked. The first bar is how active they were at the first report after they were placed (i.e. 0-1 months), and then again at the third report after they were placed (i.e. 2-3 months).
The chart only goes to the July 2020 placements, as that is the last one we would have two to three months of data on.
There are three charts (each one can be seen with the actual values or the percentages):
If these charts are useful, I will include them in future reports to make it easier for those trying to follow the numbers.
Daniel Lerner
Personnel Director
© 1991-2024 STF. Terms of Service
Version 1.15.11