Excel KPI Dashboard
- or -
Post a project like this2835
$$$
- Posted:
- Proposals: 12
- Remote
- #1166294
- Awarded
Business Analyst, VBA Programmer, Microsoft Excel Expert, Proofreader, Qlik Sense Data Architect, Qlik Sense Visualisations Expert
Glasgow
Business Consultant, Website Design, Website Development, PHP, WordPress, Web App, Mobile App, Branding, Designer, Business Plans, Business Support, Presentation, Adviser, Analyst, Strategist, Advisor
City of London
61768320827028073857940969903175079796347410176291053593125900712671401267356
Description
Experience Level: Expert
Description of excel work: I want to create an interactive Key Performance Indicator excel dashboard for our employees.
This dashboard is to track employees monthly, quarterly, yearly KPI's.
I want this to be visual though and show visuals of the data to show if they are on track with there quarterly KPI's.
So visuals like traffic lights, speedometer etc
For yearly then to show graphs for example on KPI's to show if there is any trends over the space of 6-9 months for example with a KPI
The KPI's i want to track are
1. Website traffic - increase in visitors, sessions, average time, reduce bounce rate
2. Content development - they have to create a specific number of infographics, videos, case-studies per quarter based on yearly target
3. Social media - target of posts per quarter & number of followers per quarter
4. Marketing campaigns - target to create and launch 4 marketing campaigns per year. create database/content & generate leads.
5. CRM Management - target to update all contacts with vertical/sector. Build out contacts for our key accounts & cleanse/validate the contacts.
I've attached some pictures of ideas for the dasboard visuals.
Extra notes:
See attached document - essentially i want these KPI's in excel then with a dashboard showing visual progress througout the year
Update:
I've added the word document with KPI's and two sample images of the dashboard in excel that i'd like.
This dashboard is to track employees monthly, quarterly, yearly KPI's.
I want this to be visual though and show visuals of the data to show if they are on track with there quarterly KPI's.
So visuals like traffic lights, speedometer etc
For yearly then to show graphs for example on KPI's to show if there is any trends over the space of 6-9 months for example with a KPI
The KPI's i want to track are
1. Website traffic - increase in visitors, sessions, average time, reduce bounce rate
2. Content development - they have to create a specific number of infographics, videos, case-studies per quarter based on yearly target
3. Social media - target of posts per quarter & number of followers per quarter
4. Marketing campaigns - target to create and launch 4 marketing campaigns per year. create database/content & generate leads.
5. CRM Management - target to update all contacts with vertical/sector. Build out contacts for our key accounts & cleanse/validate the contacts.
I've attached some pictures of ideas for the dasboard visuals.
Extra notes:
See attached document - essentially i want these KPI's in excel then with a dashboard showing visual progress througout the year
Update:
I've added the word document with KPI's and two sample images of the dashboard in excel that i'd like.
Claudine D.
100% (9)Projects Completed
15
Freelancers worked with
13
Projects awarded
69%
Last project
10 Nov 2015
Ireland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies