Excel Dashboard it is like presentation or visualization using Monthly/Half-yearly/ Yearly data. Along with this I have included Excel Dashboard Tutorial from youtube video.
Data is primary source.
Role of Tools..
Excel has very good features to build very good Dashboard. First we discuss features, and later we discuss about why you need to learn new reporting tools.
Reporting tools means these tools help you generate report or Dashboard quickly and interactively.
Where EXCEL is good..
Below are the top 4 areas..
- Less expensive
- Ready to use
- Backward compatibility
- Less turnaround time
You know that the excel product cost cheaper compared to other Tools.
2. Ready to use
You need less customization. Excel is almost ready to use Tool. You do not need critical skills. It is is easy to learn. You can develop your own dashboards or reports quickly.
3. Backward Compatibility
No need to worry about new versions. You always have option to get compatibility. So, if any new version comes just you can adopt quickly.
4. Less Turnaround Time
VB Script is not so complex. You can learn and apply in less time. Any dashboard or report you can develop quickly. No need to worry about delay of development.
Excel Dashboard Youtube..
Where Tools come into picture..
Excel is a good reporting or Dashboard development tool – there is no doubt about it.
Here, it has some negative features.
Negative means, not useful for some applications.
- You cannot use Excel as a full-fledged database
- Not fit for Enterprise level reporting
- You cannot use it as a full-fledged software
- Lack of intelligence
See the details..
1. You cannot use Excel as a full-fledged database
In reality, excel is a flat file.
It is not a database. So it has some limitations. You cannot apply complex SQL queries. This is the reason tools like Tableau, QlikView etc came into picture.
2. Not fit for Enterprise level reporting
Yes, not suitable.
The issue comes, when you integrate all small applications into one application.
It is good for all stand alone applications.
3. You cannot use it as a full-fledged software
Yes, you cannot use it as a full-fledged software. Adding more options causes your excel application becomes bit heavy and so you cannot use it as a full-fledged software.
4. Lack of intelligence
You cannot use Excel to predict the scenarios based on your data. This is one of the big drawback. Since in most advanced tools, they have feature like Artificial intelligence.
I welcome your comments.
- Excel Dashboard features Why you need to learn reporting Tools
- How to Convert Excel into XML easy steps
- How to find duplicates in a Column using Excel