How to Create a Business Development Dashboard in Looker with AI

Creating an effective business development dashboard helps you see beyond day-to-day sales and focus on long-term, strategic growth. It pulls all your partnership, channel, and new market data into one place, telling you what's working and where to double down. This article will walk you through how to define an effective dashboard and build one in Looker using its unique data modeling and AI features.

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 Exactly is a Business Development Dashboard?

While a sales dashboard tracks transactional metrics like deals closed and quota attainment, a business development dashboard measures the health and progress of your strategic growth initiatives. It answers bigger questions about your business's future.

Think of it as the cockpit for your company's expansion strategy. It doesn’t just show revenue, it shows the pipeline of future revenue being built through partnerships, new channels, and market entries. It's less about the performance of individual reps and more about the performance of strategic relationships and initiatives.

A good biz dev dashboard gives you a clear view of metrics related to:

• Partnership Health: Are you sourcing enough new partners? Are your current partners generating leads and revenue?
• New Market Entry: How are your initial efforts performing in a new territory or vertical?
• Channel Performance: Which channels (e.g., resellers, referrals, integrations) are driving the most growth?
• Pipeline Strength: What does your pipeline look like for initiatives that may take months or even years to mature?

Ultimately, it helps you move from reactive decision-making based on last month's sales numbers to proactive planning based on a clear view of your growth engine.

Choosing the Right Metrics for Your Dashboard

Every business is different, but a powerful business development dashboard typically includes metrics across a few key categories. Avoid cluttering your view with vanity metrics and focus on numbers that directly tie to strategic outcomes.

Partnership Pipeline & Sourcing

This section tracks your ability to build and grow your partner ecosystem.

• New Partnerships Sourced: A simple count of potential new partners you've identified and engaged with, filterable by month or quarter.
• Partnership Conversion Rate: The percentage of sourced partners that end up signing a formal agreement. This tells you how effective your outreach and negotiation process is.
• Time to Close New Partnerships: The average number of days it takes to move a potential partner from first contact to signed agreement.
• Active vs. Inactive Partners: A ratio or count showing how many of your signed partners are actively engaged (e.g., submitting leads, co-marketing) vs. dormant.

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

Partner-Driven Performance

Once partners are onboard, you need to measure their impact on the bottom line.

• Partner-Sourced Revenue: The total revenue attributed to leads or deals that came from your partner channel. This is the ultimate measure of success.
• Number of Partner-Referred Leads: A leading indicator of future revenue. Track this to see if your partners are generating a healthy stream of opportunities.
• Lead-to-Deal Conversion Rate (by Partner): This helps you identify your best-performing partners. Who is sending you high-quality leads that actually close?
• Average Deal Size (Partner vs. Direct): Compare the average value of deals coming from partners to those generated by your direct sales team. This can reveal valuable insights about deal quality and partner influence.

Strategic Growth Initiatives

This area focuses on broader growth plays, like entering new territories.

• New Market Penetration: If you've targeted a new geographic region or industry vertical, track your pipeline and revenue growth within that segment.
• Pipeline Coverage from New Channels: For future quarters, how much of your revenue target is covered by the current pipeline from strategic partners?
• Product Attach Rate for Partnerships: If a partnership is centered around a new product or integration, track how often that product is being included in deals.

Step 1: Get Your Data Ready for Looker

Before you build anything, you need a solid data foundation. Looker’s power comes from its centralized modeling layer, LookML, which requires clean and structured data from your source systems. For a business development dashboard, this data will likely come from your CRM (like Salesforce or HubSpot), and potentially spreadsheets holding partner data.

Garbage in, garbage out reigns true. Focus on cleaning up your data at the source:

• Tag Your Sources: Ensure every lead, contact, and deal in your CRM has a clear source property. Create specific "Lead Source" values for each partner or partner channel (e.g., "Partner Referral - Company A," "Reseller - Company B").
• Use Custom Fields: Create CRM fields to track the status of partnerships (e.g., "Identifying," "Negotiating," "Active," "Inactive") and partner types (e.g., "Referral," "Reseller," "Integration").
• Maintain Data Hygiene: Enforce rules for your team. Every deal associated with a partner needs to be correctly tagged. Consistency is your best friend here.

Understanding LookML in Simple Terms

