Excel Infographics
Dashboard Spy Topic: Excel Dashboard Example.
Excel dashboard guru Chandoo offers a download of an excellent infographic he created using Excel 2010. Did you know that Excel 2010 has sparklines? Take a look at this awesome excel dashboard done in an infographic poster style.
Visit his post to download the excel file: Sachin Tendulkar Statistics [...]
a
For more information visit Excel Infographics
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service
iDashboards Winter Olympics Dashboard
Dashboard Spy Topic: 2010 Winter Olympics Scorecard from iDashboards.
The dashboard gurus at business intelligence dashboard software vendor, iDashboards, are continuing their tradition of helping fans of the Olympic Games track the medal counts of the competing countries.
Take a look at this dashboard screenshot. Use this link to try out the interactive iDashboards Winter Olympics Dashboard for [...]
a
For more information visit iDashboards Winter Olympics Dashboard
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service
Go Back to School for Excel
Dashboard Topic: Excel School
The dirty little secret in business intelligence dashboards is that sometimes (and actually more often than you think!), Microsoft Excel is a perfectly fine choice of platform for a business dashboard.
And the even dirtier secret is that we business intelligence gurus are less adept at Excel than we should be.
Is it [...]
a
For more information visit Go Back to School for Excel
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service
7 Ways to Remain Relevant for Business Intelligence in 2010
This year, while saying “Happy New Year!”, I was also thinking “Good riddance!”. Face it, the year was a really rough one for many of you Dashboard Spy readers. Corporate earnings were horrible, revenues fell off a cliff, I.T. budgets got slashed, and many, many smart, hardworking people were downsized.
I personally attended goodbye lunch [...]
a
For more information visit 7 Ways to Remain Relevant for Business Intelligence in 2010
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service
Common Digital Dashboard Layouts
While business dashboards can adopt many distinct designs in terms of look and feel, there are a core number of basic layouts that they tend to follow. I suppose this comes from grid-based design in general and the prevalence of the template approaches in popular presentation layer technologies such as tiles and struts.
When designing custom layouts for dashboard applications built in-house or creating a custom layout in an off-the-shelf dashboarding software product, I tend to follow the 3 or 4 column approach with portlets of various sizes spanning the different columns as needed. Can’t picture what I mean?
Take a look at this dashboard layout picker from a dashboard software package (iDashboards 5.0).

What is your most commonly used layout? Do you mostly arrange portlets containing charts and graphs of various metrics and KPIs? If so, maybe you choose the 3×3 layout for 9 charts. More likely, you mix up wider portlets for text content.
It would be interesting to find out how these various digital dashboard layouts are ranked in terms of usage.
Click on the “read more” link below to see how the iDashboards software product handles the dashboard layout selection process. Screenshots of the dashboards can be found below.
Here is the sequence of actions for creating a new dashboard in iDashboards.
First, take a look at the default sales dashboard that comes with iDashboards:

As you see, it has a 3 column by 2 row configuration for the portlets. It has the following metrics:
- Top 10 Shipping Customers
- Market Share
- Sales by State
- Top 3 Products
- Sales Performance
- Sales by Province
Note the bottom leftmost section where you will find a “Menu” button. If you click it, you get the following panel where you can select a new dashboard and pick out the desired layout per the screenshot we saw earlier:
If you pick the 2 row layout, you will get the following dashboard template:

At this point, you can populate the top portlet of the dashboard with a graph.

Use the SQL Custom Query tool to select your data for the chart.

Here is the resulting chart in the top portlet of the dashboard:

Tags: iDashboards 5.0 Screenshot, idashboards layout configuration, digital dashboards
This is a post by The Dashboard Spy as part of the Dashboards By Example blog. Check out the following Business Intelligence resources:
Dashboards.TV
Dashboards by Example Volume 1
Business Intelligence White Papers
For more information visit Common Digital Dashboard Layouts
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, Featured, IT, Service
Excel Dashboard Tutorials
Excel for dashboards? Yes, Microsoft Excel is an excellent starting point for business intelligence visualization. It’s everywhere in the enterprise and is a good way to start an organization down the dashboard path.
Chandoo, the Pointy Haired Dilbert, consistently offers amazing Excel Dashboarding Tips over at his blog at chandoo.org. He has a set of 4 great excel dashboard tutorials contributed by one of his faithful readers, Robert from Munich. These excel dashboard lessons are great and come with downloadable excel dashboard worksheets.
Take a look at these screenshots and visit Chandoo for the corresponding lessons.
Post 1 – Implementing a Scrolling Excel Dashboard Table

Post 2 – Add Sorting to the Excel Dashboard

Post 3 – Add Percentile Information to the Excel Dashboard

Post 4 – Excel Dashboards for Data Visualization

