Data Model

erDiagram

    FactSale {
        money Amount
        decimal Units
        money Price

    }


    DimProduct {
        code sku
        string Name
        code Class "time managed, demand managed, zone managed"
        code Area "facade, installation"
        code Group "legacy group"
    }

    DimDate {
        date Date "StandardDateTable"
    }

    DimClient {
        id Id
        code Country
        code Type "EPB, PEB"
    }

    DimTerritory {
        code Territory "NL,BE,LUX,FR, DACH, UK, Export"
    }

    DimSalesRep {
        string Name
        code Team
    }

    FactSale }o--|| DimDate: SalesDate
    FactSale }o--|| DimProduct: Product 
    FactSale }o--|| DimClient: Client
    FactSale }o--|| DimSalesRep: Rep
    FactSale }o--|| DimTerritory: Territory

QUESTION: Is a Sales rep always assigned to a single team?
ANSWER: No, there is one sales rep who is assigned 50%/50% to two teams.

QUESTION: Are Sales Teams unambiguously assigned to a territory?
ANSWER: Yes, except for one case, where an employee is working 50% for one team, and 50% for the other.

QUESTION: Can we attribute a sale to a sales rep, or only to a team?
ANSWER: currently only team.

• Class

  • time managed
  • demand managed
  • zone managed
  • DB foucs
  • DB Energy premium
  • External tow-zone valves for DB Energy comfort plus
  • control motor for tronic rooster

• Country (Installations)

  • NL
  • BE
  • LUX
  • FR
  • Export (= remaining countries)

• Country (Facade)

  • NL
  • BE
  • LUX
  • FR
  • DACH
  • UK
  • Export (= remaining countries)

• Client Type

  • EPB/PEB
  • Architect
  • Installer

This is the CRM category

QUESTION: what is EPB, PEB?
ANSWER: EPB (nl), PEB (fr) → indicator showing how energy-efficient a building is.