Invenias Power BI: User Groups View

This view is optimized to make managing and analyzing user group data more efficient. Simplify the complex process of user data management and analysis by centralizing important group-related user information.

What It Does

Unified Group Information: Consolidate key details of user groups into one unified data set.
- Quickly understand group dynamics and user affiliations within our software.
Distinct User Identification: Each record in this view includes a unique identifier for every user group (ItemId).
- Provides precise tracking and data correlation across various system modules.
Group Name Formatting:Display each user group's formatted name (FileAs).
- Provides clarity and consistency in group identification across the system.

Columns

This view returns the following columns:

Column Name	Column Type	Description	Joins To
ItemIdString	String	A VARCHAR(36) string representation of each user group's unique identifier. Facilitates easy integration with other data sets.	N/A
ItemId	Guid	Unique identifier for each user group. Essential for distinct data tracking and internal system references.	N/A
FileAs	String	Formatted name of the user group. Provides a clear and consistent reference for each group within the system.	N/A

Column Name

Column Type

Description

Joins To

ItemIdString

String

A VARCHAR(36) string representation of each user group's unique identifier.

Facilitates easy integration with other data sets.

N/A

ItemId

Guid

Unique identifier for each user group.

Essential for distinct data tracking and internal system references.

N/A

FileAs

String

Formatted name of the user group.

Provides a clear and consistent reference for each group within the system.

N/A