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

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

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

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

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

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