ANLY 2500 Prоject 3: Tаbleаu Prоject Questiоns/Tаsks Starter File: VideoGamesDataset.xlsx Tableau Public Business Context Gamers' Arena is a website dedicated to providing comprehensive information about video games. It tracks the release dates and sales performance of games across various platforms and genres. Different genres, such as RPGs, shooters, multiplayer, and action, appeal to distinct audiences. Recently, Gamers' Arena has introduced a new feature on their website that allows gamers to subscribe on a month-to-month basis. With an active subscription, users can play a limited number of games available on the platform. Objective As the Analytics Lead, your task is to design an interactive dashboard to assist the company director in making a strategic decision regarding a new sales model—a subscription model aimed at attracting more gamers to the platform. Several key questions need to be addressed to evaluate the feasibility of this subscription model. For instance, which games should be included in the subscription, and what should be the optimal duration for the subscription period? To answer these questions, the dashboard should include the following insights: (2 points) Question 1 - Overall Statistics: Total number of games. Total global sales (in millions of USD). Average Critic Score. Total number of users. (5 points) Question 2 - Top-N Analysis: Top-N games, platforms, and genres based on global sales. (2 points) Question 3 - Sales Distribution: Distribution of global sales across different platforms and genres. (5 points) Question 4 - Top-N Games by Scores: Top-N games based on User Score, and Critic Score. (3 points) Question 5 - User Ratings Analysis: Top-N games based on the number of users rated. Average User Score for these top-rated games. (3 points) Create the Dashboard 'Final Dashboard': Replicate the layout as shown in the Tableau visualization. This dashboard will provide a comprehensive view of the current gaming landscape and support data-driven decisions for the subscription model's implementation. Data Description The dataset contains information related to video games, including their release year, platform, genre, and sales figures. Each row represents a unique game and the platform for which it was released, along with details such as sales (in millions of USD), User Score, Critic Score, etc. Column Name Data Type Description Game Name String Name of the game. Platform String Platform for which the game has been released (e.g., PS4, Xbox One, PC). YearOfRelease Date Year of the game's release. Genre String Genre of the game (e.g., RPG, Action, Shooter). Publisher String Publisher of the game. Developer String Developer of the game. NorthAmericaSales Integer Sales in North America (in millions of USD). EuropeSales Integer Sales in the European Union (in millions of USD). JapanSales Integer Sales in Japan (in millions of USD). OtherSales Integer Sales in other regions (in millions of USD). GlobalSales Integer Total global sales of the game (in millions of USD). CriticScore Integer Score given by critics, out of 100. UserScore Integer Average rating given by users, out of 10. UserCount Integer Number of users who rated the game. Note For each Key Performance Indicator (KPI), create a separate sheet. No charts are required for the KPIs listed in Question 1. For Questions 2, 3, 4, and 5, create separate sheets based on the required columns for each question. You should create only one dashboard to address the problem statement by combining the sheets created for all questions. Multiple dashboards are not necessary. If needed, you can use Objects in the Dashboard for titles and to display KPIs. Guidelines Here is an example of how the final dashboard should look. Yours does not need to be exactly the same. Project 3 Tableau Viz Solution Approach (2 points) Question 1: Create a separate measure for each metric using the columns: Game Name, GlobalSales, CriticScore, and UserCount. Display these metrics as KPIs using text boxes or summary tables, as no charts are required for this question. (5 points) Question 2: Create a Treemap using GlobalSales as the main measure. Create a parameter, Top Field Selection - Q2, to switch between displaying data for games, genres, and platforms. Create a calculated field. Name the calculated field, Field Selected - Q2. This calculated field will dynamically update its value based on the selection made in the parameter Top Field Selection - Q2. Create a parameter, Top-N-Q2, for games/genres/platforms to filter the Treemap based on GlobalSales. This will allow the director to focus on the top-performing categories. (2 points) Question 3: Create a Heat Map to visualize the distribution of GlobalSales by platform and genre. Use GlobalSales as the measure and Platform and Genre as the dimensions. This will provide insights into the performance of different game genres on various platforms. (5 points) Question 4: Create a parameter, Rank by average score - Q4, to switch between CriticScore, and UserScore. Create a calculated field. Name the calculated field, Ratings. This calculated field will dynamically update its value based on the selection made in the parameter Rank by average score - Q4. Create another parameter, Top-N-Q4, to filter the data based on the average of Ratings. Use Ratings and Game Name to create a Treemap, displaying the top games by user score and critic score. (3 points) Question 5: Create a Bar Chart using UserCount and Game Name as the main axes. Use Average UserScore in the color marks to show how user ratings vary among the top games. Create a parameter, Top-N-Q5, to filter and highlight the top games based on the number of users. (3 points) Create the Dashboard 'Final Dashboard'. Replicate the layout as shown in the Tableau visualization.
Mаtch eаch with оne оptiоn:
Which type оf clоning deаls with stem cell reseаrch?
At whаt stаge is the embryо when the stem cells аre garnered?