Тёмный

How to Connect to Different Data Sources in Tableau: A beginner's guide 

Tableau Tim
Подписаться 177 тыс.
Просмотров 17 тыс.
50% 1

Connecting to data in Tableau is very easy. In this video tutorial, you will be introduced to the process of connecting to different data sources in Tableau. Whether you have data stored in a CSV file, an Excel file, or a database. Tableau provides a seamless way to connect to your data and start creating meaningful visualisations and dashboards.
We will start with connecting to a CSV file. You'll learn how to navigate to the "Connect to Data" screen, select "Text File" as the data source type, and then choose the desired CSV file. You'll also see how to select options such as changing the default data type of columns and setting the first row as the header. Finally, we'll show you how to click "Connect" to establish a connection to the CSV file and start using the data in Tableau.
Next, we'll move on to connecting to an Excel file. The steps are similar to connecting to a CSV file, but instead of "Text File," you'll select "Microsoft Excel" as the data source type. You'll also see how to select options such as changing the default data type of columns and setting the first row as the header, and then click "Connect" to establish a connection to the Excel file.
Finally, we'll demonstrate how to connect to a database using Snowflake. You'll learn how to enter the necessary connection details, such as the Snowflake account name, username, password, and database/warehouse name, and then click "Sign In" to authenticate the connection. Once the connection is established, you'll see how to start creating visualisations and dashboards using the data from Snowflake.
By the end of this video, you will have a solid understanding of the process of connecting to different data sources in Tableau, and be well on your way to creating powerful visualisations and dashboards.
Timestamps
0:00 Intro
0:24 The connection Pane
1:30 Static File types
4:05 Connecting to a CSV file in Tableau
15:22 Connecting to an Excel file
23:51 Connecting to a database - Snowflake
29:04 Switching to an Extract
34:28 Save your workbook with the data
Join this channel to get access to perks:
/ @tableautim
#tableau #salesforce #analytics #data
Follow me on Twitter: / tableautim
My recording gear & what's on my desk. kit.co/TableauTim/desk-setup
My website: www.tableautim.com/
My Screen Annotation Tool: j.mp/3HWc4Mj
My technology Channel: j.mp/3F0d28f
Share feedback and Suggestions: tableautim.canny.io/suggestions ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.

Опубликовано:

 

17 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 19   
@datadocsdailydose2
@datadocsdailydose2 7 месяцев назад
You're priceless! Many thanks...
@Nick-px5tq
@Nick-px5tq Год назад
Hi, Tim. Just watched this after your 10-min intro to Tableau, and got pretty lost! Which of your videos do I need to watch to be able to understand this one?
@perryiro6283
@perryiro6283 Год назад
This was very helpful. Do you have a video on how to compute for Average, Minimum, Maximum and Standard deviation from an Excel data? Thank you.
@TableauTim
@TableauTim Год назад
These are just functions in tableau, no need to compute them. Tableau does this for you. Look at any of my videos on functions to get an idea how ort just google, "Average, Minimum, Maximum and Standard deviation Tableau" and you should find many guides.
@alainponroy2621
@alainponroy2621 Год назад
very useful video
@shrutishreya5242
@shrutishreya5242 7 месяцев назад
Hi, i am getting an error while connecting tableau prep to Mysql saying that System error: An error occurred while communicating with MySQL [MySQL][ODBC 8.2(w) Driver]Access denied for user 'root'@'localhost' (using password: NO) what to do give some solution plz.
@CancilleriLuis
@CancilleriLuis Год назад
Hi tim How can you connect a folder of excel files (that you will update weekly) to Tableau?
@TableauTim
@TableauTim Год назад
Excel files are the worst. I would first have a data pipeline that checks all the excel files to make sure theyre the correct structre, column fields are correctly labelled and metadata correct. If one sheet in one file is incorrect that can break the entire pipeline. To do this I would start with Tableau prep or Altered or python if your familiar with that. Then once you're ready you can just bring all the file sin and union them accordingly but i wouldn't ever deliver this a solution to a client. Id start by moving the data into a csv, one file for each relevant data structure and connect to that.
@CancilleriLuis
@CancilleriLuis Год назад
@@TableauTim But if I have 100 + .cvs files and I will add new ones weekly, ¿Is it recommended to do it like that? On Power BI, for example, you can connect already to a folder (with excel files on it) and it updated automatically (considerating that every column is the same and the structure overall)
@BowenShi-dt7hg
@BowenShi-dt7hg 3 месяца назад
hi Tim! thx for your video, could you show the link to how to connect tableau and snowflake? And is it necessary for us to install it for data visualization?
@TableauTim
@TableauTim 2 месяца назад
i have a sepearte video on snowflake where we use Tableau. Just google Tableau Snowflake Tableautim and it should come up
@fishkenorian
@fishkenorian 11 месяцев назад
Hi, In public tableau don't we have the option to choose between extract and live?
@TableauTim
@TableauTim 11 месяцев назад
On Public desktop edition yes on Public web version no. All web versions have to create an extract because your uploading your data to Tableau's cloud.
@adityareal32
@adityareal32 Год назад
Hi Tim Ur thumbnail look cool. how do you make thumbnails. Can u make a video on that
@TableauTim
@TableauTim Год назад
already have >> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--8S6ZqDvzjw.html
@adityareal32
@adityareal32 Год назад
@@TableauTim thanks tim
@salaiarunmanijb174
@salaiarunmanijb174 Месяц назад
Any one please explain creating new connection vs new data source in tableau
@TableauTim
@TableauTim Месяц назад
A data source is a single piece of information or data model in your workbook that answers a set of problems. It can contain multiple connections to data sources. An example you might have a connection to excel, a connection to csv and a connection to database that you join or union into a single data source.
@salaiarunmanijb174
@salaiarunmanijb174 Месяц назад
@@TableauTim thanks for the explanation 🙂
Далее
Understanding the grain of your data in Tableau
12:47
меня не было 9 дней
12:48
Просмотров 2,3 млн
Minecraft Pizza Mods
00:18
Просмотров 2,2 млн
The 5 Business Growth Principles™
9:04