How to Create an Employee Dashboard in Looker

Creating an effective employee dashboard is one of the most impactful things a People Operations or HR team can do. Instead of digging through spreadsheets or separate HR systems to answer basic questions about headcount, hiring, and retention, you can get a real-time, consolidated view of your organization's health. This article will walk you through how to create a powerful and insightful employee dashboard using Looker.

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 Employee Dashboard?

An employee dashboard (sometimes called an HR dashboard or people analytics dashboard) is a data visualization tool that centralizes and displays key workforce metrics in one place. It transforms raw data from various HR systems into easy-to-understand charts, graphs, and summary numbers. The goal is to provide leaders, managers, and HR professionals with at-a-glance insights into the company's most valuable asset: its people.

A well-built dashboard lets you answer critical questions instantly:

• What is our current total headcount, and how has it changed over the last year?
• Which departments have the highest employee turnover rates?
• How long does it typically take us to fill a new role?
• Are we meeting our diversity and inclusion goals?
• How is employee performance trending quarter over quarter?

Without a centralized dashboard, answering these questions often involves a frustrating, manual process of exporting CSVs from different platforms, stitching them together in a spreadsheet, and painstakingly creating charts - a process that has to be repeated every time you need an update.

Before You Build: Planning Your Dashboard

Jumping directly into Looker without a plan is a recipe for a confusing and ultimately useless dashboard. Before you create a single chart, take the time to map out your strategy.

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 Audience and Their Questions

Who is this dashboard for? The metrics that a CEO cares about are different from what a departmental manager or an HR business partner needs. Define your audience personas and the specific questions each one wants to answer.

• Executives (CEO, CFO): Concerned with high-level trends and business impact. They need to see overall headcount costs, company-wide turnover rates, and progress against organizational goals.
• HR Leaders: Need to see both high-level trends and operational details. They'll want to track cost-per-hire, time-to-fill, employee engagement scores, and promotion rates.
• Department Heads & Managers: Focused on their specific team. They need to see their team's headcount, open roles, performance ratings, and potential retention risks.

2. Define Your Key Metrics (KPIs)

Once you know who you’re building for, you can decide what to show. Group your metrics into logical categories. Don't try to track everything, focus on the data that drives decisions.

Common Employee Dashboard Metrics:

• Workforce Composition:
• Recruitment & Hiring:
• Engagement & Retention:
• Performance & Growth:

3. Locate Your Data Sources

Where does all this information live? An employee's journey is often spread across multiple systems. List them out so you know what needs to be connected.

• HRIS (Human Resource Information System): Your source of truth for employee records (e.g., Workday, BambooHR, Sapling). This holds data on hire dates, termination dates, departments, job titles, and demographics.
• ATS (Applicant Tracking System): Where your recruitment data lives (e.g., Greenhouse, Lever). This has data on applications, time-to-hire, and offer acceptance.
• Performance Tools: Includes goals and performance ratings (e.g., Lattice, 15Five).
• Spreadsheets: Google Sheets or Excel spreadsheets might be used for historical data, compensation bands, or ad-hoc survey results.

Connecting and Modeling Your Data in Looker

Looker's power comes from its modeling layer, LookML. Before you can build charts, you need to prepare your data so Looker can understand it. This often requires support from a data team, but understanding the concepts is crucial for any builder.

1. Connecting Your Data Sources

First, your employee data needs to reside in a database that Looker can connect to, like BigQuery, Snowflake, or Redshift. Typically, data from your HRIS, ATS, and other systems is piped into this central data warehouse. Your data team will establish the connection between this warehouse and Looker.

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. Modeling with LookML

LookML is the language Looker uses to describe your data's dimensions, measures, and relationships. It’s what gives Looker its "smarts." Instead of writing complex SQL queries every time you want to build a chart, your data team defines the logic once in a LookML model. For example, they can create a "turnover rate" measure that is always calculated the same way, ensuring consistency across every report in your company.

• Views: These correspond to the data tables in your database. You’ll have views for employees, job_openings, performance_reviews, etc.
• Dimensions: These are the fields you use to group or filter your data - the "who, what, where, when." Examples include Department, Hire Date, or Employee Name.
• Measures: These are the numbers you want to calculate - the aggregates like counts, sums, or averages. Examples include Employee Count or Average Tenure in Months.
• Explores: An Explore defines the relationships (or "joins") between different views. For instance, you could join the employees view with the performance_reviews view using an employee_id to analyze performance ratings by department. The Explore becomes your starting point for building reports.

