1 / 52

Exploring Excel Services: Business Intelligence Solutions

Discover integrated business intelligence capabilities with Excel Services architecture. Learn to share and secure spreadsheets effectively.

shanna
Download Presentation

Exploring Excel Services: Business Intelligence Solutions

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. Excel Services Overview

  2. What Will We Cover? • Broad sharing of spreadsheets • Business intelligence capabilities • Excel services architecture

  3. Helpful Experience • Experience with SharePoint Server • Experience with Excel spreadsheets Level 200

  4. Agenda • Introducing Excel Services • Sharing Spreadsheets Securely • Exploring Excel Services Architecture

  5. Integrated Business Intelligence SQL 2005 Relational Database Management System BIPlatform

  6. Integrated Business Intelligence SSIS SQL 2005 Relational Database Management System BIPlatform

  7. Integrated Business Intelligence SSIS SSAS SQL 2005 Relational Database Management System BIPlatform

  8. Integrated Business Intelligence SSIS SSAS SQL 2005 Relational Database Management System BIPlatform SSRS

  9. Integrated Business Intelligence Microsoft OfficeSharePoint Server 2007 User Analysis(Excel) UserTools SSIS SSAS SQL 2005 Relational Database Management System BIPlatform SSRS

  10. Integrated Business Intelligence Microsoft Office Business Scorecard Manager 2005 AnalyticApplications Microsoft OfficeSharePoint Server 2007 User Analysis(Excel) UserTools SSIS SSAS SQL 2005 Relational Database Management System BIPlatform SSRS

  11. Office SharePoint Server PlatformServices Workspaces, Mgmt,Security, Storage,Topology, Site Model

  12. Office SharePoint Server Collaboration PlatformServices Workspaces, Mgmt,Security, Storage,Topology, Site Model

  13. Office SharePoint Server Collaboration PlatformServices Workspaces, Mgmt,Security, Storage,Topology, Site Model Portal

  14. Office SharePoint Server Collaboration PlatformServices Workspaces, Mgmt,Security, Storage,Topology, Site Model Portal Enterprise Search

  15. Office SharePoint Server Collaboration PlatformServices Workspaces, Mgmt,Security, Storage,Topology, Site Model Portal ContentManagement Enterprise Search

  16. Office SharePoint Server Collaboration PlatformServices BusinessProcesses Workspaces, Mgmt,Security, Storage,Topology, Site Model Portal ContentManagement Enterprise Search

  17. Office SharePoint Server BusinessIntelligence Collaboration PlatformServices BusinessProcesses Workspaces, Mgmt,Security, Storage,Topology, Site Model Portal ContentManagement Enterprise Search

  18. Microsoft Office Excel 2007 Excel 2007

  19. Microsoft Office Excel 2007 Excel 2007

  20. demonstration Demo • Exploring Excel 2007 Features • Work with Excel 2007 Data Connections • Create a PivotTable • Combine PivotCharts and PivotTables

  21. SharePoint Excel Services Excel 2007

  22. SharePoint Excel Services Thin renderingin browser Excel 2007 Customapplications

  23. SharePoint Excel Services Excel 2007

  24. SharePoint Excel Services Thin renderingin browser Thin renderingin browser Thin renderingin browser Excel 2007

  25. Demo demonstration • Designing a Simple Application • Create a Trusted Location • Save a Workbook to Excel Services

  26. Agenda • Introducing Excel Services • Sharing Spreadsheets Securely • Exploring Excel Services Architecture

  27. The Challenges of Ubiquity Lack of Control: No Centralized Management Data Overload: The Need for Business Intelligence Isolated Data: The Need for Logic Reuse and Integration Timeliness: The Need for Reliability, Availability, and Performance

  28. A Single Version of the Truth Centralization Enabling Secure Sharing of Spreadsheets Rich Tools Enabling Business Intelligence Shared Logic Enabling Reuse and Integration Server-Side Solutions Enabling High Availability and Performance

  29. Demo demonstration • Publishing a Distributor Price List • Organize SQL Server Data • Explore PivotTable Options • Publish the Pricing List

  30. Publishing Excel Workbooks Excel 2007

  31. Publishing Excel Workbooks Excel 2007

  32. Managing Workbook Permissions Excel 2007

  33. Managing Workbook Permissions • Spreadsheet User Rights • Administrator • Contributor • Reader • Viewer Excel 2007

  34. Managing Workbook Permissions Excel 2007

  35. Connecting to External Data Sources Excel 2007

  36. Connecting to External Data Sources Excel 2007 Data Connection Libraries

  37. Connecting to External Data Sources Excel 2007 • Discovery

  38. Connecting to External Data Sources Excel 2007 • Discovery • Management

  39. Connecting to External Data Sources Excel 2007 • Discovery • Management • Security

  40. Connecting to External Data Sources Excel 2007 • Discovery • Management • Security

  41. Authenticating External Data

  42. Authenticating External Data None

  43. Authenticating External Data None SSO

  44. Authenticating External Data None SSO Windows Authentication

  45. Managing Workbooks Excel 2007

  46. Managing Workbooks Administrator

  47. Managing Workbooks Excel 2007 Thin renderingin browser

  48. Session Summary • Rich, secure access to spreadsheets • Easy connection to live data sources • Enterprise solution for spreadsheets

  49. For More Information Visit TechNet at:www.microsoft.com/technet Visit the following site for additional information: www.microsoft.com/technet/dsk-110

  50. Heard the News About TechNet? • Software without time limits • Complimentary technical support • The most current resources on hand www.microsoft.com/technet/subscriptions

More Related