Generating EVEN MORE Data using Tableau Prep

You just can’t get enough of data. I published this post last month So, some of you reached out and mentioned that the routine I had built was very basic and that you would love a version with some additional dimensions to the data.

Yes, it was very basic indeed. It was fun experiment for a few hours. Having said that, I thought to give the project a few more hours to add some more elements that I would have liked to add. So, I present the v2.0 of the Data Generator routine with Prep.

Again, to understand what we have built here, the videos explaining the generator and how to use it in this post still are relevant.

Just be aware, that we now have additional fields to play with. I have also added instructions directly in the spreadsheet so you know which columns to play with and which ones to leave alone.

Here are the v2.0 files that you will need

1. Tableau Prep Builder (Download the .tfl file)
2. Data Input File (Download excel here)
3. Tableau Desktop (Download .twb here)

Also, some of you also asked for the output file that the Prep flow creates. So, here is that file so you can use the workbook

Data Output File (Download excel here)

And, here is one of the Sample Dashboards based on this dataset.

Enjoy and continue to provide feedback and suggestions.

Advertisement

Generating Data using Tableau Prep

So, if you are like me and somehow, happen to have a few hours with no specific task to do, you get itchy. Itchy to do something with tech. That’s what happened today. I had a few hours and someone recently asked to create some dummy data for a project. So, I said to myself, why don’t I create a Data Generator routine using Tableau Prep Builder?

I know I can look at a lot of online data generators that allow me to create custom data. The big issue is they don’t help me create a good story because there is no signal or an outlier in the data.

Well, worry not. In less than 5 minutes, you can create the dataset that you need with your own liking for your own industry.

So, what do you need

1. Tableau Prep Builder (Download the .tfl file)
2. Data Input File (Download excel here)
3. Tableau Desktop (Download .twb here)

And watch the following video. In less than 5 minutes, you will have some nice data to play with.

Chapter 6: Calculated fields with Tableau

It’s not always that your data EXACTLY the way you need. Infact, many a times, you don’t have much of the data in your dataset

However, often, what you are looking for is available in your dataset in a different form. And, that’s when we can use calculated fields to build new ways of looking at our data. These calculated fields are new blocks from existing blocks of information we already have. We discussed that in our next session with the olympics data

As a quick reminder, here is the link to our main project page and don’t forget to sign-up if you would like to get emails when we publish another blog

Chapter 5: Filters with Tableau

In order to keep interest in a topic, some changes are required. We realized that “at home” that using the same data that we have been using so far for our “Data+Kids” project isn’t quite working so well. So, we moved over to Olympics data to see what we can find about that

In this chapter, we mostly covered “Tableau Filters” and some concepts like understanding the various fields in your data set and how they could be related

As a quick reminder, here is the link to our main project page and don’t forget to sign-up if you would like to get emails when we publish another blog

Sharing Lavanya’s exploration with data about music

Lavanya wanted to explore data about music and in our video, she shares her perspective about research on the topic, understanding the data and showing us how she learnt