Versions Compared

Old Version 20

changes.mady.by.user Mubtasim Akhyar [X]

Saved on

compared with

New Version Current

changes.mady.by.user Andy R. Andersen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Aura - Title
color#0073a4
textAlignleft
fontSize28
lineHeight28
cloudTextDemo Title
tagh1
fontWeightbold
Tableau: Downloading Tableau Data

Aura - Divider
serializedStyles{"alignment":{"horizontal":"start"},"icon":{"name":"faPaperPlane","color":"#333","size":24},"text":{"color":"#333","fontSize":14,"textAlign":"left","fontWeight":"bold","text":"Aura Divider"},"border":{"top":false,"right":false,"bottom":true,"left":false,"color":"#0073a4","style":"solid","width":2},"size":{}}
typeregular

Info
iconfalse
Overview

Tableau allows users to configure data and save it locally.

Additionally, users can download reports and share them internally, and under certain circumstances, externally.

Downloading Data from Tableau Reports

This page outlines how to download data from Tableau in different formats. Some Tableau dashboards contain multiple tabs that represent each worksheet in the dashboard. Data is only downloaded from the active worksheet. This does not apply to Views which contain the same data elements but organized differently.

UI Steps
sizesmall
UI Step

Select the Download option, located on the Tool Bar. The Tool Bar is displayed at either

The Download option is located on the Tool Bar which is either displayed at

the top or bottom of the screen.

Expand
titlescreenshot

Image Added

image2019-6-17_14-13-43.pngImage Removed

When you click on the download icon you will get the following choices:
UI Step

Select the file format for the data export. Refer to the additional instructions below for each specific file format. 

Expand
titlescreenshot

image2019-6-17_14-14-1.pngImage Removed

  • PDF: Allows users to select multiple views (tabs) and consolidate them into one report and print as a PDF
  • Crosstab: Downloads data as displayed in reports into excel, giving the same view as the tabular view (one view at a time)
  • Data: Downloads all underlying data used to create a tab into excel 
  • Image: Downloads a picture of the view, although usually not recommended
Tip

Some tabs have multiple worksheets on the same tab — Example in the NEIS Periodic Procurement Report, the Section 1 summary includes two worksheets. One worksheet is a summary table and the other has calculations of the competitive percentage. When working in a view like this, Tableau downloads the data that pertains to the worksheet that your cursor is in.  If you want to download the table itself, your cursor would have to be active in the table.

Image Added

UI Step

The additional instructions in the table below vary based on the option selected in the step above.

File Format

Output

Additional Steps

Image

Png. image file of the selected visualization.

N/A

DataUnderlying data in the Tableau workbook as a CSV file.
  1. Select Full Data.
  2. Check off the Show all columns box.
  3. Click on Download all rows as a text file.
Expand
titlescreenshot

Image Added

Crosstab Allows for the export of a particular Tableau visual to an Excel or CSV file.
  1. Click into the Tableau visual that you would like to download into Excel. If you have selected a visual, Tableau will default to having that sheet selected in the next step.
  2. Select the sheet you wish to download.
  3. Select CSV. 
  4. Select Download.
Expand
titlescreenshot

Image Added

Warning
iconfalse

Selecting Excel format can result in merged cells in Excel, which can pose challenges for data analysts.

PDFVisual(s) will be opened in a PDF file.
  1. Select the view(s) you would like to export.
  2. Adjust the scaling, paper size, and orientation as necessary.
  3. Select Download.
Expand
titlescreenshot

Image Added

PowerPointVisual(s) will be opened in a PowerPoint file. Each visual selected will have a separate slide.
  1. Select the view(s) you would like to export.
  2. Select Download.
Expand
titlescreenshot

Image Added

Tableau WorkbookEntire Tableau Workbook will be downloaded.
  1. Select the Tableau version you would like the workbook exported to. For most users, this will be the current version. Check for accuracy on this statement.
  2. Select Download.
Expand
titlescreenshot

Image Added

HTML
<style type="text/css">
#title-text {display: none;}
</style>

Sharing Data with External Stakeholders

Question

Can a Tableau project (dashboards, reports, maps, etc.) be shared with an external stakeholder such as a NYSERDA contractor, partner, or another state entity?

Answer

Yes, there are two ways to share a Tableau project with an external stakeholder; either via a URL or via a static file.

PROS

CONS

Notes

URL

· Automatically refreshes data daily

· Provides user with access to the underlying data

· Not secure; Only PUBLIC information can be included in the Tableau Project

Sharing a Tableau project with an External Stakeholder via a URL is the preferred method, but it can only be leveraged for Public information. All Tableau projects published to the External space on NYSERDA’s server are vulnerable to discovery by the public. The only way to share a Tableau project with someone external to NYSERDA given NYSERDA’s existing Tableau server structure is by publishing it to the External space on NYSERDA servers. Solutions to add/modify servers to securely share a Tableau project with an External Stakeholder are very expensive.

Static File

· Tableau project can contain confidential information

· User must download and install a free version of Tableau Reader. ITS tenants can submit a ticket to ITS to get Tableau Reader installed on their machine. ITS has an install package in SCCM for Tableau reader software.

· Data is NOT automatically refreshed; any updates to the data or project requires NYSERDA staff to send a new File to the External Stakeholder

· User cannot access the underlying data

The Tableau File can be shared securely through an External SharePoint site or other secure file transfer; Confidential information can be included in the Tableau Project (permission from Data Governance must be obtained prior to sharing any confidential information through any means with an External Stakeholder)

Required Action:

  • Complete a Service Desk request if you are interested in data visualizations.  Select “IT Support”, then “Data Sets, Maps and Visualizations”.
    • Contact Data Governance if you need to share Tableau project information that contains Confidential-Internal or Confidential-Private data.