Brief
Produce a system allowing retailers to submit performance based figures on a monthly basis. Harbour the information in a database and compile a monthly report showing these figures.
What was delivered?
A fully dynamic reporting suite capable of:
- Allowing head office to view all the data submitted over several months, not just the one month by allowing head office to specify the date ranges themselves.
- Displaying live up-to-the-second data from the database
- Converting raw data from the database into flash animated bar graphs and pie charts. This makes it very easy to spot patterns and trends in the data
- Illustrating using animated pie charts and bar graphs for the best/worst performers at certain parts of the air con scheme
- Showing all the retailers who submitted their figures late after the specified deadline
- Showing all the retailers who have not submitted to date along with their area manager and contact details should further/disciplinary action needed
- Showing a submission participation review over a period specified by the user. This allows the head office to get an accurate idea of the % of retailers participating in the initiative and when
- Allowing the user to filter the submission data by upto 3 levels of precision
- This filtered data can then be exported into an excel spreadsheet to allow further interpretation and processing of the data if necessary.
All of the above were achieved using cutting edge technology and practice and delivered on-time. Once again all the extra curricular features were implemented out of my own initiative and desire to take pride in my work and satisfy the client. And it worked! I was later informed head office were very impressed and satisfied with the end result.