Skills & Employee Availability

Interactive case study · synthetic dataset · inspired by an enterprise Power BI solution
DEMO ACCESS
Employee availability & assignments Hover for tooltip · click employee for details
InfoEmployeeRoleAssignmentAvailabilityEntityLocationSkillsDaily cost
Select any employee to inspect project dates, allocation percentages and registered skills.
Selected availability date
Location / employee distribution
Fictional workforce records · map markers update with filters
Assignment distribution
Employee Skills Matrix Employees → Skills · Experience · Proficiency · Costs
Expand a person to explore their skills, experience, proficiency and daily costs. Cost values are only visible in the authorized demo view.
Availability vs Assignment by Service Line Selected date · active filters
AvailabilityAssignment
People availability trends by period
Export information All columns reflect active filters and selected date

Review the synthetic records below, then export the current selection as CSV compatible with Excel.

Costs are omitted entirely from standard-viewer exports. Selecting the authorized cost viewer only simulates a permission check — it is not production RLS.

EmployeeIDEntityGeoOfficeService LineRoleAssignment %Availability %Skills count
Filter context Active filters: 0
All employees, project names, skill records and costs in this demonstration are fictitious. Real Power BI role-based access controls must be enforced server-side, never through HTML or JavaScript. The exact original DAX and SVG implementation is not included.