Building Data Model

Create Data Model

The video below guides you through the steps to create a Data Model and set up Primary Keys for the corresponding datasets.

Set up Primary Keys

A Primary Key is essential for setting up Relationships within each Data Model.

Establish Relationships

The video below walks through the steps to create a Relationship in a Data Model, assuming the Data Model has been created previously.

Define Measures

Measures are created using aggregate functions (such as SUM, COUNT, etc.) that can be calculated from data.

FPT Data Suite supports Basic Measures (like SUM, AVG, MIN, MAX), and users can leverage these in the report-building process.

Additionally, users can create their own custom Measures for different, more complex calculations to meet specific reporting needs.

The video below walks you through the steps to create a Measure and test the newly created Measure.