Accidents and Incidents analysis
Budget: £18 – £36 GBP
It started as excel spreadsheets, entering data for the month and then using pivot charts to show a graphical analysis.
I have created an 'area' on my website (DNN CMS) assigned to a user role, and then wanted a dashboard of information and then analyse further. I thought I might be able to do this with Mandeeps Live Visualizer module. I have got so far, but have run into problems.
I am not sure storing this information into the website db is the best way forward, and its defiantly giving me problems as I find it difficult to understand how the data is stored within the tables. For example, I managed to create a SQL Query to return the total number of accidents, but cannot return the number of accidents for the current month.
I would be happy for advice and hear from anybody who would be able to take this forward with me.
It would be advantageous if you have DNN experience, and that of Mandeeps modules and MS SQL db's
I have created an 'area' on my website (DNN CMS) assigned to a user role, and then wanted a dashboard of information and then analyse further. I thought I might be able to do this with Mandeeps Live Visualizer module. I have got so far, but have run into problems.
I am not sure storing this information into the website db is the best way forward, and its defiantly giving me problems as I find it difficult to understand how the data is stored within the tables. For example, I managed to create a SQL Query to return the total number of accidents, but cannot return the number of accidents for the current month.
I would be happy for advice and hear from anybody who would be able to take this forward with me.
It would be advantageous if you have DNN experience, and that of Mandeeps modules and MS SQL db's