LookML is the heart of Looker. It's a layer of code that sits between your database and your dashboards. In LookML, a data analyst on your team defines all your business logic. For example, they define what "Active Partner Revenue" means once. From that point on, anyone in the company who drags that metric into a report will get the exact same, consistent number.

This prevents the classic problem of the marketing team and the sales team showing up with two different numbers for the same metric. While setting up LookML requires a technical analyst, it’s what makes the dashboards reliable and scalable for everyone else.

Step 2: Build Your Dashboard Visualizations

With a clean data source and a basic LookML model in place, you can start creating the charts (or "Looks," in Looker's terminology) for your dashboard.

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

1. Start From an "Explore"

An "Explore" is a curated starting point for analysis that your data analyst sets up. For a biz dev dashboard, you’ll likely start from an explore built around your CRM data, like "Opportunities" or "Deals." This view contains all the pre-defined dimensions (like Partner Name, Deal Create Date, Region) and measures (like Total Revenue, Lead Count) that you need.

2. Create Your First Visualization (a "Look")

Let's build a simple bar chart showing "Revenue by Partner."

• In your explore, select the required fields. From the "Dimensions" list on the left, you would select Partner Name.
• From the "Measures" list, you would select Sum of Revenue.
• Click "Run" to pull the data.
• Under the "Visualization" tab, select the bar chart icon.
• You can customize labels, colors, and more. Once it's ready, click the gear icon and select "Save" > "As a new Look." Give it a clear name like "YTD Revenue by Partner."

Repeat this process for all your key metrics: a line chart for Partner-Referred Leads over time, a number card for the Partnership Conversion Rate, a table for your top-performing partners, etc.

3. Assemble the Dashboard and Add Filters

Now, it's time to put all the pieces together.

• Create a new Dashboard from the main navigation.
• Click "Add" and select "Add Look" to add the visualizations you've just saved.
• Drag and drop the charts to create a logical flow. A good layout starts with high-level KPIs at the top (e.g., Total Partner Revenue), followed by detailed charts and tables that provide more context.
• Crucially, add dashboard-level filters. At the top of your dashboard, you can add filters for Date Range, Region, Partner Manager, or Partner Tier. This makes your dashboard interactive, allowing anyone on your team to drill down and find the precise answers they need without having to build a new report.

Step 3: Supercharge Your Dashboard with Looker's AI Features

A static dashboard presents what happened. An AI-powered dashboard helps you understand why it happened and what might happen next. Looker offers several features that move your dashboard from a simple report to a proactive analysis tool.

1. Use Forecasting to See What's Coming

In any line chart, Looker allows you to add a forecast with just a few clicks. For a chart tracking "Partner-Referred Leads by Month," you can turn on forecasting to project the lead volume for the next 3, 6, or 12 months based on historical data and seasonality. This is incredibly useful for capacity planning and setting realistic future targets.

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

2. Set Up Proactive Alerts

Instead of checking your dashboard daily for changes, you can have Looker tell you when something needs your attention. You can set up an alert on any visualization. For example, you can create an alert that sends you a Slack notification if:

• Any partner's lead volume drops below a specific threshold.
• A new high-value deal from a partner enters the pipeline.
• Your overall partnership conversion rate falls by more than 10% month-over-month.

3. Ask Questions with Natural Language

The industry is rapidly moving towards "conversational analytics," where users can simply ask questions instead of manually building reports. While it requires developer setup, Looker can provide a rudimentary version of this through Looker Actions that integrate with tools like Slack. This allows users to request saved Looks or basic data points directly from their communication tools, making data more accessible to non-technical team members who live in Slack all day.

Final Thoughts

Building a top-tier business development dashboard in Looker organizes your strategic growth initiatives into a single, reliable source of truth. By focusing on the right metrics, preparing your data carefully, and using AI features for forecasting and alerting, you can turn your dashboard into a proactive tool that predicts trends and flags opportunities.

For many teams, however, the complexity and resource requirements of building a LookML model can be a major hurdle. That’s where new tools built entirely around conversational AI are changing the game. With Graphed , we created a way for marketing and business development teams to get the insights they need without the steep learning curve. After connecting your Salesforce, HubSpot, and other data sources in a few clicks, you can simply ask for what you want in plain English. There’s no need to learn LookML, just ask, "Create a dashboard showing partner-sourced revenue by month for this year" and Graphed builds a live, interactive dashboard for you instantly.