Player activity data: an individual planning report
My individual plan for a group project on player data from a research game server. I joined two tables, explored the data in three charts and proposed a model.
- Question
- Which kinds of players contribute the most play time to the research server?
- Data
- Course data from a research game server: 196 players and 1,535 play sessions.
- Method
- I joined the sessions to the players and calculated the total session minutes for each player as the response. I made three exploratory charts.
- ResultPublished
- A proposal for a k-nearest-neighbours regression with scaled inputs, a 75/25 split and five-fold cross-validation.
A plan, not a fitted model. This page gives no model result. The final report of the group took a different approach and is not shown here.
What the report contains
- A description of the two tables and their variables.
- The join of sessions to players, and the total session minutes for each player.
- Three exploratory charts of play time.
- The proposed method: the split, the scaling, the model and the cross-validation.
Why this method
The response is a number, so the task is a regression. A k-nearest-neighbours model makes no assumption about the shape of the relation. It needs scaled inputs, because it uses distances.
Cross-validation on the training part selects the number of neighbours. The test part stays unused until the end.
More work
- Stay for the exhale
I turned a yoga teacher's classes into a membership product. I did the strategy, the design, the build and the operations.
- A bank reconciliation that explains each difference
A working sample of the reconciliation method from my years as Operations & Finance Lead. Excel formulas match 119 bank lines to 121 ledger entries, explain each difference and reconcile to 0.00.
- SQL case studies: revenue share, donor segments and a 3NF schema
Three SQL studies on small course datasets. Each one starts with a business question. Every figure is query output that you can run again.