Welcome to new things

[Technical] [Electronic work] [Gadget] [Game] memo writing

Tableau

Difference between "dimensions" and "measures" in BI tools

The first time I used a BI tool, I was confused by the difference between "dimensions" and "measures. I will try to briefly explain the differences and ideas here. name In Tableau, they are called "dimensions" and "measures". In PowerBI, t…

How to use "relative date" and "date range" at the same time in Tableau

To the UI for specifying the display range of time series graphs The default is to show the most recent X days, and you can specify any date in the calendar when you need it." I often see things like this. But I can't do the equivalent wit…

How to use "relative date" and "date range" at the same time in Tableau

PS Now there is another, better way, which is shown below. www.ekwbtblog.com To the UI for specifying the display range of time series graphs The default is to show the most recent X days, and you can specify any date in the calendar when …

Memo on how to use Tableau's LOD (Level of Detail)

Tableau is intuitive, and you can create graphs by dragging and dropping with the mouse. However, when trying to port Excel graphs to Tableau, sometimes it is not possible to create a graph properly using only mouse operations. Such graphs…

What to do when you can't log in to an app with Azure Active Directory single sign-on (SSO)

I was interested in single sign-on (SSO) services and tried various services for a while. www.ekwbtblog.com I wanted to log in with my Office365 user as a key, so I ended up using Azure Active Directory SSO. As for the usage, I mainly use …

Organize Tableau formatting to the extent that Excel-like graphs and tables can be drawn.

Tableau's default graphs are quite beautiful. For practical use, it is sufficient to slightly modify the defaults, but for graphs used for documentation purposes, you may want to change the appearance of the graphs in various ways to match…

How to easily arrange graphs in a grid on a Tableau dashboard

It is difficult to arrange graphs in a Tableau dashboard because it is hard to get the layout to look the way I want. The reason is that when you drop or move an object with the mouse, it does not enter the intended hierarchy, Because chan…

How to center a Tableau bar chart on a date

When displaying a bar chart in Tableau with continuous date values, it is difficult to see the bar chart because the starting position of the bar chart is to the left. In particular, when displayed with a line graph in a two-axis display, …

Tableau is recommended over Python for easy cluster analysis

Tableau not only displays graphs, but also provides cluster analysis capabilities. Python is free, and it is easy enough to perform cluster analysis with Python, but when trying to perform cluster analysis in Python, work such as standardi…

Draw a quick graph in Google Data Portal (formerly Data Studio)

I usually use Tableau or PowerBI, but there are times when I don't want to use them, but want to quickly display a graph and check the data. I thought it might be useful to know about the Google Data Portal for such occasions, so I put tog…