Some time ago I wrote a blogpost on how to compare different time series and plot them on the same axis. This blogpost was using a rather complex table calculation to calculate the days since start of each different time series and use that as an axis. In this blogpost I will demonstrate an easier way to achieve this, including a proper data axis. [Read more…]
Early september I visited the Tableau Conference in Seattle. A session by Jewel Loree, Andy Kriebel and Peter Gilks with the inspiring name “Porn, Pokemon and Pop Culture” really got me pumped up and ready to make my first Tableau Public viz. It took me a while to find inspiration for a good viz and after trying out various topics ranging from a story on Trappist beer to a viz on the impact of sleep deprivation (I have a six month old daughter and two your old son) I received an action camera ahead of my upcoming birthday. I had seen a post by the great Ben Jones on embedding a Youtube video within Tableau Public and I was wondering if I could take this one step further and make the video responsive to interaction with the viz. [Read more…]
These past few months I’ve seen a rapid rise in the use of Piwik as a webanalytics solution. My clients are choosing Piwik as an alternative to paid solutions like ComScore Digital Analytix or free solutions like Google Analytics. Benefits include the data storage location, ownership of data and the ability to access non aggregate data.
Piwik stores clickstream data like visitors, visits and pageviews but is also able to store information like onsite search queries and eCommerce data. Data is stored within a MySQL database which can be hosted wherever you want giving you full control over data ownership and data storage location. I’ve seen implementations with over >100M interactions a year and I am currently working within an organization implementing a 50M interactions a year setup.
Analyzing the data gathered by Piwik can be done through their web interface which allows you to generate reports and segment the data, but as a Tableau enthusiast I was also curious if I could connect directly to the underlying MySQL database. It turns out you can! [Read more…]
Reporting on the most visited pages within your website can be a rather static endeavor if your most popular content doesn’t change very often. Changing this report to a list of pages with the largest change (both positive and negative) in visits is most likely a lot more interesting.
Tableau is a great and easy to use data visualization tool, allowing you to create beautiful and meaningful visualizations within minutes.
From time to time I run into visualizations that are harder to implement in Tableau. Comparing two time series on a day level within the same line graph is one of them. Many webanalytics solutions like Google Analytics or ComScore Digital Analytix come with these kind of visualizations build in so replicating this in Tableau is a must for me.
I’ll share the steps I’ve taken to create a similar visualization in Tableau in this blogpost.