Connect Google Sheets to Tableau & Joining Data - Tableau Tutorial P.1

(My recommended course that I took to learn Tableau!)

Part 1 of this tutorial covers how to connect your Tableau Dashboard to Google Sheets. We also cover other data sources that you can connect to as well as best practices when importing your data into Tableau.

00:00 Intro
00:11 Google Sheet To Import
00:46 Tableau Dashboard To Build
01:15 Data Sources Tableau Connects To
01:51 Connecting To Google Sheets
04:03 Joining Data - Managing Multiple Sheets
05:55 Verify Data Import
06:49 Conclusion

Link for Google Sheets - Tableau Superstore Data Set 👉🏼

Link for Tableau Superstore Dashboard 👉🏼

Recommended Certificates/Courses (Affiliate Links)
==================================
DataCamp:

Coursera:

My Tech for Data Science
(Includes Amazon Affiliate Links)
==================================

Social Media / Contact Me
======================

As an Amazon Associate, I earn a small commission from qualifying purchases on the Amazon links above. It costs you nothing but helps me in keeping the content coming.

#tableau #tableaututorial #tableaudashboard

[nicbajito]

I'll be very clear, im gonna watch all ur videos from now on, so i'll call u my mentor lol thanks you for your excellent content ❤️ greetings from Chile !!

[christopher]

Thanks for this info, really good vid.

[packog.]

Hi Luke excellent tutorial, I started to follow you and your material is awesome ! Thanks !

[zhihengxu]

Hey, if i update the data on gsheets, can it be automatically updated on tableau?

[alis]

I died when you started with "Hello nerds" hahaha

[AshutoshTyagii]

Hey @Luke
I have a shared Google sheet via G-suite that will be updated manually time to time, hence I want my Dashboard to be updated. But I am not seeing shated files. Is there any workaround to connect shared sheets because I suspect this is not directly feasible from Tableau.

[tapu]

Provide google sheets schedule refresh

[superawesomecaptainmcfluff]

Hey Luke, wonderful vid! I have an issue though. Say I have two separate worksheets. I can't combine them because then I'll get the error: "file is too large to be exported". How do I union these two separate worksheets (as in, how do I join two tables with different connections)?

[lydanghuong]

Hi Luke, can I use Tableau public instead of Tableau desktop to practise along your Tableau tutorial series?

[Rumil_]

Hey thanks for this! Is it possible to have the data automaically refresh on its own whenever the google sheets is updated?

[resarese]

What do you use to clean your data on google sheets?

[JW-muoh]

Thanks for the tutorial Luke! I'm running into an error (3834C88E). I think it's because I have pivot tables in one of the tabs of the Google Spreadsheet that I'm importing. If I'm only interested in specific tabs within Google Sheets (ones that don't have a pivot), is it possible to remove those error-causing tabs from the import? Or does the entire workbook just always have to be clear of pivots. Any ways of circumventing the issue, like a third-party tool?

[sprsanyal]

How can i use two data sets independently in a tableau...(dont want to create any join)

[michaellilly]

Hey Luke,   thanks as always for all your tutorials and mentoring.  I don't know if you have a recommended reading list (apart from Storytelling With Data (I even found Cole's Google talk on her book)), but I would love it if you did.  If you did, I found a resource that I think you could endorse for Tableau:  "Tableau Strategies: Solving Real, Practical  Problems With Data Analytics" by Ann Jackson and Luke Stanke (O'Reilly, 2021). It's got lots of good stuff for datanerds.

[Nobodyday]

Was really considering learning tableau... however, $70/mo to play with something... no thanks.