Dashboard Design Concepts Archives - Excel TV

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 reading

Using 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 reading

Spruce 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