Company A has 10-15 departments and multiple office all over India (Mumbai, Delhi, Chennai, Kolkata, Bengaluru, Hyderabad, Gurugram, Pune). Each department publishes a public contact number, Employees fro any office can send messages to any of these departments using a mobile app. The messages get stored in a database along with users location and other associated basic data. We need to display 3 reports based on this data.
What needs to be done
I have an existing static web site. We need to create a link that will lead to a login page. The user logs in and views any of the following reports
1) over a period of time (3, 6, 9, 12 months), which department received how many messages (let's assume one chat is one message) - user can select time period and department
2) month wise distribution of messages for all or a particular department
3) on a map display all locations from where messages were received. Should be color coded for all departments.This can be filtered by time period or particular department.
All above reports will need fake data to be populated in the database so we can generate believable reports with substantial data. Along with other data, we need to display department name and number in the reports. No need to display employee phone number.
We need it done by end of next week (9th September, 2016)