Hi,
At the Dublin conference last year, I was interested to learn that some organisations use imported government data to report against key statistics for schools.
We would like to adopt a similar approach in order to help us with our reporting for Arts Council England.
I would love to get in touch with organisations who have already implemented this approach to find out more about how they used it and what obstacles they had to overcome.
I would appreciate your advice and thoughts.
Josefine
Hi Josefine, this was definitely the case when I was at the NT. It was implemented by Dmitrij Zeile who is now at Sadler's Wells. I remember there being an issue with matching up schools records and de-duping but apart from that believe it was fairly logical.
Dmitrij can give you more details on this as it was his project adn he did the actual implementation and worked with the Learning person to get all the data connected and validated.
Essentially we added an attribute to each school which we populated with the unique code from the schools data we were given. This allowed us to then load that data into a separate table and create a view that linked that data back to the constituent record with the attribute.
I proposed doing it this way so that with every new year we could create a second table and import the new data into that and test it before having to switch it into the record (as just needed to change the view to point to new table) as this would also let us investigate any changes in data etc
Mark