How to Create a Property Management Dashboard in Looker with AI

Juggling spreadsheets for rent rolls, a separate app for maintenance tickets, and accounting software for financials can feel like a full-time job in itself. A centralized property management dashboard is the answer to bringing all your critical data into one place for a clear, real-time view of your portfolio's health. This guide will walk you through the essential metrics to track and how to structure your dashboard in Looker, using AI to speed up the process from hours to minutes.

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 a Centralized Dashboard is a Game-Changer for Property Managers

If you're managing more than a couple of properties, you're likely feeling the pain of scattered data. Did a tenant pay rent this month? You check your bank statement or accounting software. How many open maintenance requests are there for Building C? You log into your property management portal. What was your total repair cost last quarter? You start rooting through emailed invoices or exporting CSVs.

This constant platform-hopping isn't just inefficient, it prevents you from seeing the bigger picture. Are maintenance costs consistently higher at one property? Is tenant turnover increasing across your entire portfolio? Answering these strategic questions is nearly impossible when your data lives in separate silos.

A well-built dashboard consolidates everything into a single source of truth, giving you several key advantages:

• At-a-Glance Portfolio Health: Instead of digging for numbers, you can instantly see your most important metrics like overall occupancy, monthly revenue, and outstanding maintenance issues.
• Real-Time Decision Making: Most PM software updates data daily or hourly. A live dashboard means you’re making decisions based on today’s numbers, not a stale report from last week.
• Early Trend Detection: Visualizing data over time in charts and graphs makes it easy to spot trends you’d otherwise miss, like a slow decline in rent collection rates or a seasonal spike in utility costs.

Planning Your Dashboard: Key Metrics to Track

Before you build anything, you need a clear plan. The most effective dashboards focus on metrics that directly impact your bottom line and operational efficiency. We can group these into three main categories: Financial Performance, Occupancy & Operations, and Maintenance & Tenant Experience.

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

Financial Performance Metrics

These are the numbers that determine the profitability of your investments. Your dashboard should make it easy to see where your money is coming from and where it's going.

• Gross Potential Rent (GPR) vs. Actual Collected Rent: GPR is the total rent you would collect if every unit were occupied and every tenant paid on time. Comparing this to the rent you actually collect immediately highlights losses from vacancies, concessions, or non-payment.
• Rent Collection Rate: A simple but powerful metric calculated as (Actual Rent Collected / Scheduled Rent) x 100%. Tracking this over time can signal issues with specific tenants or economic shifts affecting your portfolio.
• Net Operating Income (NOI): This is the ultimate measure of a property's profitability. The formula is straightforward: Total Revenue - Total Operating Expenses. A dashboard that visualizes NOI per property is invaluable for identifying your best and worst-performing assets.
• Operating Expenses Breakdown: A single "expenses" number isn't very useful. Break it down into categories like repairs & maintenance, utilities, property management fees, taxes, and insurance. A bar chart is perfect for comparing this across different properties.
• Vacancy Loss: The amount of GPR lost due to unoccupied units. Displaying this as a hard dollar amount can be more impactful than just showing a vacancy percentage.

Occupancy & Operational Metrics

These metrics measure how efficiently you are keeping your properties filled and your leasing operations running smoothly.

• Occupancy & Vacancy Rate: The flip sides of the same coin. An occupancy rate is the percentage of your units that are currently occupied. Tracking this trend over time helps with forecasting future income and marketing spend.

**Example KPI Card:** A simple, large number showing "95% Occupancy Rate" with a small indicator showing if it's up or down from last month provides a quick and powerful snapshot.

• Average Lease Duration: Knowing the average term length can help with turnover forecasting. Shorter average leases might mean more frequent turnover costs, even with a high occupancy rate.
• Tenant Turnover Rate: The percentage of tenants who move out over a specific period (usually a year). High turnover is expensive – it means more cleaning, repairs, and marketing costs to find new tenants.
• Time to Fill Vacancies (Average Days on Market): How long does it take you to get a new tenant into a vacant unit? Shaving even a few days off this average can significantly boost your revenue over the course of a year.

Maintenance & Tenant Experience Metrics

Happy tenants stay longer, which reduces turnover costs. Keeping a close eye on maintenance performance is essential for both your budget and tenant morale.

• Number of Open vs. Closed Work Orders: A running tally of maintenance requests helps you gauge your team's workload and responsiveness. If the number of open tickets is growing, it might be a sign you're understaffed.
• Average Time to Resolution: How long does it take from when a tenant submits a request to when the job is marked complete? Faster resolution times lead to happier tenants.
• Maintenance Costs per Property/Unit: This metric helps you spot properties with recurring issues. If one building consistently has higher repair costs, it may be time to investigate the need for capital improvements like a new roof or HVAC system.

Getting Your Data into Looker

