Once connected to MS Access database one should see underlying tables in the left pane.
Choose Access under Connect option browse to the location where MS Access database file exists. If you are using Tableau Public then you will still be able to connect to MS Access database. Now that we understand the schema of the database, let us go ahead and connect to it from Tableau.Ĭonnecting to MS Access database is no different from connecting to any other data source. There is also a dimension missing from the table that is Geography represented by Store Key in FactSales table. The dimensions table indicate Sales of Products happening through different Channels over different Time with one or more Promotions. We also have data for discount amount and quantity. In nutshell, we have Facts table, which has facts such as sales quantity, sales amount and corresponding metrics for goods returned. If one looks closely at DimProduct table, which refers to DimProductSubcategory one will realize that it is generally observed in snowflake schema where dimensions are normalized into multiple related tables. 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.
#HOW TO FIND MY TABLEAU PRODUCT KEY HOW TO#
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.