Build me an excel dashboard for exchange mailbox reporting various aspects of emails.

I need to start tracking average response times (I mean the time between when an email is received to when it is replied to), numbers of emails unanswered at the end of a day, email received per day (per inbox), etc from the customer service emails into our shared Outlook mailbox

Need this to track the SLA of incoming emails for the service desk with Microsoft outlook client 2016

Must haves :

1. Detailed Data for average response time for an email coming to mailbox

2. how many emails coming/going from desk on hourly/day/week/months...

3. calculate the response time from when at e-mail is received to when it has been responded to

4. SLA for the hour/day/week/months

5. Data should be in details so that customized reports and charts can be created through excel

6. everything should be embedded, including extraction of data from outlook or exchange in Microsoft Excel which means no manual stuff to load the data

will help you with more details if needed.

Készségek: Adatbevitel, Adatfeldolgozás, Excel, Microsoft Access, Microsoft Outlook

Bővebben: office 365 mail traffic statistics by user, message trace office 365 powershell, power query exchange, office 365 user activity log, office 365 reports powershell, office 365 email activity report powershell, office 365 email logs, office 365 email reports, excel Dashboard ,excel reporting, excel dashboard build, excel dashboard financial reporting, excel dashboard project, programing excel dashboard, build excel pivot table, excel dashboard creator, type exchange mailbox create sql server, build excel pread sheets, project information excel dashboard, excel dashboard free advertising, excel dashboard macros

A munkaadóról:
( 0 értékelés ) Allahabad, India

Projektazonosító: #16489196

7 szabadúszó tett átlagosan ₹1886 árajánlatot erre a munkára


I have excellent command on MS Excel and know how to get outlook data into Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet Több

₹5000 INR 2 napon belül
(26 vélemény)

Best place and best team to work on your desired project within a specific time period. .................................................

₹1750 INR 3 napon belül
(0 vélemény)

I think you do your mail wowbox send then problem solve

₹1300 INR 1 napon belül
(0 vélemény)

I read your project and I understood your project.I am available right now. I am waiting for your reply. Thanks,

₹1300 INR 3 napon belül
(1 Visszajelzés)
₹1300 INR 1 napon belül
(0 vélemény)
₹1250 INR 1 napon belül
(0 vélemény)

Hi Currently i am working as a junior accountant i m looking for bookkeeping and accounting work from home i am able to maintain books of accounts, Filling Income-Tax, G.S.T Returns, G.S.T Registration Kindly co Több

₹1300 INR 1 napon belül
(0 vélemény)