How to Build a Looker Dashboard

Creating a Looker dashboard from scratch can feel like a major project, but it breaks down into a handful of straightforward steps. Once you understand the core concepts, you can build a centralized view of your key metrics to track performance, spot trends, and share insights with your team. This guide will walk you through the entire process, from planning your layout to adding interactive filters.

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 is a Looker Dashboard, Anyway?

In Looker, a dashboard is simply a collection of charts, graphs, and key performance indicators (KPIs) gathered on a single page. Each individual chart or data point on the dashboard is called a "Tile." These tiles are visualizations built from "Explores," which are curated datasets you can use as a starting point for asking questions about your business data.

The main goal of a Looker dashboard is to provide a high-level, at-a-glance view of performance. Instead of digging through multiple reports or spreadsheets, everyone on your team can look at the same source of truth to answer questions like:

• How is our sales pipeline progressing this quarter?
• Which marketing campaigns are driving the most revenue?
• What are our key customer support metrics week-over-week?

A well-built dashboard turns raw data into clear, actionable information, getting everyone aligned and focused on the same goals.

Before You Build: The Essential Prep Work

The single biggest mistake people make with Looker is jumping straight into building charts without a plan. A great dashboard isn’t about displaying every possible metric, it’s about answering specific questions. Taking 15 minutes to plan will save you hours of frustration later on.

1. Define Your Objective (Start with a Question)

What is the one primary question this dashboard needs to answer? A dashboard without a core purpose will quickly become a cluttered collection of "nice-to-have" charts that nobody actually uses.

Your objective should be specific. Instead of a vague goal like "view marketing data," frame it as a question:

• Good: "Which specific channels are driving the most MQLs with the lowest cost-per-acquisition this quarter?"
• Vague: "See marketing performance."
• Good: "What is the average deal velocity, and how does it compare across different sales reps?"
• Vague: "A sales report."

Your primary question will be your north star, guiding every decision about which metrics to include and which to leave out.

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. Understand Your Data & Terminology

Before you can build, you need to know a few basic Looker terms and where to find the data you need. You don't need to be a data scientist, but understanding these concepts is essential:

• Explore: This is a starting point for a query. Your data team sets up different Explores for different types of analysis (e.g., a "Users" Explore, a "Transactions" Explore, or a "Google Analytics" Explore).
• Dimension: These are the "group-by" fields in your data. Think of them as attributes or categories. Examples include Date, Country, Campaign Name, or User Type.
• Measure: These are the numbers you want to calculate or aggregate. They are often mathematical operations on your dimensions. Examples include Count of Users, Sum of Revenue, or Average Order Value.

Take a moment to browse the available Explores in your Looker instance. Click into them and look at the list of dimensions and measures. This will help you understand what data is available for building your dashboard tiles.

3. Sketch a Quick Draft

Grab a piece of paper, a whiteboard, or open a simple diagram tool. Sketch out a rough layout of your ideal dashboard. This quick visual will help you think about information hierarchy.

The most important, high-level number (like "Total Revenue this Quarter") should be clearly visible, often in the top-left corner. Supporting charts that break down that number should be placed logically around it. For instance, after your main revenue KPI, you might have charts showing "Revenue by Channel" or "Revenue Over Time." Your sketch doesn’t have to be pretty, but it will give you a clear roadmap to follow.

Step-by-Step Guide to Building a Looker Dashboard

With your plan in place, you’re ready to start building. We'll go through the process of creating one tile and adding it to a new dashboard. You’ll just repeat these steps for every visualization you want to include.

Step 1: Create Your New Dashboard

First, you need a place for your tiles to live. Navigate to the folder where you want to save your work (like your personal folder or a team folder).

1. Click the New button in the top right.
2. Select Dashboard from the dropdown menu.
3. Give your dashboard a clear and descriptive name, like "Q3 Marketing Performance" or "Daily Sales Velocity Tracker."
4. Click Create Dashboard.

You’ll now have a blank canvas ready for your visualizations.

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 2: Add Your First Tile from an Explore

Your goal is to fill this blank dashboard with tiles. Each tile starts as a question you ask of your data in an Explore.

In your new dashboard, click Add and then choose Visualization. Looker will now prompt you to Choose an Explore. This is where your earlier prep comes in handy. Select the Explore that contains the data for your first chart (e.g., "Sales Records" or "Website Traffic").

