How to Create an Executive Dashboard in Looker

Building a dashboard that resonates with your executive team requires more than just dropping a few charts onto a page. It’s about distilling complex data into a clear, scannable story that answers their most pressing questions in seconds. This guide will walk you through the entire process of creating an effective executive dashboard in Looker, from defining the right KPIs to designing a layout that delivers instant insights.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Makes an Executive Dashboard Different?

An executive dashboard isn't just a standard report with a prettier layout. It serves a distinct purpose and needs a different approach. While a marketing manager's dashboard might track granular metrics like email open rates or cost-per-click for individual campaigns, an executive dashboard operates at a 30,000-foot view.

Think of it as the cockpit of the business. The pilot doesn't need to see the oil pressure for each individual engine part, they need to know the overall engine status, airspeed, and altitude. Similarly, your C-suite needs to see the highest-level indicators of business health.

Key characteristics include:

• High-Level KPIs: Focus on company-wide Key Performance Indicators (KPIs) that directly map to business objectives, not tactical metrics. For example, instead of "website traffic," show "marketing-sourced sales pipeline."
• Focus on Trends and Goals: Is revenue trending up or down? Are we on track to hit our quarterly sales targets? The dashboard should answer "How are we doing compared to our goals?" at a glance.
• Cross-Departmental View: True executive insight comes from connecting the dots between departments. The dashboard should display how marketing efforts influence sales, how sales performance impacts financial forecasts, and how product usage affects customer retention.
• Instant Scannability: Executives are short on time. They should be able to grasp the state of the business in 30 seconds or less. This means clear visuals, minimal text, and a logical flow of information.

Step 1: Planning Your Dashboard Before You Build

The single biggest mistake people make is jumping straight into Looker and starting building. A successful dashboard is 80% planning and 20% execution. Time spent here will save you hours of rebuilding and ensure your final product actually gets used.

Identify Your Audience and Their Main Question

Before you drag and drop a single chart, ask yourself: Who is this for, and what is the one key question they need answered every time they look at this dashboard? Different executives have different priorities:

• CEO (Chief Executive Officer): What is the overall health and growth trajectory of the business? Main Question: “Are we winning?”
• CFO (Chief Financial Officer): How is our financial performance tracking against forecasts? Are we operating efficiently? Main Question: “Are we profitable and financially stable?”
• CMO (Chief Marketing Officer): Is marketing delivering a positive return on investment (ROI) and building a healthy sales pipeline? Main Question: “Is our marketing investment growing the business?”
• CRO (Chief Revenue Officer): How is the sales team performing against quota, and is the pipeline strong enough to hit future targets? Main Question: “Will we hit our revenue target?”

Focus your entire dashboard around answering that primary question.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Define Your Key Performance Indicators (KPIs)

Based on your audience's main question, select 5-7 core KPIs. Restricting yourself is discipline, more than that, and the dashboard becomes cluttered and loses its high-level focus. Group them by business function (Marketing, Sales, Finance, etc.).

Example KPIs for a SaaS Company's Executive Dashboard:

• Finance: Monthly Recurring Revenue (MRR), Customer Lifetime Value (LTV), Gross Margin.
• Sales: New Bookings vs. Goal, Sales Pipeline Value, Average Deal Size.
• Marketing: Customer Acquisition Cost (CAC), Marketing-Sourced Pipeline, Lead-to-Customer Conversion Rate.
• Product/Customer Success: Churn Rate (Net and Gross), Active Users.

Sketch a Layout

Don't skip this. Grab a whiteboard or a piece of paper and draw a simple wireframe of your dashboard. This low-fidelity mockup helps you think through the data's narrative before you get lost in technical details.

Follow the "inverted pyramid" model used in journalism: the most critical, summary-level information goes at the top. As the user's eye travels down the dashboard, the data can become slightly more granular. Place your most important KPI — usually overall revenue or MRR — in the top-left corner, as that’s where the eye naturally looks first on a screen.

Step 2: Building Your Executive Dashboard in Looker

With a solid plan in place, you’re ready to build inside Looker. Remember, the goal is to implement your vision, not to explore new ideas on the fly.

Create a New Dashboard

This is the easy part. From your Looker homepage or a folder:

1. Click the New button in the top right.
2. Select Dashboard from the dropdown menu.
3. Give your dashboard a clear, descriptive name like "Executive Business Overview" or "C-Suite KPI Dashboard".

You now have a blank canvas to work from.

Add Your Visualizations (Looks and Tiles)

In Looker, dashboards are made up of Tiles. Tiles can be tied to a saved report (a "Look") or built directly as a query from an Explore right within the dashboard editor.

