• I would add the group id that the employee is in to the dim user table as well. This will allow group counts.

    ----------------------------------------------------