This is a typical example of a star schema where we have a Fact table referencing one or more Dimension tables. The screenshot below shows the relationship between the tables that exists in the database opened in MS Access. Let us spend some time understanding the data itself that we are going to use for the purpose of this blog.
One can find the sample MS Access database file under “\Documents\My Tableau Repository\Datasources” folder if Tableau is already installed on the machine. Dataįor this exercise, you can choose to open any MS Access database that you may have or use sample datasets that are bundled with Tableau installation package. In this blog, we will learn how to connect to MS Access Database from Tableau, how to perform joins on multiple tables (a.k.a Data Blending) across different data sources and how to import data from tables selectively.
0 kommentar(er)
