![Page 1: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/1.jpg)
![Page 2: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/2.jpg)
![Page 3: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/3.jpg)
![Page 4: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/4.jpg)
![Page 5: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/5.jpg)
6
What is Business Intelligence?
Business Intelligence (BI) is about getting the right information, to the right decision makers, at the right time.
BI is an enterprise-wide platform that supports reporting, analysis and decision making.
BI leads to:
fact-based decision making
“single version of the truth”
BI includes reporting and analytics.
![Page 6: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/6.jpg)
7
• What happened?
• What is happening?
• Why did it happen?
• What will happen?
• What do I want to happen?
ERP CRM 3PtySCMBlack
books
Past
Present
Future
Data
![Page 7: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/7.jpg)
8
Improving organizations by
providing business insights
to all employees leading to
better, faster, more
relevant decisions
Advanced Analytics
Self Service Reporting
End-User Analysis
Business Performance Management
Operational Applications
Embedded Analytics
Microsoft Business Intelligence Vision
![Page 8: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/8.jpg)
![Page 9: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/9.jpg)
Business User Experience
Data Infrastructure and BI Platform
Analysis Services
Reporting Services
Integration Services
Master Data Services
Data Mining
Data Warehousing
Business Collaboration Platform
Dashboards & Scorecards
Excel Services
Web based forms & workflow
Collaboration
Search
Content Management
LOB data integration
Familiar User Experience
Self-Service access & insight
Data exploration & analysis
Predictive analysis
Data visualization
Contextual visualizationBusiness Collaboration Platform
Data Infrastructure & BI Platform
Get more out of the products you own
![Page 10: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/10.jpg)
![Page 11: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/11.jpg)
![Page 12: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/12.jpg)
![Page 13: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/13.jpg)
![Page 14: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/14.jpg)
Share Diagrams in SharePoint
• Visualize your business intelligence with Visio diagrams
• Diagrams can be viewed without having Visio client installed
• Full Fidelity rendering with Silverlight, or PNG
Connect Diagrams to Data
• Use data graphics to build front ends for your real-time business
intelligence solutions
• Diagrams can be connected to various Data sources
Build Dashboards
• Use Web Part Connections to integrate with other SharePoint web
parts
• Use the Mashup API to fully customize your dashboards and
manipulate data
![Page 15: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/15.jpg)
1 hour later… Top Features:
Diagrams all live in SharePoint
Diagrams viewable in the
browser
Diagrams created once only
Diagrams containing data
graphics are refreshable
Diagrams give data context and
improve insights into the state
of a system
![Page 16: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/16.jpg)
![Page 17: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/17.jpg)
Visio Services
JavaScript Object
Model
• Enables diagrams
to participate in
mash-up
applications.
Custom Data
Providers
• Enables refresh
from non-native
data sources.
Custom Data
Graphics
• Enables the
refresh of non-
native data
graphic shapes.
Web part
connections
• Consume and
provide
information
between Visio
services and web
parts
![Page 18: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/18.jpg)
![Page 19: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/19.jpg)
![Page 20: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/20.jpg)
![Page 21: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/21.jpg)
External Data Sources
REST APIExcel Web
Services
Excel Web
Access JSOM
SharePoint Content Database
XLSX / b / m
User-Defined
Functions Excel Calculation Service
Excel Proxy
![Page 22: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/22.jpg)
![Page 23: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/23.jpg)
Provides a browser based view of Excel
Allows interaction within the Excel WorkbookExpand / collapse Pivot Table, Sorting, Filtering, Parameters
EWA integration with SharePoint filters enable Excel based dashboards
Excel Web App
![Page 24: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/24.jpg)
![Page 25: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/25.jpg)
![Page 26: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/26.jpg)
![Page 27: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/27.jpg)
![Page 28: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/28.jpg)
http://server/_vti_bin/ExcelRest.aspx/Shared%20Documents/File.xlsx/Model/Ranges(‘Sheet!A1’)
Handler – the ASPX that handles all
Excel Services REST requests
Name of the file as you would
access it in SharePointPath inside the
workbook.
Resource Name Allows access to…
/Model The workbook (the binary or the available feeds)
/Model/Ranges List of named ranges in a workbook (some of them)
/Model/Ranges(‘RangeName’) Specific range.
/Model/Charts List of charts
/Model/Charts(‘ChartName’) Specific Chart
/Model/Tables List of tables (Lists)
/Model/Tables(‘TableName’) Specific table
/Model/PivotTables List of PivotTables
/Model/PivotTables(‘PivotName’) Specific PivotTable
![Page 29: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/29.jpg)
![Page 30: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/30.jpg)
![Page 31: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/31.jpg)
![Page 32: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/32.jpg)
![Page 33: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/33.jpg)
![Page 34: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/34.jpg)
![Page 35: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/35.jpg)
![Page 36: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/36.jpg)
![Page 37: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/37.jpg)
![Page 38: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/38.jpg)
![Page 39: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/39.jpg)
![Page 40: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/40.jpg)
![Page 41: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/41.jpg)
![Page 42: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/42.jpg)
![Page 43: LeaderQuest SharePoint Business Intelligence Presentation](https://reader033.vdocuments.us/reader033/viewer/2022051816/547095e7b4af9fb90a8b47ec/html5/thumbnails/43.jpg)