Skip to content

Perspective XXX

Introduction

In the Sales Perspective, we are analysing the effectiveness of the sales team...

Processes

  1. The Sales Agent signs the DEAL in Sales Force
  2. The basic PROJECT parameters are synced to Business Central
  3. In the weekly collab meeting, the PROJECT is assigned to a Project Manager

  4. etc.

Semantic Model

erDiagram
    FactAmount {
        id TransactionNumber
        eur Amount "signed amount (+/-)"
    }

    DimCalendar {
        date Date
        etc etc
    }

    DimAccount {
        int AccountCode "3402"
        txt AccountName
        txt etc "Add any level of groups, categories, etc."
    }
    DimRealisationType {
        code RealisationTypeCode "R, P"
        txt RealisationTypeName "Realised, Planned"
    }

    DimAccountingType {
        code AccountingTypeCode "AC, AL"
        txt AccountingTypeName "Accounting, Allocation"
    }

    DimDivision {
        code DivisionCode
        txt Divisionname
    }

    DimCompany {
        code CompanyCode
        txt CompanyName
    }





    DimCalendar ||--o{ FactAmount: refs
    DimAccount ||--o{ FactAmount: refs
    DimRealisationType ||--o{ FactAmount: refs
    DimAccountingType ||--o{ FactAmount: ref
    DimDivision ||--o{ FactAmount: ref
    DimCompany ||--o{ FactAmount: ref

KPIs

\[ SalesRate=\frac{\#NewCustomers}{\#Qualifiedleads} \]