You are not happy at work. I can clearly see that. Morale is low due to the economy, but it’s something else, isn’t it? You feel handcuffed. You keep hitting a wall. It hurts, hitting a wall while handcuffed… You work with data. There is a formal
Read more →Archive for the ‘Dashboards’ Category
You know that you should avoid the Crystal Xcelsius dashboard style, but now what? Where do you place your charts, kpi, tables? Here is a trick that you can use: write a sentence or a paragraph that summarizes the core message. For example “Our sales are growing
Read more →Dmitry asks: I face an issue that has nothing to do with Excel itself: human resistance. I showed a dashboard to my manager and he answered to me that my dashboard is too difficult for him and for top management and insisted to use simple XL-tables with
Read more →I am a moderately advanced Excel user. This means “a dangerous person” for the IT department, but I like this daily fight, and Excel dashboards are among my preferred weapons. Let’s see how they can be used. Excel is the best tool for executive dashboard prototyping, because of
Read more →I am sure Albert Einstein was thinking of Excel dashboards when he said “everything should be made as simple as possible, but not simpler”. Let me tell you why. Demographic Dashboard: The VBA edition I published some time ago a first version of my Demographic Dashboard to
Read more →Some metaphors are really stupid. Convincing people that running a company is like driving a car and you need a similar dashboard is one of them. If you are naive enough to buy it, most dashboard vendors will happily fill up your precious screen real estate with
Read more →Bonavista Systems announced today an Excel Dashboard Competition. Participants stand a chance to win an iPhone, a workshop hosted by Stephen Few and a copy of Few’s “Information Dashboard Design”. Unlike other competitions, there is no data set. You just have to use Excel and MicroCharts, their
Read more →Do you need VBA to create an Excel dashboard? Our recent discussion clearly shows two lines of thought: a) you should use it because there are things you just can’t do without VBA and if you have access to a powerful tool you should put it to
Read more →Do you need VBA to create an Excel dashboard? Should you take the plunge and go beyond Excel formulas? Well, I think you should, but feel free to disagree. Charley Kyd, commenting on my review of his e-book, disagrees: As a consultant, I visited too many clients
Read more →The other day I was reading Dundas’ whitepaper “Best Practices for Building Digital Dashboards” (PDF) [update: this whitepaper is no longer available] and you know what? What they say makes a lot of sense. I agree with at least 75% of what is written. For example: …
Read more →
Recent Comments