Opening & Connecting Data Sources in Tableau Desktop
Tableau Desktop
| Intermediate
- 11 videos | 49m 53s
- Includes Assessment
- Earns a Badge
In this 11-video course, learners will explore Tableau Desktop, which is data visualization software that allows users to see and understand data at a deeper level. Begin by locating and opening Tableau Desktop in a Windows 10 work environment, and once done, explore the Tableau Desktop interface. This leads into examining the Tableau Data Source Page, which is one of the most fundamental and important parts of Tableau. Discover how to connect to a desktop source and use single and multiple tables to extract data into Tableau Data Engine; how to connect to a Microsoft SQL Server database, select tables, and directly connect to the data to enable working with live data; and how to configure and use Extract Mode with a Microsoft SQL Server database connection. Next, examine how to extract data with a custom SQL query; use Google Analytics and Tableau to analyze your web data; work with OData source to consume data in Tableau; and demonstrate and implement inner, left, and right joins with Tableau. Conclude the course by observing how to use cross-database and more advanced joins.
WHAT YOU WILL LEARN
-
locate and open Tableau Desktop in a Windows 10 work environmentexplore the Tableau Desktop interfaceexplore the Tableau Data Source Pageconnect to a desktop source and use single tables and multiple tables to extract data into Tableau Data Engineconnect to a Microsoft SQL Server database, select tables, and directly connect to the data to enable working with live dataconfigure and use Extract Mode with a Microsoft SQL Server database connection
-
demonstrate how to use a custom SQL query with a database to extract data into the Tableau Data Engineuse Google Analytics and Tableau to analyze your web datawork with an OData source to consume data in Tableaudemonstrate and implement inner, left, and right joins using Tableaudemonstrate cross-database and more advanced joins
IN THIS COURSE
-
2m 41sBefore you can connect data sources and start creating data visualizations, you will need to know how to open the Tableau Desktop application. See how to locate and open the application and navigate using the Start page. FREE ACCESS
-
4m 10sThe Tableau Desktop interface is organized into different areas, allowing you to connect new data sources, open existing Tableau workbooks and saved sources, and configure the application. Knowing how to navigate within… FREE ACCESS
-
5m 39sThe Data Source Page is used to control, prepare, and configure the data that you are going to work with in Tableau Desktop. See how to manage your data source connection settings, use the canvas to set up data tables,… FREE ACCESS
-
4mBringing data into Tableau Desktop can be as simple as connecting an Excel workbook or a locally-stored Access database. Tableau Desktop allows you to work with files containing single and multiple data tables. See how to… FREE ACCESS
-
5m 1sIf you have a Microsoft SQL Server database, you can connect it to Tableau and start working with the data that it holds. See how to connect a Microsoft SQL Server and configure the Live Mode for working with the data in… FREE ACCESS
-
5m 9sThe Extract Mode in Tableau Desktop is a way of bringing data into the Tableau Data Engine. It can help to improve performance when working with the data and reduce the workload on the data source itself. It can also help… FREE ACCESS
-
3m 44sSQL queries can be used to prepare or configure your data before beginning work on it. They can also be used to get around certain database restrictions, append and aggregate data, and reduce data sizes. See how to add a… FREE ACCESS
-
5m 27sIf you are running Google Analytics on a website or property, you can use Tableau Desktop to run analysis on the data that is harvested. See how to retrieve your web data from your Google Analytics account, extract it… FREE ACCESS
-
3m 39sOData is a widely-used open protocol for querying and consuming data. If you have access to an OData source, you can quickly connect it in Tableau Desktop and configure it for extraction into the Tableau Data Engine. FREE ACCESS
-
4m 37sUnderstanding joins is essential if you want to know how to combine data and go further with your analysis. By creating joins, you can work with related data values stored across multiple tables within a source or across… FREE ACCESS
-
5m 45sOnce you have got the basics of joins, you can start to explore connecting data across multiple sources, known as cross-database joins. You can also adjust and edit your join settings and even create calculated joins to… FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book
Tableau for Dummies