How to Create a Weekly Report in Tableau

Building the same weekly report from scratch every Monday is a classic time-sink. You know it's necessary for tracking progress and course-correcting quickly, but the manual process of exporting data, updating charts, and sending it out can drain hours from your week. This guide will show you how to build a dynamic, automated weekly report directly in Tableau, so you can set it up once and get back to making decisions instead of wrangling data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Tableau is Perfect for Weekly Reports

While many people default to spreadsheets for weekly check-ins, Tableau offers significant advantages that save time and surface deeper insights. Its power lies in creating interactive dashboards that are directly connected to your data sources. Instead of a static picture of last week's performance, you get a dynamic view that can be filtered and explored in real-time.

More importantly, Tableau is built for automation. Once your dashboard is complete, you can publish it and set up a refresh schedule. This means every Monday morning, your report updates itself with the latest data and can even be automatically emailed to your team. Forget manual CSV downloads and copy-pasting charts - this is a "set it and forget it" workflow for your reporting needs.

Setting the Stage: Prepping Your Data for Success

Before you open Tableau, the most critical element for any time-based report is your data structure. "Garbage in, garbage out" is especially true here. For a weekly report, your data absolutely must have a clear date column.

• A Consistent Date Field: Check your data source (whether it's an Excel file, a Google Sheet, or a database) and make sure you have a column that contains dates for every record. It could be named Order Date, Transaction Date, Signup Date, or similar.
• Clean and Tidy Data: Ensure your dates are in a consistent format (e.g., MM/DD/YYYY). Inconsistent formatting can cause Tableau to read some dates as text, breaking your time-based analysis. Also, check for blank rows or null values in your key metric columns, as these can skew your results.

A few minutes spent cleaning your source data upfront will save you hours of frustration inside Tableau.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Connecting to Your Data Source

First, let's get your data into Tableau. The process is straightforward and works similarly for various data sources.

1. Open Tableau Desktop.
2. In the Connect pane on the left, choose the type of file or database you want to connect to. For this example, we'll use Microsoft Excel.
3. Navigate to your saved Excel file and click Open.
4. Tableau will take you to the Data Source page. Here, you can see all the sheets in your workbook. Drag the sheet containing your data (e.g., 'Orders') onto the canvas.

You’ll now see a preview of your data's columns and rows. Tableau automatically identifies which fields are Dimensions (descriptive data like text and dates, shown in blue) and which are Measures (numeric data you can aggregate, shown in green). If everything looks correct, click on the "Sheet 1" tab at the bottom to head to the main workspace.

Step 2: Building Your First Weekly View

This is where the magic happens. Let's create a simple line chart to visualize weekly sales over time. This foundational skill will be the building block for your entire dashboard.

Bring in Your Date Field

Drag your date field (e.g., Order Date) from the Dimensions list and drop it onto the Columns shelf at the top of the workspace. By default, Tableau will likely aggregate this by YEAR.

To change this to weeks, right-click the blue YEAR(Order Date) pill in the Columns shelf. In the dropdown menu, find the section for Week Number. You’ll see two options - one is discrete (blue) and one is continuous (green). To create a flowing line chart showing trends over time, you should almost always choose the continuous green option for WEEK(Order Date). This tells Tableau to plot the weeks sequentially along a continuous axis.

Add Your Key Metric

Next, find the metric you want to track, like Sales, in the Measures list. Drag it to the Rows shelf. Just like that, Tableau generates a line chart showing your sales trend by week across the entire dataset.

This is a great start, but it's showing all of your historical data. A weekly report is most useful when it focuses on a recent, relevant time frame.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Filtering for a Rolling Time Period

To make this report automatically show only the last few weeks, we need a dynamic date filter.

1. Drag your Order Date dimension onto the Filters card.
2. A dialog box will appear. Select Relative Date and click Next.
3. In this new dialog, you can set the dynamic time frame. Click the radio button for Weeks.
4. In the next screen, you can choose options like "Last X weeks," "Previous week," or "This week." Let's select Last and enter 12 in the box. This will configure the chart to always show the last 12 weeks of data relative to today.
5. Click OK.

Your chart now updates to show a rolling 12-week view. When you open this report next week, the filter will automatically adjust to show the newest week and drop the oldest one without you having to change a thing.

Step 3: Creating a Dashboard to Tell the Full Story

One line chart is useful, but a real weekly report often needs multiple views to provide context. Perhaps you want to see weekly sales alongside weekly user signups or ad spend. The next step is to combine multiple worksheets into a single, cohesive dashboard.

1. Create another visualization in a new sheet. For example, create a bar chart showing Sales by Product Category for the same time period. To do this, simply create a new worksheet, add the same "Last 12 Weeks" filter, place Sales on the Columns shelf, and Product Category on the Rows shelf.
2. Once you have a couple of worksheets ready, click the New Dashboard icon at the bottom of the screen (it looks like a grid).
3. From the Sheets list on the left, drag your "Weekly Sales Trend" and "Sales by Category" sheets onto the empty dashboard canvas.
4. Arrange and resize them as you see fit.

For an even better user experience, you can make the filters apply to the entire dashboard. Click the dropdown arrow on your date filter on the dashboard view and select Apply to Worksheets > All Using This Data Source. Now, if you change that filter, every chart on your dashboard will update simultaneously.

Step 4: Automating and Sharing Your Report

Building the dashboard is only half the battle. The real goal is to automate the delivery so you never have to manually update it again. This is accomplished using Tableau Cloud or Tableau Server.

Before publishing, make sure your data connection is set up correctly. You have two options:

• Live Connection: This queries your data source directly every time the report is opened. It's great for truly real-time data but can be slow if your data source is large.
• Extract: An extract is a snapshot of your data stored within Tableau. It’s faster to load and is ideal for automation because you can schedule Tableau to refresh the extract from the source at regular intervals (e.g., every morning). We recommend using an extract for most weekly reporting.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Publishing and Setting up a Schedule

1. First, save your Workbook (.twb file).
2. Next, go to Server > Publish Workbook in the top menu.
3. Sign in to your Tableau Cloud or Server account if prompted.
4. Choose a Project to publish to, give your workbook a name, and under Data Sources, click Edit. Ensure Authentication is set correctly, often to "Embedded password," so Tableau can access the data source without you needing to log in. Click Publish.

Once published, you can go to the workbook on Tableau Cloud/Server, navigate to the Data Sources tab of the workbook, click the three dots (...) next to your data connection, and select Refresh Schedule. Here, you can tell Tableau to update the extract daily at 5 AM, ensuring the data is fresh by the time you start your day.

Setting Up Email Subscriptions

The final step is to have the report delivered to your inbox and your team's inboxes automatically. From the published dashboard view, click the Subscribe icon in the top right. You can add users, select your delivery schedule (e.g., Weekly on Monday at 8:00 AM), choose the format (Image, PDF, or Entire workbook), and write a subject line. Now, your weekly report is 100% automated.

Final Thoughts

Creating an automated weekly report in Tableau involves connecting your data, building visualizations using a relative date filter, assembling them into a dashboard, and finally publishing and setting up refresh and subscription schedules. Once done, you've transformed a repetitive manual task into a fully automated workflow that delivers timely insights to your whole team.

While tools like Tableau are incredibly powerful, there's still a learning curve to building, filtering, and automating reports. We created Graphed to remove that complexity entirely. Instead of clicking and dragging pills, you connect your marketing and sales platforms - like Google Analytics, Shopify, or Facebook Ads - and simply ask for what you want in plain English. Want a dashboard comparing last week’s ad spend to revenue? Just ask, and our AI builds the live, interactive dashboard for you in seconds, no technical skills needed.