Excel Dashboard.

In previous videos, I demonstrated the use of PowerView when creating dashboards. Now, I going to demonstrate dashboard creation with a more familiar tool, Excel. Despite the release of several visualization tools by Microsoft, Excel still represents Microsoft most common tool for dashboard development. In this video, I hope to demonstrate why this continues to be so.

Why Excel?

Excel has always been a jack of all trades tool. It’s been used by Project Managers, Accountants, Scientists, and of course, data analysts. The advantages that Excel presents as a dashboard tool is that although it may not be easy to use, its familiarity among non-IT users allow it to be leverage by Microsoft as a way to introduce new features with a familiar face.

I’m going to essentially create items that you typically find in dashboard. Separate data sources, filters, and various types of charts.

A very powerful data visualization tool

You can create almost any type of chart within Excel, using any type of data, save in various formats, and deploy to SharePoint with ease. I use all of the common report development tools that Microsoft has tool offer. Whether it be SQL Reporting Services, SharePoint PowerPoint Services, or PowerView, they all have some limitations. However, Excel can do many of the data features found in these technologies with a lot less resources. I will highlight some of these capabilities and how easy it is to create impressive dashboards with just a few clicks.

Click here to Download the Excel Document

Leave a Comment

Your email address will not be published. Required fields are marked *