Employee AnalyticsInteractive prototype for a Power Apps canvas app on SharePoint lists
Sample data

Headcount trend, last 24 months

Headcount by department

Select a bar to see the employees.

Turnover by department, last 12 months

Leavers divided by average headcount. Select a bar to see who left.

Tenure of active employees

Years since hire date. Select a column to see the group.

Every figure on this screen is calculated in the browser from one employee list of 260 fictitious records, the same way the canvas app will calculate them from your SharePoint list. Names and numbers are invented for this demonstration.