Category Archives for Dashboard Design Concepts
Excel Requirements Gathering Process – Excel Dashboards
Excel consultants know that requirements gathering exercises can look deceptively simple. Whether that be for creating a dashboard for the client or an Excel application, there is always something in hindsight that one could have done better. Let’s not depend solely on our own mistakes to become better Excel consultants. Our in-house team of Excel […]
Continue readingUsing White Space In Excel Dashboards – Excel Tips
Whoever has been tasked with making a dashboard ever knows that there are three aspects to it: Business acumen: choosing which metrics are relevant to the problem at hand, amongst other things. Technical capability: working out the macros and complex functions to make sure the dashboard is user-friendly. Design element: ensuring that the numbers and […]
Continue reading
Guidelines for Creating Effective Dashboards – My First Presentation from PASS BA Conference 2015
First off, the PASS Business Analytics Conference 2015 was a blast. Met a lot of great people. I will dig into that further in another post. Beyond just being there, having a great time, and my Excel TV duties, I was also a speaker. I spoke about larger strategic issues. I had two presentations. Here […]
Continue readingSpruce up you Color Palette in Excel – ColorBrewer – Excel Design Tips
Tired of the same old color palette in Excel? You know what I mean. Its either Excel Green, Word Blue or Powerpoint Purple. Maybe a few different hues of each color. But if you are a “designer”, it leaves something to be desired. No self respecting Excel Dashboard designer is showing up with an out […]
Continue reading