Defining KPI's From Raw Data

[Yrstruly2021]

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)?

[VijayP · Accepted solution]

@Yrstruly2021 

U can establish connections between BU and Bu Lookup and aslo create a date dimension and connect to holidays date

[Yrstruly2021]

How do i create a date dimension?

[VijayP]

@Yrstruly2021 

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

[Yrstruly2021]

@VijayP could you find relationships between the tables?

[Yrstruly2021]

Thank you. Any relevant calculations that go's along with kpis identified?