Various methods of creating Digital Dashboards – Part 4

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.

Comments are closed.