Our customer – big research institute NelsonHall – wanted to improve data collection and processing system which was done previously with the use of Microsoft Access, Excel and Word.
Existing system required several people to manage many files and process all data and report generation manually. Due to complexity of that work NelsonHall issued its report for customers only once a year while customers would prefer to be updated more often.
Another issue is that due to software limits NelsonHall cannot process more than certain amount of data entries while their reports value can be much bigger if much more data could be processed.
What was the challenge?
When we started working, database contained about 1 million records each record had 50 fields to be filled in.
But the biggest challenge was not the size of database but endless amount of formulas and connections which processed that data into reports.
What we did?
We made web application which not only represents functionality of previously used system but increases it.
Different access roles System Administrator, Customer etc. were made to protect system and allow simultaneous work with system.
In addition to predefined reports web application allows to modify different parameters of reports which extends the list of possible reports to endless amount.
New reports generation were simplified and doesn’t require adjustment of any formulas.
System performance were optimised to process several times more data within no time lag.
What was achieved?
- Customer were able to increase data entries in database from 1 million to 15 millions.
- Reports can be generated not once a year but any time customer needs.
- Customer of NelsonHall received option to customise reports the way they need without any difficulty.
- Database is updated live and always up to date for customer.
- Number of people required to generate reports reduced to zero in far as customers can generate reports themselves. Number of people required for data entry reduced as well.
- Mistakes in data entry were reduced close to zero.