Recovery Act Data Dashboard from MicroStrategy

Dashboard topic: Recovery Act Dashboard from Microstrategy. The Recovery Act (The American Recovery and Reinvestment Act of 2009) was signed into law on 2/17/2009 by President Obama and is an unprecedented effort to jumpstart the economy. Recovery.gov was set up to provide transparency for Recovery Act spending.

This week, the Recovery Accountability and Transparency Board and the Office of Management and Budget is hosting a national online dialogue to engage leading information technology vendors, thinkers, and consumers in finding approaches to ensure that all citizens can monitor the expenditure and use of recovery funds. Participants will recommend, discuss, and vote on the best ideas, tools, and approaches at Recovery.gov.

Microstrategy has submitted an information dashboard to the Recovery.gov site to be used as a tool for government agencies to provide greater transparency into their use of the recovery funds. This Recovery.gov Dashboard provides a way for government agencies to streamline their own reporting of how much money is being spent on what programs.

Let’s take a look at some screenshots of this Microstrategy dashboard:

Recovery Act Dashboard by Microstrategy

Recovery.gov dashboard

Microstrategy dashboard

Try out the Microstrategy dashboard for yourself.

>>>
Start your own blog about dashboards and business intelligence!
Visit dashboards.org

Visual Design Guidelines for Geographical Data Visualization Dashboards

We business intelligence dashboarders have been taken advantage of the relative ease of incorporating maps and geographic location information into our business dashboards more than ever. Remember how expensive geographic information systems used to be and how arcane a science it was? Well, now there are plenty of free APIs that you can incorporate into your mashup dashboards.

However, Stephen Few reminds us in his latest newsletter Introduction to Geographical Data Visualization that we must follow certain visual design guidelines or risk creating confusing “stories” when incorporating maps into our information visualizations.

The opportunity that many of us now have to display quantitative information on maps offers great potential, but only if we know and follow a few simple visual design guidelines. This article will help you design displays that clearly feature quantitative data in the context of geography, and will suggest ways to extend your analytical reach by coordinating the use of maps and graphs together in complementary and seamless ways.

Here’s a sample chart he provides as a sample of something that just doesn’t work. You can’t just slap what you are doing on your current data visualizations onto a map. Note how difficult it is to compare bars from different charts (unless they are close to each other).

geographic data visualization

Here’s an example of a dashboard done right in terms of bringing in a geographic location data visualization to fully flesh out the story being told. This dashboard shows house price trends:

house sales dashboard

Taking Data Chart Minimalism Too Far

Show the data and nothing but the data, right? We’ve all seen the trend towards minimalism in our charts and graphs. Sometimes this results in business dashboards populated by mysterious and tiny scratchings that only a true data visualization expert can understand.

In the recent issue of his Visual Business Intelligence Newsletter: Sometimes We Must Raise Our Voices, Stephen Few explains what he calls a “rare disagreement” with the principles of graph design as espoused by Edward Tufte (See The Visual Display of Quantitative Information
).

Few begins with an explanation of the title of this issue:

When we create a graph, we design it to tell a story. To do this, we must fi rst fi gure out what the story is. Next, we must make sure that the story is presented simply, clearly, and accurately, and that the most important parts will demand the most attention. When we communicate verbally, there are times when we need to raise our voices to emphasize important points. Similarly, when we communicate graphically, we must find ways to make the important parts stand out visually.

He then tells the importance of Edward Tufte’s work on his own career path.

My original thinking about graph design was formed almost entirely by the work of Edward Tufte. I owe him not only for the formative development of my knowledge, but also for inspiring me to pursue this line of work in the first place. I left his one-day seminar over 10 years ago with my mind ablaze and my heart beginning to nourish the kernel of an idea that eventually grew into my current profession. Even after many years of working in the field of data visualization, which has involved a great deal of experience and study that has expanded my expertise into many areas that Tufte hasn’t specifically addressed, I have only on rare occasions discovered reasons to disagree with any of his principles. The topic that I’m addressing in this article, however, deals with one of those rare disagreements.

