The Dashboard Spy

January 25, 2007

Excel 2007 Executive Dashboard with new excel cube functions and sparklines

Filed under: Dashboard Screenshots — Tags: , , — dashboardspy @ 7:28 am

Some of you enterprise dashboard project members have not yet moved with the Dashboard Spy to his new url at so here is a clip of the types of enterprise dashboard posts that you’ve been missing. We’ve been covering dashboard issues such as sparklines and new excel 2007 cube functions.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.Sparklline Enterprise Dashboard Excel Cube FunctionsThe 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.Excel Pivot Table Dashboard SparklinesFor the latest info on MicroCharts check out: Sparklines, Excel 2007 Dashboard, Enterprise Dashboard, Executive Dashboards, Excel Dashboards

The Dashboard Spy Business Intelligence Dashboards Blog


  1. You can download the Adventure Works dashboard here:

    Andreas Flockermann

    Comment by Andreas Flockermann — January 26, 2007 @ 6:36 am

    • How can I get this dashboard?

      Comment by yongjae lee — April 25, 2013 @ 8:58 pm

  2. Hello Dashboard Spy. I enjoy your blog about executive dashboards. It is good to see such information. I have been studying this topic for many months now and am glad to see so many examples. I will visit your site often.

    I was very interested in seeing your post about “KPI Requirements for Dashboard Projects – Using the KPI.Thank you for the information about this dashboard topic. There is a dashboard project at work about this subject.

    The graphic is very nice. I like the colors and the questions are very interesting – What Question? Who’s Asking, Why is it Important, etc. I think it is very good. I also like the layout of the screen. I have a question about the boxes on the right side. Is the user supposed to type the answers to the questions into the boxes?

    Comment by Shylesh — November 21, 2007 @ 11:56 pm

  3. […] Read More Posted under DashboardSpy | […]

    Pingback by Excel 2007 Executive Dashboard with new excel cube functions and sparklines | Dashboard Examples - Samples - Tutorials — August 12, 2008 @ 9:20 am

  4. It’s an amazing paragraph in favor of all the online viewers; they will obtain advantage from it I am sure.

    Comment by Kristina Tschida — December 4, 2011 @ 4:59 pm

  5. […] Source Asked by n/a […]

    Pingback by tab-shape or round corner background in Excel — February 8, 2012 @ 1:46 pm

  6. you’re truly a good webmaster. The web site loading pace is amazing. It sort of feels that you’re doing any distinctive trick.
    Also, The contents are masterwork. you have performed a wonderful process in this topic!

    Comment by Daisy — September 16, 2012 @ 5:18 am

  7. Today, while I was at work, my cousin stole my iphone and tested to see if it can survive
    a twenty five foot drop, just so she can be a youtube sensation.
    My iPad is now broken and she has 83 views.
    I know this is entirely off topic but I had to share it with someone!

    Comment by Download Cubeworld — July 21, 2013 @ 7:52 pm

  8. Good day! Do you know if they make any plugins to protect against hackers?
    I’m kinda paranoid about losing everything I’ve worked hard on. Any

    Comment by top nike bot — July 8, 2014 @ 6:07 pm

  9. Hey! I’m at work surfing around your blog from my new iphone 4!

    Just wanted to say I love reading through your blog and look forward to all your
    posts! Carry on the superb work!

    Comment by based websites — October 1, 2014 @ 4:47 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

<span>%d</span> bloggers like this: