How to Create a Business Development Dashboard in Tableau

Bringing your business development data into a Tableau dashboard transforms it from a static list of numbers in a spreadsheet or CRM into a dynamic command center. Instead of guessing what’s working, you get a clear, visual story of your activities, pipeline, and results. This guide will walk you through defining the right metrics, prepping your data, and building a versatile business development dashboard in Tableau step-by-step.

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

First Things First: What KPIs Should You Track?

Before you drag a single field onto a worksheet, you need a plan. A great dashboard answers important questions. Start by asking yourself: What do I need to know daily, weekly, and monthly to see if my business development efforts are on track? Your answers will point you to the key performance indicators (KPIs) you need to build around.

While every business is different, most powerful biz dev dashboards track metrics across a few key areas.

Lead and Opportunity Metrics

This is the top of your funnel - the raw material your team works with every day. Tracking these metrics helps you understand the volume, velocity, and quality of new business coming in.

• New Leads/Opportunities Created: The total number of new prospects entering your pipeline over a specific time frame.
• Leads by Source: Where are your leads coming from? (e.g., Organic Search, Paid Social, Events, Referrals). This is critical for knowing which channels deliver real value.
• Lead-to-Opportunity Conversion Rate: What percentage of those new leads are qualified enough to become active opportunities? A low rate here could signal a problem with lead quality or your follow-up process.

Pipeline Health Metrics

Your sales pipeline is the heart of your business development efforts. These KPIs tell you how healthy it is and help you forecast future revenue more accurately.

• Pipeline Value: The total potential dollar amount of all open opportunities in your pipeline. You'll also want to view this by stage.
• Funnel Stage Conversion: What percentage of opportunities move from one stage to the next? Seeing where deals get stuck is the first step to fixing the problem. (e.g., "Discovery" to "Proposal," "Proposal" to "Negotiation").
• Deal Velocity: How long, on average, does it take for a deal to move from creation to close (won or lost)? You can also measure the time spent in each stage.
• Average Deal Size: The average value of a closed-won deal. Tracking this over time tells you if you're successfully moving upmarket or if deal sizes are shrinking.

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

Activity Metrics

These are the input metrics that your business development reps (BDRs) control directly. They provide insight into team effort and efficiency.

• Activities Logged: The raw numbers - calls made, emails sent, meetings booked.
• Activities Per Opportunity: Are your reps putting in enough effort on your most valuable deals?
• Meetings Booked: For most BDR teams, this is the primary goal and a direct measure of their success.

Performance & Outcome Metrics

These are the ultimate output metrics that tell you the final score. They show how activities and pipeline management translate into actual revenue.

• Win Rate: The percentage of all closed opportunities that were won. (Formula: Count of Won Deals / (Count of Won Deals + Count of Lost Deals)).
• Revenue vs. Target: A simple comparison showing closed-won revenue against your team's quota or goal.

You don't need to jam all of these into one view. Choose the ones that align with your immediate goals and build from there. Start simple and add complexity later.

Prepping Your Data for Success

Your dashboard can only be as good as the data powering it. The principle of "garbage in, garbage out" is especially true with data visualization. Most business development data lives in a CRM like Salesforce or HubSpot, though many teams still track efforts in Google Sheets or Excel.

Wherever it lives, you need to clean it up before connecting to Tableau.

• Standardize Fields: Make sure there's consistency in your categorical data. "USA," "United States," and "US" should all be one value. Check for consistent spelling in lead sources and opportunity stages.
• Check Data Types: Tableau is smart, but it's good to confirm that dates are recognized as dates, monetary values as numbers, and geographic location as geographic data types.
• Address Nulls: Decide what to do with missing values. Should an opportunity with no close date be excluded from your velocity calculations, or should it be shown as "open"?

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

Connecting Your Data to Tableau

Tableau makes it easy to connect to various data sources. From the start screen, you can choose to connect to a file (like an Excel or CSV file) or to a server (like Salesforce, Google Analytics, or a SQL database).

Once you connect, Tableau will open the Data Source page. Here, you can preview your data, set data types, create joins if you're bringing in multiple tables (e.g., an activity table and an opportunities table), and perform basic cleanup tasks. Taking a few minutes here will save you hours of frustration later.

Building the Dashboard, One Chart at a Time

Now, let's build the components of our dashboard. The best Tableau dashboards are built worksheet by worksheet, where each sheet is a specific chart or "viz." Then, you'll assemble them all on a final dashboard canvas.

1. Create Your Headline KPIs

