Demonstration · Illustrative data · BI Consulting Services · not ZERO TO THREE's real HR data
× BI Consulting Services

One People Analytics board, four ways in — Paylocity, Greenhouse and your spreadsheets in a single view.

Your October 2024 ask was four HR dashboards with different permission levels for different employee groups. This demo answers it with one governed Power BI model and a role switch: Executive, HR, People Manager and Employee each see the panels they are allowed to see — the same numbers, different aperture.

Prepared for Kherissa · Human Resources September 2026 Sources PaylocityGreenhouseSpreadsheets

Headcount & annualised turnover

Month-end active headcount (bars) and rolling-12 annualised voluntary turnover (line)

Paylocity
HeadcountTurnover % (annualised)Hires in month

What this board answers

Three questions your team asked in discovery, each answered by the board

    Org constellation — departments sized by headcount

    Each orbit is a division; circle area = headcount; ring colour = annualised turnover; halo = open requisitions. Hover a department.

    PaylocityGreenhouse
    Turnover under 12%12–18%Over 18%Open req halo

    Departments ranked by headcount

    FTE, headcount and turnover for the selected period

    Paylocity

    Greenhouse hiring funnel & time-to-fill

    Candidates by stage for requisitions opened in the period; median days per stage

    Greenhouse

    Open requisitions by age

    Days since the req was opened in Greenhouse; 45 days is the internal target

    Greenhouse

    PTO balances & utilisation

    Accrued vs used hours; employees carrying more than 120 hours are flagged

    Paylocity

    Position in compensation band

    Share of staff below, within and above their grade band midpoint ±10% — aggregate only

    PaylocityComp bands.xlsx

    Onboarding completion — 30/60/90 day checklist

    New starters in the period and the share who completed each milestone on time

    Onboarding tracker.xlsx

    Workforce profile — tenure & work location

    Aggregate only. No protected-attribute detail is exposed on any role's view.

    Paylocity

    Ask the data

    A natural-language layer over the same governed model — answers cite the panel they came from

    ?Which departments have open reqs older than 45 days?

    Who sees what — the four views on one model

    Row-level security in Power BI: one dataset, one refresh, four permission levels. Highlighted row = the view you are in.

    FullOwn team / own record onlyHidden
    Also from BI Consulting Services

    Private AI on your own server

    The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

    Private AI Servers — slide 1 of 14
    Private AI Servers — slide 2 of 14
    Private AI Servers — slide 3 of 14
    Private AI Servers — slide 4 of 14
    Private AI Servers — slide 5 of 14
    Private AI Servers — slide 6 of 14
    Private AI Servers — slide 7 of 14
    Private AI Servers — slide 8 of 14
    Private AI Servers — slide 9 of 14
    Private AI Servers — slide 10 of 14
    Private AI Servers — slide 11 of 14
    Private AI Servers — slide 12 of 14
    Private AI Servers — slide 13 of 14
    Private AI Servers — slide 14 of 14

    Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min