Tableau for Finance Reporting: Data Sources, Worksheets and Dashboards Explained

If you are asking how Tableau fits into finance reporting, the short version from Tableau's own documentation is this: you connect to data, build individual views on worksheets, combine those views into dashboards, and then share the result, for example by publishing to Tableau Server or Tableau Cloud. This guide walks through those four steps using the vendor's help pages, written for Dublin-based finance and operations teams who want the concepts before they open the software.

We are describing documented behaviour only. Menus, names and availability change by version and licence, and the help pages we read show no publication or last-updated date, so check the current Tableau documentation for the version you use. This post does not compare Tableau with other tools; for that, see our piece on Power BI or Tableau for accountants.

Step one: connecting to data

The "Connect to Your Data" page lists the kinds of source Tableau can connect to. Among them are local files such as spreadsheets and text files, enterprise databases (relational, big data and cube), cloud sources, and published data sources on Tableau Server or Tableau Cloud. It also lists options such as Other Databases (JDBC or ODBC), Web Data Connectors and connector plugins, and says Tableau provides limited support for connections created that way. You can also paste copied data from the clipboard to create a data source quickly.

In Tableau Desktop, the page describes choosing a connector on the Connect pane and supplying connection details. For most connections you need to supply a server name and sign-in information. In web authoring on Tableau Server or Tableau Cloud, the page describes starting from a Connect to Data page with tabs for the site, file uploads (.xlsx, .csv, .tsv) and connectors.

For finance teams, a sensible first question is where the numbers will come from. Our suggestion: decide whether the source is a controlled system extract, a database or a manually maintained spreadsheet before you build anything, because the reliability of a dashboard cannot exceed the reliability of its source. Our guide to financial dashboards and executive reporting in Excel makes the same point about the Excel route.

Combining tables: relationships, joins and unions

The "Plan the Data Source" page explains three ways of combining tables:

• Relationships: described as the default way to combine data in Tableau. Tableau stores the link between tables and builds joins only when a visualisation needs them. The page says this suits data at different levels of detail.
• Joins: merge two tables based on a join clause and join type to form a new, fixed table. The page warns that joins may lose data with some join types, and may duplicate data when the tables sit at different levels of detail.
• Unions: append rows across the same basic column structure. The tables must share the same columns.

The duplication warning matters in finance. If a join repeats a budget line for every transaction it matches, totals can silently overstate. A practical approach: after any join, reconcile a total in Tableau back to a known control total from the source system.

Live connections and extracts

The "Extract Your Data" page defines a data extract as a subset of information saved separately from the original dataset. It says extracts optimise query performance, can handle very large volumes, can unlock functionality the original source does not support, and allow offline access in Tableau Desktop. An extract can be refreshed from the original source. A full refresh replaces all existing content; an incremental refresh includes only new rows since the previous refresh. The page notes that incremental refresh requires All Rows and is not available with Aggregation.

The page does not say which approach is right for any given reporting task. For month-end reporting, a point-in-time extract has an obvious attraction, because the numbers do not move while you review them. That is our suggestion, not a documented recommendation.

Step two: worksheets

The "Workbooks and Sheets" page says Tableau uses a workbook and sheet file structure, much like Microsoft Excel. A workbook contains sheets, which appear as tabs along the bottom. A worksheet contains a single view of your data, built by placing fields on shelves, and includes cards, legends and the Data and Analytics panes. The page also states that a workbook must always contain at least one worksheet.

In practice, a finance team might keep one worksheet per measure or comparison, such as revenue by month or cost by department, and then assemble them. That is a working habit we suggest, not documented guidance.

Step three: dashboards

According to the same page, a dashboard is a combination of views from multiple worksheets, arranged for presentation or monitoring. The "Create a Dashboard" page describes the documented steps:

• Click the New Dashboard icon at the bottom of the workbook.
• Drag views from the Sheets list onto the dashboard.
• To replace a sheet, use Swap Sheets. The page notes filters specific to the old sheet may become blank.

Objects can be dragged in from the Objects section, including horizontal and vertical containers, text, images, web pages, blanks, navigation and download buttons. The page says containers group objects and affect how the dashboard resizes. For interactivity it describes Use as Filter, so selected marks filter other sheets, and actions in Tableau Desktop. The Workbooks and Sheets page adds that worksheets used in a dashboard cannot be deleted, only hidden.

The Workbooks and Sheets page also describes a story as a sequence of worksheets or dashboards that work together to convey information.

Step four: publishing and sharing

The "Publish Data Sources and Workbooks" page says you can share work with your team by publishing to Tableau Server or Tableau Cloud, where colleagues can view and interact with it in a browser or the Tableau mobile app. A published data source gives everyone one shared source, so connected workbooks reflect updates to it. A workbook contains views, dashboards, stories and the data connection. To publish, the page says you need the Creator site role on the target site and View and Save capabilities on the destination project, otherwise contact your Tableau administrator.

The page also mentions Tableau Public as a free alternative, with publicly accessible views. The Get Started tutorial adds a warning: Tableau Public views and underlying data are public, and it advises considering Tableau Server or Tableau Cloud when sharing confidential information. For finance data, that distinction is important. Our suggestion: agree with your data protection lead and IT team where reporting is allowed to be published before anyone uploads a workbook.

A practical checklist

• Confirm the source and who owns it.
• Choose live or extract, and note the refresh date on the dashboard.
• Reconcile a total after every join.
• Keep one question per worksheet before combining them.
• Check who can see the published workbook.

These are our suggestions, not Tableau requirements. If your team also works with Microsoft's reporting tool, our overview of Power BI for finance teams covers the equivalent ideas.

Learnsignal's offices are off Baggot Street in Dublin, and we offer in-person training from there. For current details, see our CPD pages.

Frequently asked questions

What is a worksheet in Tableau?

According to Tableau's Workbooks and Sheets page, a worksheet contains a single view of your data, built by placing fields on shelves.

What is the difference between a worksheet and a dashboard?

A dashboard combines views from multiple worksheets, arranged for presentation or monitoring, according to the same page.

What is an extract?

Tableau defines a data extract as a subset of information saved separately from the original dataset. It can be refreshed from the original source, fully or incrementally.

Can I publish finance data to Tableau Public?

The tutorial page warns that Tableau Public views and underlying data are public and advises considering Tableau Server or Tableau Cloud for confidential information. Check your internal policy first.

Tableau's documentation describes a clear sequence from data to worksheet to dashboard to published workbook; whichever version you use, check the current help pages for exact menus and options.