Dashboard summarising a workbook to identify missing data

[Ghislain Hachey]

Details to be discussed but online version of #324

[Ghislain Hachey]

Here the process for data verification is simple.

1) Look at the summary of data returned when uploading the workbook. This provides a first data verification at the moment the data goes into the system. 2) After this as been uploaded and the warehouse generated the online dashboard should provide a means to compare the data in the warehouse with the data in the workbooks uploaded.

2) Is the essence of this issue. We could have under Schools -> Dashboards or link to Workbook Audit which is a special purpose built dashboard to check out against the workbook's pivot tables. I am including samples of those summary pivot tables below. @jeremy_kells please let me know if you would like a sample workbook to have a close look at that. It will prbably be useful to check out all the various filter options, etc. I believe the warehouse may not be able to provide all the data in the workbook in the current state but let's provide an audit on what we can.

[Ghislain Hachey]

This audit workbook might be useful too. Only screenshot provided but you can get the actual workbook if you like.

[Ghislain Hachey]

And this one for teacher qual/certs. They all provide useful summary for comparison bring confidence to the data managers that their data is all good in the warehouse.

[Ghislain Hachey]

We mostly have this. Anything more specific that becomes a need can be documented in separate issues