Build MS Access 2016 KPI dashboard

已关闭 已发布的 5 年前 货到付款
已关闭 货到付款

There are two parts

One:

I have an excel KPI dashboard, and 6 excel files in which different people input their numbers. The graphs are then populated based on those numbers in the main excel dashboard called "Virtual Improvement Board 1.0".

I want to make this process user friendly and more eloquent, and I need the following:

For Entering values:

Simple data entry form where a person can input numbers for any date for their required KPIs e.g. 5 KPIs for Production Supervisor, 4 KPIs for process engineers, 4 KPIs for maintenance supervisors as mentioned in the excel spreadsheet that I am attaching.

Also a table for entering improvement actions as mentioned in that tab.

For seeing results/dashboard/report:

1) Visual, graphical one page summary all KPIs for any particular day of the month.

2) Summary of KPIs by position name and date with one click, drag and drop system

3) The graphs should turn red or green automatically as I have done in my excel spreadsheet.

4) Ability to add or remove KPIs, name of person etc, this dashboard should be editedable my an administrator

5) A page where I can add list of users and assign them password, so access to this dashboard can be limited.

6) Simple way to view the improvement actions entered above.

7) If they can be made accessible through mobile, that would be an added advantage but not required.

8) Any other ideas to make this dashboard awesome are welcome, and I am looking forward to your creativity.

Two:

I need a system which is part of this dashboard, and similar in functionality i.e. different users with usernames and passwords, can add information using 3 forms. These forms are basically problem investigation forms. Then different reports should be accessible easily with a couple of clicks where we can see:

1) Results of different problem investigations should be easily accessible, by person, by month, day, by process step, by other columns present in the example.

2) We should be able to rate different parts of this investigation form using 1 to 5 stars, just like we do online on facebook, etc, by page 1, 2 & 3 and overall.

PLEASE don't experiment with this if you are not an expert who has done this multiple times before, not not waste my time if you don't know what you're doing.

微软Access

项目ID: #17710075

关于项目

6个方案 远程项目 活跃的5 年前

有6名威客正在参与此工作的竞标,均价$364/小时

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As 更多

$24USD 在1天里
(81条评论)
7.3
alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel 更多

$555 USD 在10天内
(69条评论)
5.8
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Access 更多

$888 USD 在15天内
(44条评论)
6.1
vijayvizzu7

Hi I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. i am sure i can handle your request

$100USD 在1天里
(4条评论)
3.6
amitfuliya85

Dear Next Employer We will give you the best result by using my skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar projects I've completed. Thanks

$15 USD 在2天内
(0条评论)
0.0