
Excel (VBA) data manipulation and analysis + Management dashboard
- or -
Post a project like this4278
€300(approx. $355)
- Posted:
- Proposals: 12
- Remote
- #463271
- Awarded
Design and Build Turnkey Data based business solutions and process streamlining for SME's

595682225866193595619365275573552652819190114590689582314
Description
Experience Level: Expert
Industry: Business
Description of excel work: I'm looking for a developer who can create an Excel dashboard for data that is pulled from a Learning Management System.
The data is exported to an Excel report that is quite unreadable for the people who it is intended for, so that's why we want to have a nicely visualized dashboard that reads the information from the excel. In addition, the current report contains information on how students have responded to eLearning courses, I want the information that is not directly summarized in the management dashboard to be displayed in a nicely visualized Excel table.
The way it should work:
- User exports data from Learning Management System to an Excel file.
- The data is then copied to your developed Excel dashboard in a separate tab
- Your dashboard visualizes the data.
Mind that the no. of columns and rows is not fixed.
The dashboard should at least display this:
- Grades per employee/student
- Average score of entire group
- Students' responses to questions
- What questions were answered correctly/incorrectly
- What questions were incorrectly answered most
- Students that have attended vs. not attended the eLearning course
I have an example report that I can send you.
As for the timeline, I'm looking at a first version before April 16.
Please provide me with your fixed price (also taking into account revisions).
Thanks!
Extra notes:
Description of excel work: I'm looking for a developer who can create an Excel dashboard for data that is pulled from a Learning Management System.
The data is exported to an Excel report that is quite unreadable for the people who it is intended for, so that's why we want to have a nicely visualized dashboard that reads the information from the excel. In addition, the current report contains information on how students have responded to eLearning courses, I want the information that is not directly summarized in the management dashboard to be displayed in a nicely visualized Excel table.
The way it should work:
- User exports data from Learning Management System to an Excel file.
- The data is then copied to your developed Excel dashboard in a separate tab
- Your dashboard visualizes the data.
Mind that the no. of columns and rows is not fixed.
The dashboard should at least display this:
- Grades per employee/student
- Average score of entire group
- Students' responses to questions
- What questions were answered correctly/incorrectly
- What questions were incorrectly answered most
- Students that have attended vs. not attended the eLearning course
I have an example report that I can send you.
As for the timeline, I'm looking at a first version before April 16.
Please provide me with your fixed price (also taking into account revisions).
Thanks!
Extra notes:
Rene N.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
33%
Last project
28 Jul 2014
Netherlands
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