Solution Overview

TODO

Background

We have built the following:

• A DWH in Azure SQL

• A set of Power BI reports

Data Sources

System	Version	Access	Refresh	Other Remarks
BC	23 on prem	AF	daily

Data Lineage

graph LR


   BC[fa:fa-cloud BC]
   DWH((fa:fa-database DWH))
   SM((fa:fa-star-of-life vdm BC_Dataset))
   R1(fa:fa-star-of-life MTD Report)
   R2(fa:fa-file-text-o Open Bedragen )
   R3(fa:fa-file-text-o Rental Report)
   R4(fa:fa-file-text-o Sales-Origineel)

   BC --> DWH --> SM --> R1
   SM --> R2
   SM --> R3
   SM --> R4

   style DWH fill:#007fff
   style BC fill:#55a8c3,color:#fff
   style SM fill:#FFD700,color:#000
   style R1 fill:#FFD700,color:#000
   style R2 fill:#FFD700,color:#000
   style R3 fill:#FFD700,color:#000
   style R4 fill:#FFD700,color:#000

Perspectives

Perspective	Type	KPQ
Finance		NA

Entities

Entity	System	Description	Count
SALES_INVOICES	bc		850k lines
SALES_ORDERS	bc		135k lines
SALES_CREDIT_MEMOS	bc		17k lines
SERVICE_INVOICES	bc		110k lines
SERVICE_ORDERS	bc		70k lines
SERVICE_CREDIT_MEMOS	bc		3k lines
PURCHASE_INVOICES	bc		20k lines
PURCHASE_CREDIT_MEMOS	bc		250 lines

Workspaces

Workspace	Description	Access
Datasets		Joshua, Brecht, Pieter
Reports		Joshua, Brecht, Pieter

Files

File Name	Workspace	Description
vdm BC_Dataset.pbix	Datasets
MTD Report (Current).pbix	Reports
Open Bedragen.pbix	Reports
Rental Report.pbix	Reports
Sales-Origineel(no filters).pbix	Reports