Friday, October 30, 2020

Running 360 Esports Reviews Using APEX - Part 2

This is Part 2 of my blog post exploring using Oracle Application Express to develop an esports 360 review process! If you haven't already please go give Part 1 a read.

After sending everyone their own customized links it took around 24 hours to receive all the player feedback, and my next step was to put together the player-facing dashboards.

Step 3 - Building the Player Dashboards

I wanted players to only be able to view their own information to allow some privacy. I could have made a bunch of user accounts to accomplish this, but instead just used a hidden page item passed via the URL and a unique code for each player. A few additional items I wanted to be able to show for each category evaluated:
  1. The range of scores teammates gave, anonymized so as to give no hard feelings.
  2. The average score from teammates.
  3. The coach's score.
  4. The self-score, or how each person self-evaluated.
That's a lot of information to display at once, but APEX provides a range chart which combined with some line series with line disabled provided this:

The most difficult part was not so much the charting as assembling the data. I had used a flat table structure which didn't fit well with the charting, so I created a view with some UNION queries and the Oracle min/max/avg analytic functions to better align the data structure with what the chart needed. Most players scored themselves within the range provided, although one player we discovered scored himself much higher than both his teammates and coach consensus.

Step 4 - Building the Coach Dashboard

The coach decided not to do the self evaluation, but I still wanted to provide him his ratings as seen by his players in a similar fashion. I also wanted to give the coach the ability to view each player dashboard individually. That was accomplished by simply copying the page above and turning the hidden page item into a visible drop down list to allow the coach to cycle through the player dashboards. This is one feature I love about APEX, how you can easily leverage and reuse prior work. Finally I made a new range chart to provide the coaching data like so:

Part of the reason for evaluating the head coach on these criteria is to help better divide his responsibilities for the next season, allowing him to focus on where he's strongest and adding more staff to provide deeper dives in other areas. I'm happy to see agreement with the team on areas I felt the coach was strongest in - Itemization/Runes, Micro, and Picks & Bans.

The one area I had disagreement on was in Macro/Strategy, where I felt the coach had a great grasp on this but the team at times struggled in game to think on their feet, so I felt a disconnect between player and coach. However the team clearly felt they gained in this area, so I'll need to factor that in for next season's planning. The areas of Team Fight Analysis, Video Review, and Vision are going to to be split into two new video analyst positions next season, and I may or may not seek to fill a third analyst position for Macro/Strategy.

Future Esports Dashboards

The dashboards above have already been helpful as management held a call and stepped through the data with the coach to help make some decisions towards next season. Here are some other ideas I've come up with for dashboards I'd like to develop in the offseason:

  1. Signups for Open Tryouts - We're planning to move into next season with two teams, a Silver/Gold and a Plat/Diamond, so I'll be creating a dashboard to handle signups and gathering of player information.
  2. Player Stats - The game has some nice new built in deep stat analysis, and I would like to explore the API to see if I can pull stats into a dashboard for tracking player progress and areas of improvement.
  3. Accountability - An important piece to the team's continued development is accountability at all levels. Are players showing up for practice or game review? Are coaches doing their individual responsibilities? Is everyone actively playing the game and staying fresh? We can find ways to track this and understand week to week what areas need the most help.
If you have a beginner understanding of SQL and would like to try building your own dashboards I would definitely recommend checking out Oracle Application Express - you can grab a free workspace here to test around with. I've found it a great tool at helping to gather data and solve problems!

The newly constructed Pudong football stadium in Shanghai, China will hold its inaugural event this Saturday 10/31 at 6 am EDT - the League of Legends World Championship featuring SN Gaming (China) vs. Damwon Gaming (South Korea). Stadium will operate at 20% capacity due to COVID.

No comments:

Post a Comment