Data Analysis - Call Center

In Progress

Need to analyze call center metrics to develop three formulas for a call center report.

Please review the 2 attached reports & sample formula.

1.) We need to determine the amount of work we are doing: Something like (time logged into system - actual work time)

2.) Determine our efficiency: - Something like (Talk Time + Work Time/Hours logged in)

3.) Number of agents needed per hour: Forecast of calls expected / (work time*60)/Call handle time.)

The formulas above are a very vague idea of what I am looking for. We want someone to develop the actual formulas based off the available reports we have.

You may have to research how call centers measure efficiency.

End product must be 3 sample reports in Excel and an written report of the formulas with a proof for the reports.

Skills: Data Processing

See more: data analysis call center, analyze call center data, call center data analysis, looking for call center work, i want to have a call center, i need a call center, i call center, excel for data analysis, data analysis with excel, data analysis reports, data analysis for excel, call center number, call center calls, agents formula excel, i am looking for a call center, system center, excel data analysis, Data analysis in excel , Data Analysis excel, call review, call handle, call center, analysis excel, excel 2013 formula, call center need agents

Project ID: #4680757

Awarded to:

TwoExcelKings

Hi John, our team of two specializes in developing formulas and I have previous experience with call center statistics and performance metrics. We would be a perfect fit for this job and will be able to complete this More

$75 USD in 2 days
(0 Reviews)
0.0

18 freelancers are bidding on average $64 for this job

uumairkhalid

Expert here. Please see PM. Thanks

$74 USD in 3 days
(14 Reviews)
4.8
tuhindo82

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE More

$77 USD in 5 days
(5 Reviews)
4.6
priyal1997

Dear John.. MORE THAN YOUR EXPECTATIONS. kindly check PM. Thanks - Priyal

$75 USD in 3 days
(11 Reviews)
3.8
PatrickDev

Hi, I am a USA based freelancer with a lot of experience in data analysis and report building. I am available to work on this project immediately and will return results to you within 24 hours.

$66 USD in 1 day
(1 Review)
1.6
spaul1107

I am new to freelancer but have extensive experience in call center and data analysis. I will have this closed to your satisfaction

$75 USD in 3 days
(0 Reviews)
0.0
bhaktas50

I am interesting this project I have willing do this work batt I want one fair chance so kindly please give me one opportunity.

$50 USD in 3 days
(0 Reviews)
0.0
chhibber

Hi We are professionals expert in excel and VBA programming with extensive experience in using formulas in excel. We can turn around this work within 2 days once your requirements are set. We will set up formulas for y More

$74 USD in 2 days
(0 Reviews)
0.0
vandanamishra86

An MBA and IIM Graduate with rich experience in analytics

$50 USD in 1 day
(0 Reviews)
0.0
drevak

Could you check your PM?

$75 USD in 3 days
(0 Reviews)
0.0
kironmollik

Dear Sir, I'm a certified at Higher Secondary School Certificate exam and now I am continuing my study at Electrical & Electronics Engineering and I'm very interested in your job post involving these skills. I ha More

$55 USD in 13 days
(0 Reviews)
0.0
ronadajar

I worked in a call center when I was younger and is very familiar with BPO metrics like Average handling time, QA scores, log ins, log outs, breaks, and efficiency. I'm very proficient in Microsoft Office applications More

$74 USD in 3 days
(0 Reviews)
0.0
hardikshah83

Hello, Call center professional with more than 10 years of experience here. Let's discuss.

$50 USD in 3 days
(0 Reviews)
1.0
gkan1234

Hi I will do this for you.

$50 USD in 2 days
(0 Reviews)
0.0
ndepambola

To who it may concern, I have 1 year experience in reporting and excel data processing at a call center entreprise, in payroll. You can view my CV at this link https://dl.dropboxusercontent.com/u/85284679/CVE_ND_22041 More

$66 USD in 3 days
(0 Reviews)
0.0
sri4lu

Hi, i am new to freelancer, kindly give me this opportunity...

$55 USD in 3 days
(0 Reviews)
0.0
prithvi81

Hi, I can serve you the best

$50 USD in 3 days
(0 Reviews)
0.0
LillaSmith

I am an expert in data analysis, statistic. I can make a good, efficient formula for you. :)

$66 USD in 3 days
(0 Reviews)
0.0