In Peliqan you can model your data as you like, for example by using the Star schema data model.

Below is a simple example where we build one fact table and a few dimension tables, based on tables from a CRM called “Teamleader”.

Thee below queries can be created as Views in the data warehouse, to make them visible by your BI tool. See Query Settings > Create as view.

Or you can “Materialize” these queries into a physical table in the data warehouse, using Query Settings > Replicate. More info:

Materialize & Replicate

Dimension table “customer”: dim_customer

The source table is the table “companies”, created by the ELT pipeline:

SELECT
  id AS customer_id,
  name,
  address
FROM teamleader.companies

Dimension table “status”: dim_status

The source is column “status” from the table “deals”, created by the ELT pipeline:

SELECT
  ROW_NUMBER() OVER () AS status_id,  -- Create an ID for each status
  status
FROM (
  SELECT DISTINCT
    status
  FROM teamleader.deals
  ORDER BY
    status
) AS t

Fact table “deals”: fct_deals

The fact table is created based on the source table “deals” from the ELT pipeline, combined with the id’s from the dimension tables, which are added as FK: