Forum Discussion
Solved
Defining KPI's From Raw Data
I identified KPI’s for the data below(see linkbelow): https://drive.google.com/file/d/1aHULztI9Q0Ho7ffoRcBceAiElOTIZVji/view?usp=sharing -Comparrisons of invoices paid over time -Sum of days to pa...
U can establish connections between BU and Bu Lookup and aslo create a date dimension and connect to holidays date
Age of inovices unpaid, because unpaid invoices may attract any penalty ( few vendors may do so)
Number of invoices by BU / By Age (Paid and Unpaid)
Paid invoices Age when the get paid - this will give the overview how payments are made and if any flaws can be noted
Use DrillThru to extract the Details of each aggregated value
Let me know if any further help required
Thank you. Any relevant calculations that go's along with kpis identified?
VijayP could you find relationships between the tables?