Every dashboard needs big, bold numbers at the top that give you the most important takeaways at a glance. Let's create a few KPI cards.

1. Create a new worksheet and name it "Pipeline Value".
2. Drag your opportunity value measure (e.g., [Amount]) over onto the Text mark on the Marks card.
3. Drag your opportunity status dimension (e.g., [Stage]) to the Filters shelf and select only the "Open" or active stages.
4. Format the text to be large, centered, and bold. Right-click the number and select "Format" to change it to currency.
5. Repeat this process for other key KPIs like "New Leads (This Month)," "Win Rate," and "Average Deal Size" on separate worksheets, using the appropriate filters for each.

2. Build a Sales Funnel Chart

A funnel is the iconic visualization for any sales pipeline. It clearly shows the volume of opportunities at each stage.

1. Create a new worksheet called "Sales Funnel."
2. Drag your deal count measure (this could be COUNT([Opportunity ID]) or simply using Number of Records) to the Columns shelf.
3. Drag your opportunity stage dimension (e.g., [Stage]) to the Rows shelf. Tableau will create a horizontal bar chart.
4. Drag the Stage dimension again, but this time hold down Ctrl (or Command on Mac) and drag it to the Color mark on the Marks card. This gives each stage a unique color.
5. To add labels, drag your deal count measure to the Label mark on the Marks card.
6. Finally, sort your stages by dragging them in the right order on the Rows shelf, so they mirror your actual sales process (e.g., Inquiry, Qualifying, Proposal, Negotiation).

3. Create a Leads Over Time Trendline

This line chart helps you spot trends and understand if your lead generation is growing, stalling, or seasonal.

1. Create a new worksheet named "Lead Gen by Source."
2. Drag your lead creation date dimension (e.g., [CreatedDate]) to the Columns shelf. Right-click the pill and select the "Month" level that has a green line next to it (this makes it a continuous axis).
3. Drag your lead count measure (e.g., COUNTD([Lead ID])) to the Rows shelf. You'll now see a single line chart showing total leads over time.
4. To break this down, drag your [Lead Source] dimension to the Color mark. Tableau will automatically create a separate colored line for each lead source, making it easy to see which channels are driving growth.

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

4. Assemble The Dashboard Masterpiece

Once you have a few worksheets built, it's time to bring them all together.

1. Click the New Dashboard icon at the bottom of the screen (it's the one with four little squares).
2. You'll see a list of your worksheets on the left. Simply drag each sheet onto the empty dashboard canvas. By default, they'll be arranged in a tiled layout.
3. Drag your KPI "card" sheets to the top. Arrange the Funnel, Lead Trendline, and any other charts below them in a logical order.
4. Add Interactivity: This is where Tableau shines. Select one of your charts (like the Lead Gen chart) and click the little funnel icon in its top corner that says "Use as Filter." Now, when you click on a lead source line (e.g., "Organic Search"), all the other charts on the dashboard will filter to show data only for that source.

Tips for a More Effective Dashboard

Building the charts is just one part of the process. How you present them is equally important.

• Prioritize and Simplify: Don't try to answer every possible question on one screen. Too much information creates noise. Stick to the metrics that matter most and use filters to allow users to dig deeper. A clean dashboard is an effective dashboard.
• Use Color with Purpose: Use your brand's colors for a professional feel. Otherwise, use intuitive colors: green might represent growth or hitting a goal, while red could highlight areas that need attention. But avoid using red and green together, for accessibility reasons.
• Tell a Story: Organize your visuals logically. Put high-level summaries (your KPIs) at the top, followed by trends, and then more detailed breakdowns. The dashboard should guide the user's eyes from the overview to the specifics.

Final Thoughts

With a well-designed Tableau business development dashboard, you're not just presenting data, you're providing insights. You're giving your team a tool to spot bottlenecks in the sales funnel, identify top-performing channels, and hold everyone accountable for key activities - all in real-time. It moves you from reacting to past performance to proactively shaping future success.

While Tableau offers incredible power and flexibility, we know it can have a steep learning curve and take time to set up. If you're looking for a faster way to get business development insights, we built Graphed for exactly that. It connects to your CRM and other data sources in a few clicks, then allows you to create dashboards using simple, conversational language. Instead of building charts manually, you can just ask, "Show me a dashboard of my sales pipeline by stage and lead source for this quarter," and get an interactive, live dashboard instantly. It's a great way to put the power of analytics directly in the hands of your sales team, without the technical hurdles.