Step 3: Build a Query in the Explore View

You are now in the Explore interface. This is mission control for building your chart’s data. Let's build a simple report showing sessions by traffic source.

1. Select Dimensions: In the left-hand pane, find and click the dimension(s) you want to group your data by. For our example, search for "Traffic Source" and click it.
2. Select Measures: Next, find and click the measure(s) you want to calculate. In our case, we'll search for and click "Sessions."
3. Apply Filters: You almost always want to filter your data. The most common filter is a date range. In the "Filters" section, find your date dimension (like "Created Date"), click filter by field, and set a range, such as "is in the last 90 days."
4. Run the Query: Once your dimensions, measures, and filters are set, click the Run button in the top right.

Looker will process your request and display the results in a data table at the bottom of the page.

Step 4: Choose Your Visualization Type

A table of data is great, but a chart is better. Now it’s time to choose how you want to display the data.

1. Near the data table, click on the Visualization tab.
2. Looker will suggest a chart type, but you can click the small chart icons to override it. For our "Sessions by Traffic Source" example, a Bar Chart or a Pie Chart would work well.
3. Click the Edit gear on the right side of the visualization tab to open the settings panel. Here you can tweak colors, axis labels, add value labels, and more to make your chart clear and easy to read.

Step 5: Save Your Visualization to the Dashboard

When your chart looks right, it's time to add it to the dashboard you created in Step 1.

1. Click the gear icon in the top-right corner of the Explore page.
2. Select Save to Dashboard...
3. In the popup, search for and select the name of your dashboard.
4. Give your new tile a clear and descriptive title like "Traffic Sessions by Source (Last 90 Days)." The title should explain exactly what the chart shows.
5. Click Save to Dashboard.

Step 6: Arrange, Resize, and Repeat

Head back to your dashboard (you'll see an alert at the top that a new tile was added). Your chart is now there! From here, you are in "Edit Mode."

• Move Tiles: Click and drag a tile to reposition it.
• Resize Tiles: Click and drag the bottom-right corner of a tile to make it larger or smaller.

Follow your initial sketch to arrange your tiles logically. Now, simply repeat steps 2 through 6 for every chart you planned to include on your dashboard.

Pro Tip: You can also add text tiles to create section headers and buttons to link to other relevant reports or dashboards, helping you add context and organize your layout.

Pro Tips for an Effective Dashboard

Building a dashboard is one thing, but making it truly valuable is another. Here are a few final pointers to take your work to the next level.

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

Add Interactive Filters

Instead of locking every chart to a specific date range, add a dashboard-level filter. This allows anyone viewing the dashboard to change the date range (or filter by rep, product, etc.) and have every tile on the dashboard update at once.

In Edit Mode, click Filters at the top of the dashboard, choose the field you want to filter by (like "Date"), and configure the settings. Map this filter to the appropriate date field in each of your tiles.

Set an Auto-Refresh Schedule

For data that changes frequently (like daily sales or website traffic), you can set the dashboard to automatically refresh its data so you're always looking at the latest numbers. In Edit Mode, go to Settings and set a "Run on load" and "Auto-refresh" schedule, like every 4 hours.

Keep it Clean and Focused

Resist the temptation to add every possible metric. A cluttered dashboard is an ignored dashboard. If a chart doesn’t directly help answer the main question your dashboard addresses, leave it out. Aim for 5-9 key visualizations at most. Use clear, simple titles and focus on making the information easy to digest in under 30 seconds.

Final Thoughts

You now have the framework for building a powerful Looker dashboard. It all boils down to starting with a clear question, building individual tiles from Explores to answer parts of that question, and arranging them in a way that tells a clean, logical story. Master that loop, and you'll be able to create useful, informative dashboards for any part of your business.

While Looker is an incredibly robust tool for data teams, its steep learning curve often slows down marketing and sales professionals who just need quick answers from their own data. If you’re tired of navigating complex BI tools or waiting on an analyst, we built Graphed to simplify the entire process. You can connect sources like Google Analytics, Shopify, and Salesforce in a few clicks and build entire real-time dashboards just by describing what you want to see in plain English - no Explores or chart settings needed. It gives you immediate access to your insights so you can get back to growing your business.