How to Create an Executive Dashboard with Looker

Thinking about building an executive dashboard in Looker? It’s a smart move. A well-designed dashboard gives leadership a clear, high-level view of business performance, allowing for faster, more informed decisions. This article will walk you through a practical, step-by-step process for planning and building an executive dashboard that your leadership team will actually use and appreciate.

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 an Executive Dashboard?

Before we jump into the "how," let's quickly align on the "what." An executive dashboard is a reporting tool that displays key performance indicators (KPIs) and critical business metrics in a simple, visual format. Its purpose isn't for deep, granular analysis, it's for providing a quick, at-a-glance health check of the company.

Think of it as the cockpit of an airplane. A pilot doesn't need to see the mechanical schematics of every engine component during flight. They need to see the most critical dials - altitude, speed, and fuel - to understand the situation and make adjustments. Your executive dashboard should serve the same function for your CEO, CFO, and other leaders.

Why Use Looker?

Looker is a powerful choice for this task. Its core strength lies in its LookML data modeling layer, which creates a centralized, single source of truth for your business metrics. This ensures everyone from sales to marketing is looking at the same definition of "revenue" or "customer." This governance is exactly what you need for a dashboard that drives strategic conversations.

Before You Build: Planning is 90% of the Work

Jumping straight into Looker without a plan is the fastest way to build a dashboard that nobody uses. The most effective dashboards are carefully designed around the needs of their audience. Take the time to plan your dashboard before you write a single line of code or drag a single chart.

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. Define Your Audience and Their Core Questions

First, identify who this dashboard is for. The C-suite? A specific VP? Each role has different priorities and cares about different questions. Sit down with the primary stakeholders (or make informed assumptions based on their roles) and figure out what they need to know.

An executive isn't asking, "What was the click-through rate on our latest email campaign?" They're asking bigger questions like:

• Are we on track to hit our quarterly revenue target?
• Is our customer base growing, and how much is it costing us to acquire them?
• How healthy is our sales pipeline for the next three months?
• Are our customers happy and sticking around?

Your dashboard's entire purpose is to answer these high-level questions in seconds.

2. Translate Questions into Key Performance Indicators (KPIs)

Once you have the core business questions, you can map them to specific KPIs. This is where you connect high-level strategy to concrete data points. For example:

• “Are we hitting our revenue target?” → Monthly Recurring Revenue (MRR) Growth, Actual Revenue vs. Forecast
• “Is our customer base growing?” → New Customers per Month, Customer Acquisition Cost (CAC)
• “Is our sales pipeline healthy?” → Total Pipeline Value, Lead-to-Close Conversion Rate, Sales Cycle Length
• "Are our customers sticking around?" → Net Revenue Retention (NRR) Rate, Customer Lifetime Value (LTV), Churn Rate

Resist the urge to include everything. An effective executive dashboard contains only the most essential metrics. Aim for 5-10 KPIs at most. Any more and you risk creating noise instead of clarity.

3. Sketch a Layout

Before you even open Looker, grab a piece of paper or a whiteboard and sketch out how you want the dashboard to look. This simple step saves hours of work later.

Organize the layout logically. Place the most important, top-level KPI (like overall revenue) in the top-left corner, as that's where the eye naturally goes first. Group related metrics together. For instance, put all your sales pipeline metrics in one section and customer retention metrics in another. This visual organization helps tell a clear story.

How to Build the Dashboard in Looker: A Step-by-Step Guide

With your plan in hand, you’re ready to start building. In Looker, dashboards are essentially collections of individual query visualizations called "Tiles" (which are saved reports, known as "Looks"). The process is to build each visualization one by one and then arrange them on a dashboard canvas.

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 1: Create Your First Visualization (a Look)

Every chart on your dashboard begins as a standalone visualization, or a "Look," which you build in Looker's "Explore" interface.

In your Looker project, navigate to an Explore that contains the data you need (e.g., your sales data, marketing data, or web analytics data). Here, you’ll select the dimensions (the "what," like "Date" or "Region") and the measures (the "how much," like "Total Revenue" or "Number of Users") for your first KPI.

