Microsoft Office Tutorials and References
In Depth Information
What if Visio diagrams came alive? Can they be powered by data in real time? The answer is yes! Visio Services
became available as part of the SharePoint 2010 Enterprise edition, allowing you to connect real-time data and
update your Visio diagrams on the fly. Share and view published Visio diagrams using the Visio Web Access Web Part,
which provides the functionality to integrate Visio diagrams into the SharePoint platform. With a basic knowledge
Services and SharePoint 2013 enhancements in Chapter 2.
Reporting Services and Power View
A lot of new functionality was added to Reporting Services in SharePoint 2010. New features included support for
claims-based authentication and user tokens, deployment utilities, support for multiple languages, and connectivity
with list and document libraries.
Power View, a SQL Server 2012 Reporting Services feature introduced initially for SharePoint 2010, is a reporting
tool meant primarily for business users. With Power View, you can create highly interactive, presentation ready
reports that literally bring data to life.
Learn more about enhancements to Reporting Services and SharePoint 2013 in Chapter 3.
With SharePoint 2010, PerformancePoint Services became available as an integrated part of the SharePoint Server
Enterprise license. You could consume context-driven data, build dashboards with the help of the built-in Dashboard
Designer, and take advantage of KPIs and scorecards. Data from various sources could be integrated using SSIS,
loaded using SSAS, and finally published into SharePoint. Support for SharePoint lists and Excel Services were
additional benefits. The Rich Internet Application(RIA)-enabled Decomposition Tree allowed you to drill down into
SharePoint 2013 introduces some useful enhancements to PerformancePoint Services, which include dashboard
migration features, support on iPad, BI Center Update, and more.
Learn more about PerformancePoint Services in Chapter 4.
Excel and PowerPivot
Excel Services also became available as part of SharePoint Server 2010 Enterprise licensing, with support for
multiple data sources aggregation in a single Excel workbook. Excel Services allowed these workbooks to be accessed
as read-only parameterized reports via the thin web client. You could choose to expose the entire workbook or only
portions of it, such as a specific chart or a specific pivot table. Content in Excel could be accessed through various
addition of PowerPivot to Excel 2010 and its in-memory data store capabilities, it became possible to connect to the
OLAP data sources that gave users the flexibility to analyze their data.
SharePoint 2013 introduces a number of enhancements, which include improvements related to data
exploration, enhanced timeline controls, In-Memory BI Engine (IMBI) that allows for almost instant analysis of
millions of rows, and introduction of the Power View Add-in for Excel 2013.
Learn more about Excel Services and PowerPivot in Chapter 5.
Search JabSto ::