How to Create a CRM Dashboard in Tableau

Creating a CRM dashboard in Tableau is a powerful way to turn your raw sales data into a clear, actionable story about your business. It allows you to move beyond the limitations of standard CRM reports and build a comprehensive view of your sales pipeline, team performance, and overall revenue health. This guide will walk you through the process step-by-step, from planning your design to building interactive charts.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Move Your CRM Reporting to Tableau?

While CRMs like Salesforce and HubSpot have decent built-in reporting, they often fall short when it comes to deep, customized analysis. Native dashboards are great for quick, surface-level checks, but a dedicated business intelligence tool like Tableau opens up a new level of insight.

Here’s why it’s worth the effort:

• Deeper Customization: Tableau gives you complete creative control over your visualizations. You can build any chart you can imagine, tailored precisely to the questions your team needs to answer, without being constrained by the pre-set widgets in your CRM.
• Unified Data Sources: Your CRM data tells only part of the story. With Tableau, you can pull in data from other platforms - like your marketing automation tool, your financial software, and your website analytics - to create a single, unified view of the entire customer journey.
• Enhanced Interactivity: Tableau dashboards allow users to explore the data dynamically. You can build interactive filters, drill-down capabilities, and click-actions that let your team slice and dice the information on their own, uncovering insights that a static report would miss.
• Better Storytelling: A well-designed dashboard guides the viewer through a narrative. You can structure your dashboards to present high-level KPIs first and then provide more granular detail, creating a logical flow that makes complex data easy to understand.

Step 1: Plan Your CRM Dashboard Before You Build

Jumping directly into Tableau without a plan is a recipe for frustration. A few minutes of planning will save you hours of rebuilding and ensure your final product is actually useful. Before you connect any data, take the time to answer these questions.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Who is the Audience?

A dashboard for a C-suite executive will look very different from one for an individual sales rep. Define who you're building for and what they care about most.

• Sales Executives (VP of Sales, CRO): They need high-level metrics on overall pipeline health, revenue forecasting, team performance against quota, and sales cycle length.
• Sales Managers: They’re focused on team performance, individual rep quotas, deal velocity, and pipeline conversion rates by stage for coaching purposes.
• Sales Reps: They need an operational dashboard showing their personal pipeline status, activities completed, and progress toward their own quota.

What Key Metrics Will You Track?

Once you know your audience, identify the most important metrics (KPIs) to answer their key questions. Avoid the temptation to include every metric possible, focus on the data that drives action.

Common CRM metrics include:

• Sales Performance: Total revenue, number of deals won, average deal size, revenue vs. quota, win/loss rate.
• Pipeline Health: Total pipeline value, number of open deals, deal value by stage, deal velocity (time spent in each stage), and deal age.
• Team Activity: Calls made, emails sent, meetings scheduled, tasks completed, lead response time.
• Forecasting: Forecasted revenue, weighted pipeline value, forecast accuracy.

Sketch a Quick Outline

You don't need to be an artist. Grab a piece of paper or open a simple diagramming tool and sketch out a basic layout for your dashboard. Where will you place your KPI cards? Where will the main pipeline chart go? How will the filters be arranged?

A standard approach is to place high-level KPIs at the top, followed by more detailed trend charts and tables below. This "inverted pyramid" design gives viewers an immediate snapshot of performance and lets them dig deeper if they choose.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Connect Tableau to Your CRM Data

With your plan in place, it’s time to get your data into Tableau. The connection method will depend on which CRM you use.

Connecting to Salesforce

Tableau offers a native connector for Salesforce, which makes the process straightforward.

1. In the Tableau startup screen, under the "Connect" pane on the left, click "To a Server."
2. If you don't see it immediately, click "More..." and select "Salesforce."
3. A new window will appear prompting you to sign in with your Salesforce credentials. Grant Tableau access to your account.
4. Once connected, you can choose from Standard Connections (pre-defined tables for common use cases) or simply drag the tables you need (like Opportunity, Account, and User) onto the canvas to create your data source.

Connecting to HubSpot and Other CRMs

If your CRM doesn’t have a native Tableau connector, you have a few options:

• Export to CSV/Excel: This is the simplest but most-manual method. You can export reports from your CRM and connect Tableau to the saved file. The major drawback is that the data is static, to update your dashboard, you’ll have to repeat the export process every time.
• Use a Data Warehouse: The most robust solution is to pipe your CRM data into a centralized data warehouse (like Snowflake, BigQuery, or Redshift). Tableau can then connect directly to the warehouse for real-time reporting. This requires more engineering effort upfront but is the best practice for organizations with mature data needs.
• Middleware Connectors: Tools like Fivetran or Stitch can automate the process of moving data from your CRM to a warehouse. Alternatively, you could use automation platforms like Zapier or Make.com to push CRM data into Google Sheets, which Tableau can connect to directly for quasi-real-time updates.

