110 likes | 227 Views
This module provides an in-depth overview of Filter Web Parts in SharePoint 2010, highlighting their role in enhancing Business Intelligence (BI) applications. Learn how Filter Web Parts can pull data from various sources on the page and send it to other web parts for dynamic filtering. We will explore nine out-of-the-box filter types and their integration with Excel Services, PowerPivot, and other BI services. Gain insights into developing custom filter web parts and creating a tailored user experience in BI environments.
E N D
SharePoint 2010 Business Intelligence Module 7: Filter Web Parts
Overview • Filter Web Parts
Lesson: Filter Web Parts • Filter Web Parts • Filter Web Parts & BI • Extensibility
Filter Web Parts • Filter web parts can pull data from anywhere on the page and send to another web part to perform filtering • 9 filter web parts out of the box • Many other 3rd party web parts support connections from filter web parts
Filter Web Parts • Nine out of the box filters: • Choice • Current user • UserProfile • Date • Page Field • Query String • SharePoint List • SQL Server Analysis Services • Text • BDC Filter web part was removed in 2010 • Filter Actions – a simple post back button to apply filters
Filter Web Parts & BI • Many of the other features of SharePoint can utilize Filter Web Parts • Excel Services & PowerPivot • Reporting Services • Business Connectivity Services • Performance Point • Charts & Maps • As we progress through the course we will use filter web parts every step of the way • We will create a user context focused reporting environment
Extensibility • Filter web parts are simply web parts • Web parts are easy to create • Filter web parts simply require an interface to be implemented that tells SharePoint it is a filter type web part • Developers can easily create more advanced filter web parts to further tailor your BI environment
Lab 1: Filter Web Parts • Use each of the Filter Web Parts
Lab 2: Filter Web Parts & Excel Services • Use Filter Web Parts to enhance Excel Services experience
Review • Your instructor will ask a series of questions on this module
Summary • Filter web parts are very powerful allies in the BI battle! • Use Filter web parts with other BI web parts to further customize the user BI experience • New filter web parts can be created to extend your BI functionality