Step 1: Connect to your data
- Step 1: Connect to your data (you are here)
- Step 2: Drag and drop to take a first look
- Step 3: Focus your results
- Step 4: Explore your data geographically
- Step 5: Drill down into the details
- Step 6: Build a dashboard to show your insights
- Step 7: Build a story to present
- Step 8: Share your findings
Want an overview? Head back to the Introduction.
Your manager asked you to look into the overall sales and profitability for the company and to identify key areas for improvement. You have a bunch of data, but you aren’t sure where to start. With a free trial of Tableau Desktop, you decide to begin there.
Open Tableau Desktop and begin
The first thing you see after you open Tableau Desktop is the start page. Here, you select the connector that you want to use - how you will connect to your data.
The start page gives you several options to choose from:
Click the Tableau icon in the upper left-hand corner of any page to visit the start page at any time.
Under Connect, you can:
Connect to data that is stored in a file, such as Microsoft Excel or Access.
Connect to data that is stored on a server, such as Tableau Server, Microsoft SQL Server, or Google Analytics.
Connect to a data source that you’ve connected to before.
Tableau supports the ability to connect to a wide variety of data stored in a wide variety of places. The Connect pane lists the most common places that you might want to connect to, or click the More Servers link to see more options. More on connecting to data sources in the Learning Library (in the top menu).
Under Open, you can open workbooks that you have already created.
Under Sample Workbooks, view sample dashboards and worksheets that come with Tableau Desktop.
Under Discover, find additional resources like video tutorials, forums, or the “Viz of the week” to get ideas about what you can build.
Under Saved data sources, select Sample - Superstore to connect. Your screen will look something like this:
The Sample - Superstore data source comes with Tableau. It contains information about products, sales, profits, and so on that you can use to identify key areas for improvement within your company.
After you connect to your data, Tableau does the following:
Opens a new worksheet. This is a blank slate where you create your first view.
Automatically assigns data types (such as date, number, string, etc.) and roles (dimension or measure) to your data. (We'll talk more about these terms later.)
Adds columns from your data source to the Data pane on the left-hand side. Columns are added as fields.
If you want the juicy details, you can select the Data Source tab in the bottom left-hand corner. Here, you can view the first 1,000 rows of your data, and some analysts go nuts: Sort or hide fields, split fields into multiple columns, and rename column headers, all without modifying the original data. What happens in Tableau stays in Tableau; the data is safe.
Note: If you navigated to Data Source to check out the details, just click on the tab for Sheet 1 to get back to where you started.
More on the Data Source page in the Learning Library (in the top menu).
When you connect to your own data, you might need to do some prep work before connecting to it in Tableau. This is because Tableau makes assumptions about your data so that it can display it properly for you to work with.
More on preparing your data in the Learning Library (in the top menu).
Continue to Step 2: Drag and drop to take a first look.