How to Create a Construction Dashboard in Looker

Building a high-rise or a custom home requires more than just blueprints and materials, it requires a constant stream of information. Unfortunately, for most construction projects, that information is scattered across dozens of spreadsheets, project management tools, and accounting software. This article will guide you through building a centralized construction dashboard in Looker, giving you a single source of truth to monitor project health, track budgets, and make smarter decisions in real-time.

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

Why Build a Construction Dashboard in Looker?

You’re not building a dashboard just for the sake of having nice-looking charts. The goal is to solve real problems. Manually pulling data from Procore, QuickBooks, and a handful of Excel files every Monday morning is slow and error-prone. By the time you’ve built the report for a Tuesday meeting, the data is already out of date.

Using a tool like Looker changes that dynamic entirely. Here’s why it’s a powerful choice for construction analytics:

• Centralized Data: Looker allows you to connect all your disparate data sources - your construction management software (Procore, Autodesk Construction Cloud), accounting system (QuickBooks, Sage), and any supplementary spreadsheets - into one unified view.
• Real-Time Insights: Dashboards in Looker are live. They reflect what’s happening on-site right now, not last week. This empowers you to identify budget overruns or schedule delays as they happen, not after the fact.
• Drill-Down Capabilities: A good dashboard gives you a high-level overview but also lets you dig deeper. You can start with a portfolio view of all your projects and, with a few clicks, drill down into why one specific project is behind schedule and what tasks are causing the delay.
• Enhanced Collaboration: A single, shared dashboard ensures everyone from the project executive to the site foreman is working from the same numbers. You can share access with stakeholders, clients, and finance teams to offer transparent, on-demand project updates.

Planning Your Dashboard: The Step Everyone Skips

The temptation is to jump straight into Looker and start building visualizations. Avoid this at all costs. A powerful dashboard is born from careful planning, not from blindly dragging and dropping charts. A few hours of planning will save you days of rework later.

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

A dashboard that tries to be helpful to everyone ends up being useful to no one. Start by identifying who will be using it and what they need to know. The questions a CEO asks are very different from those a project manager needs answered.

• For Executives or Owners: They need a high-level "bird's-eye view." Their questions are about portfolio health, profitability, and risk.
• For Project Managers (PMs): They need a detailed, tactical view of the projects they’re managing. Their questions are about daily progress and resource management.
• For Clients or Investors: They want simplified updates on progress and key milestones to feel confident in the project's direction.

Answering these questions first helps you focus a dashboard on providing answers, not just showing data.

2. Identify Your Key Performance Indicators (KPIs)

Once you know the questions, you can identify the specific metrics (KPIs) needed to answer them. Here are some of the most common and impactful KPIs for construction dashboards:

Financial Metrics

• Budget vs. Actual Costs: The most fundamental financial KPI. This can be tracked at the project level, by phase, or even by cost code (e.g., labor, materials, subcontractors).
• Cost Variance (CV): The difference between your budgeted cost and your actual cost. A negative variance means you’re over budget.
• Change Order Volume: Total value and number of approved vs. pending change orders. This helps identify scope creep.
• Profit Margin: Tracks the profitability of each project in real-time.

Schedule Metrics

• Schedule Variance (SV): Similar to cost variance, this measures if you are ahead of or behind your planned schedule.
• Milestone Completion Rate: Tracks the percentage of key project milestones completed on time.
• Days Ahead/Behind Schedule: A simple, clear indicator of schedule health.

Safety & Compliance Metrics

• Recordable Incidents Rate: Number of incidents per hours worked.
• Days Since Last Lost-Time Incident: A leading indicator of your safety program's effectiveness.
• Open RFIs or Submittals: Tracks the number of pending Requests for Information or submittals that could cause potential delays.

3. Map Out Your Data Sources

Finally, identify exactly where the data for each KPI lives. This is a critical step before you move into Looker.

• Schedule and task data might be in Procore or Autodesk Construction Cloud.
• Budget and actual cost data might come from QuickBooks, Sage, or another accounting system.
• Daily Reports, change order logs, or safety incidents might be tracked in separate Excel or Google Sheets.

You'll need a way to combine this data. Typically, companies use an ETL (Extract, Transform, Load) tool to pull this data into a central data warehouse like BigQuery, Snowflake, or Redshift. Looker then connects to that warehouse to get a complete view.

Building Your Construction Dashboard in Looker: Step-by-Step

With your plan in place, you can finally start building in Looker. The process revolves around Looker's core strength: LookML, its data modeling layer.

