Tableau Note by Yoshitaka Arakawa

Tableau NOTE

Privacy Policy

https://www.yarakawa.com/privacy-policy

当BlogはTableauおよびデータ可視化の

技術的事項を取り扱っています。

１．世界で使われているAdvancedな技術を広めたい

２．テクニカルな事が書かれている日本語ドキュメントを増やしたい

３．自分の勉強ノート・備忘録として。

上記3点をモチベーションに書いています。

Author

Yoshitaka Arakawa

- Tableau Forum Ambassador 2020

- BI Developer/Tableau Trainer

Network Graph in Tableau

Network Graph in Tableau

When I study how to implement network graph in Tableau with this article, I wonder, when we face to the real data, for example, historical data of transactions where a database has each transaction record, how we can use this method. As we can imagine, data we will face will be much complex and have many records, so I felt that we need to know how to create it from a preparation process. In this post, I try to make the network graph with more complicated data. Here is google

Time-series data segmentation.

Time-series data segmentation.

In the last post, we found that the sales has a seasonal trend. In this post, I'd like to see the detail of the trend. When we see the seasonal trend (Blue line), it looks that there are peaks in September, November and December. We can assume that there were promotions in those periods or other events. As you can imagine, sales condition can be changed. The goal is this post is to see how to catch the "Change" with some methods. The purpose is to catch the change is because

Tableau Dashboard Training 1-7: Time Series Analysis with R in Tableau

Tableau Dashboard Training 1-7: Time Series Analysis with R in Tableau

In this post, I'd like to talk about 1. How to use R in Tableau 2. Time-series decomposition visualization in Tableau 3. Forecast with ARIMA model We are back to data visualization finally. As far as I know there is not much information about R codes in Tableau, especially time-series analysis. I hope my blog helps you learn this combination. First of all, we have to connect Tableau with R. References are here (first 2 are written in Japanese). https://community.tableau.com/d

Tableau Dashboard Training 1-6: Decomposition and Forecast with Single Variable Time Series Analysis

Tableau Dashboard Training 1-6: Decomposition and Forecast with Single Variable Time Series Analysis

In this post, I will talk about time-series decomposition. According to this website and the author's book, "Time Series Decomposition is to decompose a time series into trend, seasonal, cyclical and irregular components" and "The trend component stands for long term trend, the seasonal component is seasonal variation, the cyclical component is repeated but non-periodic fluctuations, and the residuals are irregular component". (After we learn time-series analysis, we will con

Tableau Dashboard Training 1-5: Data Prep for Time Series Analysis

Tableau Dashboard Training 1-5: Data Prep for Time Series Analysis

In next couple of posts, I'd like to talk about "Time-Series Analysis" in R. The global superstore data has Order_Date so we can use time-series analysis technique to predict future. The picture above is the goal for this analysis. For precise definition of time-series data, since I skipped theories (because I prefer to have a practice first), please study by yourself. In this post, I will talk about 1. how to aggregate data by a certain category 2. how to convert ordinal dat

Tableau Dashboard Training 1-2: Overview Dashboard

Tableau Dashboard Training 1-2: Overview Dashboard

This is the goal for this post. In this post, I will talk about 1. Calculation in Tableau 2. Filters through worksheets for interactive dashboards I would like to skip basic of Tableau. For basics, please watch Tableau Tutorial Video. Let's start with Sales Map. With this visualization, I would like to see 1. Profit Margin, Sales and Profit by specific area, for example, by postal code. 2. What Category is profitable and has high sales? 3. What segment of customers is profita

Tableau Dashboard Training 1-1: Data Preparation

Tableau Dashboard Training 1-1: Data Preparation

(9/27 Edited: some data prep should be done in Tableau. Detail is at the end of this post.) From today, I'd like to write Tableau Dashboard Training Series. This is the first series. The pictures above are my goals and a reference for this series is here: https://www.tableau.com/solutions/workbook/map-and-track-profitability-with-an-executive-overview As the first part, I will talk about data preparation in this post. From the next post, data visualization will start with ste

Integration of R, Tableau and Google Analytics

Integration of R, Tableau and Google Analytics

I am studying R, Tableau and Google Analytics and my current task is to analyse website's traffics in order to 1. understand customer segments such as demographics and behavior 2. determine what channel is the most effective based on conversion rate, number of sessions and so on. I found that R, Tableau and Google Analytics are not separated, they can be integrated into one entire system. For example, I can write R codes in Tableau that make up for the complexity of coding to

1

2