Excel Data Manipulation into Dashboard View
- or -
Post a project like this3848
£45(approx. $56)
- Posted:
- Proposals: 4
- Remote
- #331415
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 1 day
My company has a requirement to build a basic dashboard where the management team can view a few different pieces of information at once,
PART ONE - PROJECTS
We currently have separate workplans for each project we are working on.
Team members update them daily with hours worked on each project so time can be logged and compared against an estimate.
We need to collate this data into a dashboard view which will show, for each project:
Hours Logged
Hours Remaining
Status
- status should turn RED if a particular workplan hasn't been updated in 24hours.
PART TWO - SALES
We have a sales pipeline spreadsheet which is updated by the sales team, and data logged per lead.
The dashboard needs to show
Number of new leads this month
Value of deals won this month
-broken down by NEW and EXISTING clients
We have the basic spreadsheets all created and data entered, we just need the dashboard built. More than likely a combination of scripts and a pivot table.
For someone that knows what they're doing it shoudn't take more than a couple of hours.
Ideally we'd like this complete by Monday 30th September
PART ONE - PROJECTS
We currently have separate workplans for each project we are working on.
Team members update them daily with hours worked on each project so time can be logged and compared against an estimate.
We need to collate this data into a dashboard view which will show, for each project:
Hours Logged
Hours Remaining
Status
- status should turn RED if a particular workplan hasn't been updated in 24hours.
PART TWO - SALES
We have a sales pipeline spreadsheet which is updated by the sales team, and data logged per lead.
The dashboard needs to show
Number of new leads this month
Value of deals won this month
-broken down by NEW and EXISTING clients
We have the basic spreadsheets all created and data entered, we just need the dashboard built. More than likely a combination of scripts and a pivot table.
For someone that knows what they're doing it shoudn't take more than a couple of hours.
Ideally we'd like this complete by Monday 30th September
Jennie W.
100% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
50%
Last project
8 Nov 2016
United Kingdom
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