Connecting to Access databases
by Matt Floyd, Ashley Ohmann, Ashutosh Nandeshwar, Jen Stirrup
Tableau: Creating Interactive Data Visualizations
- Tableau: Creating Interactive Data Visualizations
- Table of Contents
- Tableau: Creating Interactive Data Visualizations
- Tableau: Creating Interactive Data Visualizations
- Credits
- Preface
- 1. Module 1
- 1. A Short Dash to Dashboarding!
- 2. Summarizing Your Data for Dashboards
- 3. Interacting with Data for Dashboards
- 4. Using Dashboards to Get Results
- 5. Putting the Dash into Dashboards
- 6. Making Dashboards Relevant
- 7. Visual Best Practices
- 2. Module 2
- 1. Connecting to Data Sources
- Introduction
- Connecting to text files
- Connecting to Excel files
- Connecting to Access databases
- Connecting to a SQL Server
- Pasting from a clipboard
- Connecting to other databases
- Connecting to Windows Azure Marketplace
- Understanding dimensions and measures
- Changing data types
- Applying filters
- Merging multiple data sources
- 2. Creating Univariate Charts
- 3. Creating Bivariate Charts
- 4. Creating Multivariate Charts
- 5. Creating Maps
- 6. Calculating User-defined Fields
- 7. Customizing and Saving
- 8. Exporting and Sharing
- 9. Exploring Advanced Features
- 1. Connecting to Data Sources
- 3. Module 3
- 1. Getting Started with Tableau Public
- 2. Tableau Public Interface Features
- 3. Connecting to Data
- 4. Visualization – Tips and Types
- 5. Calculations
- 6. Level of Detail and Table Calculations
- 7. Dashboard Design and Styling
- 8. Filters and Actions
- 9. Publishing Your Work
- A. Bibliography
- Index
Microsoft Access is a good tool to store smaller datasets in a relational database format without purchasing and installing complete data storage solutions, such as Microsoft SQL Server, Oracle, or MySQL. Tableau provides an option to connect to Access databases.
Let's use the Access database (Sample - Coffee Chain.mdb) that came with the standard installation. As with the Excel file used in the previous recipe, unless you made any customization during installation, the database file should be found by navigating to Documents | My Tableau Repository | Datasources.
Once you have located the Access database file, perform the following steps to connect to the sample Access database file:
- From Tableau's main screen, click on Connect to Data.
- Under the In a file option, select Microsoft Access as the connection option.
- Browse and select the file
Sample - Coffee Chain.mdb. - Tableau will determine and list tables found in the database and will ask whether to analyze a single table or a query. Select CoffeeChain Query and hit OK.
- Use the Connect live option to connect to the data from the Access database.
- You'll see that Tableau loaded the query from the Access database and also determined the data types using Microsoft's Jet Engine Driver.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.