Skip to main content

Connect and Modify Your Sales Data

Learning Objectives

After completing this unit, you’ll be able to:  

  • Connect to data in a spreadsheet.
  • Modify the metadata.
  • Save the modified worksheet for future analysis.

Now that you have learned how to connect to, edit, and save a data source, you’re ready to go through these steps yourself. In the following simulation, you connect to your company’s data source, make some changes to the metadata, and save the data source for later use.

Trailhead Simulator

For the best experience, view the Trailhead Simulator on a computer, not a mobile device. Trailhead Simulator is different from a Trailhead Playground. The simulator doesn’t store your progress or any data you enter. If you close your browser, you start from the beginning of the simulation again. You can always use the navigation controls at the bottom of the simulator to get back to where you left off.

A screenshot showing the navigation controls at the bottom of the simulator. There is a left arrow button, a right arrow button, a scrub bar, and a close (x) button.

Navigation Controls Description
(1) Left Arrow Go backward in the simulator.
(2) Right Arrow Go forward in the simulator.
(3) Scrub Bar View your progress, plus you can use the progress arrow to quickly move to a different location within the simulator.
(4) Close Button Exit the simulator. Remember that if you close the simulator, you start from the beginning the next time you launch it.

 

When you click in the wrong spot, highlighting shows you where to click.

screenshot of what a highlighted element looks like in the simulator.

Now you’re ready to practice what you’ve just learned.

Connect to a Data Source

Connect to your company data, which is stored in the Orders.xls file.

  1. Launch the Trailhead Simulator.
  2. Click Connect to a Data Source.
  3. Click Begin.
  4. In the Connect pane, under To a file, click Microsoft Excel.
  5. In the Open dialog box, the Orders.xls file is already selected. Click OpenOrders is listed under Connections in the Data Source pageThe new data source now appears under Connections at the top of the worksheet.
  6. Click Next Exercise to continue to the next exercise.

Rename and Load Data

Rename the data connection to My CompanyOrders Data and load the Orders worksheet data into Tableau.

  1. Ensure you’re in the Rename and Load Data simulation. If you’re not there yet, launch the Trailhead Simulator and click Rename and Load Data.
  2. Click Begin.
  3. In the top left of the data source page, right-click (PC) or control-click (Mac) the data connection Orders, and then select Rename.
  4. Type MyCompanyOrders, and press enter (PC) or return (Mac) on your keyboard.
  5. Under Sheets, double-click Orders to move the table to the area that says Drag tables here. You renamed the data connection and loaded the data in the Orders table. The data source area now displays the new name.
  6. Click Next Exercise to continue to the next exercise.

Edit a Data Source

Using the metadata grid, change field names to make the data more understandable.

  1. Ensure you’re in the Edit a Data Source simulation. If you’re not there yet, launch the Trailhead Simulator and click Edit a Data Source.
  2. Click Begin.
  3. Click manage metadata button to open the metadata grid. The Preview data source button also allows you to change field names, but the metadata grid uses a list view that is more helpful at this stage.
  4. Click the dropdown arrow next to Row, and click Rename.
  5. Enter Row ID, then press enter (PC) or return (Mac) on your keyboard.
  6. Click the dropdown arrow next to Global Area and click Rename.
  7. Enter Country, then press enter (PC) or return (Mac) on your keyboard.
  8. Click Sheet 1 to see the new field names. You made several changes to the field names in your metadata. Next, you save the changes you made to the metadata.
  9. Click Next Exercise.

Save the Data Source

Now that you have made the necessary changes, the next step is to save the data source as a .tds file so that you can use it for future analysis work.

  1. Ensure you’re in the Save the Data Source simulation. If you’re not there yet, launch the Trailhead Simulator and click Save the Data Source.
  2. Click Begin.
  3. Within the worksheet, right-click or control-click the data connection Orders.
  4. Then click Add to Saved Data Sources.
  5. Enter MyCompanyOrders as the filename and press enter or return.
  6. Click close  at the top right to close Tableau Desktop.
  7. Click No when prompted to save changes.
  8. When you open Tableau again and look under Saved Data Sources, you see your saved data source MyCompanyOrders. Click to open it.
  9. Now, view the new field Country. Click the scroll bar to see the renamed field RowID.
  10. Click Home to restart the activity or Exit to continue.

Great job! You’ve walked through connecting to your company’s sales data, made changes to the fields to make them more meaningful for your analysis, and then saved it for future use. It is also ready for you to share with your colleagues so that they can dive right into analysis.

Resources

Keep learning for
free!
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities