Well, better late than never, as I’m too fond of saying. In this series, you’ve seen how you can use some DVWPs, jQuery (and simple JavaScript), and the SharePoint Web Services to build a pretty slick and complex application.

I left you with the details of how one of the Data View Web Parts (DVWPs) – sections A and B below – on the dashboard worked by using an AggregateDataSource, values passed in on the Query String, and complex links to other functionality. In this article, I’ll talk about the DVWP in section C.

Earlier this month, Christophe Humbert led a live online workshop on how to create miniature inline charts and graphs with Sparklines and jQuery.

I showed how I used my jQuery Library for SharePoint Web Services to improve data quality by enhancing an out of the box form using the SPRequireUnique, SPDisplayRelatedInfo, and PreSaveAction functions. In this installment, I’ll show you how I created part of the nice dashboard-like page to display the current state of things to each Project Manager using Data View Web Parts (DVWPs).

This is yet another blog post on comparing dates in XSL in a data view web part.

SharePoint is really a collection of capabilities. At its heart, it is a Portal that exposes information customized for a particular user. It has extended functionality to quickly build features inside this portal to enable Enterprise Content Management and Enterprise Search. It has ventured into Social Computing and Collaboration by creating shared work spaces, supporting blogs and wikis and allowing people search. With the inclusion of PerformancePoint in its licensing, it also becomes a strong Business Intelligence offering, though it will require expanded knowledge of that capability to implement. It starts to break down when pushed to work as a Business Process Management Suite or Application framework.

You have now connected a SharePoint filter to a single workbook that contains multiple worksheets with multiple pivot tables and are driving all of the pivot table filters with one single filter from the SharePoint Dashboard.

Most organizations have been using Excel to do analysis, create charts and design dashboards for years, yet there is a lot of functionality in Excel that is not easily accessed in SharePoint, sometimes even for those with Excel Services. The question becomes, how does one translate their work from Excel to SharePoint? This means more than linking to an Excel workbook in a Document Library; rather, it requires displaying the charts and dashboards directly within SharePoint.

Although implementing a KPI dashboard like this one might look complicated it is not. By using the Data View Web Part you can create your own dashboards plus extras. The solution does not do anything special (only displays colorful icons) but your managers will love it.

Laura Rogers is putting the finishing touches on her “SharePoint Site Permissions Dashboard” solution. In this screencast, she shows how you can setup the dashboard to show permissions levels on multiple sites, access the permissions management screen, and have direct access to each group or person to manage their settings.