Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #377: Video Game Sales Insights

AYXAcademy
Alteryx
Alteryx

 

This challenge comes to us from @Kenda . Thank you for your contribution, Kenda!


Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.


Video_Game_Image.pngImagine you work as a data analyst for a company that develops video games. They want to create a strategy to increase profitability. The company has asked you to use industry sales data to determine whether the number of new video games released by a company impacts its profit for that year. You have a dataset (video_game_data.csv) that contains historical sales data of video games by multiple publishers around the world across several platforms. Your challenge is to do the following:


• Determine the years when the same video game publisher released the most game titles (based on the exact value in the Name column) AND had the most sales globally (a value you need to calculate).

 

 

Source: https://www.kaggle.com/datasets/gregorut/videogamesales

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
I don't know why Maveryx isn't letting me upload images... 🤔

 

benjimoser
9 - Comet

My Solution

Spoiler
 
Screenshot 2023-06-26 163940.png
ahsanaali
11 - Bolide
Spoiler
 
Untitled.png
braveraj
10 - Fireball

Can't upload the screen shots unfortunately.

nSpire
8 - Asteroid
Spoiler
 
 

Challenge 377.png

 

Clifford_Coon
11 - Bolide

My Solution:

Spoiler
377.jpg

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
 

 
Clipboard01.png
balajilolla2
8 - Asteroid
Spoiler
Solution Attached

 

mmontgomery
10 - Fireball

C377

Spoiler
C377.png