How to Create a Quarterly Report in Tableau

Creating a quarterly report often means wrestling with spreadsheets, copying and pasting charts into a slide deck, and hoping the numbers are still correct by the time you present them. But with Tableau, you can build an automated, interactive report that not only saves you hours of manual work but also uncovers deeper insights. This guide will walk you through the entire process, step-by-step, from connecting your data to designing a professional dashboard that tells a compelling story about your business performance.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Build Your Quarterly Report in Tableau?

Ditching static slide decks for an interactive Tableau dashboard is a significant upgrade. Traditional reports present a snapshot in time, but a Tableau dashboard is a living tool. You can connect it directly to your data sources, meaning the numbers are always up-to-date. Instead of a flat report that leads to more follow-up questions, you can answer them on the spot by filtering, clicking, and drilling down into the data.

The core benefits include:

• Automation: Set up your report once, and it will automatically refresh as new data comes in. The frantic pre-meeting scramble to update reports becomes a thing of the past.
• Interactivity: Stakeholders can explore the data themselves. They can filter by region, product line, or marketing channel to see what’s most relevant to them, making the report more engaging and valuable for everyone.
• Deeper Analysis: Go beyond surface-level metrics. With features like tooltips, hierarchies, and table calculations, you can easily compare performance quarter-over-quarter, identify trends, and pinpoint the exact drivers of your success or challenges.

Preparing Your Data for Tableau

Before you build a single chart, it’s essential to have your data structured correctly. Tableau works best with "tidy data," where each row represents a single observation and each column represents a variable. For most sales and marketing reports, this means a row might be a single transaction, lead, or website session.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Connecting Your Data Source

Tableau can connect to a wide array of data sources, from simple spreadsheets to complex databases.

1. Open Tableau Desktop and look at the Connect pane on the left.
2. Choose your data type. For this example, let's say your data is in an Excel file. Select Microsoft Excel and locate your file. If it’s in a database like PostgreSQL or a cloud source like Google BigQuery, you'd select that and enter your credentials.
3. Once connected, Tableau will show you the available sheets or tables. Drag the sheet containing your main dataset (e.g., 'Orders') onto the canvas.

The most critical element for a quarterly report is a proper date field. Ensure you have a column with dates (e.g., Order Date, Transaction Date, Lead Created Date) that Tableau correctly recognizes as a date data type (it will have a small calendar icon next to it).

Building Your Quarterly Report, Step-by-Step

With your data connected, you can start building the individual components (worksheets) that will eventually make up your final dashboard.

Step 1: Create Key Performance Indicator (KPI) Cards

KPIs give a high-level summary of performance at a glance. These are often the first thing people look at on a dashboard.

Let's create a KPI for Total Sales:

1. Open a new worksheet and rename it "Total Sales KPI."
2. Drag your primary measure, like Sales, from the Measures pane onto the Text mark on the Marks card.
3. The view will now show the sum of all sales in your dataset. Click the Text mark to format the number. To make it larger and bolder, use the editor.
4. To format the number as currency, right-click the SUM(Sales) pill in the view, choose Format, select Pane, and under Numbers, choose a currency format.

Repeat this process for other key metrics like Profit, Number of Customers (using a COUNTD on Customer ID), or Website Sessions to create separate worksheets for each KPI.

Step 2: Filter by Quarter and Year

To make the report specific to a quarter, you need to create a filter. Tableau makes this incredibly easy.

1. On one of your KPI worksheets (like "Total Sales KPI"), drag your date field (e.g., Order Date) onto the Filters shelf.
2. A dialog box will appear. Select "Range of Dates" for continuous filtering or "Relative Date" if you want something like "This Quarter," but for maximum flexibility, choose "Years" and then "Quarters." Select the specific quarter you want to analyze (e.g., Q2 2024).
3. To make this filter usable by anyone viewing the dashboard, right-click the Order Date pill on the Filters shelf and select Show Filter. A filter control will appear on the right side of your view, allowing users to select the year and quarter.

You can apply this same filter to all your worksheets to ensure every chart reflects the same time period.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Visualize Trends with a Line Chart

KPIs show the total, but a line chart reveals the story within the quarter. A common choice is to view performance by week.

