How to Use Tableau Public for Business Reporting

Tableau Public is a free version of Tableau Desktop that covers the core visualization workflow: connect a spreadsheet or CSV file, drag and drop fields to build charts, and publish an interactive dashboard to a public URL. For business reporting, it works well for sales trends, customer breakdowns, and operational metrics as long as the data does not contain anything confidential, since every published dashboard is visible to anyone on the internet.

What Tableau Public Can and Cannot Do

Tableau Public is free to download and use without a Salesforce or Tableau license. The main restrictions compared to paid versions are worth knowing before you invest time building dashboards.

All dashboards are publicly visible by default. Once you publish, anyone with the URL can view your dashboard. There is no password protection on the free tier. The row limit per data source is 1 million rows, which does not constrain most small business reporting but will affect large transactional exports. There is no automatic data refresh, so updating a dashboard requires re-publishing manually. Account storage is capped at 10 GB.

For typical business use cases, including monthly sales summaries, regional performance breakdowns, or customer retention trends, Tableau Public handles the job well. The public visibility constraint simply means you should strip out names, emails, or any identifying information before connecting your data.

Step 1: Download and Install Tableau Public

Go to public.tableau.com and click "Download the App." You will be asked for a name and email address. Tableau sends a download link for the Windows or macOS installer.

Installation is straightforward. Run the installer and follow the prompts. No server setup or database driver installation is required for CSV and Excel files. The current version requires macOS 12 (Monterey) or later on Mac, or Windows 10 (64-bit) or later on Windows.

Step 2: Connect to Your Data

When you open Tableau Public for the first time, the start screen shows a "Connect" panel on the left side. For spreadsheet-based business reporting, the two most common options are Microsoft Excel (.xlsx) and text file (.csv). Click your source type, navigate to your file, and click Open.

Tableau will open the Data Source tab where you can preview the first 1,000 rows. Verify that column types are correct here. A column containing dates needs to be recognized as a Date field rather than a String field for time-series charts to work properly. If Tableau misidentifies a column type, click the icon above the column header and change it manually.

Practical tip for messy data: Tableau handles mixed types and inconsistent values poorly at the row level. If a column has some blank cells and some numeric values, Tableau will often classify the entire column as a string. Clean your spreadsheet before connecting: remove rows with blank primary keys, replace empty numeric cells consistently, and ensure date columns use a single format throughout. Fifteen minutes of spreadsheet cleanup prevents hours of chart debugging inside Tableau.

Step 3: Build Your First Chart

Click the orange "Sheet 1" tab at the bottom to open the worksheet view. The left panel shows two groups of fields. Dimensions are categorical fields shown in blue (region, product name, sales rep). Measures are numeric fields shown in green (revenue, quantity, profit).

To build a bar chart of revenue by region:

1. Drag "Region" from the Dimensions list to the Columns shelf.
2. Drag "Revenue" from the Measures list to the Rows shelf.
3. Tableau generates a bar chart automatically.

To sort the bars in descending order, click the sort icon in the toolbar. To change the chart type, open the "Show Me" panel on the right, which shows which visualization types are available based on what you have placed on the shelves.

For a time-series line chart showing monthly trends:

1. Drag your date field to the Columns shelf. Tableau defaults to aggregating by year. Click the date pill on the Columns shelf, hover over "Date Part," and select Month.
2. Drag the measure (for example, "Orders") to the Rows shelf.
3. Tableau draws a line chart showing monthly values.

Step 4: Build a Dashboard

Once you have two or more worksheets, assemble them into a dashboard. Click the "New Dashboard" icon at the bottom of the window, which looks like a rectangle with a plus sign.

Drag individual sheets from the "Sheets" panel on the left onto the dashboard canvas. Sheets snap into a tiled grid layout by default. To switch to a free-form layout where you can position sheets anywhere on the canvas, click "Floating" at the top of the left panel.

To add interactivity that links charts together:

1. Go to Dashboard and select Actions.
2. Click "Add Action" and choose "Filter."
3. Set the source sheet to the chart you want to click and the target sheets to the charts you want filtered.

This turns a static report into an interactive tool. Stakeholders can click a region bar and watch all other charts filter to show only that region, without any code required.

Step 5: Publish and Share

To publish, go to File and select "Save to Tableau Public." You will be prompted to sign in with a free Tableau Public account, which you can create at public.tableau.com if you have not already done so. After sign-in, name the workbook and click publish.

The result is a URL under the public.tableau.com domain. From there you can embed the dashboard in a website or Notion page using the iframe embed code from the Share button, share the direct URL with stakeholders who can interact with the published viz without a Tableau account, or download the viz as an image or PDF from the published view.

To update the dashboard with new data, open the original workbook in Tableau Public desktop, update or replace the data source, and re-publish. Tableau overwrites the existing viz at the same URL.

When Tableau Public Is Not the Right Fit

Data privacy: If your reporting involves individual customer records, employee data, or any information you cannot share publicly, Tableau Public is not the right tool. Alternatives that support private sharing include Tableau Cloud (paid), Metabase (self-hosted and free), and Looker Studio (free with Google Workspace).

Automated data refresh: Tableau Public requires manual re-publish each time data changes. If your dashboards need to stay current without manual work, Looker Studio connected to a live Google Sheets data source handles refresh automatically.

Scale beyond 1 million rows: At this scale, pre-aggregate your data before connecting. Summarize transactions by week or month in Excel or Google Sheets, then connect the aggregated file to Tableau Public instead of the raw transaction log.

For situations where you want to analyze a file with plain English questions rather than building charts manually, VSLZ AI lets you upload a spreadsheet and ask for specific insights directly, which can complement a Tableau Public dashboard built from the same data.

What Data Quality Means in Practice

A 2025 survey of business dashboard users found that 51 percent said their biggest frustration was that dashboards did not let them interact meaningfully with the data, and 37 percent said the insights were not actionable. Both problems often originate in how data was prepared before it reached the visualization layer.

Before connecting any file to Tableau Public:

• Remove duplicate rows from your source data.
• Ensure date columns use a consistent format. YYYY-MM-DD is the most reliable choice.
• Use a single row per record with no merged cells.
• Put column headers in row 1 with no blank rows above them.

Tableau is only as good as the data you feed it. The visualization layer cannot compensate for structural problems in the source file.

Summary

Tableau Public covers the full reporting workflow from data connection to interactive published dashboard at no cost. Its practical limitation for business use is that all published work is publicly accessible. For non-sensitive reports including regional sales performance, product mix analysis, or customer segment trends, it delivers results comparable to paid tools. Download the app, connect your spreadsheet, and a shareable dashboard can be ready within an hour.