What is some advice for designing a data visualization solution?
When you start offering a dashboard initially, you want to create a team that has a lot of expertise. Someone should be very experienced with dashboard intelligence, in the ideal world, in your organization. You also want to have a business analyst who responsible for collecting the requirements of the key performance indicators. And of course, you want the people who will be using the dashboard. Lastly you are going to have to work with the database team as well to make sure there are actual data behind these KPIs. With regard to the infrastructure, you need an IT team to work with, to make sure that database is ready to go, to establish the networking system, whatever the case may be.
And as with any project that cuts across functions in a large enterprise, you probably want project management involved to make sure everybody is communicating properly. Those are the technical aspects you would like to see in a dashboard development team. The first thing you start off with is figuring out the right KPIs, to make sure that the people who will be consuming the dashboards care about them. So generally speaking, you have to go to the stakeholders, ask questions, what are the corporate goals, what you are trying to improve in the organization.
Next come questions about data update frequency. How often will people need to be using this dashboard? Do you use it in real time, or is the data being updated daily in a data warehouse? Finally, are there existing reports in the organization already that could be the basis for arriving at the right KPIs?