Today’s dashboard deals with vegetable production and consumption data in the U.S.; from 1970 to 2019. Especially on loss - adjust or how much a food has lost; for instance, the loss in weight since it was plucked from the ground till it arrives in a supermarket. Weight loss can be due to reasons such as spoilage, pests, or how it was transported.

   The first objective was to form a sketch by only looking at the excel sheet. I decided to focus on the Loss-Adjusted Food Availability section; on the sheet named “Vegetables”. Looking at the excel sheet I decided to focus on big KPI’s relating to canned, frozen, and fresh foods. I also decided to show a timeline of the primary weight from the 1970 till 2019. Furthermore, some type of bar chart to show vegetable comparisons.

  After this, I decided to prep the data. I realized that the structure of the data was pretty much the same. The only difference being that the columns had different names. My thought was to wildcard union them in Tableau and rename some of the fields. Although my Tableau Prep wasn't working on the desktop; so with some advice I decided to just choose 5 canned vegetable sheets, 5 fresh vegetable sheets, and 5 frozen vegetable sheets. I unionid them together and eventually brought them into Tableau desktop.

The last data cleaning step I’ve done was to split the vegetable section by each food condition. This field was now named ‘Food Condition’.

Then I focused on creating a timeline that detailed the change in consumer weight (the weight in which the consumer buys a vegetable in store). Furthermore, I showed the change in weight from the primary weight (the weight from when a vegetable was picked) and the weight in which the vegetable was edible.

The major challenges I’ve found were to prep the data without getting to use Tableau Prep on the desktop. Other than that, the dashboarding and creating charts was not too difficult.