Microsoft Excel 2007 Video on Business Intelligence

You’ve got to watch the Channel 9 video at http://channel9.msdn.com/Showpost.aspx?postid=164396. As Charles Torre (Microsoft Technical Evangelist) says in his post, “Is there any business intelligence out there? Mike Arcuri, group program manager on the business intelligence team shows off Excel 12’s new features for looking at how your business is doing.”

The video is a must-watch for seeing how Office 2007 and Excel 12 in particular will make business intelligence even easier to obtain. Excel will contain dashboard features! Arcuri defines a dashboard as “a bunch of parts that show relevant, related information in a coherent way, on the same screen.”

Arcuri presents the features via a business scenario. It is a non-technical discussion that all business users should listen to. It concentrates on “what’s going on” and “why”.

I’ve captured some stills of the dashboard from the video.

Here is the main page from the demo. It’s a Sharepoint page with webparts:

Dashboard web parts

This next shot shows the Business Scorecard webpart (powered by the Business Scorecard Manager):

Business Scorecard Web Part

This tool tip shows an out-of-line data point:

Excel 12

The chart web part with image rendered by Excel Services:

Chart Webpart Excel Services

The web part containing the live Excel workbook bound to external data (SQL Analysis Services)”

Excel Webpart

Here are some configuration options for dashboard presentation elements:

Excel12 icons 

 

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of business dashboards. He could not find any executive dashboard design source books and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books.

Leave a Reply