Step 3: Build Your Dashboard Visualizations (Worksheets)

Now for the fun part: building the individual charts (which Tableau calls "worksheets"). We’ll create a few essential visuals for a typical sales performance dashboard.

KPI Summary Cards

Every dashboard needs headline numbers at the top. These cards show at-a-glance performance.

1. Open a new worksheet and name it "Total Revenue."
2. Find your revenue metric in the Data pane (often called "Amount" or "Value") and drag it to "Text" on the Marks card.
3. To show revenue for only closed-won deals, find the "Stage" dimension and drag it to the "Filters" card. Select only the "Closed Won" stage.
4. Drag your "Close Date" dimension to the Filters card and set a relative date range, such as "This Quarter."
5. Click on the "Text" box on the Marks card to format the label. You can add text like "Total Revenue" and increase the font size.
6. Duplicate this worksheet to quickly create other KPIs like "Deals Won" (using a Count Distinct on the Opportunity ID) or "Average Deal Size."

Sales Pipeline Funnel or Bar Chart

A bar chart showing the number of deals or total value in each stage of your sales funnel is essential for understanding pipeline health.

1. Create a new worksheet named "Pipeline Stages."
2. Drag your "Opportunity Stage" dimension to the "Columns" shelf.
3. Drag your opportunity count measure (e.g., COUNTD(Opportunity ID)) to the "Rows" shelf.
4. Right-click the "Opportunity Stage" pill in the Columns shelf and select "Sort" to arrange the stages in their logical order (e.g., Prospecting, Qualification, Proposal, etc.).
5. To add more context, drag your revenue measure (e.g., SUM(Amount)) to the "Color" mark. Now, a darker color will indicate a higher total value in that stage. Customize your colors to match your brand.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Performance vs. Quota Chart

Visualizing each rep's performance against their goal is key for sales managers. A bar-in-bar chart or a bullet graph is perfect for this.

1. Create a new worksheet named "Revenue vs. Quota."
2. Drag "Sales Rep Name" to the "Rows" shelf.
3. Drag your revenue (SUM(Amount)) and quota (SUM(Quota)) measures to the "Columns" shelf. You should have two separate bar charts.
4. Right-click the Quota axis and select "Dual Axis." Right-click it again and choose "Synchronize Axis."
5. On the Marks card, you now have controls for both revenue and quota charts. Select the card for Quota, change the chart type to Bar, and increase its size to make it the taller, thicker background bar.
6. Select the card for Revenue. Ensure it is also a bar chart, but make its size smaller so it appears "inside" the quota bar. This creates a clear visual of progress toward a goal.

Step 4: Assemble and Add Interactivity

Once you’ve built your individual worksheets, it’s time to put them together on a dashboard.

1. Click the "New Dashboard" icon at the bottom of the screen (it looks like a grid).
2. On the left, you’ll see the worksheets you just created. Drag and drop them onto the canvas, arranging them according to your plan from Step 1. Use layout containers to keep everything organized.
3. Add a Global Filter: Let’s add a date filter that controls the entire dashboard. Pick any worksheet on your dashboard, click its context menu (the small dropdown arrow), navigate to "Filters", and select your date filter. Now, when you modify that date filter, it will only apply to that one chart. To apply it to all charts, click the filter's context menu and select "Apply to Worksheets > All Using This Data Source."
4. Create a Filter Action: Interactivity is what makes dashboards special. You can set it up so that when you click on a sales rep's name in the "Revenue vs. Quota" chart, the rest of the dashboard filters to show only their data. Go to "Dashboard > Actions... > Add Action > Filter."

Final Thoughts

By connecting your CRM data to Tableau and following these steps, you can create a highly insightful and dynamic sales dashboard. The key is to start with a clear plan, focus on the metrics that matter, and build visualizations that tell a clear story, allowing your team to move from guesswork to data-backed decision-making.

While mastering tools like Tableau provides immense control, we know it can also feel like a steep learning curve that takes hours away from analysis. That’s why we built Graphed. Instead of spending your day clicking, dragging, and formatting, you can connect your Salesforce or HubSpot account and simply ask, "Show me a dashboard of deals won vs. goal by rep this quarter," and have an interactive, real-time dashboard built for you instantly. We automate the busy work of reporting so you can get back to acting on insights.