Forum Discussion
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 pay date
-Paid on time
-Paid on time, posted on time.
-Overview of sum by TEST
-Sum of invoices paid on time.
-Top BU by sum
-Coun Distinct Net
By looking at the data, please advise of metrics are relevant and what can be improved?
I need to use drill down functions, to get to the core why the numbers are as it displays(tips please)?
U can establish connections between BU and Bu Lookup and aslo create a date dimension and connect to holidays date
5 Replies
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?
U can establish connections between BU and Bu Lookup and aslo create a date dimension and connect to holidays date
How do i create a date dimension?
