Need to deliver filterable online reporting on site participation for our client.
We require a series of dynamic charts and tables (10) for embedding onto an existing website, drawing from data in both our custom Survey application and learning management system (2 databases).
Working from our detailed spec, including layout examples and source data location info (db name, table, column), you will develop the required SQL queries to output the key reporting deliverables. Using a slick chart graphics library of your choice, you will translate these queries into a series of dynamic charts (line, pie and bar) and tables that refresh for new data monthly.
A reporting solution for this project is currently being delivered in Excel, which is also available for cross-checking.