For example, to visualize MRR over time, you’d select a time dimension like "Order Month" and a measure like "Sum of MRR."

Step 2: Choose the Right Chart Type for Each KPI

How you display your data is just as important as the data itself. For an executive audience, clarity and simplicity are everything.

• Single Value: Perfect for displaying a single, powerful KPI number. Use this for your most important metrics like "Total Revenue This Quarter" or "Active Customers." You can also show a comparison to a previous period (+15% vs last month) to add critical context.
• Line Chart: The best choice for showing trends over time. Use line charts for KPIs like MRR Growth, Website Traffic, or New Leads per Month.
• Bar or Column Chart: Ideal for comparing values across categories. For example, use a bar chart to show "Revenue by Region" or "Sales Performance by Rep."
• Gauge Chart: Great for showing progress toward a specific goal, like "Percentage of Quarterly Sales Target Achieved."

In the "Visualization" pane of the Explore, select the chart type that best represents your data. Take time to customize it. Give it a clear title, adjust the colors to be intuitive (e.g., green for positive growth, red for negative), and simplify the axes.

Once you are happy with your visualization, click the gear icon in the top right and select "Save" → "As a Look." Give it a memorable name, like "YTD Revenue vs. Goal," and save it to a shared folder.

Repeat this process for each of the 5-10 KPIs you identified during the planning phase, creating a saved "Look" for each one.

Step 3: Assemble Your Dashboard

Now it’s time to bring all your individual Looks together into one cohesive dashboard.

1. Navigate to the folder where you saved your Looks.
2. Click "New" and select "Dashboard."
3. Give your new dashboard a clear name, like "Executive KPI Dashboard."
4. Click "Add Tile" or "Add Look" (this varies slightly by Looker version). A window will appear allowing you to select the Looks you just created.
5. Add a tile for each of your key visualizations.

Once the tiles are on your dashboard, you can drag and drop them to rearrange your layout according to the sketch you made earlier. Resize tiles to give more visual weight to your most important metrics. Remember: big numbers for big KPIs.

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

Step 4: Add Interactive Filters

A static dashboard is good, but an interactive one is even better. Filters allow executives to drill down into the data just enough to answer their own follow-up questions without needing to create a new report.

While in Edit mode on your dashboard, click "Filters" in the toolbar and select "Add Filter." A common and incredibly useful filter is a Date Range filter. This lets a viewer instantly change the dashboard's timeframe from "Last 90 Days" to "This Quarter" or a custom range. Other useful filters could be "Region," "Product Line," or "Sales Team."

When you create a filter, you’ll need to link it to the appropriate field in each dashboard tile that should respond to the filter. For a date filter, you’ll link it to the date field used in each of your Looks.

Final Polish and Best Practices

• Add Context with Text Tiles: Use Looker’s text tiles to add titles for different sections, short explanations of how a KPI is calculated, or commentary on why a certain metric spiked or dropped. Context turns data into a story.
• Set up Scheduled Delivery: The best dashboard is one that's top of mind. Use Looker’s delivery scheduler to automatically email a PDF or a link to the dashboard to your executive team every Monday morning, so they can start their week with a clear picture of the business.
• Get Feedback and Iterate: Your first version won't be your last. Share the dashboard with your stakeholders and ask for their honest feedback. Is it clear? Is anything missing? Use their input to refine and improve the dashboard over time.

Final Thoughts

Building an executive dashboard in Looker is about more than just data visualization, it's about translating your company's performance into a clear, compelling story for a non-technical audience. By focusing on your audience's needs, starting with a solid plan, and choosing simple, effective visualizations, you can create a powerful tool that guides strategic decision-making.

While powerful, tools like Looker often come with a significant learning curve and demand technical expertise to get right. We've experienced firsthand the long hours it can take to wrangle data and build reports. That's why we created a solution where you can connect your data sources - like Google Analytics, Salesforce, and Shopify - and then simply ask for what you need in plain English. With Graphed, you can say "create a dashboard showing MRR growth, new customers, and pipeline value for this quarter," and get a live, interactive dashboard in seconds, not hours.