# Key Performance Indicators (KPI) Expert MS Access/Excel Charts and Graphs -- 2

Key Performance Indicators (KPI) Expert MS Access/Excel Charts and Graphs

Show me you can take the raw data in the attached spread sheet and show me the formulas for

12 month rolling avg

Vs

KPI 12 month rolling avg

If you can’t do this then move on!

Using MS Access

MS Excel

MS PowerPoint

Hint:

1. Formula for Rolling Total

a. Enter the following formula, and press Enter:

=SUMIF(A\$2:A2,">=" & DATE(YEAR(A2),MONTH(A2)-11,DAY(A2)),B\$2:B2)

2. KPI: Monthly / Month over Month KPI Movers

a. =OFFSET(reference, rows, columns, [height], [width])

b. =OFFSET(Sheet1!\$A\$1,1,0,COUNT(Sheet1!\$A:\$A),5)

Looking for an expert that knows all the different ways that we can make KPI's that I can use to measure

Examples compare the following

Please show me you can complete the following

And tell me what you can do for me

Compare 12 Month Rolling Average vs KPI's rolling average

• Placements – Account Average Age by Month

• RollingPlacements Average Age by Month

• Placements – Total Number of Accounts Placed by Month

• RollingPlacements – Total Number of Accounts Placed by Month

• Placements - Total Dollars Placed by Month

• RollingPlacements - Total Dollars Placed by Month

• Placements – Average Account Balance by Month

• RollingPlacements – Average Account Balance by Month

• Total Dollars Collected by Month

• RollingTotal Dollars Collected by Month

• Gross Collection Percent

• RollingGross Collection Percent

• Total Calls by Month

• RollingTotal Calls by Month

• Total Contacts by Month

• RollingTotal Contacts by Month

• Average Collector Call Audit Score

• RollingAverage Collector Call Audit Score

• Total PIF’s by Month

• RollingTotal PIF’s by Month

• Total New Promises to Pay by Month

• RollingTotal New Promises to Pay by Month

• Total Complaints by Month

• RollingTotal Complaints by Month

1. KPIs vs Metrics

2. The difference between Business Metrics and KPI’s

3. The Difference Between Quantification, Measure, Metric, and KPI

4. KPI: Monthly vs 12 Month Moving Average Revenue

Tracking KPIs in Collections

Placements – Account Average Age by Month

RollingPlacements Average Age by Month

Placements – Total Number of Accounts Placed by Month

RollingPlacements – Total Number of Accounts Placed by Month

Placements - Total Dollars Placed by Month

RollingPlacements - Total Dollars Placed by Month

Placements – Average Account Balance by Month

RollingPlacements – Average Account Balance by Month

Total Dollars Collected by Month

RollingTotal Dollars Collected by Month

Gross Collection Percent

RollingGross Collection Percent

Total Calls by Month

RollingTotal Calls by Month

Total Contacts by Month

RollingTotal Contacts by Month

Average Collector Call Audit Score

RollingAverage Collector Call Audit Score

Total PIF’s by Month

RollingTotal PIF’s by Month

Total New Promises to Pay by Month

RollingTotal New Promises to Pay by Month

Total Complaints by Month

RollingTotal Complaints by Month

Percentage of Accounts with

Missing or Incomplete Data

Percentage of accounts managed by the collections group that have missing or incomplete data fields within company systems.

Percentage of Accounts Requiring Skiptracing

The percentage of accounts managed by the collections group that require skiptracing in order to collect valid contact information.

Number of files worked each day -

Right party contacts generated

Payment Evaluation -

Call Times --

Escalated Calls --

Kemahiran: Analitik, Excel, Microsoft Access, Powerpoint, Statistik

Tentang Majikan:
( 45 ulasan ) Eden Prairie, United States

ID Projek: #10106028

## 16 pekerja bebas membida secara purata \$173 untuk pekerjaan ini

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Lagi

\$147 USD dalam 3 hari
(63 Ulasan)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Lagi

\$250 USD dalam 3 hari
(107 Ulasan)
6.2
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

\$200 USD dalam 5 hari
(80 Ulasan)
5.9
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliv Lagi

\$157 USD dalam 3 hari
(65 Ulasan)
5.7
\$555 USD dalam 10 hari
(22 Ulasan)
5.2
sharmasraj10

Greetings ! I am a "Dean Scholarship" recipient for business graduate studies from a leading public university in New York, USA. I am CFA (Level 2) USA certified chartered financial analyst. I am expert in financia Lagi

\$173 USD dalam 3 hari
(11 Ulasan)
4.5
\$150 USD dalam 3 hari
(13 Ulasan)
3.5
shahzaib121

Hi Dear I have a lot experience in Data Analysis, Business Intelligence. I am Data Analysis Certified from Oracle. I have done many work in Oracle, MYSQL, Access, Sql Server. I have done all kind of work Dashboards Lagi

\$166 USD dalam 7 hari
(8 Ulasan)
3.6
lramanathan

Being a systems expert across various domains for over 18 years, I am well placed to take up this assignment. I have designed & deployed KPIs for various scenarios .

\$166 USD dalam 8 hari
(2 Ulasan)
2.8
\$50 USD dalam sehari
(4 Ulasan)
2.9
\$277 USD dalam 10 hari
(1 Ulasan)
1.5
maliksamta8680

A proposal has not yet been provided

\$222 USD dalam 15 hari
(0 Ulasan)
0.0
sunnyarul

I have experience in working with excel macros during my work as a process engineer. I have processed numerous data of operating conditions using macros to prepare daily and monthly reports with the key performance in Lagi

\$166 USD dalam 3 hari
(0 Ulasan)
0.0
\$155 USD dalam 3 hari
(0 Ulasan)
0.0
vermavinod

Final no. of delivery days will depend on the actual task.

\$99 USD dalam 10 hari
(0 Ulasan)
0.0
toup7

There is some confusion in the project description. There is no such thing as a KPI monthly rolling average. Basically a KPI is a metric that has been chosen as a good indicator of the current status or performance. Th Lagi

\$300 USD dalam 5 hari
(0 Ulasan)
0.0
\$100 USD dalam 5 hari
(0 Ulasan)
0.0
yassiroo

A proposal has not yet been provided

\$166 USD dalam 7 hari
(0 Ulasan)
0.0