Sales & Pipeline Planning

004 · Analytical Workspace
Workspace 13 datasets 1 DTPs

Lineage overview

Dataset
Virtual Dataset
Datasource
DTP
External / cross-workspace
data flow direction
flowchart LR classDef dsStyle fill:#eff6ff,stroke:#1d4ed8,color:#1e3a6e classDef dtpStyle fill:#fef3c7,stroke:#d97706,color:#92400e classDef srcStyle fill:#f5f3ff,stroke:#6d28d9,color:#4c1d95 classDef vdsStyle fill:#ecfdf5,stroke:#059669,color:#064e3b classDef extStyle fill:#f1f5f9,stroke:#94a3b8,color:#475569,stroke-dasharray:4 3 DS_004_000001["000001
Historical opportunities and Pipeline"]:::dsStyle DS_004_000002["000002
Data for financial workspace"]:::dsStyle DS_004_000003["000003
Web Traffic Tracker"]:::dsStyle DS_004_000004["000004
Planned Mark. Campaigns"]:::dsStyle DS_004_000005["000005
Enrich w/ Past Marketing Camp."]:::vdsStyle DS_004_000006["000006
Enrich w/ Web Traffic"]:::vdsStyle DS_004_000007["000007
Enrich w/ Planned Marketing Camp."]:::vdsStyle DS_004_000008["000008
Competitors"]:::dsStyle DS_004_000011["000011
Past Mark. Campaigns"]:::dsStyle DS_004_000012["000012
Channel Type Mapping"]:::dsStyle DS_004_000013["000013
Product Item / Product / Portfolio mapping"]:::dsStyle DS_004_000014["000014
Customers Attributes"]:::dsStyle DS_004_000015["000015
Opportunity, basic calcs"]:::vdsStyle DTP_004_000001["000001
Calculations & Data Validation"]:::dtpStyle click DTP_004_000001 href "dtp_004_000001.html" "Open DTP: Calculations & Data Validation" click DS_004_000001 href "dataset_004_000001.html" "Open Dataset: 000001" click DS_004_000002 href "dataset_004_000002.html" "Open Dataset: 000002" click DS_004_000003 href "dataset_004_000003.html" "Open Dataset: 000003" click DS_004_000004 href "dataset_004_000004.html" "Open Dataset: 000004" click DS_004_000005 href "dataset_004_000005.html" "Open Dataset: 000005" click DS_004_000006 href "dataset_004_000006.html" "Open Dataset: 000006" click DS_004_000007 href "dataset_004_000007.html" "Open Dataset: 000007" click DS_004_000008 href "dataset_004_000008.html" "Open Dataset: 000008" click DS_004_000011 href "dataset_004_000011.html" "Open Dataset: 000011" click DS_004_000012 href "dataset_004_000012.html" "Open Dataset: 000012" click DS_004_000013 href "dataset_004_000013.html" "Open Dataset: 000013" click DS_004_000014 href "dataset_004_000014.html" "Open Dataset: 000014" click DS_004_000015 href "dataset_004_000015.html" "Open Dataset: 000015" DS_004_000015 --> DTP_004_000001 DTP_004_000001 --> DS_004_000001 DS_004_000001 --> DTP_004_000001 DTP_004_000001 --> DS_004_000002 DS_004_000006 --> DTP_004_000001 DS_004_000011 --> DTP_004_000001 DTP_004_000001 --> DS_004_000011 DS_004_000005 --> DTP_004_000001 DS_004_000007 --> DTP_004_000001

Datasets 13source
Sources: ows_tabella

CodeDescriptionTypeStatusFieldsWritten by
000001 Historical opportunities and Pipeline Dataset active 87 8 DTPs
000002 Data for financial workspace Dataset active 8 2 DTPs
000003 Web Traffic Tracker Dataset active 6 —
000004 Planned Mark. Campaigns Dataset active 9 —
000005 Enrich w/ Past Marketing Camp. Virtual Dataset active 51 —
000006 Enrich w/ Web Traffic Virtual Dataset active 62 —
000007 Enrich w/ Planned Marketing Camp. Virtual Dataset active 54 —
000008 Competitors Dataset active 5 —
000011 Past Mark. Campaigns Dataset active 4 1 DTP
000012 Channel Type Mapping Dataset active 2 —
000013 Product Item / Product / Portfolio mapping Dataset active 4 —
000014 Customers Attributes Dataset active 4 —
000015 Opportunity, basic calcs Virtual Dataset active 44 —

DTPs 1source
Sources: ows_dtp

CodeDescriptionActivitiesWrites to FWTriggered by
000001 Calculations & Data Validation 11 — no process data

Special Methods 1source
Sources: ows_metodo_speciale

Custom PostgreSQL scripts used as DTP operations.

CodeDescriptionParamsReads fromWrites to
RANDOM_FOREST Calculate Forecast Values using Random Forest model 4 —
000001 Historical opportunities and Pipeline