ANLY 2500 Project 3: Tableau Project Questions/Tasks St…
ANLY 2500 Project 3: Tableau Project Questions/Tasks 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.
Read DetailsKrispy Kreme employs value-based pricing to maximize profits…
Krispy Kreme employs value-based pricing to maximize profits. Krispy Kreme uses research and customer analysis to formulate targeted price increases that capture the greatest amount consumers are willing to pay. Which of the following statements is true of value-based pricing?
Read DetailsANLY 2500 Homework 7: Tableau 1 Homework Questions/Task…
ANLY 2500 Homework 7: Tableau 1 Homework Questions/Tasks Starter File: Omega_HR.csv Tableau Public Business Context:Omega Pvt. Ltd. is a consultancy firm that partners with multiple companies to deliver services tailored to client requests. The company has around 12 departments, each with teams ranging from ten to thousands of employees. Recently, several departments have requested additional hires due to low team bandwidth. Objective:The company’s COO wants to explore ways to optimize employee bandwidth internally. The COO also wants a dashboard included in their deck to track the following metrics to enhance bandwidth optimization: Number of employees and their location Number of employees based on designation and age distribution Hiring trends within the organization The “Omega_HR” dataset contains 22,211 employee records and provides detailed information on demographics, employment status, and location. Key columns include: Employee Identifiers: Id (unique identifier) and Complete Name. Demographic Information: Age, Birthdate, and Gender. Employment Details: Employment Status (Active or Terminated) and Terminated (binary: 1 if terminated, 0 if active). Hire Date and, if applicable, Termdate (date of employment termination). Jobtitle, specifying each employee’s role within the organization. Location Data: Location (HQ or Remote), Location City, and Location State. Based on the ‘Omega_HR’ dataset, create the following 8 sheets and 2 dashboards in Tableau Public. Instructions Guidelines Here is an example of how the final viz should look. Yours does not need to be exactly the same. HW 7 Tableau Viz (1 point) Question 1: How many employees do we have? Create a worksheet named ‘Number of Employees’ and display the total number of employees on this sheet using the ‘Id’ column. Drag and drop “Id” into “Text.” Set the measure to “Count Distinct.” This number looks fine here, but creates a problem when we add it to a dashboard. So, change the standard setting to “Fit Width.” The number moves to the far right. To align it to the left: Go to “Text,” select “Alignment,” and click “Left Alignment.” (1 point) Question 2: How many job titles are there? Create a worksheet named ‘Number of Designations’ and display the total count of distinct designations on this sheet using the ‘Jobtitle’ column. Repeat the process for the field “jobtitle.”You should see 185 as the result.Don’t forget to set Fit Width and Left Alignment for proper formatting. Change the chart type to “Text Tables” if it is currently displayed as a “Bar” chart. (1 point) Question 3: Number of Active Employees Create a worksheet named ‘Number of Active Employees’ and display the total count of active employees using the ‘Employment Status’ column. Apply ‘Employment Status’ as a filter to keep only the active employees. Drag and drop “Employment Status” into “Text.” Set the measure to “Count Distinct.” This gives the total number of employees (same as in Sheet 1). However, we only need to find the count of active employees. Drag and drop “Employment Status” into the filter. Select “Active” > Apply > OK. What is the total? 19,987 Don’t forget to apply formatting. Change the chart type to “Text Tables” if it is currently displayed as a “Bar” chart. (2 points) Question 4: Distribution of Employees Across Departments Create a worksheet named ‘Number of Employees by Department’ and display the count of employees in each department using the ‘Id’ and ‘Department’ columns. Show the result as a bar chart. Drag “Department” into Rows. Drag “Id” into Columns and set the measure to “Count Distinct.” (2 points) Question 5: Map Chart – Finding Employees by Location Create a worksheet named ‘Number of Employees by State’ and display the count of employees in each state using the ‘Id’ and ‘Location State’ columns. Display the result as a map chart. Drag “Location State” into Columns. Drag “Id” into Rows. Click “Show Me” and select the Map chart. Fill the states with the number of employees by clicking the “T” button. (2 points) Question 6: Hiring Trend – Line Chart Create a worksheet named ‘Number of Employees by Hire Year’ and display the count of newly hired employees for each year using the ‘Id’ and ‘Hire Date’ columns. Show the result as a line chart. Drag “Hire Date” into Columns. Drag “Id” into Rows. Display values using the “T” button. (2 points) Question 7: Age Distribution – Histogram Create a worksheet named ‘Employee Age Distribution’ and display the age distribution of employees using the ‘Age’ column. Show the result as a histogram. Drag “Age” into Rows. In Show Me, select Histogram as the chart type. (2 points) Question 8: Number of Employees by Job Title Create a worksheet named ‘Number of Employees by Job Title’ and display the count of employees in each job title using the ‘Id’ and ‘Jobtitle’ columns. Show the result as a treemap. Drag “Jobtitle” into Rows. Drag “Id” into Columns and set the measure to “Count Distinct.” You will see a bar chart. Change it to a Tree Map. To display the job title numbers in each rectangle, drag and drop “Id” into Label and set the measure to “Count Distinct.” (3.5 points) Question 9: Create a dashboard named ‘Employee Insights Dashboard – Overview’, replicating the layout shown in the Tableau visualization above. (3.5 points) Question 10: Create a dashboard named ‘Employee Insights Dashboard – Hiring Insights’, replicating the layout shown in the Tableau visualization above. After completing the assignment, upload your finished Tableau file (.twbx) here. https://www.youtube.com/watch?v=7GQItHzW9lM
Read Details