720 likes | 1.02k Views
Microsoft Office SharePoint Server. Agenda. Microsoft Office SharePoint Server 2007 Core features Content Management Business Intelligence Business Process Management Portal Collaboration Search Q & A. Introduction. About Inetium ( www.inetium.com )
E N D
Agenda • Microsoft Office SharePoint Server 2007 • Core features • Content Management • Business Intelligence • Business Process Management • Portal • Collaboration • Search • Q & A
Introduction About Inetium (www.inetium.com) Bloomington, MN based Microsoft consulting company New office in Omaha, NE Microsoft Gold Certified Partner Practice area focused on Information Worker Technologies Minnesota SharePoint User Group Sponsor www.sharepointmn.com
Microsoft Office SharePoint Server 2007 (MOSS) • Major component of Office System 2007 • Web platform • Clients talk to servers • Business Intelligence • Business Process • Content Management • Search • Portal • Collaboration
Single Infrastructure for Intranet, Internet, and Extranet Portals SharePoint as a Platform • Single infrastructure • Multiple scenarios
Intranet Portals Extranet Portals Business Process Business Intelligence Public Internet Sites Composite Applications
Core Platform • Web site platform • Libraries and Lists • Web parts • Security • Configurable • Customizable
General Improvements • Navigation • Breadcrumb • Improved views • Item level security • Security trimmed UI • Better menu’s • Recycle Bin • Offline • RSS • Much more!
Collaboration DiscussionsCalendarsE-MailPresenceProject MgtOffline Content Mgt AuthoringApprovalWeb PublishingPolicy & AuditingRights MgtRetentionMulti-LingualStaging Portal MySitesTargetingPeople Finding Social NetworkingPrivacyProfiles Site Directory Search IndexingRelevanceMetadataAlertsCustomizable UX BPM Rich\Web FormsBiz Data CatalogData in ListsLOB ActionsSingle Sign-OnBizTalk Integ. BI Excel ServicesReport Center KPIsDashboardsSQL RS\AS Integ. Data Con. Library Core Services Management DelegationProvisioningMonitoringStaging Security Rights\RolesPluggable Auth.Per ItemRights Trimming Storage RepositoryMetadataVersioningBackup Topology Config. Mgmt.Farm ServicesFeature PolicyExtranet Site Model RenderingTemplatesNavigationVisual Blueprint APIs Fields\Forms OM and SOAPEventsDeployment Web Parts | Personalization | Master Pages | Provider Framework (Navigation, Security…) Database services Search services Workflow services Operating System Services
What is Content Management? • The ability for end users to manage content in a variety of forms online without necessarily having to enlist IT to do so. Content Management
Content Management in the Office System • Document Management • Metadata – Profiling documents • Integration with Office – Document information panel, document action bar • Records Management • Policy and Auditing – Retention schedules and policies • Records Repository site template – Records vault • Web Content Management • Corporate Internet Site Template – Public facing • Authoring and Approval – Publishing schedules, routing, approval Content Management
Document Management on the Server • SharePoint is the backend • Metadata • Workflow • Security Content Management
Document Management using the Client • Office provides document information panel • Metadata • InfoPath form • Improves visibility • Can be branded • Document publishing Content Management
Slide Management using PowerPoint • SharePoint • Publish slides • Build slide deck automatically • Metadata Content Management
Records Management • Customized retention policies • Holds • Audits Content Management
Creating Records Management Policies • Audits • Workflows • Expiration dates Content Management
Web Content Management • End user driven • Rich text editor • Publication date • Approval workflow Content Management
Web Content Management • End user driven • Rich text editor • Publication date • Approval workflow Content Management
Web Content Management Scenarios • Public facing website • Intranet home page • Corporate communications • Extranet collaboration Content Management
What is Business Intelligence? • Improved visibility of information to make better business decisions via analysis and reporting • Answering one question often drives more questions • Often brings data together from multiple systems Business Intelligence
Office 2007 Business Intelligence Investments • Excel client • Excel Services • Dashboards • Key Performance Indicators (KPI’s) • Filter Web Parts • Report Center/Report Library • Business Data Catalog (BDC) Business Intelligence
Excel Services – What is it? • New server technology in MOSS 2007 • Load, calculate and display Excel Workbooks in MOSS 2007 • Thin client view in browser • Published workbooks can connect to external data • Designed to cut down on proliferation of Excel files Business Intelligence
Excel 2007 Excel 2007client Customapplications Excel Services – How does it work? Thin renderingin browser View and Interact Author and Publish Spreadsheets Open Spreadsheet/Snapshot Web ServicesAccess Authoring Exploration and Consumption
Example – Publishing from Excel to Excel Services • End user creates spreadsheet in Excel 2007 • Publishes it to SharePoint Excel Services • Configures the view of the spreadsheet in SharePoint Business Intelligence
Example – Create spreadsheet in Excel 2007 Business Intelligence
Example – Publish to Excel Services Business Intelligence
Example – Connect Excel Web Access Web Part Only shows published sheet Business Intelligence
Business Data Catalog • Expose Data to SharePoint • Custom Line of Business Data • Database or Web Services • Can be used as metadata • Automatically provides lookup functions Business Intelligence
Business Data Catalog Business Intelligence
The Report Center • Report site template • Houses reports • Includes • Excel Services • KPI lists • Report calendar • Data connection library Business Intelligence
Key Performance Indicator (KPI) List • List template • Graphically displays KPI’s • Use to track metrics • Data from multiple sources • SharePoint Lists • Excel Services • SQL Analysis Services 2005 • Manually entered Business Intelligence
KPI Web Part • Displays KPI’s in SharePoint List Detail Business Intelligence
Filtering Data in SharePoint • Used to filter data • Multiple filter types • Authored List • Business Data Catalog • Current User • Date • Query String (URL) • SharePoint List • SSAS • Text Business Intelligence
Bringing it all together in SharePoint Filters Excel Services KPI’s Business Intelligence
Business Intelligence Scenarios • Operational dashboard • Departmental dashboard • Balanced scorecard • Individual performance KPI list Business Intelligence
What is Business Process Management? • Automation of processes via workflow and digital forms Business Processes
Office 2007 Digital Forms Landscape • Microsoft Office InfoPath 2007 • Client application for designing forms • Smart Client for filling out forms • Microsoft Forms Server (Part of Microsoft Office SharePoint Server) • Allows you to fill out forms via Web and Mobile • Improved Workflow Integration • Managed forms templates to host trusted forms • Manage Data Connection Files Business Processes
InfoPath 2007 Improvements • Web capabilities • Mobile capabilities • Integration with Outlook • Word and Excel conversion • Template Parts • Connection to workflow Business Processes
Forms Server • Web based • Mobile • Workflow • Design once • Some features Don’t work Business Processes
Workflow in the Office System • SharePoint libraries / lists have Workflow • Office 2007 clients connect to workflow Business Processes
Workflow in the Office System • Office 2007 clients connect to workflow • Users can take action in client tool Business Processes
Workflow Options LOB Integration (BizTalk) Visual Studio and Workflow SDK Purchase Order Processing Custom Tracking Apps Service Requests Asset Tracking SharePoint Designer Workflows Document Processes Spec Review Weekly Status Report Structured Ad Hoc Custom Form Actions Email Notification Exception Handling Server Features List Moderation Publishing Process Document Expiration Translation Process Document Review (parallel) Out-of-the-Box Solutions (with customization) Ringi (eApproval) Task & Issue Tracking (WSS, Access, & Project) Document Approval (serial) Custom Routing Signature Collection Business Processes
Using SharePoint Designer to Write Workflows Business Processes