# 4|TABLEAU – Wheelz Sales Visualization

**URL:** https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574
**Category:** Challenges
**Tags:** sales, fpa, intermediate, managerial, dataviz, tableau
**Created:** [May 1, 2023, 6:17pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574 "2023-05-01T18:17:32Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![Alex\_Garrett](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/alex_garrett/32/57_2.png) [@Alex\_Garrett](https://www.techhub.training/u/Alex_Garrett)
#### Post date: [May 1, 2023, 6:17pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/1 "2023-05-01T18:17:32Z")

</div>

_BYU Student Author_: @Alex_Garrett  
_Reviewers_: @IWillyerd, @TylerBooth, @Brett_Lowe  
_Estimated Time to Solve:_ 30 Minutes

We provide the solution to this challenge using:

- Tableau
- [Go here to perform this challenge in Power BI](https://www.techhub.training/t/4-powerbi-wheelz-sales-visualization/154)

Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138).

**Overview**  
You recently started your summer internship at Wheelz Distribution Company, a toy car distributor located in Los Angeles, California. In your interview, you mentioned that you have some experience with Tableau, and your boss said that she would love to have a dashboard that “brings to life” the data that they have from the previous year, 2020. Your boss will present these visualizations at the mid-year meeting, so it’s important that your work is descriptive and easy to understand.

**Instructions**  
Your boss gave you access to the company’s sales spreadsheet for the past 30 months from which you will build your visualizations. She has also given you some requirements about what visualizations you should create. Here’s what you wrote down from your meeting with her:

1. Include a title and a description of what the dashboard represents.
2. Display total sales for the year using a text table.
3. Compare sales across product lines by quarter using a side-by-side bar chart.
4. Display the top 3 customers and their total sales using a text table.
5. Show the proportion of sales made in the US versus outside the US using a pie chart.
6. Include 1 other visualization that you think would be helpful for shareholders to see.

Remember these helpful tips when creating your dashboard:

1. Your boss will be presenting this data to shareholders for the 2020 financials. In other words, leave out all other years of data.
2. Orders with a status of “cancelled” or “on hold” do not represent actual revenue so make sure to filter these rows out.

Your boss didn’t give you a detailed list of steps to follow, rather she gave you room to be creative, as long as it looks professional. Get creative! Your dashboard may not look the same as the solution provided, but we’ve provided a few check figures below to make sure you’re on the right track (i.e., dollar amount for 2020 revenue, top 3 customers, etc.)

**Data Files**

- [Challenge4\_Wheelz\_Sales\_Data.xlsx](https://byu.box.com/shared/static/mg2v0iz425csh4fbcl6f3eif68fqp13a)
- [Challenge4\_Data\_Dictionary.docx](https://byu.box.com/shared/static/v0y5461po4l9erhtt9arxyqsrff9xemt)

> **Check Figures**
>
> Check Figures
> 
> 1. Total 2020 Sales Revenue: $4.55M
> 2. Top 3 Customers: Euro Shopping Channel; Mini Gifts Distributors Ltd.; Australian Collectors, Co.
> 3. 2020 USA Sales: $1.64M (36.03%)

**Solution**

> **Solution Image**
>
> ![Challenge4_Solution_Image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/bf9ceda7405e3e5c087ce90af54c3eb4b44b5334.jpeg)

[Challenge4\_Solution.twb](https://byu.box.com/shared/static/s1gwzlp2u4qu69tpumgwed89hbo9j6ye)  
_Solution Video:_ [Challenge 4|TABLEAU – Wheelz Sales Visualization](https://youtu.be/dPnZgLelKAE)

---

<div class="post-metadata">

### Author: ![Camryn\_Russon](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/camryn_russon/32/7604_2.png) [@Camryn\_Russon](https://www.techhub.training/u/Camryn_Russon)
#### Post date: [December 12, 2023, 11:42pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/2 "2023-12-12T23:42:27Z")

</div>

Here is my attempt! I am pretty new to Tableau but this helped me practice!  
[camrynsolution-wheelzsalesvisualization.twbx](https://www.techhub.training/uploads/short-url/oSD8E6PFmrL5spmRYCJJLp6bgPr.twbx) (367.0 KB)

---

<div class="post-metadata">

### Author: ![Clay\_Davis](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/clay_davis/32/6805_2.png) [@Clay\_Davis](https://www.techhub.training/u/Clay_Davis)
#### Post date: [October 29, 2024, 11:00pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/3 "2024-10-29T23:00:40Z")

</div>

Time to Complete: 30 minutes  
Rank: Beginner

 ![Top Customers and Sales](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/34870206b41485f67a193017c707299ae4e314a2.png)  
 ![US vs Other Countries](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/c50b89a02e4c62398f644cb463b7c8d0d0ef5b46.png)  
 ![Top 5 Customers Worldwide](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/4/4d3744d2d159e557fc303b6f3583f3700eeaaafe.png)  
 ![Total Sales per Year](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/399db8eb8aab9853e83642d044e3c9e7a3428cb7.png)  
 ![Comparable Sales per Year Across Product Lines](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/c855cfd5762e1843139578528701ca3b77e8e35c.png)

---

<div class="post-metadata">

### Author: ![Clay\_Davis](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/clay_davis/32/6805_2.png) [@Clay\_Davis](https://www.techhub.training/u/Clay_Davis)
#### Post date: [October 29, 2024, 11:03pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/4 "2024-10-29T23:03:26Z")

</div>

![US vs Other Countries Orange and Blue](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a58d7ae2046e6fae9c6b6dcf36d2aa34b3322c6c.png)

---

<div class="post-metadata">

### Author: ![Khai\_Huynh](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/khai_huynh/32/10999_2.png) [@Khai\_Huynh](https://www.techhub.training/u/Khai_Huynh)
#### Post date: [April 15, 2025, 5:52am UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/5 "2025-04-15T05:52:56Z")

</div>

Time to complete: 2 Hr  
Rating: Beginner

I am fairly new and had much to learn and this challenge allowed me to have easy yet thorough steps to learn what seems like basic processes that appear difficult until they are learnt.

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/5/57293256cc6de4ff13835b93705f3efe4f9cd500.png)

---

<div class="post-metadata">

### Author: ![Hogan\_Doyle](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/hogan_doyle/32/10996_2.png) [@Hogan\_Doyle](https://www.techhub.training/u/Hogan_Doyle)
#### Post date: [April 15, 2025, 6:48pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/6 "2025-04-15T18:48:18Z")

</div>

Time to complete: 30 minutes  
Difficulty: Beginner  
This was a fun and quick challenge

 ![Screenshot 2025-04-15 at 2.45.35 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/2/27e12db60a141fc80295a5d2923d3208ca0a6769.png)

 ![Screenshot 2025-04-15 at 2.45.42 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a8f33780fe7ba1f092e95c0d89cbe0d05d5f8230.png)

 ![Screenshot 2025-04-15 at 2.45.46 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/6/665873f74f2cb3dfeafe1a7d361262bb207ba1cb.png)

 ![Screenshot 2025-04-15 at 2.45.51 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/5/5461ecd1e8421b451c9bc9cd231ca31202ea1246.png)

 ![Screenshot 2025-04-15 at 2.45.54 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/db18ce26b1f3a9590e0b76a6da7fbbe131a63c48.png)

---

<div class="post-metadata">

### Author: ![Nate\_Orcutt](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/nate_orcutt/32/11100_2.png) [@Nate\_Orcutt](https://www.techhub.training/u/Nate_Orcutt)
#### Post date: [April 22, 2025, 2:25am UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/7 "2025-04-22T02:25:31Z")

</div>

![Screenshot 2025-04-21 at 10.24.48 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/5/5a4f143631b26caa9d27f62fccb1672ed7224c30.png)

---

<div class="post-metadata">

### Author: ![Lauren\_Thomason](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/lauren_thomason/32/11154_2.png) [@Lauren\_Thomason](https://www.techhub.training/u/Lauren_Thomason)
#### Post date: [October 11, 2025, 11:39pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/8 "2025-10-11T23:39:59Z")

</div>

![244815DA-4E40-4557-A189-55266E98964F](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/7/7fd69e59f40dbbd01494bd6ac741cf01dbc3abae.jpeg)

---

<div class="post-metadata">

### Author: ![Kylie\_Todd](https://avatars.discourse-cdn.com/v4/letter/k/e99b99/32.png) [@Kylie\_Todd](https://www.techhub.training/u/Kylie_Todd)
#### Post date: [November 24, 2025, 10:13am UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/9 "2025-11-24T10:13:54Z")

</div>

[Wheelz Sales Visualization.twbx](https://www.techhub.training/uploads/short-url/9L9t2douHyGlA1fTUhXxwiLBm9J.twbx) (114.2 KB) This is my attempt at this challenge! It was increadibly fun to try out!

---

<div class="post-metadata">

### Author: ![Soyeon\_Bak](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/soyeon_bak/32/11382_2.png) [@Soyeon\_Bak](https://www.techhub.training/u/Soyeon_Bak)
#### Post date: [November 24, 2025, 11:55pm UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/10 "2025-11-24T23:55:52Z")

</div>

![Screenshot_24-11-2025_185157_](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/2/2c94e144f2a4076a306a79a31fa2de652ad8062e.jpeg)

 ![Screenshot_24-11-2025_185217_](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/12c3cc2dcaf68a5724fee086c3fe08ed0a4e15a1.jpeg)

 ![Screenshot_24-11-2025_18527_](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8b3024b90cba8550939b5d4b2ae4482a1c14309e.jpeg)

---

<div class="post-metadata">

### Author: ![Galilea\_Ramirez](https://avatars.discourse-cdn.com/v4/letter/g/3bc359/32.png) [@Galilea\_Ramirez](https://www.techhub.training/u/Galilea_Ramirez)
#### Post date: [April 15, 2026, 6:10am UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/11 "2026-04-15T06:10:26Z")

</div>

Here is My attempt!

[Wheelz Sales Visualization-GalileaSolution.twbx](https://www.techhub.training/uploads/short-url/sC1wGD9UL1QX3otsDWecq8LX3e3.twbx) (128.1 KB)

---

<div class="post-metadata">

### Author: ![Brooklyn\_Kent](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/brooklyn_kent/32/11456_2.png) [@Brooklyn\_Kent](https://www.techhub.training/u/Brooklyn_Kent)
#### Post date: [April 21, 2026, 1:44am UTC](https://www.techhub.training/t/4-tableau-wheelz-sales-visualization/574/12 "2026-04-21T01:44:54Z")

</div>

This is my completed challenge! This was a fun learning assignment.

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/13232b1d537ee12e2d086701b1fe09d0e447ba48.png)

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/9/9776c6728f5eed88da9111b4be5394a0b7896645.png)

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a71287fb6baebeab94f9a83428616b81bde62774.png)

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a01dfe8db387605989140e6569af3bb81d5d3b17.png)

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/6/6011ce0d61ec87439eb16b553f086d9c236aafec.png)
