For this 2nd week's #MakeoverMonday, I am using CAGR to analyze the iPhone sales data.

CAGR (Compound Annual Growth Rate) is a way to calculate average annual growth rate. Here I use CAGR from last N years as a measure for the analysis:

([Volume 2016]/[Volume N Year Ago])^(1/N) - 1

Here is the result.

Click the image to go to the interactive version.

A MakeoverMonday viz is excellent as follows. The 2nd week's data set of year 2017 is on the iPhone unit sales trends. The author Haiping is from our MakeoverMonday Data Camp.

The only pet peeve I have is about the vertical year order. My thought is that we care more about the latest change in sales. That is the focus of the analysis. We need to arrange the chart so that the latest year is at focus. So I suggested the author to make the latest year on top.

Our data is dynamic and the axis by default in Tableau will change accordingly. For example, in this Fibonacci Spiral chart, the chart and the grid are changing from iteration to iteration. This creates some visual uneasiness and can even make viewers dizzy.

The goal here is dual: 

- keep the origin at the center of the grid 

- make both axis the same scale

Both should be done dynamically

The options in the axis editor won't help.

Here is the first #MakeoverMonday submission of the year 2017.

Click image for the interactive version.

In my last post, I created a continuous Fibonacci Spiral, based on Zen Master Noah Salvaterra's Fibonacci viz. He actually created the similar Golden Spiral in continuous form (to which the Fibonacci Spiral is an approximation). But it doesn't fit into the Fibonacci Rectangle.

Then the math professor left me a piece of homework: Fit the Fibonacci Spiral into the Rectangle.

So I spent the last few days, tweaking the viz. Finally, I got them together.

Given a workbook URL either on Server or Tableau Public, we should be able to open it from its URL. This will make our life much easier. It should come with proper authentication of course.

Currently, most of time we have to download a workbook first. Then open it from a file folder. If it's a recent file, we are able to open it from the server though.

1.Add an menu item in Tableau Desktop or Tableau Public.

2.Follow by proper authentication if necessary.

Happy New Year 2017!

Recently I have been interested in charting mathematical functions, such as Sigmoid and Trochoids. Sigmoid has found applications in Bump and Sankey charts. For other math functions, it is just a great exercise to visualize them and to learn creating beautiful curves using Tableau.

So, I found this Fibonacci chart below by Zen Master Noah Salvaterra who was a math professor.
2
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.