How to Create an HR Dashboard in Looker with AI

Creating an HR dashboard that actually helps you make better decisions can feel like a huge project, especially in a powerful tool like Looker. It's easy to get lost in data models and custom fields before you’ve even built your first chart. This guide will walk you through exactly how to build a useful HR dashboard in Looker, step-by-step, and explore where AI can turn it from a simple report into a strategic asset.

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, Why Build an HR Dashboard?

In today's competitive landscape, HR is no longer just an administrative function, it's a strategic partner in business growth. But you can't be strategic with gut feelings alone. An HR dashboard moves you from reactive fire-fighting to proactive, data-informed decision-making. It centralizes scattered data from your HRIS, ATS, and payroll systems into a single source of truth.

A well-built dashboard helps you:

• Spot Trends Instantly: Is employee turnover creeping up in a specific department? Are you hiring faster than last quarter? A dashboard makes these trends obvious at a glance.
• Improve the Employee Experience: By tracking metrics like eNPS (Employee Net Promoter Score) and engagement survey results, you can spot issues before they become widespread problems.
• Make a Stronger Business Case: When you can show leadership a chart linking high employee engagement to lower turnover rates, your requests for new wellness programs or training initiatives carry a lot more weight.
• Enhance Diversity and Inclusion: Visualizing metrics on diversity in hiring, promotions, and leadership helps you hold the company accountable to its D&I goals.

Planning Your HR Dashboard: Define Your Goals First

Before you even open Looker, the most critical step is to plan. A dashboard without a clear purpose is just a collection of charts collecting digital dust. Ask yourself: "What questions do we need to answer to improve our people operations?"

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. Identify Your Key Metrics (KPIs)

Your KPIs will be the heart of your dashboard. Don't try to track everything, focus on the metrics that align with your company's strategic goals. Here are some of the most common and valuable HR KPIs to consider:

• Headcount: The total number of employees, often segmented by department, location, or employment type (full-time, part-time, contract).
• Employee Turnover Rate: The rate at which employees are leaving your company. It could be calculated as (Total Separations in Period / Average Headcount in Period) * 100. You'll want to track both voluntary (resignations) and involuntary (terminations).
• Retention Rate: The flip side of turnover - the percentage of employees who remained employed during a specific period.
• Time to Hire: The average number of days between opening a job position and a candidate accepting the offer. This helps measure recruiting efficiency.
• Cost Per Hire: The total cost of recruiting divided by the number of new hires. This includes recruiter salaries, job board fees, background checks, and other expenses.
• Offer Acceptance Rate: The percentage of candidates who accept a job offer. A low rate might indicate issues with compensation, culture, or the interview process.
• Employee Satisfaction (eNPS): Measured through surveys that ask, "On a scale of 0-10, how likely are you to recommend our company as a place to work?"
• Diversity Metrics: Gender, ethnicity, and age distribution across the company, within leadership roles, and for new hires.

2. Know Your Audience

Who will be using this dashboard? The answer determines what you show and how you display it. A dashboard for a CEO should provide a high-level, strategic overview summary. An HR Manager might need a more granular, operational view to track team performance and tactical metrics. Make sure your design serves the daily, weekly, or monthly needs of its primary user.

Getting Your Data Ready in Looker

This is where the behind-the-scenes magic happens. HR data is notoriously siloed - employee records in your HRIS (like BambooHR or Workday), candidate data in your ATS (like Greenhouse), compensation data in your payroll system, and so on. Looker needs a way to bring it all together.

Connecting and Modeling Your Data with LookML

Looker's power comes from its modeling layer, called LookML. It is a language used to define dimensions, aggregates, calculations, and data relationships in your database. Think of it as creating a custom "user manual" for your company's data.

This is probably the most technical part of the setup, and it’s typically handled by a data analyst or developer. Here’s a simplified overview:

1. Connect Sources: Your data team will first connect Looker to the underlying databases or warehouses where your HR data lives. If your data isn't already centralized, it may need to be piped into a central location like BigQuery, Snowflake, or Redshift first.
2. Define the Model: An analyst writes LookML code to define the relationships between your different tables. For example, they'll create a "join" to link your employees table to your departments table.
3. Create "Explores": Within the model, you create user-friendly entry points called "Explores." An HR professional can open an "Employee Data Explore" and see a clean list of fields like "Headcount," "Department," and "Hire Date," without ever needing to know the complexities of the underlying database tables.