Now, isn’t that an interesting setup? Steve’s writing is always superb and the reason why I subscribe to his newsletter. Visit the Perceptual Edge site for details.

Getting back to the disagreement with Tufte, Few has some issues with carrying the idea of minimalism too far. He explains Tufte’s concept of keeping the Data-Ink Ratio high and minimizing Non-Data ink on a chart.

Data Ink Ratio

There are 2 graph design principles closely related to the Data Ink Ratio concept.

Erase non-data ink (within reason)
Erase redundant data-ink (within reason)

Few is in complete agreement with the first rule, but has problems with the second rule about erasing redundant data-ink.

He presents a series of charts based on Tufte examples where he shows the danger of taking the minimalist approach too far. Each successive chart shows an increasing level of minimalism (is that me speaking in an extremely backassward way or what?)

Ed tufte chart

Tutfe Few Graphs

Tufte minimal chart

Stephen Few demonstrates Tufte Data Ink Concept

and here is an alternative by Stephen Few:

Clear data visualization by Stephen Few

Read his post for his explanations of why Tufte’s charts may take data-ink redundancy removal too far.

Tags: Data Visualization, Stephen Few, Edward Tufte

Dashboards

A Dashboard Blog of Your Own

Dashboard Spy readers are invited to start their very own blog. It’s an easy and fun way to connect with the business intelligence community and promote your company or your self. Whether you want to blog about dashboards, business intelligence, metrics, management or anything else you’d like to rant about, you’re welcome to claim your own subdomain at dashboards.org.

I’ve set up a blogging and social networking community called Dashboards.org that will allow you to not only to blog with a cool yourname.dashboards.org web address, but also to set up a profile and connect with other business intelligence practitioners.

Blogs are free (advertiser supported) and the collection of unique business intelligence related themes are growing everyday.

Please visit today and help grow the community. I look forward to reading your blog.

Here are some of the themes available for your blog:

World Data Map Dashboard Blog Data Cube Dashboard Blog Data Pyramid Dashboard Blog Dial Gauge Dashboard Blog Green Charts Dashboard Blog Purple Pie Chart Dashboard Blog Arrow Up Trend Dashboard Blog

Yellow Boxy Dashboard HTML Template

The last two Dashboard Spy templates have been very popular. Thanks for the positive comments! I’m glad you’re using them to mock up your business dashboard projects. A Dashboard Spy newsletter subscriber wrote me asking if I would provide a dashboard template that dealt with the browser size issue. Typically, in a corporate environment, we have the luxury of being able to dictate a screen resolution and browser. More than likely, it’s Internet Explorer running at a 1024 pixel width, followed by 800 pixel width. This dashboarder, however, needed a design that would work on a business scorecard meant for a general web audience.

I came up with the Yellow Boxy Dashboard HTML Template. As you can see, it’s one of those “float in the middle with a fixed width” type of designs that is so popular with blogs and such these days.

Hope it’s useful to you.

To get this free dashboard html template, just sign up for the Dashboard Spy newsletter if you’re not already on the list. Use the sign up form below the screenshot of the dashboard. You’ll get dashboard templates, dashboard examples and other helpful business intelligence resources. For those Dashboard Spy readers who have signed up previously, you’ll receive this template automatically as part of your subscription.

Yellow Boxy Dashboard Template

tags: Dashboard Templates

SAS Dashboards on Nintendo Wii

Think you can get away from the pressures of business intelligence dashboards by hiding in your den and playing video games on the Nintendo Wii? Think again because SAS announced today that they are bringing SAS Dashboards to the Nintendo Wii platform. It seems that the product team at SAS feels that the Wii’s innovative remotes can be put to great use for data mining. Hyperactive business users will be able to scroll through big data tables by swinging the wii-motes from side to side and up and down.

Here’s the announcement as it appeared on the 4/1/09 issue of The SAS Dummy blog titled Announcement: SAS on the Wii.

SAS Wii Announcement

Amazing, isn’t it?

Tags: Business Dashboards Invade Video Game Platform, Nintendo Wii Dashboard, Sas Wii