Various methods of creating Digital Dashboards – Part 4

A very Good Dashboard Software for your Business. Try It!

Read about the

Type – 1 approach

Type – 2 approach

Type – 3 approach

Type 4: This type defines the method of creating dashboard using Excel. The data and presentation is all part of the Excel file. This is the most popular approach as it is very easy and affordable to create dashboards. It is the least favourable approach for the same reasons it is very popular.

Skills Needed:

  • Excel basics
  • Excel Macros
  • Excel charting techniques

Pros:

  • Quick prototyping
  • Affordable

Cons

  • Static dashboards
  • Non-scalable
  • No security
  • No data ownership
  • Bound with Excel Limitations

When should we use Excel as Dashboarding solution?

For small organizations or quick dashboard prototypes this is a very good option but as your reporting needs go beyond basic then you need start looking for some serious dashboard options.

This completes the analysis of different approaches for creating dashboards.

Check these related Dashboards

  • Various methods of creating Digital Dashboards – Part 2
  • Various methods of creating Digital Dashboards – Part 3
  • PHP Dashboards – Create Custom Dashboards – Totally Free
  • Various methods of creating Digital Dashboards – Part 1
  • Create Dashboards With PHP and Flex

  • Please rate it/strong>
    1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 3 out of 5)
    Loading ... Loading ...

    Create Excel dashboards quickly with Plug-N-Play reports.
    Post a Comment or Leave a Trackback

    One Comment

    1. Paulo Bastos
      Posted December 21, 2008 at 2:07 am | Permalink

      Sorry to say, but with a little more knowledge of excel, you can create a complete, pixel perfect, dashboards with filters, security (for example each sales regional manager only see his information). It can looks like an application. Only cons is not being web.

    Post a Comment

    Your email is never published nor shared. Required fields are marked *

    *
    *
    Dashboard Zone - Your online community for everything Dashboards