If you are new here, you may want to subscribe DashboardZone
Read about the
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.
Loading ...
