Skip to main content

Tableau Data for Target's Good and Gather Products

 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.

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

The G&G item is usually less expensive by a few cents. Target's food brands have built enough goodwill with me to take the chance.

Not every item is a winner - some I still prefer a different, more established brand. Some  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.


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. It's .99 cents, so you could do worse. I wanted to use it in a smoothie to replace a dairy-based option. 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 to 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 unless you're allergic to nuts, it won't kill you.


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

Connecting IoT Devices to a Registration Server (Packet Tracer, Cisco)

In Packet Tracer, a demo software made by Cisco Systems. It certainly has changed a lot since 2016. It's almost an Olympic feat to even get started with it now, but it does look snazzy. This is for the new CCNA, that integrates, among other things, IoT and Automation, which I've worked on here before. Instructions here . I don't know if this is an aspect of "Let's make sure people are paying attention and not simply following blindly", or an oversight - The instructions indicate a Meraki Server, when a regular one is the working option here. I have to enable the IoT service on this server. Also, we assign the server an IPv4 address from a DHCP pool instead of giving it a static one. For something that handles our IoT business, perhaps that's safer; Getting a new IPv4 address every week or so is a minimal step against an intruder, but it is a step. There are no devices associated with this new server; In an earlier lab (not shown), I attached them to 'H

Building, Breaking, and Building A CRM with Retool

 I like no- or low-code solutions to things. I've often wanted to simply push a button or move some GUI around and have the code implement itself.  I've thought about building something that's like a customer relationship management (CRM) system for keeping up with my network better than my little spreadsheet where I click links and then go like something. The general idea in this CRM Development is:  To have a GUI to add people to a NRM (Network Relationship Management).       Attach it to a database (MySQL is what I went with eventually using Amazon Relational Database service, but you can use PostGRES, and probably others).     Make sure components are connected to each other in the retool interface. This video is a good start. Watching the tutorial video, heard some SQL commands and went 'Oh no 😳" before going "Wait I know basic SQL", which is good, because you'll see.  When you get set up, there's a plethora of resources you can use -- Incl

Securing Terraform and You Part 1 -- rego, Tfsec, and Terrascan

9/20: The open source version of Terraform is now  OpenTofu     Sometimes, I write articles even when things don't work. It's about showing a learning process.  Using IaC means consistency, and one thing you don't want to do is have 5 open S3 buckets on AWS that anyone on the internet can reach.  That's where tools such as Terrascan and Tfsec come in, where we can make our own policies and rules to be checked against our code before we init.  As this was contract work, I can't show you the exact code used, but I can tell you that this blog post by Cesar Rodriguez of Cloud Security Musings was quite helpful, as well as this one by Chris Ayers . The issue is using Rego; I found a cool VS Code Extension; Terrascan Rego Editor , as well as several courses on Styra Academy; Policy Authoring and Policy Essentials . The big issue was figuring out how to tell Terrascan to follow a certain policy; I made it, put it in a directory, and ran the program while in that directory