Very nice job Robert and Chandoo. Thanks!
The Dashboard Spy
For more information visit Excel Dashboard Tutorials
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, Featured, IT, Service
Xcelsius TCO Dashboard
Dashboard Example: Xcelsius TCO Dashboard
Total Cost of Ownership (TCO) is a popular financial estimate used to assess costs (both direct and indirect costs). Typically, TCO analyzes the financial impact of deploying information technology (to take an example) over the entire life cycle. Depending on the IT deployment, factors such as the following are accounted for:
- End-user computer Hardware purchase costs
- Software license purchase costs
- Hardware and Software Implementation / deployment costs
- Hardware warranties and maintenance costs
- Software license tracking costs
- Operations Infrastructure Costs
- Infrastructure (floor space) costs
- Cost for electricity and cooling
- Network hardware and software costs
- Server hardware and software costs
- Testing costs
- Cost to upgrade or scalability
- IT Personnel costs
- “C” Level Management Time costs
- Backup and Recovery Process costs
- Costs associated with failure or outage
- Diminished performance incidents (i.e. users having to wait)
- Costs of security breaches (in loss of reputation and recovery costs)
- Technology training costs of users and IT staff.
- Audit costs
- Insurance costs
- Replacement costs
- Migration costs
- Decommissioning costs
The following example of an Xcelsius TCO dashboard is from myxcelsius.com, a blog dedicated to Xcelsius Dashboards.
The following is just a static screenshot. You can click on the dashboard thumbnail to enlarge the image, but visit the dashboard itself to try out all the interactive elements. There are plenty of controls that you can use to model total cost of ownership.
Tags: Business Objects Xcelsius Dashboard, TCO dashboards, dashboard example
Reference: Have you seen this new book on Business Objects Xcelsius 2008?
Crystal Xcelsius For Dummies (For Dummies (Computer/Tech))
For more information visit Xcelsius TCO Dashboard
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service
Data Visualization: Voting Down the Bailout
Use of color is the key to this data visualization. Take a close look and you’ll realize that the gray color indicates a “yes” vote. It shows not only who voted “nay” on the 0 billion financial bailout plan, but also shows the breakdown between the Republican and Democratic representatives.
This information graphic appeared on nytimes.com. View it at this link: The No Votes – Details on the House of Representatives Bailout Vote.
Click on the image below to enlarge the information visualization graphic:
For more information visit Data Visualization: Voting Down the Bailout
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, Featured, IT, Service
Washington State Economic Dashboard
As we saw with the Washington State Transportation Improvement Board Dashboard, Washington State takes the issues of accounting and transparency quite seriously.
They have a program called GMAP – Government Management Accountability and Performance. It was set up as an approach for the Governor and her cabinet agencies to track spending and tie it to performance. The business intelligence dashboard is a primary tool used by the various agencies to measure and manage their programs.
While some of the BI dashboards used are online (see above for the link to the transportation dashboard), others exist as powerpoint dashboards.
The powerpoint-based dashboard is titled The Next Washington and it consists of a series of slides with various metrics and economic indicators on them.
Here is a screenshot of one particular page with the “Economic Vitality Dashboard”. Click on the dashboard screenshot to enlarge it.
The powerpoint is distributed via email as well as posted on the State’s website.
Tags: Washington State Economic Vitality Dashboard, Washington GMAP Dashboard
For more information visit Washington State Economic Dashboard
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, Featured, IT, Service
Edward Tufte on the iPhone Interface
The iPhone interface offers advances in information resolution. It “elegantly solves the design problem of small screens by greatly intensifying the information resolution of each displayed page. Small screens, as on traditional cell phones, show very little information per screen, which in turn leads to deep hierarchies of stacked-up thin information – too often leaving users with “Where am I?” puzzles.”
Edward Tufte walks us through how the iPhone accomplishes this in his post and video published earlier this year titled “iPhone Interface Design”.
His basic message is that the Apple iPhone has great value as an interface because of the higher information resolution available to the end user. Computer information debris reduces information visualization resolution and steals content space away from the user. Edward Tufte lauds Apple’s approach of having the controls go away leaving the user to control the information right off the page by tapping and swiping.
When you visit the page, you’ll find that a large video will load. It’s worth the wait. Here are some screen captures from the video.
This screenshot shows an image on Edward Tufte’s iPhone gallery. It is an image with sparklines. Click on the image to enlarge it for more detail.
In this screen capture, you can see Edward Tufte’s finger as he swipes the screen to move the image.
Here is the stock market page from the iPhone. Note the level of the Dow Jones!
Here is an updated screenshot from the Dashboard Spy’s iPhone:
Don’t be fooled by all the green. Stocks are bouncing off their lows from the other day when the Dow Jones went below 8000!
For more information visit Edward Tufte on the iPhone Interface
Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT, Service