Step 1: Connect to Your Data

First, connect Looker to your data warehouse where you've consolidated your data from Procore, QuickBooks, etc. This involves providing credentials and configuring the connection settings in Looker’s Admin panel.

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: Model Your Data with LookML

This is where Looker differs from other BI tools like Tableau or Power BI. Instead of just connecting to raw tables, you use LookML to create a logical, reusable model of your business data. This ensures consistency and makes it easy for anyone on your team to explore data without needing to be a SQL expert.

You’ll create:

• Views: A view file in LookML corresponds to a data table in your warehouse. You’d have a projects view, a costs view, a schedule_tasks view, etc. Within each view, you define your dimensions and measures.
• Dimensions: These are the fields you use to group or filter your data, like Project Name, Date, or Task Status.
• Measures: These are the calculations or aggregations you perform on your data, like Total Costs (a sum), Average Days Delayed (an average), or Number of Projects (a count).
• Joins: You use "joins" to define the relationships between your views. For example, you would join your projects view and your costs view using a common field like project_id. This is how you are able to analyze 'Cost by Project Name'.

Here’s a simplified LookML snippet for a view that tracks costs:

view: costs { sql_table_name: your_database.financials.actual_costs ,,

dimension: cost_code { type: string sql: ${TABLE}.cost_code_number ,, }

dimension: transaction_date { type: date sql: ${TABLE}.transaction_date ,, }

measure: total_actual_cost { type: sum description: "Sum of all actual costs." sql: ${TABLE}.cost_amount ,, value_format_name: usd_2 } }

This code defines the table, two fields (Cost Code and Date), and one aggregation (Total Cost). You have now taught Looker your business logic, which can be reused across countless charts and reports.

Step 3: Create Explores for Self-Service Analytics

An "Explore" in Looker is a user-friendly starting point for business users to ask questions of the data. You create an Explore by combining the different views you modeled. For example, you can create a "Project Health" Explore that joins together data from your projects, costs, schedules, and safety views. A project manager can then use this Explore to build reports on their own without needing your help.

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: Visualize Your KPIs on a Dashboard

Now for the fun part. Using the Explores you built, you can start creating visualizations ("Looks") and adding them to a dashboard.

1. Navigate to your "Project Health" Explore.
2. In the left-hand panel, select the dimensions and measures you defined in your LookML model (e.g., select 'Project Name', 'Total Actual Cost', and 'Total Budgeted Cost').
3. Run the query and choose a visualization type.

Here are a few visualizations every construction dashboard should have:

• KPI Scorecards: Use single-value visualizations at the top to display your most important, high-level numbers like 'Total Active Projects', 'Overall Cost Variance', and 'Days Since Last Safety Incident'.
• Project Health Table: A table is perfect for looking at all your projects at once. Create columns for 'Project Name', 'Project Manager', 'Percent Complete,' 'Budget,' 'Actual Costs,' and 'Variance'. Use conditional formatting to make variances stand out - red for over budget and green for under.
• Budget vs. Actual by Cost Code (Bar Chart): This chart helps you immediately see where you are spending your money. Seeing that 'Labor' costs are significantly over budget lets you investigate further.
• Schedule Performance Over Time (Line Chart): Plot the 'Days Behind Schedule' over a timeline for a key project. Is it getting worse over time? This trend is crucial for forecasting.

Step 5: Add Interactive Filters

A static dashboard is nothing more than a poster on the wall. Make it interactive by adding dashboard filters. Common filters include:

• Project Manager
• Project Name
• Date Range
• Project Status (e.g., Active, Completed, On Hold)

Filters empower your users to self-serve. A PM can filter the entire dashboard to see only their projects, and an executive can filter by date to review last quarter's performance.

Final Thoughts

Building a construction dashboard in Looker turns your complex project data from a noisy liability into a strategic asset. By taking the time to plan your KPIs, model your data properly in LookML, and craft intuitive visualizations, you can create a single source of truth that keeps everyone aligned and empowers your teams to keep projects on schedule and on budget.

However, the process, especially setting up data pipelines and learning Looker's modeling layer, can feel like a project in itself. We built Graphed because we believe valuable insights shouldn't be locked behind technical barriers. You can connect your data sources like Procore, QuickBooks, and Google Sheets in minutes, then simply ask questions in plain English, like "Show me a comparison of budget vs actual spend across all active projects, visualized as a table." We instantly generate the live, interactive dashboards you need, helping you skip the complex setup and get straight to the answers.