How to Create a Small Business Dashboard in Looker

Building a dashboard in Looker often feels like a task reserved for a dedicated data team with specialized skills. The truth is, it's more accessible for small businesses than it might seem. This guide will walk you through the essential steps to create a powerful, customized business dashboard in Looker, from connecting your data to creating visualizations that tell the story of your performance.

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

First Things First: Why a Central Dashboard Matters

If you're running a small business, your daily routine probably involves jumping between different tabs: Google Analytics for website traffic, Shopify for sales, your ad manager for campaign performance, and QuickBooks for finances. Trying to stitch this information together usually means creating a clunky spreadsheet that's outdated the moment you export the data.

A central dashboard in Looker solves this headache. It provides a single source of truth that helps you:

• Save time and reduce errors: Automating your reporting puts an end to manual data pulling and copy-pasting, freeing up countless hours and minimizing the risk of human error.
• Make faster, data-driven decisions: Instead of making decisions based on old data or gut feelings, you can see what's happening in your business right now.
• Spot trends and opportunities: Visualizing your data makes it easier to identify patterns, like a marketing channel that's suddenly performing well or a product that's losing popularity.
• Align your team: When everyone is looking at the same Key Performance Indicators (KPIs), the entire team can move forward with a unified goal and clear priorities.

Before You Build: Key Questions to Answer

Jumping straight into building charts is tempting, but a little planning goes a long way. The most effective dashboards are focused and deliberate. Before you create a single visualization, take a moment to answer these three questions.

1. What questions are you answering?

A great dashboard isn't just a collection of charts, it's an answer sheet. Start by thinking about the questions you constantly ask yourself about your business. For example:

• Which of my marketing channels (Facebook Ads, Google Ads, SEO) is driving the most revenue for the lowest cost?
• How does our sales performance this quarter compare to last quarter?
• What is our average customer lifetime value, and which products contribute to it the most?
• What's the conversion rate from website visit to purchase?

By defining these questions first, you create a clear roadmap for what your dashboard needs to include.

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. What are your Key Performance Indicators (KPIs)?

Based on your questions, you can now identify the specific metrics that matter most. Avoid the temptation to track everything. A cluttered dashboard is an ignored dashboard. Focus on a handful of KPIs that give you a true pulse of your business health.

Here are some common examples for small businesses:

• Marketing: Website Sessions, Cost Per Acquisition (CPA), Conversion Rate, Return on Ad Spend (ROAS).
• Sales (B2B): New Leads, Deal Conversion Rate, Average Deal Size, Sales Cycle Length.
• E-commerce (B2C): Total Sales, Average Order Value (AOV), Cart Abandonment Rate, Customer Lifetime Value (CLTV).

Choose 5-8 of your most critical metrics. These will form the foundation of your dashboard.

3. Who is the dashboard for?

The information your marketing manager needs is different from what your CEO needs to see. A dashboard designed for a C-level executive might focus on high-level financial summaries like overall revenue, profit margins, and year-over-year growth. A dashboard for a marketing team, on the other hand, should provide more granular details on campaign performance, cost-per-click, and lead quality. Tailor the content and complexity to the end-user.

The Looker Workflow: Understanding the Building Blocks

Looker has its own terminology and structure, which can be intimidating at first. Here's a simple breakdown of the core concepts you'll need to understand to get started.

1. Data Connections and LookML

The first step in Looker is connecting to where your data lives, such as a database like Google BigQuery, Amazon Redshift, or Snowflake. Once connected, Looker uses a modeling layer called LookML. Think of LookML as a central "dictionary" that defines all your business metrics. You or a developer can define 'Total Revenue' once in the LookML model as sum(sale_price). From that point on, anyone in your company who uses the metric 'Total Revenue' is pulling the exact same, consistent calculation. This is Looker's secret sauce - it ensures everyone is using reliable, vetted data, eliminating arguments over whose spreadsheet has the "right" number.

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

2. Explores

Once the LookML model is set up, business users don't have to touch any code. Instead, they interact with the data through Explores. An Explore is a curated starting point for asking questions. For example, a marketing data model might have several Explores like 'Campaign Performance,' 'Website Traffic,' and 'User Engagement.' If you want to build a chart about your Facebook Ads, you'd start in the 'Campaign Performance' Explore.

3. Looks and Dashboards

Building in Looker is a two-step process. First, you create an individual chart or data table within an Explore. Once you save that visualization, it's called a Look. A Dashboard is simply a collection of these Looks, arranged on a single page to provide a comprehensive overview of your business.

Building Your First Dashboard: Step by Step

With the planning and vocabulary out of the way, it's time to start building. Here's a simplified walkthrough of creating a small business dashboard in Looker.

Step 1: Start with an Explore

In the main Looker navigation, click on the "Explore" menu. You'll see a list of available data sources defined by your LookML model. Let's say you want to visualize sales data. You might select an Explore named 'Orders' or 'Sales transaction'.

Step 2: Selecting Your Dimensions and Measures

On the Explore page, you'll see a list of fields on the left, divided into Dimensions and Measures.

• Dimensions are the attributes you use to group or filter your data, like Date, Product Category, or Traffic Source. These are typically blue.
• Measures are the quantifiable metrics you want to calculate, like Total Sales, Number of Orders, or Average Profit. These are typically orange.

To create a report, simply click on the fields you want. For example, to see your total sales for each product category, you would click on the "Product Category" dimension and the "Total Sales" measure. Looker will instantly run a query and display the results as a data table.

Step 3: Choosing Your Visualization

A table of numbers is useful, but a chart is often easier to interpret. Under the "Visualization" tab, you'll find a range of options.

Pro-Tip: Use the right chart for the job.

• Line Chart: Perfect for showing trends over time (e.g., website sessions per day over the last month).
• Bar/Column Chart: Ideal for comparing values across different categories (e.g., sales by sales representative).
• Pie/Donut Chart: Use this to show the parts of a whole (e.g., the percentage of sales coming from different regions). Just be careful not to use it with too many categories, as it can become unreadable.
• Single Value: Excellent for displaying a single, critical KPI at the top of a dashboard for quick scanning (e.g., Total MRR This Quarter).

Clicking on a new visualization type will instantly transform your data table into that chart format.

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: Save Your Look to a Dashboard

Once you're happy with a chart you've created, click the gear icon in the top right and select "Save to Dashboard." A dialog box will appear, allowing you to name your new Look and choose which dashboard to add it to. You can either select an existing dashboard or create a new one on the fly.

Step 5: Arrange, Resize, and Filter Your Dashboard

After you've added a few Looks to your new dashboard, you can enter Edit Mode to customize the layout. Here, you can:

• Drag and drop tiles to reposition them.
• Resize tiles to make more important visualizations larger.
• Add dashboard filters for things like date range, region, or product category. A single filter at the top of the dashboard can update all the relevant tiles at once, making your dashboard fully interactive for anyone who views it.

Repeat steps 1-5 for each question and KPI you identified during the planning phase until your dashboard is complete.

Tips for a Dashboard That Actually Gets Used

Building the dashboard is only half the battle. To make sure it becomes a central part of your team's workflow, follow these best practices.

• Keep it simple: The best dashboards are scannable and intuitive. Stick to a maximum of 8-10 visualizations per dashboard to avoid overwhelming your audience. If you need more detail, consider creating a separate, more granular dashboard for drilling down.
• Tell a story: Arrange your visuals in a logical flow. Put your most important, high-level KPIs in single-value charts at the top. Below that, show the trends that influence those KPIs. At the bottom, provide the most granular tables or charts for deeper context.
• Use clear titles and labels: A chart titled “Revenue Trend” is okay, but “Monthly Revenue vs. Target (Last 12 Months)” is much better. Give every chart a descriptive title so anyone can understand what they're looking at without having to guess.
• Design for clarity: Use your brand colors consistently, but don't overdo it. The goal is to make the dashboard easy to read, not flashy. Use colors intentionally - for example, green for positive growth and red for negative - to give viewers quick visual cues.

Final Thoughts

Creating a Looker dashboard for your small business is an investment of time upfront, but the payoff is enormous. By outlining your goals, understanding Looker's core building blocks, and methodically creating visualizations that answer your key business questions, you can transform disconnected data points into a powerful decision-making engine that drives growth.

While building a dashboard from scratch in a BI tool like Looker provides incredible customization, the setup complexity and learning curve can be a significant hurdle for busy teams. At Graphed, we bypass this challenge completely. We let you connect data sources like Google Analytics, Shopify, and Facebook Ads in seconds and then build dashboards simply by using conversational language. This approach lets you get from raw data to actionable insights in minutes, not weeks.