How to Calculate Burn Rate in Tableau with AI

Calculating your business’s burn rate is the quickest way to understand your financial health and forecast your future. This article walks you through how to calculate, visualize, and analyze your burn rate in Tableau, first using traditional methods and then using its powerful AI features to get answers faster.

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

What is Burn Rate and Why Does It Matter?

Burn rate is the speed at which your company is spending its cash reserves. Understanding it is critical for managing your cash flow, planning for the future, and making strategic decisions. It’s the metric that tells you how long you can operate before you run out of money. There are two main types:

• Gross Burn Rate: This is a simple measure of your total monthly operating expenses. It shows how much money is going out the door each month for things like salaries, rent, marketing, software, and other overhead.
• Net Burn Rate: This is the more insightful figure. It represents the actual amount of money your company is losing each month. It's calculated by subtracting your monthly revenue from your monthly expenses. If your revenue is higher than your expenses, you have a negative net burn, which is another way of saying you're profitable!

For startups and growing businesses, tracking burn rate is non-negotiable. It’s the primary input for calculating your "runway" - the number of months you have left before your cash balance hits zero. This figure dictates hiring plans, determines when you need to fundraise, and signals to investors that you have a firm grip on your company’s financials.

Preparing Your Data for Tableau

Before you even open Tableau, your data needs to be organized. Clean, well-structured data is the foundation of any good analysis. A sloppy dataset will lead to confusing visualizations and incorrect calculations, no matter how powerful your tools are.

At a minimum, you'll need a spreadsheet (like Excel or Google Sheets) with your monthly revenue and expenses. Your accounting software (like QuickBooks or Xero) is the perfect source for this data. Structure your data in a simple, tabular format. Avoid merged cells, fancy headers, or extraneous text.

Here’s a simple structure that works well for this analysis:

• Date: A column showing the month and year (e.g., 2023-01-01, 2023-02-01). Consistency is key.
• Transaction Type: A column to categorize each line item as either "Revenue" or "Expense."
• Category: (Optional but highly recommended) A column to categorize your expenses (e.g., "Salaries," "Marketing," "Software," "Rent"). This will let you drill down later.
• Amount: A column for the dollar value of each transaction.

Example Data Structure:

Step-by-Step: Calculating Burn Rate in Tableau (The Traditional Way)

Once your data is ready, you can import it into Tableau and start building. This traditional method involves creating calculated fields, which gives you complete control over your metrics.

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

1. Connect Your Data

Open Tableau and in the "Connect" pane on the left, select the type of file you're using (e.g., Microsoft Excel or Google Sheets). Navigate to your file and open it. Tableau will display your data in the Data Source tab, allowing you to confirm that everything loaded correctly.

2. Create Calculated Fields

Calculated fields are custom formulas that let you create new metrics from your existing data. We’ll need to create separate fields for your total revenue and total expenses.

Total Monthly Revenue

Go to Analysis > Create Calculated Field. Name it "Monthly Revenue". In the formula box, you'll want to tell Tableau to only sum the amounts that are categorized as "Revenue." Here's the formula:

IF [Transaction Type] = "Revenue" THEN [Amount] ELSE 0 END

This formula checks each row. If the "Transaction Type" is "Revenue," it takes the value from the "Amount" column, otherwise, it returns zero.

Total Monthly Expenses

Follow the same process to create a field for expenses. Name it "Monthly Expenses" and use this formula:

IF [Transaction Type] = "Expense" THEN [Amount] ELSE 0 END

3. Calculate Your Net Burn Rate

Now that you have separate measures for revenue and expenses, you can easily calculate your net burn rate. Create one more calculated field named "Net Burn Rate".

The formula is a simple subtraction of the two fields you just created:

SUM([Monthly Expenses]) - SUM([Monthly Revenue])

This formula gives you the net amount of cash your business is burning (or earning) each month.

4. Visualize Your Burn Rate

With the calculations done, it’s time to build a chart. A line chart is perfect for showing trends over time.

1. Drag the "Date" field from the Data pane onto the Columns shelf. Right-click it and make sure it’s set to "Month" (the one without 'MAY 2015').
2. Drag your new "Net Burn Rate" field onto the Rows shelf.

