Invenias Power BI: User Information View

This Invenias PowerBI view is designed to provide a complete solution for managing and analyzing user data in our executive search software. It acts as a centralized platform for collecting critical user information, making the process of analyzing and managing user data simpler.

What It Does

  • Unified User Information: This view consolidates key user details into a single, easily accessible set of data.
    • Ideal for gaining insights into user profiles and activities.
  • User and Person Identification: Each record includes unique identifiers for both the User (UserId) and Person (PersonId) columns.
    • Facilitates easy tracking and correlation of data across different system modules.
  • Comprehensive Name Formatting: The view constructs full names by combining various name components (title, first, middle, last names, suffix, maiden name, and nickname) into a single, formatted string.
    • Ensure names are presented in a clear, consistent manner.
  • Contact Details: Access to essential contact information like mobile phone numbers and email addresses is streamlined.
    • Make communication management more efficient.
  • Status Indicators: The view indicates whether a user is disabled (IsDisabled) and whether they have been assigned a specific license (IsLicenseAssigned).
    • A quick reference to the user's current status in the system.
  • Group Affiliation: Each user's group affiliation is provided.
    • Can be used to segment users into different categories or for security and access control purposes.

Columns

This view returns the following columns:

Column Name Column Type Description Joins To
UserId Guid

The unique identifier for each user in the system.

Used to track and manage individual user records.

N/A
PersonId Guid

The unique identifier for each person associated with a user.

Useful for linking users to their personal details.

PeopleView
UserName String

The username for the user account.

This is typically used for login purposes and user identification within the software.

N/A
FullName String A formatted string that combines various name components (like title, first, middle, and last names, suffix, maiden name, and nickname) to display the full name of the person in a standardized format. N/A
FirstName String The first name of the person. N/A
LastName String

The last name or family name of the person.

N/A
MobilePhone String The mobile phone number of the person, crucial for contact purposes. N/A
EmailAddress String

The primary email address of the person.

 N/A
IsDisabled Boolean

Indicates whether the user's account is disabled (1) or active (0).

This is important for managing user access and permissions.

N/A
IsLicenseAssigned Boolean Shows whether a specific license (of type 0) is assigned to the user (1 for assigned, 0 for not assigned). Useful for license management and ensuring compliance. N/A
UserGroupId Guid

The identifier for the user group to which the user belongs.

Can be used to group users, manage permissions, and segment data.

UserGroupsView