_edited_edited.png)
Gamers' Arena is a website that provides information about video games.
It keeps track of the games that have been released and their sales across various platforms and genres. Different genres, such as RPGs, shooters, multiplayer, action, and so on, would appeal to different audiences. Gamers' Arena has now implemented a feature on their website that allows gamers to subscribe to their platform on a month-to-month basis. They can play a limited number of games as long as they have a subscription.
HOW TO PROCEED WITH THE CASE STUDY DATA SET:
Understand the Problem and Data
Read the case study carefully: Understand the business context, goals, and key metrics .
Data Acquisition: Access the relevant dataset in a compatible format (Excel, CSV, etc.).
Data Preparation in Tableau
Connect to Data Source: Import the dataset into Tableau.
Data Cleaning:
Identify and handle missing values.
Check for data inconsistencies or outliers.
Format data types correctly (date, numeric, text).
Data Transformation (if required):
Create calculated fields to compute new measures.
Do data blending or joins of data from various sources
Exploratory Data Analysis
Drag and drop dimensions and measures on the Tableau canvas to develop bar charts, line charts, scatter plots, and maps.
Apply filters to slice and dice data based on several variables.
Color code to emphasize the key trend.
Deep Dive Analysis
Identify Key Insights:
Look for patterns, correlations, and anomalies in the data.
Apply analytics features such as trend lines, forecast lines, and distributions available within Tableau to understand the behavior of data.
Create Calculated Fields:
Employ conditional logic, IF statements, to derive new metrics based on specified criteria.
Develop custom calculations to answer specific questions from the case study.
Visualization and Storytelling
Dashboard Design:
Set multiple charts and graphs up together in one dashboard to get an overview.
Use filters, drill-downs, and tooltips for deeper exploration.
Story Creation:
We connect the visualizations with narrative text to explain key findings and insights.
Consider the audience and tailor the story to their needs.
Important Considerations:
Documentation:
Clearly document your analysis process, including data cleaning steps, calculated fields, and key insights.
Ethical Considerations:
Be sensitive to data privacy and use results responsibly.
Communication:
Show your results in a clear and straightforward manner, using visualizations and language appropriately.
DATA SET:
DESCRIPTION:
The dataset contains information related to the games, their release year, platform, genre and their sales. Each row represents a Unique Game and the Platform for which it is released, Sales(in million $), UserScore, CriticScore etc..
Let us analyse the data,
Name: [String] Name of the game
Platform: [String] Platform for which the game has been released
YearOfRelease: [Date] Year of the game's release
Genre: [String] Genre of the game
Publisher: [String] Publisher of the game
Developer: [String] Developer of the game
NorthAmericaSales: [Integer] Sales in North America in million($)
EuropeSales: [Integer] Sales in European Union in million($)
JapanSales: [Integer] Sales in Japan in million($)
OtherSales: [Integer] Sales in other regions in million($)
GlobalSales: [Integer] Global Sales in million($)
CriticScore: [Integer] Score given by critics out of 100
UserScore: [Integer] Average Rating given by users out of 10
UserCount: [Integer] Number of users that rated the game
OBJECTIVE:
As an analytics lead, you must design an interactive dashboard that helps the director of the company make a decision on a new sales model (a subscription model) that will attract more gamers to our platform. There are multiple questions to be answered in order to make the decision on the subscription model. For example, which games need to be given for the subscription and what would be the duration? In order to answer these questions, a dashboard needs to be created with the following information:
What is the total number of games? What is the total global sales in millions of dollars (USD)?What is the average CriticScore? What is the total number of users?
Which are the top-N games, top-N platforms, and top-N genres based upon GlobalSales?
How have GlobalSales been distributed across platforms and genres?
Which are the top-N games based upon UserScore, CriticScore, and the number of users rated?
What are the top N games based on the number of users rated and what is the average UserScore for these games?
Lets find the solution for the first question using our data set for this we can use the SUM and AVG functions.
What is the total number of games? What is the total global sales in millions of dollars (USD)?What is the average CriticScore? What is the total number of users?
OBSERVATION:
The total number of games is 6046
The total global sales is 6004 in millions of dollars (USD)
The average CriticScore is 57.42
The total number of users are 1,279,688
Which are the top-N games, top-N platforms, and top-N genres based upon GlobalSales?
OBSERVATION:
 The top N Games/Genre/Platform is Willisports
 The top global sales is 82.53
 The least N Games/Genre/Platform is New super Mario bros
 The least global sales is 28.32
3. How have GlobalSales been distributed across platforms and genres?
Which are the top-N games based upon UserScore, CriticScore, and the number of users rated?
OBSERVATION:
 The top N Usercount/ User Score/ Critic Score is Soul calibur
 The top global sales is 98
 The least N Usercount/ User Score/ Critic Score is Tekken 3
 The least global sales is 96
5. What are the top N games based on the number of users rated and what is the average UserScore for these games?
The Final visualization :
CONCLUSION :
Key Outcome from the Data , Our data shows the respective visualization for each valuable catergory how it can be calculated so Whether one is a seasoned data analyst or just a beginner in the field, Tableau's friendly interface and rich functionality make it an indispensable instrument for anyone looking to visualize and interpret their data. Tableau proved to be very helpful for the junior data analysts by helping them conduct effective analyses, clearly present insights, and underpin decision-making with appealing interactive dashboards. By mastering Tableau, you will not only become a stronger analyst but also become capable of providing more value with insightful, data-driven solutions to real business problems.