Executive Overview
Weekly resource allocation across all BUs · data anchored at
Period From
To
BU
BU
Geo
Geo
Team
Team
Employment Type
Search Employee
Weekly hours by Employment Type stacked, planned hours
Hours by Business Unit
Top Customers by planned hours, period total
Bench & under-utilization next 4 weeks
Mockup based on the Allocation Master tab schema in the BSG Allocation Sheet.
Numbers shown are representative — in production this view would refresh from the source sheet
(or its normalized Postgres model) every few minutes.
From
To
BU
BU
Team
Team
Geography
Geography
Status
Monthly trend Billable · Productive · Bench %
Period breakdown hours by category
Employee utilization sorted by utilization % · period total
| Employee | BU | Department | Status | Geo | Hours | Available | Utilization |
|---|
Utilization Heatmap source: Utilization sheet · employee × week · hours logged
From
To
BU
Department
Status
0%
<50%
50–89%
90–110%
>110%
† partial week (month boundary)
Period From
To
BU
Customer
Project
Employee
Type
Hours by Employment Type filtered period total
Top Projects by period hours · filtered
| Employee | BU | Role / Team | Project | Customer | Type | Billing End | Period Hours | Share |
|---|
Hours by Customer external · planned hours, period total
Customer breakdown external
Internal & Other non-billable · planned hours, period total
Internal & Other breakdown
BU
Team
Bench & under-utilization employees below 70% billable capacity
Forecast
FY26-27
Committed · Closed Won · Materialized |
Full year · Current quarter: Q1
Business Center
Monthly Revenue Forecast
DataNimbus Revenue Sheet
Monthly Revenue Detail
Grouped by quarter · Consultants = Revenue ÷ Blended RateAttainments
Revenue & Bookings (ACV) targets vs attainment by entity & quarter
Show:
Geography
Business Center
Monthly Margin Trend
Account & Project Margins
Employee Master source: HC Details · Google Sheet
| Emp Code | Name | Department | Team | Status | Start Date | End Date |
|---|
Customers Master source: Project Master · Google Sheet
| Customer | Total Projects | Active Projects | Geographies |
|---|
Projects Master source: Project Master · Google Sheet
| Project Name | Project ID | Start Date | End Date | Geo | Customer | Active | Project Manager |
|---|