Direkt zum Hauptbereich

Posts

Es werden Posts vom 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...

How to integrate Mapbox in tableau?

I like map styles by mapbox. Creative maps from mapbox can help me make my visualisation more informative and easy to understand. Keep in mind, you can create a direct connection to mapbox from tableau. It is not necessary to have an account by mapbox. In order to integrate a map from mambos to tableau you have to follow next steps: Go to maps Background maps Map services You will get this window Go to "Add" Choose "Mapbox maps" And you will get this window Then go to  https://www.mapbox.com/studio/styles/ Press "Edit" Press "share, develop & use" Then go to the block "Use Style in GIS apps Choose "Tableau" Copy the Link and add to URL: à Press "Ok" On the website of mapbox  you can find a lot of different map styles. You can also create your own style if you upload your data by mapbox. There are a lot of different futures, which let you create a unforgettabl...

About me

See my CV Why I blog?  Tableau offers a lot of possibilities to make creative visualization. This tool also has a mass of cool features and I would like get to know some them. I try to rebuild some elements, what I discovered on tableau.public or some informative blogs like vizwiz , storytellingwithdata as also vizcandy . Sometimes I meet people with the same interests like me, so I learn also from them. In my blog, I try to cement my knowledge and also share them with you. Why do I blog in English?  My mother tongue is Russia. I also speak German very well. But I would like to learn English. When I blog an English I learn a lot. I think this is the best way to improve my English skills. So please, don't be strict, if you notice some mistakes in my posts. :) What kind of targets do I pursue with my posts?  My tableau workbooks are not perfect.  But I am working on that. My aim is not only to create cool dashboards, but also to learn how to tell a story wit...

How create a calender with tableau?

I posted a calendar to tableau public, which I have done with Tableau 9.3. In my first blog I would like to share with you the steps for creating a calendar. The data sources and calendar you can find here. There are different reasons to use a calendar in tableau e.g. You can create your own calendar with an individual format and a lot of appointments. So it will help you make planning better.  You can also analyze things with calendar, if you drop&down a relevant dimension in order to show successful or not successful days.  To create such things is just a training and will help you use dimensions&figures on another way. And thi is my approach: I created a spreadsheet in excel with three columns: Date  Type of holiday  Holiday The column "Type of holiday" is necessary in order to make differences between private and official holidays. With the spell "C" I marked all private birthdays and with the spell "F" all offici...