Game Data Analyst for Player Insights - SQL code required!
Budget: ₹600 – ₹1,500 INR
I need a game data analyst with a strong focus on player behavior analysis.
Here is the description of the task -
For all exercises, there is no limit on the scope.I want you to focus on your analysis skills;
that's why the dataset divided by the different events in the game. The dataset
includes information on player actions, time spent in the game, purchases, and other relevant
metrics. Your task is to analyse the dataset and provide insights that could be valuable for game
developers and designers.
1) TASK 1- SQL
You know that retention is really important in the gaming industry. We are worried about our
gameplay in one of our games. We think that if people don't come the day after, it is because
there is something in the gameplay that doesn't fit. Therefore, business stakeholders want to
answer a simple question: How many users spend more than 60 minutes playing on D0, and
then they don't come the day after?
Provide a SQL code to answer the question: How many users spend more than 60 minutes
playing on D0, and then they don't come the day after?
CSV file: sql_question.csv ( link at the end )
2) TASK 2 - Use case
In this section you’ll find a simulation of what you can find in your day-to-day life as a Data
Analyst. You will receive different data sets that will help you evaluate the case and provide
insights and suggestions.
One of our product managers has shared the following:
In one of our games we’ve seen that retention rate has a downward trend for the last month in
comparison to previous months. Could you take a look and give us suggestions on how we can
fix it?
DATA FILES DESCRIPTION :
You have the following tables available:
user_daily_activities: It sums up all activities for a specific date (reporting_date).
purchases: iap purchases details.
user_ftue: FTUE steps per user.
games: game per user. Each game is structured in different waves.
ads_watched: ads seen per user.
GOOGLE DRIVE LINK OF DATA FILES - https://drive.google.com/drive/folders/12t_Eks1FO_RnhNt0n20fgmn1Gebq_XOu?usp=sharing
Here is the description of the task -
For all exercises, there is no limit on the scope.I want you to focus on your analysis skills;
that's why the dataset divided by the different events in the game. The dataset
includes information on player actions, time spent in the game, purchases, and other relevant
metrics. Your task is to analyse the dataset and provide insights that could be valuable for game
developers and designers.
1) TASK 1- SQL
You know that retention is really important in the gaming industry. We are worried about our
gameplay in one of our games. We think that if people don't come the day after, it is because
there is something in the gameplay that doesn't fit. Therefore, business stakeholders want to
answer a simple question: How many users spend more than 60 minutes playing on D0, and
then they don't come the day after?
Provide a SQL code to answer the question: How many users spend more than 60 minutes
playing on D0, and then they don't come the day after?
CSV file: sql_question.csv ( link at the end )
2) TASK 2 - Use case
In this section you’ll find a simulation of what you can find in your day-to-day life as a Data
Analyst. You will receive different data sets that will help you evaluate the case and provide
insights and suggestions.
One of our product managers has shared the following:
In one of our games we’ve seen that retention rate has a downward trend for the last month in
comparison to previous months. Could you take a look and give us suggestions on how we can
fix it?
DATA FILES DESCRIPTION :
You have the following tables available:
user_daily_activities: It sums up all activities for a specific date (reporting_date).
purchases: iap purchases details.
user_ftue: FTUE steps per user.
games: game per user. Each game is structured in different waves.
ads_watched: ads seen per user.
GOOGLE DRIVE LINK OF DATA FILES - https://drive.google.com/drive/folders/12t_Eks1FO_RnhNt0n20fgmn1Gebq_XOu?usp=sharing