Hi allThis isn't directly a Tessitura question - but I know that you all wear so many different reporting and analytics hats, so I'm hoping you can help!
Our Learning team are looking for a way to show where they are running projects across the UK. They have a list of great ideas for visualisations to help them show the exec team what they are doing and to plan their future activity. Requirements include multiple layers to bring in open source data (eg deprivation index / population etc) by region, as well as plotting the location of high schools, galleries and other partners. There's also the desire to be able to see how activity changes year on year, and to filter by a number of different data points (eg type of school).Do you have any experience of programmes or websites offering this kind of functionality? We don't need the full 'sort out your delivery drivers' optimal routes' software that pops up when we search!Many thanks in advance for your help and recommendations of where we could start.best wishesAlison AtkinsonSenior Commercial Systems ManagerThe National Gallery
I've done stuff like this in 3D Maps in Excel. It doesn't have the most features and has its own quirks but can get you pretty far with a little creativity. This map was created to show different types of venues in our area. Each venue type is its own layer that I imported from tables, so that I can color code them. I could also layer in our geo areas if needed. I then duplicate the map and filter it as many times as needed and throw them in power point to animate through the various filtered maps. (There is some kind of animation in 3D Maps itself, but I haven't toyed with it) Legends callouts would need to be added in photoshop or something.