1. Create a new worksheet and name it "Weekly Sales Trend."
2. Drag the Order Date field to the Columns shelf. Right-click the pill and make sure it's set to Week Number (e.g., "WEEK(Order Date)" which looks like "Week 5").
3. Drag your Sales measure to the Rows shelf.
4. Tableau will automatically generate a line chart. Now, drag the same Order Date pill to the Filters shelf and select the same quarter and year you did for the KPIs.

You now have a view of how sales fluctuated week by week throughout your chosen quarter, which is much more informative than a single number.

Step 4: Analyze Quarter-over-Quarter (QoQ) Growth

One of the most valuable insights is understanding how performance compares to the previous period. You can do this with a Table Calculation.

1. Duplicate your "Total Sales KPI" worksheet and rename it "Sales QoQ Growth."
2. Drag your Sales measure onto the Text mark again, so you have two SUM(Sales) pills there.
3. Right-click the second SUM(Sales) pill, choose Quick Table Calculation, and then select Percent Difference.
4. By default, Tableau might calculate this relative to the previous value in the table layout. To specify you want to compare to the prior quarter, right-click the pill again, go to Compute Using > Table (across) and edit the calculation to look back one quarter. An easier method for simple KPIs is a calculated field.

A more robust method is using a calculated field. Create one named "Previous Quarter Sales":

LOOKUP(SUM([Sales]), -1)

Then, create another called "QoQ Sales Growth %":

(SUM([Sales]) - [Previous Quarter Sales]) / [Previous Quarter Sales]

Drag this new field to your view, edit the filter to show the last two quarters, and format it as a percentage. This way, you can show a clear growth metric like "+15.2%". You can even use another calculated field to add an up ▲ or down ▼ arrow for extra visual impact.

Step 5: Break Down Performance with a Bar Chart

To understand what's driving your results, you need to break down your KPIs by different categories. A simple bar chart is perfect for this.

1. Create a new worksheet named "Sales by Category."
2. Drag a dimension, like Product Category, to the Rows shelf.
3. Drag your Sales measure to the Columns shelf. A horizontal bar chart will appear instantly.
4. To add more detail, drag the Sales measure onto the Color icon on the Marks card to create a heat map effect, where darker bars indicate higher sales. You can also drag Sales to the Label icon to display the exact values on the bars.
5. Finally, add your quarter filter to this worksheet as well.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Assembling Your Interactive Dashboard

With all your individual worksheets created, it’s time to bring them together into a professional-looking dashboard.

1. Click the New Dashboard icon at the bottom of the screen (the one with four squares).
2. On the Dashboard pane on the left, you'll see all your worksheets. Drag and drop them onto the dashboard canvas. A good layout is to place the KPIs at the top, the line chart below them, and the categorical bar chart at the bottom.
3. To make the quarter filter control the entire dashboard, select one of the worksheets on the dashboard, click the small dropdown arrow that appears on its top border, and navigate to Filters > Quarter of Order Date. This ensures that when a user selects a quarter, all the charts update simultaneously.
4. Enable interactivity. Select a chart, like the "Sales by Category" bar chart. Click the dropdown arrow on its border and select Use as Filter. Now, when a user clicks on a product category bar, the rest of the dashboard (KPIs, trend line) will filter to show data for just that category. This is what transforms a static report into a powerful analytical tool.

Finish up by giving your dashboard a clear title, adding your company logo, and tidying up the formatting to align with your brand's colors and fonts.

Final Thoughts

By following these steps, you can build a dynamic and insightful quarterly report in Tableau that automates your repetitive tasks and empowers your team to make better, data-driven decisions. This approach moves you beyond just presenting numbers to creating a true tool for exploration and analysis.

While Tableau is an incredibly powerful tool for this, it does come with a learning curve. If your primary goal is to quickly answer business questions with all your data from sources like Google Analytics, Shopify, and various ad platforms, the process can still feel complex. At Graphed we’ve built a solution that lets you skip the technical setup. Instead of dragging and dropping pills, you can just ask in plain English: "Create a dashboard showing my quarterly sales trend and break it down by a product category," and our AI will build it for you in seconds with a live connection to your data.