Direkt zum Hauptbereich

Rebuilding an old article in a modern one

I tried to improve some graph what I found online on the page of NewYork Times. The article is about the relationship between driving habits and gasoline prices in the period from 1956 until 2010.

In this article I found some interesting graph:


It is informative graph was created 2010. I wonder how it will look like if I created this graph today with tableau?
And here is my result:

What become better? 
- at first sight you can recognize deepest and highest prices as the color red signaled something negative. The blue means something positive in this case.
- I added the average line, so you can estimate if the prices are over or under the average
- I made x aches a bit longer in order not to be deceived with price development. If you let data talk it is important not to overdone with visualization. Some changes look positive (e.g. 1990) but prices are still in the negative area. On the original graph it is difficult to recognize this.

There are some hidden features what will be visible if you download the workbook. For example if you go along the price line with the mouse you will get information to exact price/year/mile. If you present this graph, you have a possibility to analyses this relationship step by step by clicking on the bottom "choose mile details" or play them in different modus. So you make your presentation interactive and keep the attention of your audience until the end. (BTW: People who is familiar with HTML can bring this graph to move. For this point check this video)

What become worse? 
- The bottom ""Choose mile details" could be not recognizable at the first sight. So people can misunderstanding this inflation.
- The prices are shown only in the last mile details. All prices are visible if you download the workbook and go with the mouse along the price line

What do you think about that? It would be greater if you give me your feedback. 


Labels:

Kommentare

  1. venkat11. Juli 2017 um 21:55

    Everyone wants to get unique place in the IT industry’s for that you need to upgrade your skills, your blog helps me improvise my skill set to get good career, keep sharing your thoughts with us.
    Tableau Online Training|
    R Programming Online Training|
    SAS Online Training |

    AntwortenLöschen
  2. Unknown17. August 2017 um 22:16

    That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.

    Tableau online training

    AntwortenLöschen
  3. Unknown24. August 2017 um 03:42

    Thanks for writing such a good article, I stumbled onto your blog and read a few post. I like your style of writing…
    Tableau Online Training

    AntwortenLöschen
  4. Unknown8. September 2017 um 04:30

    Nice blog. Really helpful for learningTableau and keep update on some more tutorials….. I liked your blog.

    AntwortenLöschen
  5. Linux Training India19. Oktober 2017 um 05:26

    Great Article, thank you for sharing this useful information!!

    Linux Online Training India
    Online devops Training India
    Hadoop admin online Training India

    AntwortenLöschen

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

Tableau Table Calculation Function: WINDOW - Functions

The functions which begin with „WINDOW_...“ are also common used in Tableau. Remember! The “WINDOW_” function stays for the offset in data set, so-called WINDOW. It can look like this: 1) You can see the “WINDOW” clearly because of separation line between rows: 2) You limit the “Window” by giving the information about the first and the last row number. In this case, you give Tableau the information about the data offset. Let's have a look at the example with WINDOW_SUM I created a sample with data from Superstore. I would like to have a total sum of Sales in every row. In order to do this I created a calculation field: WINDOW_SUM(SUM([Sales]), FIRST(), LAST()) With this formula I said to Tableau: “Hey Tableau, calculate the total sum of sales from the first till the last row in the data set” And this is the result: Tableau wrote the result (total sum of Sales) in every row. As another option you can cumulate the result in each row and...
Kommentar veröffentlichen
Mehr anzeigen

Tableau Number Function: ABS

I have been working with Tableau since 2014, but I have still a feeling that my knowledge about this software not good enough. When I rebuild dashboards from tableau.public I am fascinating how some people can create amazing formulas and thus it makes the calculation of data sets easier. Sometimes I got stuck by creating of graphs and I do some calculations with data in Excel before I visualize them. Otherwise, you can find the definition of every function by creating of calculation field. But, honestly, are this definitions always clearly enough? For me not and I am done by doing long calculations with Excel. 😠 I like my work and I want to have more fun and not do such long calculation with Excel! I took up a challenge and decided to go through every function in tableau in order to understand how they work.  I would like to begin with ABS function.  ABS function is very easy one, as it used to get an absolute value of a number from a negative one. As an examp...
2 Kommentare
Mehr anzeigen

Level of Detail Expressions (LoD) in Tableau: FIXED

The last keyword of LoD I am talking to is FIXED. Remember! By the function INCLUDE we included some numbers into the calculation even though we don't visualize this number. By the function EXCLUDE we exclude some numbers from the calculation even though we visualize them. With the function FIXED we “freeze” some numbers in our calculation, i.e. we can run calculation of all art, but the “fixed” dimension remains unchanged. This is the structure of FIXED function: With this function we can e.g calculate a frequency of customer's orders, calculate unique customers from month to month as the cumulative value etc.. Let us have a look to an example, where we analyze sub-categories: I created a simple cross table with the data from Superstore: I would like to see this numbers in a hint text, if I analyze sub-categories. I created a stucked bar chart, which shows sales in each region. I also highlighted sub-categories with different color, as I would ...
Kommentar veröffentlichen
Mehr anzeigen