Invenias Power BI: People Position History View

The People Position History View is specifically crafted to chart the positional history of individuals. This view provides a record of all positions while deliberately excluding details of the default position which is detailed in the People Default Position view.

What It Does

  • Purpose and Integration: Tailored to track the professional journey of each individual (Person entities), this view seamlessly integrates with both the PeopleView and the PositionsView, offering a comprehensive view of each person's historical and additional current roles without incorporating their default position.
  • Historical Relevance: Presented with a timeline of each individual’s roles, the database is specifically structured to focus on historical data.

Columns

This view returns the following columns:

Column Name

Column Type

Description

Joins To

PositionId

Guid

Unique identifier for historical positions held by a person.

PositionsView

PersonId

Guid

Links to the individual's comprehensive profile.

PeopleView