While you might get an anecdotal answer from the illustrious audience we have here, I feel that you are asking the wrong people. You should be asking your stakeholders what insights they want to be able to derive from their data, what KPIs are meaningful to them, etc. You could spend a lot of time building a dashboard to show, for example, conversion rates of guests to members, or attendance drop off over time or impact of exhibitions on footfall, but if your stakeholders are not interested, your sponsors will get frustrated. Personally, if you don't ger clear direction from your stakeholders, I would start small, with a few charts just to show for example footfall by membership/guest by days of week, show it to your stakeholders and ask them what they found useful, what they didn't find useful, what else they would like to see, what questions they would like to be able to answer. Good luck! It sounds like an interesting and exciting project!
... View more