Your dashboard is only as good as the data feeding it. Fortunately, most modern property management processes generate a clean data trail. The challenge is just bringing it all together.

Your primary data sources will likely be:

1. Property Management Software (PMS): Tools like AppFolio, Buildium, Yardi, or RentManager are the core of your operations. They hold data on leases, rent payments, tenants, and maintenance. Most offer CSV exports or have direct database access capabilities that can connect to Looker.
2. Accounting Software: For detailed expense tracking, you’ll need to pull data from QuickBooks, Xero, or a similar platform. This is where you’ll categorize expenses like insurance, taxes, and professional fees.
3. Spreadsheets (Google Sheets/Excel): Don't overlook the simple spreadsheet. For smaller portfolios or for tracking metrics not captured in your PMS (like marketing leads), a well-organized Google Sheet is a perfectly valid and easy-to-connect data source for Looker.

Before connecting, ensure your data is clean. This means using consistent naming conventions for properties (e.g., "123 Main St" vs. "123 Main Street"), standardizing date formats, and making sure your expense categories are logical and tidy.

Building Your Dashboard: The Looker Workflow

Looker is an enterprise-grade BI tool, which means it’s incredibly powerful but has a steeper learning curve than simple dashboard apps. Building from scratch typically involves a data analyst or developer.

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 1: Connecting Your Data Source

In Looker, you'll start by establishing a connection to your database, whether it's a dedicated SQL database containing your PMS data or a direct connection to a source like Google BigQuery that houses your Google Sheets data.

Step 2: Modeling Your Data with LookML

This is where Looker's "secret sauce" comes in. Looker uses a language called LookML (Looker Modeling Language) to define your data. It acts as a semantic layer, which is a fancy way of saying it's the "brain" that tells Looker what your data means in plain English.

For example, instead of writing SQL code every time you want to calculate NOI, your data analyst would define it once in the LookML model. Then, anyone on your team can simply select "Net Operating Income" from a dropdown menu, and Looker knows exactly how to calculate it. Here, you would also define relationships between different tables, like linking your rent roll table to your maintenance requests table by using a property_id.

Step 3: Creating "Looks" and Assembling the Dashboard

Once the model is built, creating visualizations is much easier. In Looker, an individual chart or table is called a "Look." You would create several looks for your key metrics:

• A scorecard tile for Occupancy Rate.
• A bar chart for Operating Expenses by Property.
• A line chart for Collected Rent vs. GPR Over Time.
• A table showing details on Open Maintenance Requests.

After creating your "Looks," you simply add them to a new dashboard, arranging them in a logical flow. You can add filters at the top, allowing you to slice the entire dashboard by property, region, or date range.

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

Using AI to Supercharge Your Looker Dashboard

Building a robust LookML model is time-consuming and requires specialized skills. Actually using the completed dashboard to answer follow-up questions often means clicking through menus, applying filters, and hoping you configured the chart correctly. This is where modern AI changes the game.

Traditionally, BI was a reactive process. You build a dashboard, and if you have a new question, you go back to your data analyst, who then goes back to the LookML, adds a new metric, and builds a new Look. This cycle can take days.

The next evolution in business intelligence centers on natural language. Instead of navigating complex interfaces, you simply ask for what you need. AI-powered tools can interpret a question like, "what was my average time to resolve maintenance tickets last quarter, broken down by property?" and instantly generate the correct visualization. This drastically reduces the time from question to insight, allowing you to explore your data at the speed of thought.

This AI-driven approach assists in two key ways:

1. Dashboard Creation: Instead of manually defining every chart, you can describe the entire dashboard you want. You could tell an AI data analyst, "Build me a property management dashboard that shows my top 5 properties by NOI, a monthly trend of occupancy rate in a line chart, and a table of all overdue rent payments." The AI does the heavy lifting of configuring each visualization for you.
2. Data Exploration: Once the dashboard is built, you can continue to ask follow-up questions. You might see a dip in revenue and ask, "Why did revenue drop in July?" The AI can analyze the underlying data and surface potential reasons, like "Vacancy loss at property 'Elm Street Apartments' increased by $5,000 in July."

Final Thoughts

By moving away from siloed spreadsheets and into a centralized dashboard, you transform your data from a simple record into a strategic asset. A well-designed property management dashboard gives you a complete, real-time picture of financial health, operational bottlenecks, and portfolio performance, empowering you to make smarter, data-driven decisions that increase profitability and efficiency.

Building these reports from scratch in complex tools like Looker is a powerful but often slow process reserved for data teams. At Graphed, we created a single platform where you just connect your data sources - like Google Sheets or QuickBooks - and build dashboards just by describing what you want to see. Instead of a long development cycle, you can instantly create and modify reports using natural language, making a live dashboard accessible in seconds, not weeks. It’s the easiest way to get the answers you need and get back to managing your properties.