1 / 12

SharePoint 2010 Business Intelligence

SharePoint 2010 Business Intelligence. Module 3: Business Intelligence Center. Overview. Business Intelligence Center. Lesson: Business Intelligence Center. Business Intelligence Center KPIs Dashboards BI Integration Points. Business Intelligence Center.

connor
Download Presentation

SharePoint 2010 Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SharePoint 2010 Business Intelligence Module 3: Business Intelligence Center

  2. Overview • Business Intelligence Center

  3. Lesson: Business Intelligence Center • Business Intelligence Center • KPIs • Dashboards • BI Integration Points

  4. Business Intelligence Center • Included as part of SharePoint Server Site Definitions • Standard site definition with prebuilt dashboards and Key Performance Indicators • Can add multiple dashboards and KPIs • Can be used as the starting point for building your corporate BI Portal • Many BI features can be activated on a non-BI Center site definition (Team Site)

  5. Dashboards • A simple ASPX page in a library • Has a special content type tied to it • Can be locked down via SharePoint Permissions • Can contain any number of: • Key Performance Indicators web parts • Business Data catalog web parts • Excel Services Web Parts • Reporting Services web Parts • Designed to show data for a particular process • Sales Dashboard • Manufacturing Dashboard • Operations Dashboard

  6. Key Performance Indicators (KPI) • A list type that renders various images that display the status of a particular measured event • Can point to any number of data sources • SharePoint list • Excel Cells • SQL Server Analysis Cubes • Manual Entry • Can be customized to use your own images

  7. BI Integration Points • Don’t let it fool you • BI Center is just a SharePoint site! • Its up to you to make it a BI Site! • Reporting and Analysis Services (.rdl files and web part) • Excel Services with PowerPivot (.xlsx files and web part) • Performance Point integration (discussed later) • Filter Web Parts (used to filter report data and implement user context) • Visio and Access Services • Business Connectivity Services (BCS) • GeoSpatial Data with Charts and Maps

  8. What’s to Come • The Business Intelligence Center will be the center point of the course • As we move through the various modules, you will build components that will be added to the BI center, hence why we have introduced you to it here

  9. Lab 1: Business Intelligence • Explore BI Center • Dashboards • Key Performance Indicators

  10. Discussion • What does your BI portal look like today? • What should it look like tomorrow?

  11. Review • Your instructor will ask a series of questions on this module

  12. Summary • Use the Business Intelligence Center as your enterprise reporting portal for ALL users • You have to make it “BI”, it really is just a simple SharePoint site out of the box • Utilize KPIs for quick and easy decision making by your executives • Get more specific BI using all the great technologies provided by Microsoft and SharePoint 2010

More Related