Category Archives: Dashboard

Data Visualization – a real world example

Posted on March 2, 2010 by XLCubedBlog

In the following example we work through a real world example of a data visualization. We’ve chosen an example that involves Operations data – this is fairly non-domain specific so hopefully it can demonstrate some important points. The first, and … Continue reading →

Posted in Analytics, BI, Case Studies, Charts, Dashboard, Reporting, Sparklines, Visualization | 3 Comments

Gemini – Smarter Excel Dashboards with End-User BI

Posted on October 9, 2008 by XLCubedBlog

I attended beginning this week the Microsoft BI Conference in Seattle where Microsoft presented an interesting new product that might change the way you build your Excel dashboards in the future: "Gemini", an End-User Business Intelligence plug in for Excel. … Continue reading →

Posted in BI, Dashboard | Tagged | 3 Comments

Smart Dashboard Ranking Tables

Posted on August 28, 2008 by XLCubedBlog

Chandoo and Robert over at the PHD blog have a nice a 4 post series of posts about Creating KPI Dashboards in Microsoft Excel. Show only 10 items of a huge list, but give the user the chance to scroll … Continue reading →

Posted in Dashboard, Excel Tricks | Leave a comment

Excel Dashboard Competition: Bank Dashboard

Posted on August 11, 2008 by XLCubedBlog

This blog post is the first in a series of blog post that features the winners of the 2008 Excel dashboard competition. “A dashboard is a visual display of the most important information needed to achieve one or more objectives; … Continue reading →

Posted in Dashboard | Tagged , | Leave a comment

The Dashboard Squint Test

Posted on August 9, 2008 by XLCubedBlog

Before we go and review the 2008 Excel Dashboard Competition Winners I have to make you familiar with  the Dashboard Squint Test. Software usability experts and web designer use a quite effective way to assess the organization of a web … Continue reading →

Posted in Dashboard | Tagged | 1 Comment

Excel Dashboard and Visualization Boot Camp

Posted on August 5, 2008 by XLCubedBlog

Here the announcement of the Excel Dashboard Boot Camp hosted by the two experts Jon Peltier and Mike Alexander: Microsoft MVPs Jon Peltier (Peltier Technical Services) and Mike Alexander (DataPig Technologies) are joining together to bring you our first annual … Continue reading →

Posted in Dashboard | Leave a comment

The Missing Link (Part 1)

Posted on July 28, 2008 by XLCubedBlog

Every good discipline needs a missing link. Evolutionary biology had a missing link between humans and the ‘lower’ animals. Physics has a missing link between quantum mechanics and general relativity. The Information Visualization community discovered the Missing Link Between Information … Continue reading →

Posted in Dashboard | Tagged | 13 Comments

2008 Excel Dashboard Competition Winners

Posted on July 17, 2008 by XLCubedBlog

After much deliberation and debate, we are pleased to announce the winners of the 2008 Excel Dashboard Competition. We were impressed by many of the entries, and thanks to all of you who entered. It’s good to see MicroCharts being … Continue reading →

Posted in Dashboard | Tagged | 4 Comments

Sharing your Excel dashboard: from paper to the web

Posted on May 29, 2008 by XLCubedBlog

You have finished your great looking, very efficient Excel dashboard. Now, how do you share it? How do you make sure the users have a timely access to the latest update? This can be a serious issue, specially if you … Continue reading →

Posted in Dashboard | Tagged | 3 Comments

Data sources for Excel dashboards: avoid spreadsheet hell

Posted on May 26, 2008 by XLCubedBlog

This is the first of two twin posts where we’ll discuss the alpha and omega of Excel dashboards: data access and dashboard publication. These are two weak areas in Excel, and they should be approached carefully when planning for a … Continue reading →

Posted in Dashboard | Tagged , , | 3 Comments