Direkt zum Hauptbereich

Posts

Es werden Posts vom Oktober, 2016 angezeigt.

Approach by data visualisation

It is evening and already dark. I feel forced to stay at home because of the cold October weather. In order not to be bored I decided to make a post. This post will be the special one because today I'm not going to describe how to do any graphics with tableau. Today I'll share with you my approach by data visualization. As a data analyst with 1,5 year of work experience I have to create a lot of dashboards. My challenge is to create a reasonable dashboard with unknown data. So this is my approach: The first thing I do is ask the questions Who is my audience? (Management, Marketing, HR etc. -with this information you can decide what kind of KPI are important) What is relevant for my audience? (strategically, analytic or operative KPIs) Which data I need in order to create desired dashboards? Which data I miss? What is my deadline? In the second step I begin to study the data. While my first year as a data analyst I was always overdone with data, when I op...

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 hi...

How to use polygon diagram as a filter?

One a day I got to know a gay who created a polygon diagram and use that as a filter. I was very impressed of that and wanted really to rebuild that one. See my workbook  here So how to do that? - First of all I cheesed a picture. I decided to take a shop square plan. Click right to the picture you cheesed and go to "Features" - "Details" - Remember wider and higher - In order to open this picture with tableau, I created a Google sheet with this two coordinates: In order to open this file with tableau you should go to: - Maps - Background Image - Import - And fill details as on the example below - Press "OK" - Drop the X axis to column and the Y axis to the rows - and you will get this picture  - Now I want to show some departments on this picture, like where customers can find some kitchen equipments, books, games etc. In order to highlight the area, you have to mark some points on it - Choose any point on t...