Blog

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.

ANLY 2500 Homework 9: Tableau 3    Homework Questions/Task…

ANLY 2500 Homework 9: Tableau 3    Homework Questions/Tasks Starter File: wineSales.csv   Tableau Public Business Context Guns & Roses is Australia’s most well-known wine distributor, offering a wide variety of wine brands and flavors. The firm’s director requires immediate and up-to-date information to make informed decisions. Objective As a member of the analytics team, you are expected to create four dashboards focusing on customer, geographic, product-related, and sales information, respectively. Dashboards Geographical Overview Product Overview Customer Overview Sales Overview   Dataset description: The dataset is a comprehensive record of wine sales, with 9,367 rows and 21 columns. It includes information about sales transactions, customer details, order logistics, and wine-specific attributes. Columns: Row ID: A unique identifier for each row. Discount: Percentage discount applied to the order. Unit Price: Price per unit of the product. Freight Expense: Cost associated with freight. Customer Name: Name of the customer. Freight Mode: The mode of freight transport (e.g., Express Road Cargo). Category: Broad category of the wine (e.g., Red Wine, Rose / Sparkling Wine). Region: Geographical region of the sale (e.g., East, West). Priority: Order priority (e.g., Critical, High, Low). Subcategory: Subcategory of the wine (e.g., Chardonnay, Malbec). Revenue Target: Revenue goal for the transaction (mostly missing). Quantity Target: Targeted quantity for the transaction (mostly missing). Item Name: Full name of the wine item sold. Packaging Type: Type of packaging used (e.g., Standard Size Crate, Full Container). City: Customer’s city. Order Date: Date the order was placed. Dispatch Date: Date the order was dispatched. Order Quantity: Quantity of the item ordered. Order ID: Unique identifier for the order. Country: Country of the transaction. State or Province: State or province where the transaction occurred.   Dashboard 1: Geographical Overview To create the Geographical Overview dashboard, four worksheets need to be set up with the following information: (1 point) Worksheet ‘Sum of the order quantities’: Drag and drop ‘Order Quantity’ into the large blank panel in the worksheet with text ‘Drop field here’. Change the chart type to ‘text tables’. (1 point) Worksheet ‘Total Sales’: Use the following formula to create a calculated field named “Sales”. [Order quantity]*[Unit Price] Drag and drop ‘Sales’ into the large blank panel in the worksheet with text ‘Drop field here’. Change the chart type to ‘text tables’. (2 points) Worksheet ‘Sales per city’: Drag and drop ‘City’ into ‘Rows.’ Drag and drop ‘Sales’ into ‘Columns’. Change the chart type to ‘Bar’ and sort it in descending order. Create a parameter named ‘Sales baseline per city’ with the settings shown in the following picture. Use the following formula to create a calculated field named “Sales status”. IF SUM([Sales])>=[Sales baseline per city] THEN “Above the sales baseline”ELSE “Below the sales baseline”END Drag and drop ‘Sales status’ into ‘Color’. Click the ‘Analytics’ panel. Drag and drop ‘Reference Line’ into ‘Table’. : $ In the ‘Data’ panel, section ‘Parameters’, choose ‘Sales baseline per city’. Right-click and choose ‘Show Parameter’. (2 points) Worksheet ‘Sales per State or Province’: Drag and drop ‘State or Province’ into the large blank panel in the worksheet labeled ‘Drop field here.’ Drag and drop ‘Sales’ into ‘Label’. Drag and drop ‘Sales’ into ‘Color’. Add two filters: ‘Region’ and ‘Sales’ by dragging these fields into ‘Filters’. Right-click each filter and choose ‘Show Filter’. For the ‘Region’ filter, click the down-arrow icon and select ‘Single Value (dropdown)’. (1 point) Create the Dashboard ‘Geographical Overview’: Replicate the layout as shown in the Tableau visualization. Click the down-arrow icon on the ‘Region’ filter, choose ‘Apply to Worksheet’ -> ‘Selected Worksheets…’, and check all relevant worksheets.   Dashboard 2: Product Overview (0.5 points) Worksheet ‘Number of categories’: Drag and drop ‘Category’ into the large blank panel in the worksheet labeled ‘Drop field here’. Then change it to the measure ‘Count Distinct.’ Change the chart type to ‘text tables’. (0.5 points) Worksheet ‘Number of subcategories’: Drag and drop ‘Subcategory’ into the large blank panel in the worksheet labeled ‘Drop field here’. Then change it to the measure ‘Count Distinct.’ Change the chart type to ‘text tables’. (0.5 points) Worksheet ‘Number of items’: Drag and drop ‘Item Name’ into the large blank panel in the worksheet labeled ‘Drop field here’. Then change it to the measure ‘Count Distinct.’ Change the chart type to ‘text tables’. (2.5 points) Worksheet ‘Product by category’: Create a parameter named ‘Quantity/Sales For Dashboard Product’ with the settings shown in the following picture. In the ‘Data’ panel, section ‘Parameters’, choose ‘Quantity/Sales For Dashboard Product’. Right-click and choose ‘Show Parameter’. Use the following formula to create a calculated field named “Selected Field for Dashboard Product”. IF [Quantity/Sales For Dashboard Product]=”Quantity”THEN [Order quantity]ELSE [Sales]END Drag and drop ‘Category’ into ‘Rows’. Drag and drop ‘Selected Field for Dashboard Product’ into ‘Columns’. Click the down-arrow icon in ‘Selected Field for Dashboard Product’, and select ‘Quick Table Calculation’ -> ‘Percent of Total.’  Change the chart type to ‘pie charts’. Drag and drop ‘Selected Field for Dashboard Product’ into ‘Label’. Click the down-arrow icon in ‘Selected Field for Dashboard Product’, and select ‘Quick Table Calculation’ -> ‘Percent of Total.’  Drag and drop ‘Category’ into ‘Label’. Add two filters: ‘State or Province’ and ‘Priority’ by dragging these fields into ‘Filters’. Right click each filter and choose ‘Show Filter’. For each filter, click the down-arrow icon and select ‘Single Value (dropdown)’. (1 point) Worksheet ‘Product by subcategory’: Drag and drop ‘Subcategory’ into ‘Rows.’ Drag and drop ‘Selected Field for Dashboard Product’ into ‘Columns’. Change the chart type to ‘Bar’ and sort it in descending order. (1 point) Worksheet ‘Product by item’: Drag and drop ‘Item Name’ into ‘Rows.’ Drag and drop ‘Selected Field for Dashboard Product’ into ‘Columns’. Change the chart type to ‘treemaps’. Drag and drop ‘Item Name’ into ‘Label’. Drag and drop ‘Selected Field for Dashboard Product’ into ‘Label’. (1 point) Create the Dashboard ‘Product Overview’: Replicate the layout shown in the Tableau visualization. For each filter, click the down-arrow icon and select “Single Value (dropdown).” Click the down-arrow icon on filters, choose ‘Apply to Worksheet’ -> ‘Selected Worksheets…’, and check all relevant worksheets.   Dashboard 3: Customer Overview (1 point) Worksheet ‘Number of customers’: Drag and drop ‘Customer Name’ into the large blank panel labeled ‘Drop field here’. Then change it to the measure ‘Count Distinct.’ Change the chart type to ‘text tables’. (1 point) Worksheet ‘Customers by Year’: Drag and drop ‘Order Date’ into ‘Rows.’ Drag and drop ‘Customer Name’ into ‘Columns,’ then change it to the measure ‘Count Distinct.’ Change the chart type to ‘Bar’. Add two filters: ‘Region’ and ‘City’ by dragging these fields into ‘Filters’. Right-click each filter and choose ‘Show Filter’. For each filter, click the down-arrow icon and select ‘Single Value (dropdown)’. (1 point) Create the Dashboard “Customer Overview”: Replicate the layout as shown in the Tableau visualization. Click the down-arrow icon on each filter, choose ‘Apply to Worksheet’ -> ‘Selected Worksheets…’, and check all relevant worksheets.