How to Create a Utilization Report in Tableau with AI
Building a utilization report is a non-negotiable task for any agency, consultancy, or service-based business. It's the key to understanding profitability, team capacity, and project health, all in one place. This guide walks you through building a powerful utilization report in Tableau and shows you how new AI tools can take the manual busywork out of the entire process.
What is a Utilization Report and Why Does it Matter?
At its core, a utilization report measures how much of your team's available time is spent on billable tasks versus non-billable ones. It's a simple concept with a massive impact. A good report answers critical business questions instantly:
- Profitability: Are our projects profitable, or are we sinking too much non-billable time into them?
- Capacity Planning: Is the team overloaded and at risk of burnout? Or are people underutilized with too much time on their hands?
- Forecasting: Can we take on that new client, or do we need to hire?
- Efficiency: Which team members or types of projects are the most efficient?
Without these answers, you're essentially flying blind, making critical decisions based on gut feelings instead of hard data.
Setting the Stage: What Data Do You Need?
Before you even open Tableau, you need the right data. Your report is only as good as the information you feed it. Most of this info lives in your time-tracking software (like Harvest or Toggl), project management tools (like Asana or Jira), or even a well-organized spreadsheet.
Here’s the essential data you’ll want to gather:
- Employee Name: Who performed the work.
- Client/Project: Which project the work was for.
- Task/Description: The specific task performed.
- Date: The day the work happened.
- Hours Logged: The total number of hours for that entry.
- Billable Status: A simple tag to identify if the hours are billable or non-billable.
- Total Available Hours: The total capacity for each employee per week or month (e.g., 40 hours per week). This is often a separate table or spreadsheet you'll join later.
The biggest roadblock for most teams isn't finding the data, it's getting it cleaned up and organized in a way Tableau can understand. This is often a tedious slog of exporting CSV files, fixing date formats, and combining columns in Excel or Google Sheets.
The Classic Method: Building the Utilization Report in Tableau Step-by-Step
Once you have a clean data source, it's time to build your report in Tableau. This process involves connecting your data, creating some essential calculations, and then visualizing the results.
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.
Step 1: Connect to Your Data Source
This is the easy part. Open Tableau, and under the "Connect" panel, choose the appropriate connector for your file type (e.g., Microsoft Excel, Text file for a CSV, or Google Sheets). Select your cleaned-up data file to load it into Tableau.
If your employee capacity numbers are in a separate file, you can add another connection and join the two tables on the 'Employee Name' field.
Step 2: Create the Calculated Fields
Tableau doesn't automatically know what "utilization rate" means. You have to teach it by creating a few calculated fields. These formulas transform your raw data into meaningful metrics.
Navigate to Analysis > Create Calculated Field and create the following:
1. Billable Hours
This calculation isolates only the hours that are marked as billable. The formula is a simple IF statement.
IF [Billable Status] = "Billable"
THEN [Hours Logged]
ELSE 0
END2. Total Capacity Hours
This helps you aggregate employee capacity correctly. If your data shows a weekly capacity, this field helps you calculate the denominator for your utilization rate.
SUM([Total Weekly Available Hours])Note: Your field name might be different. Adjust accordingly!
3. Utilization Rate
This is the star of the show. The formula calculates the percentage of available time that was spent on billable work. A cornerstone KPI for any services company.
SUM([Billable Hours]) / SUM([Total Capacity Hours])After creating this, right-click on the new calculated field in the data pane, go to Default Properties > Number Format, and set it to Percentage so it displays correctly.
Step 3: Visualize Your Data
Now for the fun part: turning these numbers into charts that you can actually understand at a glance. Here are a few essential visualizations for a utilization report dashboard.
Utilization Rate by Employee
This is a classic for seeing who is over- or under-capacity.
- Drag the "Employee Name" dimension onto the Rows shelf.
- Drag your newly created "Utilization Rate" measure onto the Columns shelf.
- Tableau will likely create a horizontal bar chart by default. If not, select it from the 'Show Me' tab.
- Bonus: Drag Utilization Rate again onto the Color mark to create a gradient that makes high/low performers stand out even more.
Billable vs. Non-Billable Hours Breakdown
This helps you see how time is being divided across the entire company or a specific team.
- Drag the "Billable Status" dimension onto the Rows shelf.
- Drag the "Hours Logged" measure onto the Columns shelf.
- Add color by dragging the "Billable Status" dimension onto the Color mark. This will give you a simple, two-bar chart showing the total split.
Over Time Trend Line
Visualize your team's utilization rate over time to spot trends.
- Drag the "Date" field onto the Columns shelf. Right-click it and choose "Month" or "Week" to set the aggregation level.
- Drag the "Utilization Rate" measure onto the Rows shelf.
- Tableau will generate a line chart showing your utilization trends over the selected period.
From here, you can combine these worksheets into a single dashboard, add filters for "Team" or "Client," and create an interactive report for your stakeholders.
Using AI to Dramatically Speed Up the Process
The traditional process works, but anyone who has done it knows the biggest time-sink happens before you even open Tableau. Hours can be spent formatting messy CSV files, merging spreadsheets, and doing manual data prep.
This is where AI radically changes the game. Instead of you doing the grunt work, you can ask an AI to do it for you.
AI For Data Prep That Used to Take Hours
Imagine your time tracking export is a total mess. Dates are in a weird format, names have inconsistencies, and you need to combine several different reports. The old way meant a long and frustrating session in Excel.
The new way? Upload that messy CSV to an AI tool with data analysis capabilities (like ChatGPT with Advanced Data Analysis) and just ask for what you need in plain English:
"Here are three time tracking reports from this quarter. Combine them into a single file. Standardize the 'Date' column to MM/DD/YYYY format, make sure all project names are lowercase, and add a column called 'Billable Status' that is 'Billable' for all tasks except those tagged with 'Internal Meeting' or 'Admin'."
The AI will perform these steps and spit out a perfectly clean file, ready to be dropped right into Tableau. This turns an hour of tedious spreadsheet wrangling into a 30-second prompt.
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.
AI for Instant Pre-Analysis
What if you just need a quick answer without building a full dashboard? AI can get you there faster. You can get initial insights from your dataset before starting the visualization process. For example, instead of filtering and building a table in Tableau to find your best client, you could just ask:
"Based on this data, create a summary table that shows total billable hours and average utilization rate for each client in Q2. Sort it to show the most profitable clients at the top."
This simple act of pre-analysis guides your thinking and helps you focus on what visuals truly matter once you get into Tableau. It shortens the distance from raw data to a useful answer.
Best Practices for Your Utilization Report
Whether you're building it manually or getting a boost from AI, the principles of a good utilization report remain the same.
- Set Realistic Targets: A 100% utilization rate isn't the goal. That means no time for professional development, internal meetings, or even taking a coffee break. Most companies aim for a healthy target of around 70-85%.
- Context is Everything: A low utilization rate isn't always bad, and a high one isn't always good. Provide context. Maybe a senior team member has a low billable rate because they are mentoring junior staff and driving sales - both high-value, non-billable activities.
- Keep it Simple: Don't crowd your dashboard with dozens of charts. Focus on the few key metrics that tell the most important story. Answer the big questions first, then allow users to filter down for more detail.
- Make it Actionable: A report is useless if it doesn't lead to better decisions. Each chart should help a manager decide whether to reallocate resources, pitch a new project, or give an overworked team member a break.
Final Thoughts
Building a Tableau utilization report provides an indispensable view into your business's health, allowing you to optimize staffing, improve project profitability, and grow sustainably. While the traditional process in Tableau is powerful, AI is rapidly removing the biggest bottleneck - the soul-crushing manual data prep - making the entire process faster and more accessible.
Ultimately, a dashboard you build today in standalone software is based on a static data export. At Graphed, we've built the AI-powered reporting workflow we always wished we had. Instead of exporting CSVs or learning complicated software, you can connect your data sources (like your time-tracking and project management tools) directly. Then, you can simply ask for the charts and dashboards you need in plain English, and we build them in seconds. Your dashboards update in real-time, so your data is always current, saving you from the weekly grind of manual report building entirely. You can try Graphed for free to see how quick and easy your analysis can be.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.