Question: 1. Prepare the Data (Required): Joining the Sheets- After loading the dataset, join the sheets on their respective common field - e.g., join the 'Sales

1. Prepare the Data (Required): Joining the Sheets- After loading the dataset, join the sheets on their respective common field - e.g., join the 'Sales Data' and 'Zip Code' sheets on their common field. Checking on data type - Make sure to check and change each field/column data type with resect to its content. Working with Calculated Fields- The dataset includes values for Sales Price per Item, Profit per Item, COGS (i.e., cost per item), and Quantity Sold. To support your analysis, create calculated fields in Tableau such as: Total Sales = [Sales Price per Item] * [Quantity Sold] Total Profit = [Profit per Item] * [Quantity Sold] Total Costs = [COGS] * [Quantity Sold] To create a calculated field: Right-click in the Data pane > Create Calculated Field > Enter formula and click OK. 2. Create 5 Required Charts: KPI Card - Show a summary metric (e.g., Total Sales, Total Profit, Quantity Sold) (current year vs. previous year). Drill-Down Chart - Enable drill-down by Category Sub-Category to explore performance. A Map Chart - Identify location contributors to Sales or Profit. Analyst's Choice (2 charts)- Create 2 charts you believe would be most impactful for the business. 3. Add Interpretation (Required): Each chart must include a 1-2 sentence interpretation of what it reveals based on your observations. How to Add Interpretation using Captions: Right-click on the worksheet and select 'Show Caption'. OR, if the caption isn't already visible, go to the Worksheet menu and select Show Caption. Type your interpretation directly into the caption box below the chart. Focus on trends, anomalies, or key takeaways revealed by the chart

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock