Assignment Metadata
- Starter Dataset:
MV_Sales.xls - Required Software: Tableau Public (Web Authoring or Desktop)
- Submission Format: Image screenshots submitted to Canvas — each deliverable must include your name from the top-right corner of the Tableau window.
Lab Overview
This lab teaches you how to customize existing visualizations and create a map visualization in Tableau Public following best practices. You will work with an existing workbook (from Lab 1 Part A) and apply formatting, color palettes, and geographic filters.
Deliverables (30 points)
- Bubbles Visualization Screenshot — Match the result shown at the end of Step 17 in these instructions. Include your name from the top-right corner of Tableau. (10 pts)
- Region by Top 10 Products by Quantity Screenshot — Match the result shown at the end of Step 31. Include your name. (10 pts)
- Map Visualization Screenshot — Match the result shown at the end of Exercise 2, Step 16. Include your name. (10 pts)
Part 1: Customize Existing Visualizations
Step-by-Step Instructions
- Navigate to public.tableau.com. Click Sign In, enter your Tableau Public credentials, and click SIGN IN.
- Click the Profile icon (top right) → My Profile.
- Click the Hidden tab and select the
MyCleanDatavisualization. - In the top right, click the Edit icon to open the workbook.
- At the bottom of the page, click the Bubbles worksheet tab.
- Drag
Revenuefrom the Data pane to Label on the Marks card. Each circle now shows the product name and revenue details. - In the Marks card, click the dropdown arrow (default "Circle") and change it to Square.
- Hover over the
Product Namelegend in the right-hand pane. Click the small black arrow → Edit Colors. - In the Edit Colors dialog, select the dropdown at the top and choose the second-from-bottom palette: Winter. Click OK.
- Double-click the Bubbles visualization title. Select the text and format as: Tableau Book font, 20 pt, bold, dark pink, center-aligned.
- Right-click the
RegionTop10Productsworksheet tab → Duplicate. - On the duplicated tab, click Show Me and select Side-by-Side Bars. Close the Show Me menu.
- Click the Fit icon in the toolbar → Fit Width.
- Double-click the title. Rename to "Region by Top 10 Products by Quantity" and format as: Tableau Book font, 20 pt, bold, dark grey, center-aligned.
- Open Format → Worksheet. Under Fonts set to 12 pt with a chosen color. Collapse Fonts.
- In Shading → Fill, change to Dark Palette and pick a color. Collapse Shading.
- In Borders, set Column Dividers to black, Level 2. Collapse Borders.
- In Interactive Controls, set Background Style to a chosen color. Close the Format dialog.
- Click Publish in the workbook toolbar.
- At the bottom, click the New Worksheet icon.
- In the Data pane on the left, collapse all tables.
- Drag
Longitude (generated)to the Columns shelf andLatitude (generated)to the Rows shelf. - Expand the
Instructionstable. - Drag
Revenueto Color on the Marks card. - Drag
State or Provinceto Detail on the Marks card. - Click the Show Mark Labels icon (the "A" with dots) in the toolbar.
- If needed, use the map tools to pan and zoom into the United States.
- Drag
State or Provincefrom the Data pane to the Filters shelf. Click OK when prompted (keep "All"). - In the Filters shelf, hover over
State or Province, click the white arrow → Show Filter. - Open the main menu → Map → Background Maps → Satellite.
- Open the main menu → Map → Background Layers. Under Background Map Layers, check Cities.
- In the State or Province filter on the right, select only:
California,Georgia,Minnesota, andNew York. - Rename the sheet to
Map. - Click Publish.
- Show the completed visualization matching the description above.
- Include your name visible in the top-right corner of the Tableau interface.
- Capture the relevant shelves (Rows, Columns), Marks card, and any active filters.
A. Customizing the Bubbles Sheet
B. Customizing the Region Top 10 Products Sheet
C. Publish
Part 2: Create and Customize a Map Visualization
D. Publish
Screenshot Requirements
Each deliverable screenshot must: