Lineage

flowchart LR

    SAP[fa:fa-database 1. SAP]


    SAPE[fa:fa-file-excel 2. SAP Export]
    SAPSP[fa:fa-file-excel fa:fa-cloud 3. SAP Sharepoint]
    POT[fa:fa-file-excel fa:fa-cloud 4. Potential]

    DF((fa:fa-stream<br>5. Dataflow))

    DS[fa:fa-star-of-life<br>6. Dataset]



    R1(fa:fa-chart-pie Success Rate)
    R2(fa:fa-chart-pie Sales Rep Profitability)
    R3(fa:fa-chart-pie Sales Opportunities)
    R4(fa:fa-chart-pie Sales Achievements)
    R5(fa:fa-chart-pie Sales Potential)
    R6(fa:fa-chart-pie Internal Sales)

    UG1{{fa:fa-users<br>Sales Reps}}
    UG2{{fa:fa-users<br>Sales Manager}}
    UG3{{fa:fa-users<br>Internal Sales}}


    SAP-->SAPE-->SAPSP-->DF
    POT-->DF

    DF-->DS

    DS-->R1-->UG1
    DS-->R2-->UG2
    DS-->R3-->UG1
    DS-->R4-->UG1
    DS-->R5-->UG1
    DS-->R6-->UG3

    style DF fill:#FFD700,color:#fff
    style DS fill:#FFD700,color:#fff
    style R1 fill:#FFD700,color:#fff
    style R2 fill:#FFD700,color:#fff
    style R3 fill:#FFD700,color:#fff
    style R4 fill:#FFD700,color:#fff
    style R5 fill:#FFD700,color:#fff
    style R6 fill:#FFD700,color:#fff
    style UG1 fill:none,stroke-width:0px
    style UG2 fill:none,stroke-width:0px
    style UG3 fill:none,stroke-width:0px

1. SAP, hosted on prem

2. Excel Export to an Excel file, to a synced OneDrive folder on the SAP server. Nightly.

3. Excel is synced to Sharepoint by OneDrive

4. Potential Excel on Sharepoint/Teams. Manually maintained

5. Dataflow fetching the data from the various sources and ingesting it into dataset

6. Dataset hosting the ADM/Star Schema

7. Reports made available to different users