Creating a live dashboard is a skill combining data sourcing and staging (arrangement of the data to serve the dashboard elements), queries (typically SQL, or smart Excel functions), visual design, user experience and layout, and business requirements to be fulfilled. My students learn how to create beautiful, business dashboards.
I recently offered an answer on Quora to the question: How can you create a live dashboard with Excel for your clients? After submitting my answer, I thought my Blog readers may benefit from this as well, so here it is :)
Consider the following dashboard: