How do I analyse utilization rate with iDBQuery?

Utilization rate measures how much of your team's available time is spent on billable or productive work. For services firms and agencies it is the core efficiency metric, and iDBQuery computes it straight from timesheets.

• You'd ask iDBQuery: 'Show billable utilization by consultant and by team this month, as billable hours over available hours, against the 75% target.'
• It aggregates your time entries, divides billable by available hours, and returns a chart versus target plus a ranked table.
• Each figure is cited to its source rows, so 'this consultant is at 62%' traces to their actual logged hours.

The useful part is the follow-up: 'Who is consistently under target and on which projects?' or 'How does utilization trend over the last six months?' iDBQuery keeps the thread and drills in. Because time entries, rates, and project data may span a time-tracking tool and a finance system, the one live model joins them so you can extend to revenue: 'What is realised revenue per consultant at these utilization levels?' Save it as a live report for the practice lead, and let the Analyst agent flag people trending toward under- or over-utilization before it becomes a problem, backed by the underlying entries. This pairs with capacity planning and headcount analysis.