Perspective XXX
Introduction
In the Sales Perspective, we are analysing the effectiveness of the sales team...
Processes
- The Sales Agent signs the DEAL in Sales Force
- The basic PROJECT parameters are synced to Business Central
-
In the weekly collab meeting, the PROJECT is assigned to a Project Manager
-
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}
\]