Creating Useful Dashboards and Reports
We already introduced the concept of a BI dashboard. Now, we want to think about some of the techniques and methods we can use to design a BI dashboard to meet an organization's specific needs. This page gives a good overview of some things that go into the design of a BI dashboard. Think about a particular situation, organization, or context you are familiar with. Which of the techniques introduced in this module would you use to design a BI dashboard in your specific case? Why did you select those?
Bonus: automatic refresh
Improve your dashboard even further by following this bonus video.
In this second bonus lecture Bas shows you how to automatically update the sparklines on your dashboard when you select a new period using a few lines of VBA! (Visual Basic for Applications)
If you want to follow along with Bas, you can download the dashboard from the start of the video here.