This foundational work in LookML ensures that everyone in the company is using the same definitions for key metrics, creating a reliable single source of truth.

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-by-Step: Building Your HR Dashboard in Looker

Once your data is modeled, building the visuals is the fun part. You are no longer dealing with raw data tables, but rather the curated fields available in your Explores.

1. Create Individual Visualizations (Looks)

A "Look" is a single chart or data table you create in Looker’s Explore interface. You'll create several Looks and then assemble them onto your dashboard.

Example 1: Total Headcount KPI

• Navigate to your "Employee" Explore.
• In the fields on the left, find your "Headcount" measure and click it.
• Looker will display the total number. In the Visualization tab, select the "Single Value" chart type.
• Click Save > As a Look and give it a clear name like "Total Headcount KPI."

Example 2: Turnover Rate Over Time Line Chart

• Go to your "Turnover" Explore (or whichever Explore contains this data).
• Select your "Turnover Rate" measure.
• Select a time dimension, like "Separation Date - By Month."
• Choose the "Line" chart type from the Visualization tab. This now shows you the turnover trend.
• Save this visualization as a Look named "Monthly Turnover Rate."

Example 3: New Hires by Department Bar Chart

• Head to your Recruiting/Hires Explore.
• Select your "New Hires Count" or similar measure.
• Now select the "Department" dimension.
• Choose the "Bar" chart visualization to easily compare departments.
• Save it as a Look named "New Hires by Department."

2. Assemble Your Dashboard

With a few Looks saved, it's time to pull them together.

1. Navigate to the folder where you saved your Looks and click New > Dashboard.
2. Give your dashboard a name, like "HR Performance Overview."
3. Add your saved Looks to the dashboard one by one. Dashboards in Looker are composed of "tiles," and you can choose to link a tile to an existing Look or create a new query directly.
4. Drag and drop the tiles to arrange them logically. A common layout places high-level KPIs at the top, followed by more detailed trend charts and tables below.

3. Add Interactive Filters

A static dashboard is useful, but an interactive one is empowering. Filters let users slice and dice the data themselves.

• On the dashboard editing screen, click Filters > Add Filter.
• You can add a filter for "Date Range" to let users see performance for this quarter, last month, or a custom period.
• Add a filter for "Department" or "Location" to allow managers to zero in on their specific teams.
• For each tile, you'll need to specify which field the filter should apply to (e.g., the "Hire Date" field for the Date Range filter).

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

Going Beyond the Basics: Where AI Enhances Your Looker Dashboard

Building the visuals is one thing, but interpreting them and predicting what comes next is another. This is where AI and machine learning features built into modern business intelligence platforms like Looker come into play.

Leveraging tools like Google’s Gemini in Looker, you can move your analysis from descriptive ("what happened?") to predictive ("what will likely happen?") and prescriptive ("what should we do?").

• Forecasting: Many BI tools can apply forecasting algorithms to your time-series data. On your Turnover Rate line chart, for example, you could enable a forecast to predict what turnover might look like in the next three or six months based on historical trends, helping you prepare proactively.
• Anomaly Detection: Instead of you having to manually find spikes or dips, AI-driven alerts can notify you automatically. For instance, Looker could flag that "Time to Hire for the Engineering department increased by 30% last month," prompting an investigation.
• Conversational Analytics: The future of dashboards is asking questions in plain English instead of clicking filters and selecting dimensions. With AI integrations, you can ask questions like, “Show me the hiring trend for our London office this year compared to last year,” and the platform builds the visualization for you on the fly.
• Automated Insights: AI can analyze the components of a report and surface conclusions you might have missed. It might highlight that your highest Offer Acceptance Rates are coming from a specific university or that managers with higher eNPS scores also have the lowest turnover on their teams.

Final Thoughts

Building an actionable HR dashboard in Looker organizes your people data into a powerful engine for strategic insight. By starting with clear goals, carefully preparing your data, and visualizing the KPIs that truly matter, you can transform how your organization manages its most valuable asset: its people.

While Looker is a fantastic tool, its powerful features come with a steep learning curve, especially the initial data modeling in LookML which often requires dedicated data experts. That’s why we created Graphed - to remove that friction completely. With our platform, you can securely connect your HR data sources in seconds and simply describe the dashboard you want in conversational language. We handle the complex connections and chart building, turning hours of technical setup into a real-time report that’s ready in under a minute.