Over a million developers have joined DZone.

Analyze DZone's Write to Win Contest Using Tableau 10

DZone's Guide to

Analyze DZone's Write to Win Contest Using Tableau 10

Tableau has added direct connectors to Google Sheets in Tableau 10. The author decided try his hand at this new feature to create some crisp visualizations quickly after seeing DZone's December Writer's Contest Leaderboard in Google Sheets.

· Big Data Zone
Free Resource

Need to build an application around your data? Learn more about dataflow programming for rapid development and greater creativity. 

Nothing can be more exciting than examining where you stand on the leadership board in a competition. It becomes more fun when you think to use that data to do some study. Lately, Tableau, the market leaders in Data Visualization, has added direct connectors to Google Sheets in their new version Tableau 10. I thought to attempt this new feature to create some crisp visualizations quickly when I saw DZone December Writer's Contest Leaderboard in Google Sheets.

To get started, download Tableau 10 desktop. Register for a 14 days free trial if you don't have a license key. You can notice it has a lot more to offer than the previous version and the tagline is impressive — Your Data, Only Hotter

Image title

Enter your Google account credentials which open up a dialog box that presents all the sheets owned by you or shared with you. Alternatively, you can enter the Leaderboard sheet link in the search bar. Click Connect to import the spreadsheet to Tableau. 

Image title

This opens up the Data Source Interface screen. You can view all the sheets of contest leadership board appearing on the "Sheets" section as shown in below figure. 

We have chosen Connection as Live (Present at the right corner of the interface). It supports having a live connection with the sheet. Select Extractif you want the data to be extracted and stored in a Tableau Data Extract(.tde). From the Sheets section, choose Leaderboard to inspect the data.

Image title

The data appears to be a bit dirty. The column names are not imported properly and are appearing in the actual data rows. Also, we have only a day's data for doing the current analysis, so last updated field is not required. You can manually correct this errors or try out the Use Data Interpreter functionality to clean the sheet. 

Image title

Using the Use Data Interpreter functionality, we have a better representation of the data with decent column names and last updated field removed which saved a lot of our manual work.

Image title

Navigate to Sheet 1 tab to create the Visualizations. The first things we notice here are the dimensions and measures. Dimensions are those objects which we want to track. Measures are the quantities that we want to measure. Though Tableau automatically categorizes the fields into different dimensions and measure, we can change this at our discretion. To know more about working around on this, you can read the Tableau Blog.

Image title

Drag and drop the Username field from Dimensions to the Rows shelf( Shown as Red arrow in the figure). Similarly, drag and drop the Pageview Score field from Measures to the Rows shelf( Shown as Pink arrow in the figure). Sort Username by descending by Pageview Score by clicking on the button shown in a red circle.

Image title

This creates a bar chart with Pageview Scores in X-axis and Username in X-axis. We can see the huge difference in pageview scores for the top two from the rest. 

Image title

Similarly, try out different other visualizations such as a packed bubble chart.

Image title

You can also create some new attributes to engineer some more fields, for example, average page view per user. If we compare this with the previous line chart, we can watch some shuffle in the graph. mr_niko goes to the top and mcaperson gets down to 4th position. One can assume from this observation, the more columns we write will support us getting toward the top of leaderboard. So, let's start writing more.

Image title

I am lucky to analyze the data using Tableau 10 and be positioned in Leaderboard at No 10. :) Help me get some more elevation by liking and sharing this article.

The graphs I created is just a day after the competition (3rd December 2016). The entertainment will begin after a couple of days when we start seeing the shuffle in the leaderboard and perform cool visualization out of it.

Check out the Exaptive data application Studio. Technology agnostic. No glue code. Use what you know and rely on the community for what you don't. Try the community version.

data visualization ,big data analytics ,tableau ,big data

Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}