Reminder

All sessions are recorded and saved to the OneDrive link above.

Tableau Upgrade

https://ucsdcollab.atlassian.net/wiki/spaces/ACP/pages/772177934

Demo of connecting to https://tab-dev01.ucsd.edu

Q: Are there new features in Tableau 2023.1.9?

A: Nothing major that we are aware of. The top of the user interface within a workbook is a tiny bit different.

Data Guide = https://help.tableau.com/current/server/en-us/data_guide.htm?_gl=1*1gt1c4y*_ga*MTY0MzEyMDQ3OC4xNzEyNTkxODI1*_ga_8YLN0SNXVS*MTcxMzM3Njg5MC4zLjEuMTcxMzM3Njg5OC4wLjAuMA..

Metrics = will be retired in Tableau 2024

Acceleration = https://help.tableau.com/current/server/en-us/data_acceleration.htm?_gl=1*4g3kyo*_ga*MTY0MzEyMDQ3OC4xNzEyNTkxODI1*_ga_8YLN0SNXVS*MTcxMzM3Njg5MC4zLjEuMTcxMzM3Njk3Mi4wLjAuMA..

Tableau Upgrade Questions

Q: Is VPN required for Tableau QA.

A: No. Tableau QA uses DUO. If you have an issue signing in please email busintel@ucsd.edu b/c that is an issue we need to know about.

Q: We got a Tableau QA server back and should use it as before?

A: No, the Tableau QA environment is only available for upgrade testing. We are required to shut it off for the rest of the year due to pricing.

Q: Updates made after the QA/Dev snapshot... will the changes be there in Prod when Prod is upgraded?

A: Yes. We will be performing an in-place upgrade of Tableau Prod & Tableau Public. Which means all of the content in Tableau Prod & Tableau Public will remain in place while the server is upgraded. No changes in Tableau QA will be moved to Tableau Prod. Tableau QA will be deleted after the upgrade.

Q: Will the upgrade impact subscriptions? Or URLs?

A: Nope. All subscriptions, extractions, URLs, views, ect… will remain the same.

Q: When/how will we know if you end up having to do a parallel upgrade or in-place upgrade?

A: We know now that we are doing an in-place upgrade. We only do parallel upgrades when we are unable to do an in-person upgrade. Parallel upgrades are performed by setting up a new server, copying over all of the content, upgrading the server then repointing the Tableau URLs at the new server. It requires a lot more testing so we would notify the Tableau report developers if we were required to do a parallel upgrade. The April 27 upgrade will be an in-place upgrade.

Q: I have a data source that connects to a Google doc but it’s not working in Tableau QA. Is this an issue?

A: By default we don’t lower firewalls between Tableau QA and non-Hana servers, so no, this is expected behavior. You can email busintel@ucsd.edu to request that the firewalls be lowered so that you can test the connection if you would like to test that connection. We do not anticipate any issue when Tableau Prod is upgraded.

Q: What kind of tests should we do?

A: We have a short list of suggestions here:

Reminder

All sessions are recorded and saved to the OneDrive link above.

Tableau Upgrade

Row Level Security using Username

Row Level Security using AD Group

Column Level Security

Reminder

All sessions are recorded and saved to the OneDrive link above.

Tableau Upgrade

Coming soon - do not upgrade early - stay on 2021.4.x so you can publish to the server

Moving to 2023.1.9

Friday 2/23/24 - announcement confirming dates

Tentative dates - Friday March 1 Tableau QA will open for testing by report developers with a snapshot of Tableau Prod taken end of day Thursday February 29.

Report developers have 2 weeks to test reports. From March 1 to March 15.

Friday March 15 at noon will be the Go / No Go decision.

Tableau FAQ Survey

Blink:

Collab:

Where do you go to look for Tableau FAQ’s? Blink

What Tableau related questions do you get?

• What is Tableau Public and when would it be used? Allows Tableau workbook to be shared with all people including outside of UCSD. There is no customer security. There is report developer security so only your team can publish to your folder in Tableau Public. Only data extracts can be published - no live connections. Example:

• What if I want to share will all of UCSD? You can use Tableau Public Folder in Tableau Prod or use the same security as the Tableau Public Folder. Example: UCPath Dept Hierarchy

Reminder

All sessions are recorded and saved to the OneDrive link above.

Lesser Know Functions

https://community.tableau.com/s/news/a0A4T000002OOOCUA4/total-vs-windowsum

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm

Tableau

1. Assumes that your data is coming in from spreadsheets

2. Assumes that your data is flat and all in 1 table

This works well if all your reporting is coming from 1 team for your entire company.

Tableau at UCSD

1. There are at least 3 separate Tableau environments run by 3 different teams with 3 different sets of rules

2. For example: HIPPA compliance; internal vs external audience; business use; license structure; data connections

Activity Hubs Tableau

-Not HIPPA compliant; for internal UCSD use only; not for research projects or classroom work; each developer needs a license but customer do not; BIA can help you set up a connection to between our Tableau and your data source but only the AH team has direct access to the AH (and they create the AH data sources).

Short - Interim - Long Term

Short: Available Now

Interim: Can be done in a few weeks or less.  Requires a ticket to busintel@ucsd.edu requesting firewalls be lowered.

Long: Fields from an existing data source (Kuali, Oracle, UCPath) then it is part of our monthly release.  If it's new tables then we do have to wait for integration.  If it's a new set of data then we'll need to wait for integration and also go through field naming, view modeling and identification of what data you want to join with it.

Tableau upgrade

Coming soon - do not upgrade early - stay on 2021.4.x so you can publish to the server