Build a dashboard
- or -
Post a project like this2927
£1.5k(approx. $1.8k)
- Posted:
- Proposals: 18
- Remote
- #1094969
- PRE-FUNDED
- Awarded
Web & Ecommerce Development | Responsive Web Design | Mobile Application Development | Graphics Design | SEO and Social Media Marketing
Rajkot
Digital Marketing Expert | SEO Expert | Social Media Marketing Expert | Google Ads Expert
Delhi
82071121372012096461169550963961955992901076822951700615531177523930
Description
Experience Level: Expert
General information for the website: We are putting leak detectors in peoples' houses that send back data. We need a central dashboard to monitor them, it would take its data from an SQL database.
Kind of development: New website from scratch
Description of every page/module: Front page with stats (e.g. No. of devices active, leaks detected etc.) - It would be rather cool to have headline stats against date, and then be able to zoom into a day, and then into a given device.
Pages for uploading, editing and retrieving information about a given device (e.g. customer name, property address, whether the device is active, what signal it is sending back (correctly fitted, leak or no leak, any error signals), as well as notes (and potentially photographs) uploaded by engineers when they visit the property to fix the leak. They may end up fixing multiple leaks, so one device could generate multiple reports etc.
A good search function - so you could search by customer name, address, post code, device number, by order in which a device has gone live or gone off, by error code, by whether a leak has been fixed or not etc. Basically this dashboard will be coping with 1000 devices off the bat, and will need to be handling 10's or 100's of thousands of devices without glitches or major re-writes, so we don't want anything where we have to trawl through a list to get data.
Having said we don't want to trawl through a list, it would be good to have the dashboard be able to squirt out everything it knows into a big, nasty, downloadable excel file, Someone on the client side is going to want this at some stage!
Administrative set up for creating new accounts with passwords - the administrator(s) would be able to add email addresses. The individuals added by the administrator would then receive prompt emails which would allow them to log in, set up passwords for themselves etc., they would then be able to administer their own account, change passwords etc. The administrator would also be able to cancel accounts, create new administrators etc. Potentially also some sort of log to show which account has carried out which edits to the database would be useful.
Description of requirements/features: The entire dashboard/site provides a front end to an underlying SQL database on our server that we would manage (in particular we would get the devices sending back information to populate the SQL database, so you don't need to worry about that or deal with the various comms issues resulting from that) - all you have to do is make the dashboard read from and write to the database in an engaging, informative, easy to use and non-buggy manner. Thinking of not being buggy, as I've said above this thing needs to deal with thousands (potentially even tens or hundreds of thousands) of devices. Any ideas on how we test this and make sure it doesn't break down would be most welcome.
The dashboard/site would also be hosted on our server, and we would want you to transfer it across, upload it, and make sure it works on chrome/explorer/safari/firefox/whatever else you can think of, and that it works on a phone screens computer screens and everything in between, that when people forget their passwords the mechanism for them to create a new password actually works, that they can log in with their email address, not some stupid username that they're going to forget, that when an account is deleted it is actually deleted rather than simply hidden, and that having deleted the account, the same email address can be subsequently used to set up another account in the future, rather than the poor bastard being locked out for all eternity because their email address was previously used in a now deleted account that somehow hasn't been deleted, and the whole thing is not some weird mess like the last one we had!
We'd also like you to make the code available once you've finished, complete with explanatory notes.
Specific technologies required: SQL, web design skills
Extra notes: Going to want to talk to you before we hire you - we can set up a conference call whenever is convenient.
In terms of pricing - I propose something along the lines of: 1/3 when you've got a working mock up to show us, 1/3 when the dashboard is migrated to our server and talking to our SQL database, and the final 1/3 a month later when we've de-bugged the hell out of it, are confident it works with lots of users and lots of data entries across lots of devices and browsers, and when you've supplied all the code and the documentation. Sorry to keep going on about bugs, but we got quite badly burnt a couple of years ago trying to set up something similar!
Kind of development: New website from scratch
Description of every page/module: Front page with stats (e.g. No. of devices active, leaks detected etc.) - It would be rather cool to have headline stats against date, and then be able to zoom into a day, and then into a given device.
Pages for uploading, editing and retrieving information about a given device (e.g. customer name, property address, whether the device is active, what signal it is sending back (correctly fitted, leak or no leak, any error signals), as well as notes (and potentially photographs) uploaded by engineers when they visit the property to fix the leak. They may end up fixing multiple leaks, so one device could generate multiple reports etc.
A good search function - so you could search by customer name, address, post code, device number, by order in which a device has gone live or gone off, by error code, by whether a leak has been fixed or not etc. Basically this dashboard will be coping with 1000 devices off the bat, and will need to be handling 10's or 100's of thousands of devices without glitches or major re-writes, so we don't want anything where we have to trawl through a list to get data.
Having said we don't want to trawl through a list, it would be good to have the dashboard be able to squirt out everything it knows into a big, nasty, downloadable excel file, Someone on the client side is going to want this at some stage!
Administrative set up for creating new accounts with passwords - the administrator(s) would be able to add email addresses. The individuals added by the administrator would then receive prompt emails which would allow them to log in, set up passwords for themselves etc., they would then be able to administer their own account, change passwords etc. The administrator would also be able to cancel accounts, create new administrators etc. Potentially also some sort of log to show which account has carried out which edits to the database would be useful.
Description of requirements/features: The entire dashboard/site provides a front end to an underlying SQL database on our server that we would manage (in particular we would get the devices sending back information to populate the SQL database, so you don't need to worry about that or deal with the various comms issues resulting from that) - all you have to do is make the dashboard read from and write to the database in an engaging, informative, easy to use and non-buggy manner. Thinking of not being buggy, as I've said above this thing needs to deal with thousands (potentially even tens or hundreds of thousands) of devices. Any ideas on how we test this and make sure it doesn't break down would be most welcome.
The dashboard/site would also be hosted on our server, and we would want you to transfer it across, upload it, and make sure it works on chrome/explorer/safari/firefox/whatever else you can think of, and that it works on a phone screens computer screens and everything in between, that when people forget their passwords the mechanism for them to create a new password actually works, that they can log in with their email address, not some stupid username that they're going to forget, that when an account is deleted it is actually deleted rather than simply hidden, and that having deleted the account, the same email address can be subsequently used to set up another account in the future, rather than the poor bastard being locked out for all eternity because their email address was previously used in a now deleted account that somehow hasn't been deleted, and the whole thing is not some weird mess like the last one we had!
We'd also like you to make the code available once you've finished, complete with explanatory notes.
Specific technologies required: SQL, web design skills
Extra notes: Going to want to talk to you before we hire you - we can set up a conference call whenever is convenient.
In terms of pricing - I propose something along the lines of: 1/3 when you've got a working mock up to show us, 1/3 when the dashboard is migrated to our server and talking to our SQL database, and the final 1/3 a month later when we've de-bugged the hell out of it, are confident it works with lots of users and lots of data entries across lots of devices and browsers, and when you've supplied all the code and the documentation. Sorry to keep going on about bugs, but we got quite badly burnt a couple of years ago trying to set up something similar!
Philip Y.
100% (11)Projects Completed
10
Freelancers worked with
9
Projects awarded
85%
Last project
21 Apr 2022
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