Just Announced SPTechCon Tutorials

Simple (but effective) dashboards in SharePoint

Simple (but effective) dashboards in SharePoint

by: Matt Wade

One of the more common requests I get about putting SharePoint to good use is how to build a hyper-responsive, beautifully designed, amazingly cogent dashboard displaying all the key performance indicators (KPIs), report updates, big data analyses, and business intelligence of the day.

Feel free to add in whichever new synergistic buzz phrase is relevant to metrics; I've probably been asked for that too.

There's no doubt that big-picture score sheets can be remarkably helpful to get your point across, and one that's pleasing to the eye helps everyone understand it better, especially upper management.

Sure, you can incorporate a lot of this into SharePoint, and my favorite method is using Excel and displaying the dashboard directly on a SharePoint page.

Embedding an Excel spreadsheet is far from the only way to do a dashboard in SharePoint, but it's definitely one of the easiest to implement quickly since most people have a basic understand of how Excel works. 

But for every dashboard request I get, I send a word of caution: dashboards are only as good as the data they represent. A pretty dashboard with minimally valuable data and content isn't worth the time or energy required to create or maintain it. Tread carefully and make sure there's value in moving forward with a dashboard.

Read more..

View all Blog
Loading

Random image

SPTechCon will be held at the Sheraton Boston Hotel

Take advantage of special discounted room rates at the Sheraton Boston - only US $189 per night for single/double occupancy

Rooms for the reduced rate are limited! Click Here to make your hotel reservation or use the "Make Hotel Reservation" link on the confirmation page of your registration

Reservations at the reduced rate can be made through 5:00 PM Eastern time on August 15th, 2018 - assuming they don't sell out. The number of rooms in the discounted block is LIMITED and historically rooms sell out well before the deadline. Don't wait until the last minute to reserve your hotel room!

Book Now

 

Location building image