Skip to main content

Good and Gather(ing Data to use in Tableau)

 None of this is promotional. I am not paid by Target to do this. Boy, I wish I were. Someone let them know!

 



 I really love to cook. It's fun to find unrelated ingredients and make something out of them that's mostly palatable.

This idea came to me while driving home from Target. I had bought stuff from Good and Gather, their in-house grocery brand that replaced Market Pantry. With its sleek and minimalist design packaging, it's easy to spot on a busy shelf.

It was not the first time I've bought G&G items, but it was the first time I thought "What makes me go to this brand?"

Often times, the G&G item is less expensive by a few cents. Target's brands (at least on the food front) have built enough goodwill with me  for me to take the chance.

Not every item is a winner - some I still prefer a different, more established brand. Some food items are so ordinary, there's no point in reviewing it. A baby carrot is a baby carrot, G&G ones come from the same field as Green Giant. 

 

I'm guessing.

This post will be in 3 sections;

 

  • The 5 food reviews are things I have tried personally.
  • The graphs in Tableau will incorporate those 5 objects and 15 items from the Target website that have reviews, and how I changed them to work with the data I had.
  • The Stats are the information found.

For the chart (See here): I used the information on "Guest Ratings and Reviews" [example]

For 'Repurchase', I used the chart on the far right that says '____% would recommend'.

The 5 Foods

Sharp Cheddar

Department: Dairy

Taste: 3

Value: 4

A cheddar-and-apple salad with walnuts and cranberries is delicious.

Review: It's chewy, and doesn't leave you with the good snapback other cheeses do. It's like biting into something and you're waiting for the feedback, but it doesn't come. Nothing bad, but not my textural preference.

Verdict: I'd rather go with Tillamook for the extra sharp. I'd repurchase occasionally.


Green Lentils

Department: Pantry
Taste: 4
Value: 5


Lentils are little flat grains that are good at making you feel full. I usually cook mine in a crock pot for a few hours and eat them in their own liquid, which gains a nice, earthy flavor. It would probably absorb flavors fairly well. Remember to salt that water!

The texture gets mushier the longer you have them cooked and sitting. It's still edible, but my preference is to the 'just barely finished cooking ' side of the equation.

Verdict: Good. Would repurchase.


Pineapple Coconut Flavored Water

Department: Beverages

Taste: 1

Value: 3

It doesn't taste like much of anything, but it's .99 cents, so I guess you could do worse. I wanted to use it in a smoothie without opting for a dairy-based option, while having flavors I don't often use on hand. The taste is minimal.

Verdict: Spring for the Bai Molokai Coconut instead. There's also a pineapple option.


Apple and Gouda Chicken Sausage

Department: Meat and Seafood
Taste: 4
Value: 3

Needs more apple flavor, but cheaper than the other 'artisan' sausage by .30c. There are other flavor varieties.

Verdict: Good.

Chocolate Chip Cookie Dough Nutrition Bars

Department: Snacks
Taste: 5
Value: 5

The closest alternative are Larabars, which are also good and a bit more expensive. 

Verdict: The texture is a lot less distinct than the Larabars, where you can taste individual nut or chocolate pieces, but it won't kill you. Unless you're allergic to nuts.


The Analytical Reasoning part - The Graphs (& How I manipulated them)

Find them Here on Tableau Public

I had to filter out the "Blog Post HERE" section of the spreadsheet.


 

At first, Tableau was not acknowledging my "Taste (1-5)" and "Value (1-5)" labels. On the data source section, you can select "Clean with Data Interpreter" and it figured it out.


Repurchase Likelihood sheet: Tableau sorted the "Repurchase" fields by 'Yes' or 'no'...and the one time I idly put 'Sure' about that cheddar block.

By Item sheet: I had to edit the axis. My scale went only up to 5, this one stopped at 6. 


Percentile of Value and Taste Sheet: I removed 'sauces', as there was only one in that department and multiple options in others (besides snacks. I left snacks because that item was more positively received. Ah, data manipulation!)

 

The Stats

 20 Items were selected.

Average Score of Taste and Value: Avg. Taste score was 3.35, Avg. Value score was 3.65

65% of items were likely to be repurchased. I came to this conclusion by giving items with "50% recommend" or higher a 'yes' mark.

This was very fun to do, and I learned a lot. I should find some more data to play around with.

If anyone at Target would like to get in contact about this, see here.

Comments

Popular posts from this blog

What Do You Need? [AKA; List of Offered Services / My Next Role] (2020)

I am a trusted outsourced remote consultant for your company.   I enjoy having the flexibility to take on temporary projects from time to time! I start at part-time, temp work for now. If we like each other, we can renegotiate. If anything sounds weird, out there, or unusual - Feel free to e-mail me .  3 Services Offered Writing :      You want to pay me to write more of *waves hand* this blog? I am game .     I write B2C e-mails going out to over 280 people weekly. [ Example Job Description ]        Auditing :        Something doesn't work on your page or in your app. I can find it, or you can lose business. [ Here ] [ Example Job Description ]   I really enjoy testing apps and webpage concepts! I have an iPhone and Android phones ready. Technical: Still as-needed, always remote, contract, or temporary. IT Operations Tech [ Example Job Description ]     Hardware and SaaS support.     Cisco routing and switching (Networking). CCNA, A+, Sec+, Azure certified WORKING ON: Junos

Portfolio of UX/Product Feedback [Vol. 1]

I browse websites and apps, while making note of things I find frustrating for end users. You have probably been linked here from a form or my resume. If you have any questions about what I'm looking for in a role, click here .   This post is not to shame, but to point out errors and hopefully make my talent for finding and documenting such mistakes clear to someone hiring. Contents: Instances where I offer constructive feedback on someone's website, logo, or app. Actions that were taken by the developers or artists.  I'm glad you want your webpages to be the best they can be with my help; If you need your sites audited, e-mail me . Latest Update -  November 20th, 2020.   Vol. 2 is here .

Contactless Tech’s Role in the New Guest Experience ft. Intelity and The George

 Contactless hospitality technology is growing. You want to get away, and you'll be damned if a little thing like a deadly virus will stop you! But you still don't want to touch things. Ew. During the chat between INTELITY CEO Robert Stevenson and THE GEORGE Director of Operations Kerrie Hunter, you’ll learn how the historic boutique hotel has adapted a mobile-first guest experience in the wake of COVID-19—and how they see contactless technology affecting the future of hospitality. I don't remember how I found INTELITY (probably hoping to score a position with them), but I liked them enough to stay on the e-mail lists.