Course HubCourse Hub

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)

  1. 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)
  2. Region by Top 10 Products by Quantity Screenshot — Match the result shown at the end of Step 31. Include your name. (10 pts)
  3. 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

  1. Navigate to public.tableau.com. Click Sign In, enter your Tableau Public credentials, and click SIGN IN.
  2. Click the Profile icon (top right) → My Profile.
  3. Click the Hidden tab and select the MyCleanData visualization.
  4. In the top right, click the Edit icon to open the workbook.
  5. At the bottom of the page, click the Bubbles worksheet tab.
  6. A. Customizing the Bubbles Sheet

    1. Drag Revenue from the Data pane to Label on the Marks card. Each circle now shows the product name and revenue details.
    2. In the Marks card, click the dropdown arrow (default "Circle") and change it to Square.
    3. Hover over the Product Name legend in the right-hand pane. Click the small black arrow → Edit Colors.
    4. In the Edit Colors dialog, select the dropdown at the top and choose the second-from-bottom palette: Winter. Click OK.
    5. Double-click the Bubbles visualization title. Select the text and format as: Tableau Book font, 20 pt, bold, dark pink, center-aligned.
    6. B. Customizing the Region Top 10 Products Sheet

      1. Right-click the RegionTop10Products worksheet tab → Duplicate.
      2. On the duplicated tab, click Show Me and select Side-by-Side Bars. Close the Show Me menu.
      3. Click the Fit icon in the toolbar → Fit Width.
      4. 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.
      5. Open Format → Worksheet. Under Fonts set to 12 pt with a chosen color. Collapse Fonts.
      6. In Shading → Fill, change to Dark Palette and pick a color. Collapse Shading.
      7. In Borders, set Column Dividers to black, Level 2. Collapse Borders.
      8. In Interactive Controls, set Background Style to a chosen color. Close the Format dialog.
      9. C. Publish

        1. Click Publish in the workbook toolbar.

        Part 2: Create and Customize a Map Visualization

        1. At the bottom, click the New Worksheet icon.
        2. In the Data pane on the left, collapse all tables.
        3. Drag Longitude (generated) to the Columns shelf and Latitude (generated) to the Rows shelf.
        4. Expand the Instructions table.
        5. Drag Revenue to Color on the Marks card.
        6. Drag State or Province to Detail on the Marks card.
        7. Click the Show Mark Labels icon (the "A" with dots) in the toolbar.
        8. If needed, use the map tools to pan and zoom into the United States.
        9. Drag State or Province from the Data pane to the Filters shelf. Click OK when prompted (keep "All").
        10. In the Filters shelf, hover over State or Province, click the white arrow → Show Filter.
        11. Open the main menu → Map → Background Maps → Satellite.
        12. Open the main menu → Map → Background Layers. Under Background Map Layers, check Cities.
        13. In the State or Province filter on the right, select only: California, Georgia, Minnesota, and New York.
        14. Rename the sheet to Map.
        15. D. Publish

          1. Click Publish.

        Screenshot Requirements

        Each deliverable screenshot must:

        • 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.

Refer to Canvas for official submission cutoff and penalty policies.