Step-by-Step: Building an Employee Dashboard in Looker

Once your data is modeled, you're ready to start building. The core workflow in Looker involves creating individual visualizations (called "Looks" or "Tiles") from an Explore and then arranging them on a dashboard.

Step 1: Start from an Explore

Navigate to the "Explore" section and choose the employee data Explore your data team has created. This is your blank canvas, where you'll find all the dimensions and measures you need.

Step 2: Create Your First Tile (Example: Headcount by Department)

Let's build a simple bar chart showing the number of employees in each department.

• From the field list on the left, find your Department dimension and click on it.
• Find your Employee Count measure and click on it.
• Click the Run button. Looker will generate a data table with two columns: department name and the employee count for each.
• Under the "Visualization" tab, select the Bar Chart icon. Looker will immediately render the chart.
• Click the gear icon in the top right and select "Save" -> "To an existing dashboard."
• Give your new dashboard a name, like "People Ops Dashboard," and save the tile.

Step 3: Add More Tiles

Repeat the process to build out the other essential visuals for your dashboard. Here are a couple more examples:

Turnover Rate Over Time (Line Chart)

• Dimensions: Select a date field like "Termination Month."
• Measures: Select your pre-defined "Turnover Rate" measure.
• Run the query.
• Visualize: Choose a Line Chart. This is perfect for showing trends over time.
• Save to your People Ops Dashboard.

New Hires This Quarter (Table)

• Dimensions: Employee Name, Department, Hire Date.
• Filters: Set a filter on the "Hire Date" dimension to "is in the past 90 days."
• Run the query.
• Visualize: The default Table visualization is perfect here.
• Save to your People Ops Dashboard.

Step 4: Arrange Your Layout and Add Text Tiles

Once you've added a few tiles, go to your new dashboard. You can drag, drop, and resize the tiles to create a logical layout. A common practice is to place high-level, single-value KPIs (like total headcount and company-wide turnover) at the top, with more detailed breakdowns and charts below.

You can also add text tiles to provide headings for different sections ("Recruitment Snapshot," "Retention Trends") or to add definitions and context for your metrics.

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 5: Add Dashboard Filters for Interactivity

A static dashboard is good, but an interactive one is great. Adding filters allows your users to slice the data themselves. In the dashboard's edit mode, click "Add Filter" and you can link it to fields like Hire Date, Department, or Location. Now, a department head can filter the entire dashboard to see data only relevant to their team.

Best Practices for a Valuable Dashboard

Building the dashboard is just the start. Follow these principles to make it truly effective.

• Tell a Story: Organize your charts logically. Start broad (company-wide metrics) and then drill down into specifics (team-level metrics).
• Use the Right Visualization: Don't default to pie charts for everything. Use line charts for time-series data, bar charts for comparisons, and scorecards for single key numbers.
• Context is King: The number "15% turnover" is meaningless alone. Is that good or bad? Compare it to the previous year or the industry benchmark. Use Looker's comparison features to show period-over-period change.
• Schedule and Share: Use Looker's scheduling feature to send a PDF or a link to the dashboard to key stakeholders automatically every week or month. This keeps people analytics top-of-mind.
• Keep it Simple: Resist the urge to cram every possible metric onto one page. A cluttered dashboard is an ignored dashboard. If needed, create separate, more specialized dashboards for different audiences.

Final Thoughts

Building an employee dashboard in Looker takes planning and a foundational data model, but the payoff is immense. It transforms your people data from a collection of static files into a strategic asset, enabling proactive decision-making that can shape company culture, improve retention, and drive business success.

While Looker is a powerfully robust tool, getting started requires a significant investment in setting up connections and modeling your data with LookML. At Graphed, we use AI to handle all of that complexity for you. Simply connect your HR tools like BambooHR along with other sources like Google Analytics or your CRM, then use plain English to build your dashboard. You can ask for what you need - like, "Show me a chart of voluntary turnover by department last quarter" - and get a live, interactive visualization in seconds, allowing you to focus on the people, not the process.