Excel 2007 Executive Dashboard with new excel cube functions and sparklines
Excel Dashboard Update: This short video shows you MicroCharts for Excel and Microsoft BI in action.
Dear Dashboard Spy: Here’s our latest dashboard using sparkline charts. We created an Excel 2007 based dashboard and a PivotTable for KPI Analysis. The first screenshot shows you a management dashboard for the Microsoft BI sample database Adventure Works. Bullet graphs and sparklines are created with MicroCharts formulas. The disjoint blocks of figures are done with the new Excel Cube formulas.
The second screenshot shows you a Excel Pivot Table for KPI analysis. The sparklines and bullet graphs enrich the KPIs, allowing you to see trends and patterns. The small graphs are done with the MicroCharts server extension. MicroCharts are calculated as strings within SQL Server and rendered as high quality TrueType fonts with the PivotTable or Reporting Services.
For the latest info on MicroCharts check out: http://www.microcharts.net/
Tags: Sparklines, Excel 2007 Dashboard, Enterprise Dashboard, Executive Dashboards, Excel DashboardsÂ
The Dashboard Spy Business Intelligence Dashboards Blog
Related Business Intelligence Dashboard Examples:
Those of you interested in Excel Dashboards should head over to the main Dashboard Spy site for ...
In past Dashboard Spy posts, we've discussed the growing importance of Microsoft Excel as a seri ...
Dashboard designers, actually information visualization gurus in particular, love the use of spa ...
You can download the Adventure Works dashboard here:
http://www.bonavistasystems.com/Articles_DashboardsWithExcel2007.html
Andreas Flockermann
http://www.microcharts.net
Note that if you are stuck with a prior version of Microsoft Office, XLCubed (http://xlcubed.com) is an extremely powerful (and relatively cheap) Excel add-in that provides both formula and grid access to Microsoft Analysis Services cubes. It also happens to work really well with MicroCharts – I had my company purchase licenses for both… As a side note, the possibilities offered by XLCubed grids are superior to those offered by Excel 2007 pivot tables, but that’s another story.
hey people, try this out visifire has amazing Sparkline charts powered by silverlight offered under open source just for free