Tableau will automatically generate a line chart showing your net burn rate for each month. You can now see at a glance how your cash flow is trending. Are you burning more or less money over time?

You can also drag the "Category" field to the Color mark on the Marks card to see a breakdown of your expenses, which can help you identify where most of your cash is going.

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

Leveraging AI in Tableau for a Faster Workflow

The traditional method works great, but it requires you to know how to create calculated fields and understand Tableau’s interface. Tableau’s AI-powered features, like "Ask Data," offer a much faster, more intuitive way to get the same results using plain English.

Using "Ask Data" for Instant Calculations

Ask Data is Tableau’s natural language query feature. Instead of dragging and dropping pills or writing formulas, you can simply type what you want to see.

1. In your Tableau workbook, click the "New Worksheet" icon, but this time select "Ask Data" from the dropdown.
2. A new interface will appear. On the left, select the data source you connected earlier.
3. Now, in the search bar, type a question in simple language. To replicate our manual chart, you could type:

"net burn rate by month"

If Tableau is unfamiliar with "net burn rate," you can be more explicit:

"sum of expenses minus sum of revenue by month as a line chart"

Tableau's natural language processing will interpret your request, automatically create the necessary calculations in the background, choose the best visualization type (in this case, a line chart), and display the result instantly. You just skipped all the steps of creating three different calculated fields.

The real power comes from asking follow-up questions to drill down. You could ask things like:

• "What were the top 3 expense categories last month?"
• "Compare marketing spend to software spend over the last six months."
• "Show me total revenue for Q1."

This conversational approach lowers the barrier to entry, empowering anyone on your team - not just data analysts - to explore financial data and get answers.

Getting Deeper Insights with "Explain Data"

Once you’ve created your burn rate chart (either manually or with Ask Data), you can use another AI feature called "Explain Data" to understand why certain things are happening.

Suppose you see a large spike in your burn rate in a particular month. Instead of manually digging through spreadsheets to find the cause, you can let Tableau AI do the work.

1. Hover over the data point for that month on your line chart and click to select it.
2. An icon (often a lightbulb) will appear in the tooltip. Click it and select "Explain Data."

Tableau will run statistical models in the background to analyze the underlying data and identify potential drivers for that specific data point. It might generate explanations like, "The sum of Amount for this mark is unexpectedly high. The value is unusually high due to a higher than expected amount for the Marketing category." It provides you with immediate, data-backed hypotheses, turning your analysis from reporting the "what" to explaining the "why."

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

Advanced Tip: Calculating Your Runway

Now that you have your monthly burn rate, you can easily calculate your business's runway. Runway is your Current Cash Balance divided by your Average Monthly Net Burn.

To calculate this in Tableau, you'll need two things: your current cash balance (you can add this manually as a parameter) and your average burn rate. You can calculate the average using a window calculation.

Create a new calculated field called "Average Net Burn":

WINDOW_AVG([Net Burn Rate])

Next, create a parameter so you can input your current cash balance. Right-click in the Data pane and select "Create Parameter." Name it "Current Cash," set the data type to Float, and enter your current cash amount as the current value.

Finally, create one last calculated field for "Runway (Months)":

[Current Cash] / [Average Net Burn]

You can then display this "Runway" figure on your dashboard as a standalone KPI number to keep this critical metric top-of-mind.

Final Thoughts

Calculating and monitoring your burn rate is a fundamental practice for any financially responsible business. Tableau provides a robust platform for visualizing this key metric, whether you prefer the manual control of calculated fields or the speed and convenience of its AI-powered features like Ask Data.

Ultimately, a dashboard without friction is one that gets used. While Tableau's tools have made analysis more accessible, we built Graphed to remove even more of the barriers. You can connect sources like QuickBooks, Stripe, and Google ads in a click, then simply ask "show me a dashboard of a burn rate for the last 6 months" and have a real-time, interactive dashboard instantly. We wanted to make it as easy as talking to an analyst, so your entire team can get the financial answers they need to make smarter decisions, without needing to learn a new tool.