Tableau Server and Tableau Cloud Flashcards
(51 cards)
How do you Publish a Workbook to Tableau Cloud/Server?
(In Tableau Desktop)
1- Sign into your tableau server
2 - Open the “Publish Workbook” dialog box
* “Server” > “Publish Workbook”
* Under “Project”: Select the project
* Under “Name”: enter workbook
* Under “Tag”: add search tags
* Under “Permissions”: accept the default project settings
* Under “Data Sources”: Select “Edit” to change how the data is embedded or how people authenticate with data sources.
* Click “Publish”
Image 10
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_howto.htm
If you are publishing a ____ data source, you need to set a refresh schedule for each extract connection in the data source.
If you are publishing a multi-connection data source, you need to set a refresh schedule for each extract connection in the data source.
To publish a workbook, you need to first open:
- Tableau Desktop
- Tableau Public
- Tableau Reader
- Tableau Cloud
- Tableau Server
- Tableau Prep
You can publish to:
* Tableau Desktop
* Tableau Public
* Tableau Reader
* Tableau Cloud
* Tableau Server
* Tableau Prep
Tableau Desktop
Tableau Cloud & Tableau Server
T/F
To use refresh schedules with connections to a database that requires you to sign in to it, you must store (embed) a database user’s credentials with the connection.
True
(Note that store & embed mean the same thing.)
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_schedules.htm
When you publish to Tableau Server, the schedule runs and is managed on the ____.
Server
If your workbook connects to a Tableau data source, it’s recommended to choose ____ Publish Type publishing. (Note that these options are in the “Manage Data Source” dialogue box)
- Embed password
- Allow refresh access
- Prompt Users
Embed password
Note that I think the only 2 options are Embed password or Prompt Users.
Image 29
How to Publish Workbook: https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_howto.htm
If you’re publishing an extract and want to set up a refresh schedule, you must select ____ or ____ when publishing your workbook.
(Tableau Cloud & Tableau Server)
Embed password or Allow refresh
Bonus: It’s under “Authentication” Image 29
How to Publish Workbook links:
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_share.htm
.
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_howto.htm
T/F
If you’re publishing a workbook and want to set up a refresh schedule, you must select Embed password or Allow refresh access.
False
If you’re publishing an extract and want to set up a refresh schedule, you must select Embed password or Allow refresh access.
How to Publish Workbook links:
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_share.htm
.
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_howto.htm
You’re in Tableau Desktop.
If you’re publishing an extract and want to set up a refresh schedule, what are the steps to allowing extract refreshes?
- Open ____: Select ____ > Select ____ (If neccesary, ____)
- Open ____:
Go to ____ > Select ____ - Under ____, Select ____
- Select ____
(for Tableau Cloud or Server)
- Open “Publish Workbook to Tableau [Server/Cloud]” dialog box: Server > Publish Workbook (If neccesary, Sign into server.)
- Opens “Manage Data Sources”: Under “Data Source”, Select “Edit” Image 34
- Under “Authentication”, Select “Allow Refresh” Image 29
- Select “Publish” Image 34
How to Publish Workbook links:
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_share.htm
.
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_howto.htm
You have a connection that requires authentication.
.
If you want to set up an automatic refresh schedule, you must ____
(for Tableau Cloud or Server)
Hint: Choose from:
* Embed the password in the credentials
* Embed the password in the connection
* Embed the alert in the connection
* Embed the alert in the credentials
.
.
.
.
.
.
.
.
.
.
.
.
.
embed the password in the connection
In other words, you must:
store (embed) a database user’s credentials with the connection
https://help.tableau.com/current/pro/desktop/en-us/publishing_sharing_authentication.htm
To use refresh schedules with connections to a database that requires you to sign in to it, you must ______.
(for Tableau Cloud or Server)
Hint: ____a database user’s credentials with the ______
.
.
.
.
.
.
.
.
.
.
..
.
.
.
store (embed) a database user’s credentials with the connection
https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_schedules.htm
How to Publish a Data Source to Tableau Server/Tableau Cloud
(in Tableau Desktop)
- Sign into ____
- Open the “____” dialog box:
Select “…. “ > “…..” > …. (Image 1) - Edit the “….” dialog box (Image 2) >
click “____”
.
.
.
.
.
.1. Sign into Tableau Cloud/Server
.2. Open the “Publish Data Source to Tableau [Server/Cloud]” dialog box:
Select “Server” >
“Publish Data Source” >
select data source (Image 1)
.3. Edit the “Publish Data Source to Tableau [Server/Cloud]” dialog box (Image 2) >
click “Publish”
https://www.youtube.com/watch?v=_llHyB39Beg
.
https://help.tableau.com/current/pro/desktop/en-us/publish_datasources.htm
How to open a Published Data Source (From Tableau Desktop)
.
1. Open “____” dialog box Image 31:
. Open ____ >
. Under “____”, click “____”
2. Select ____
3. ____
4. Select ____
5. Click “____”
6. Select ____
(From Tableau Desktop to Tableau Cloud or Tableau Server)
- Open “Tableau Server Sign In” dialog box Image 31:
Open the Start Page (Connect Pane) >
Under “To a Server”, click “Tableau Server”
. - Select appropriate server:
Tableau Cloud: click “Tableau Cloud” at bottom left or in options Image 31
Tableau Server: type in server link Image 32
Then click “Connect”: - Sign in with credentials [username(Server)/email(Cloud) & password]
- Select the appropriate data source from the “Search for Data” dialog Image 35
- Click “Connect”
- Select the sheet tab to start your analysis
Bonus: Click “Sheet” to open up sheet: Image 6
https://www.youtube.com/watch?v=_llHyB39Beg
8:23 (I think this vid is outdated)
.
https://help.tableau.com/current/pro/desktop/en-us/examples_tableauserver.htm
https://www.youtube.com/watch?v=o675zmq2H6U
https://help.tableau.com/current/pro/desktop/en-us/examples_tableauserver.htm#:~:text=connect%20from%20tableau%20desktop
T/F
You can build a dashboard in Tableau Cloud
True
https://www.youtube.com/watch?v=plt_t04KTAA
How to update a published data source (Choose one)
- Start Page > “Tableau Server” > “Tableau Cloud” > log in > Click the appropriate datasource > edit
- Open Workbook>in the Data Pane, right click data source > “Edit Data Source” Image 7>
- Download a local copy of the Data Source > Make your edits > Open Workbook > “Server” > “Publsh Data Source” > select local copy Image 8> Change name from the copy to the published data source (usually same name) Image 9 > Uncheck “Update workbook to use the published data source > “Yes” to overwrite
- Wrong bc this is just the connection. You don’t have access to the raw data here
- Takes you to the same place as 1
- Correct option
(idk if this will be on the test, but may be good to know)
How to Download View and Workbooks on Tableau Server and Tableau Cloud
- At the top of a view in Tableau Cloud or Tableau Server, click “Download.” Or, click the download button Download icon, depicted by a rectangle with a downward facing arrow. wherever it appears on the page.
Image 14 - download format:
* Image 15
https://help.tableau.com/current/pro/desktop/en-us/export.htm
How to update a published data source (extract?) (Choose one)
- Open data source from the Start page and after signing in, there is a list of data sources from the server.
- Create and edit a local copy of the Data Source and connect to new published data source
- Edit Data Source from the Data Pane Image 7
- Wrong bc this is just the connection. You don’t have access to the raw data here
- Correct option
- Takes you to the same place as 1
(idk if this will be on the test, but may be good to know)
Steps to create a data-driven alert for Profit in Image 16.
- Select ____
- Click “____” > “____”
- “____” > “____” dialog box pops up
- ____
- Click “____”
.
.
.
.
..
.
..
. - Select “Profit” axis
- Click “Watch” > “Alerts” Image 17
- “Create” > “Create Alert” dialog box pops up Images 18
- Edit the options as appropriate
- Click “Create Alert”
https://www.youtube.com/watch?v=G7NpQJoO3UQ
and
https://help.tableau.com/current/pro/desktop/en-us/data_alerts.htm
What’s in a “Create Alert” dialog box in Tableau Server/Cloud?
How would you edit the dialog box to do the following for Image 16:
Send alert when Profit is < 0.
Send alert daily when condition is met.
Hint: strict
.
.
.
..
.
.
.
.
.
.
Hint: STRiCT
.
.
.
..
.
.
.
.
.
.
Hint: CTSTR
.
.
.
..
.
.
.
.
.
.
Images 18
* Under “Condition”: “Below/equal to”
* Under “Threshold”: type 0
* Under “Subject”: This will be the email subject line. Describe alert “Profit is below 0”
* Under “When the condition is true, send alert”: “Daily at most”
* Under Recipients: add anyone who also shares the Tableau Cloud space
https://www.youtube.com/watch?v=G7NpQJoO3UQ
and
https://help.tableau.com/current/pro/desktop/en-us/data_alerts.htm
Steps to set up a Subscription for the dashboard in Image 20
- Click ____ > “____” Image 17
- Edit “____” dialouge box Image 19
.
.
.
.
.
.
.
.
.
.
.
1. Click “Watch” > “subscriptions” Image 17
2. Edit “Subscribe” dialouge box Image 19
https://www.youtube.com/watch?v=M7IABxLm-o4
and
https://help.tableau.com/current/online/en-us/subscribe_user.htm
Steps to create & save a custom view
- Open Workbook in Tableau Cloud/Server
- ____
- Open “____” dialogue box: Select “____” or “____” from the toolbar Image 21
- Fill out “____” dialogue box > Click “____”
- Open Workbook in Tableau Cloud/Server
- Change to desired view (e.g. filter to one country)
- Open “Custom Views” dialogue box: Select “View Original” or “Save Custom View” from the toolbar Image 21
- Fill out “Custom Views” dialogue box > Click “Save”
https://help.tableau.com/current/pro/desktop/en-us/customview.htm
and
https://www.youtube.com/watch?v=8wScjSmaLNI
To efficiently manage permissions:
Manage permissions for ____, not ____
- users
- groups
Manage permissions for groups, not users
To efficiently manage permissions:
Manage permissions for ____, not ____
- content
- projects
Manage permissions for projects, not content
A common way to manage permissions is to use ____ for users who should have the same permissions.
groups