1. On your new dashboard, click Add and select Visualization.
2. Choose your starting point, called an Explore (e.g., "Sales Funnel," "Website Analytics"). Think of this as your data set.
3. In the Explore view, select your metrics. Add Dimensions (attributes, like Date or Region) and Measures (numeric values, like Sum of Revenue or Count of Users).
4. Click Run to see the data.
5. Once you have your data, choose your chart type from the Visualization bar and customize its settings.
6. Give the Tile a name and save it to your dashboard. Repeat this for all the KPIs you planned out.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Choose the Right Visualizations

The type of chart you use matters significantly for scannability. For an executive audience, clarity and simplicity trump complexity every time.

• Scorecards (Single Value): Perfect for your most important, top-line KPIs. Use these at the top of your dashboard to display big numbers like total revenue or new customers this quarter. Add a comparison (e.g., % change vs. previous period) to provide immediate context.
• Line Charts: The best choice for showing a trend over time. Use a line chart to visualize MRR growth, sales pipeline value over the last 12 months, or website sessions.
• Bar/Column Charts: Ideal for comparing a metric across categories. For example, use a column chart to show "Revenue by Region" or a bar chart for "Sales Team Performance vs. Quota".
• Gauges or Progress Bars: Excellent for visualizing progress toward a specific goal. Use a gauge to show how close the sales team is to hitting their quarterly quota.

Cautions for executive dashboards:

Avoid dense data tables and pie charts. Tables require too much reading, and pie charts are notoriously difficult to interpret precisely and become unreadable with more than two or three categories.

Arrange the Layout for Maximum Impact

Now, drag and drop your tiles to match the layout you sketched. Keep your top-line KPIs in Scorecard charts at the very top. Group related metrics together. For example, have a "Marketing" section with tiles for CAC and marketing-sourced deals, and a "Sales" section directly below or beside it. Use Text Tiles to create clear headings for these sections, guiding your audience through the dashboard's story. Keep your layout clean with plenty of white space.

Add Filters for Interactivity

Even though the main view should be high-level, executives might occasionally want to dig a little deeper. Filters give them this ability without cluttering the main view.

Add a dashboard-level filter for the Date Range. This is the most common and useful filter, allowing leaders to view performance for "This Quarter," "Last 90 Days," or "This Year." You can also add filters for things like business region or product line if relevant.

Step 3: Sharing and Automating Your Dashboard

A brilliant dashboard is useless if it's not being seen by the right people at the right time. Looker has powerful features to make sure your insights get delivered automatically.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Set Up Schedules and Alerts

Don't rely on executives to remember to log in and check the dashboard. Send it directly to their inbox.

Use the Schedule delivery feature to email a PDF or a visualization of the dashboard to key stakeholders every Monday morning. This puts critical business data at their fingertips at the start of each week, setting the tone for data-driven conversations.

You can also set up Alerts on specific KPI tiles. For example, create an alert to notify the CFO and CRO via email or Slack if your company's Net Churn Rate for the month goes above a critical threshold. This turns your dashboard into a proactive monitoring system.

Managing Access and Permissions

Use Looker's permission settings to share the dashboard directly with individual users or groups. Make sure your executive team has "Viewer" access so they can interact with filters but can't accidentally edit or delete a tile.

A Final Checklist for Effective Dashboards

Once your dashboard is built, run through this final checklist:

• Is it simple? Could someone understand the general picture in under 30 seconds? Remove anything that doesn't add immediate value.
• Does it tell a story? Does the layout guide the viewer from high-level summaries to supporting trends logically?
• Is there context? Don't just show 1.2M MRR. Compare it to the previous month or the same month last year. A number on its own is meaningless.
• Is the data reliable? Double-check that all the data sources are refreshing correctly and the metrics are calculated properly. Trust is paramount.
• Does it work on mobile? Use a single-column layout so it’s easy to review status on a phone or tablet.

Final Thoughts

Building a valuable executive dashboard in Looker is entirely achievable when you prioritize planning, focus on high-level KPIs, and design for clarity. By shifting your mindset from data presentation to storytelling, you can create a resource that becomes an indispensable part of your leadership team's decision-making process.

Looker is a mighty tool, but getting from raw data to a clear, actionable dashboard often involves a significant learning curve spanning LookML models, Explores, and visualization settings. We built Graphed because we wanted to turn that hours-long process into a simple conversation. With our platform, you just connect your sales and marketing data sources, then build powerful, real-time dashboards by describing what you need in plain English. No complex configurations or steep learning curves - just instant answers to your most important business questions.