Excel Dashboard - Pivot Tables and Charts

Pågående Publicerat 5 år sedan Betalades vid leverans
Pågående Betalades vid leverans

I'd like to create a dashboard at a Team level, then also rep level too from various KPIs to be defined. The data at the moment is one (perhaps 2) table linked to a local free sql . We can control/update the table/view so calculations can be done at source if required by etl process or in excel

The tables contain all the information we should need for dimensions such as date times, and department, and team, so we can track daily/weekly performance and attendance for example

KPIs that might be calls taken, break times, sick days call times, with monthly/weekly/daily trends or others, and the top 5 staff who got the highest conversion..., and the highest score on their feedback. And by month, which are the top 5 performers for example

You should have some suggestions into the correct charts to use for KPIs to measure staff performance.

I will need charts to show some KPIs with a representatives for example total time spent on the phone, and team average and department average on the same chart (this is the bit I would be quite slow at, the presentation bit, though the data I am quite good with). So you can click on a rep and it shows you how their scores compare their team, and their team to the department

This is the sort of information that could be displayed (as attached with the gauge for example) but I would want it looking more detailed than that/more professional looking

And this is the sort of interactivity it must have. Totally controlled by slicers/pivot tables, I like this and it should be a fast build to someone good with charts!

[login to view URL]

I like the idea of having a people graph for team filters and your suggestions too

It should be quite straightforward and the dashboard/charts should export to power point for one to one feedback to the reps on how they are doing. If we need a macro for this thats ok, but otherwise I would like to keep macros and vba to none at this time otherwise perhaps add them later

This is a proof of concept for now for my benefit to see possibilites and I will like some examples of similar type of dashboard you have made.

If this one is deliver well I might need another one soon, I dont know. Initial cost for me to get to know freelancer and capabilites, I look forward to seeing your examples. I hope there will be follow up work off good delivery when we need to enhance it or build another similar at hourly rate

Good communication is key. I would like turn around quite fast on awarding of the project and sharing of the data. I have some hours over the next 4 days to collaborate with you and would like something by end of weekend hopefully complete with just tweaks required. The detail like formatting and things is something I am not very fast with. But I want it to be no maintenance, just refresh data that is all. very important is comparison to the other teams and reps

I am looking to spend £30 which I think 3 hours of work should be quite good, as the data if in good shape generally. I look forward to your examples

Business Intelligence Charts Databehandling Excel SQL

Projekt-id: #18025288

About the project

14 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

shivaparvathi108

Dear Employer, I have gone through your project description. I am a Business Analyst. I have experience working in different BI tools and technologies like Excel, PowerBI, Pentaho, Spotfire, Qlikview and Tableau. Mer

£23 GBP inom 1 dag
(31 omdömen)
4.2

14 frilansare har lagt bud på i genomsnitt £124 för det här jobbet

TonmoyRoy111

Dear client I am very interested in creating the dashboard for you in excel. I can share previous sample which i made for my clients in the past. Kindly contact me for further details. Roy

£250 GBP inom 4 dagar
(267 omdömen)
6.5
polarjin2017

Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.

£155 GBP inom 3 dagar
(59 omdömen)
6.2
daniyal3214

I am a professional Business Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel

£50 GBP inom 1 dag
(41 omdömen)
5.2
khanmkahmed7

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 3 years of experience. I have successfully completed few projects for US clients which involved web sc Mer

£100 GBP inom 2 dagar
(14 omdömen)
3.8
afenache

Hi, I can build the dynamic dashboard that you described in your post. You can find in my portfolio a sample of a dynamic dashboard that I made in excel. Best regards, Florin Enache

£100 GBP inom 3 dagar
(11 omdömen)
3.9
dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

£55 GBP inom 3 dagar
(9 omdömen)
2.8
afrihs9486

I will complete the work on urgent basis Relevant Skills and Experience Pivot table chart etc

£20 GBP inom 1 dag
(0 omdömen)
0.0