Placeholder Image

Subtitles section Play video

  • All right, great!

  • Here is our freshly installed version of Tableau.

  • I am sure you are anxious to create some fascinating visualizations, so let’s get started.

  • First off, we need to learn how to connect Tableau to the data source we will be working

  • with.

  • There are two optionswe can either create a connection to a file or a server.

  • Of course, well choose one of the two depending on where our data is.

  • Let’s connect Tableau to a Microsoft Excel file.

  • In general, every time we use a source file in one of the lectures, you will be able to

  • find it in the supplemental resources section.

  • Just open your Course Curriculum and download the available files for that lesson.

  • See?

  • Ok.

  • Great.

  • I’ll select the file called GDP data, and underconnections”, I can now see that

  • Tableau opened the file.

  • Our source has three sheets – “Data”, “MetadataCountries”, andMetadata

  • Indicators”.

  • What we usually have to do is choose the worksheet well need and drag into the upper part

  • of the screen whereDrag sheets hereis written.

  • Once we do that Tableau is going to activate the sheet we selected and provide us with

  • a preview of the data we have inside.

  • The first two rows of the sheet are empty and hence we see all of thesenullvalues.

  • Tableau is really smart and can often help us with similar issues.

  • As you can see here, the program suggests using itsData Interpreterfunctionality

  • to clean the data.

  • All right, let’s do that.

  • And.. voila!

  • The first two rows containing null values disappeared.

  • That’s awesome!

  • In our next video, well open our first Tableau worksheet, and I’ll be happy to

  • introduce you to its structure.

  • This will do for now.

  • Thanks for watching!

All right, great!

Subtitles and vocabulary

Operation of videos Adjust the video here to display the subtitles

B1 tableau data file metadata worksheet drag

Connecting data sources: Useful tips when connecting data sources to Tableau

  • 0 0
    林宜悉 posted on 2020/03/09
Video vocabulary