Pro Bono: IEEE Chicago Section Statistician - Part 2
This past month, I submitted a first post in a series that discusses some of my pro bono contributions as Statistician for the IEEE Chicago Section. As stated in that post, my goals are to work with the Membership Development Chair to meet his immediate needs, as well as explore some ways that we can use the data to help understand our members. In other words, look at our membership at both an aggregate and individual level. I also mentioned that in my opinion, some of the best insights will likely come from an investigation of the data at a more granular level, and then determine how findings might apply to the aggregate.
Since it was recently requested that I take ownership of some ongoing monthly reports that have been manually constructed by exporting data from canned IEEE queries in an Oracle Business Intelligence Enterprise Edition (OBIEE) 11g instance called SAMIEEE to Microsoft Excel, I am expecting the need to review at some level what has been done in the past with respect to these reports. In taking a first look at these reports, I especially wanted to gain familiarity with the graph and associated spreadsheet for year over year (YOY) monthly membership totals, because it provides a snapshot of the chapter over time, and has been used to demonstrate the annual membership lifecycle.