Dashboard Pro

SQL SERVER REPORTING SERVICES – SSRS

SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization. Reporting Services includes programming features that enable you to extend and customize your reporting functionality.

With Reporting Services, EMI can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. Reports can include rich data visualization, including charts, maps, and sparklines. EMI can publish reports, schedule report processing, or access reports on-demand. Also, EMI can select from a variety of viewing formats, export reports to other applications such as Microsoft Excel, and subscribe to published reports. The reports that EMI create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. It is also possible create data alerts on reports published to a SharePoint site and receive email messages when report data changes.

POWERVIEW AND SSAS

Analysis Services is an online analytical data engine used in decision support and business intelligence (BI) solutions, providing the analytical data for business reports and client applications such as Excel, Reporting Services reports, and other third-party BI tools. A typical workflow for Analysis Services includes building an OLAP or tabular data model, deploy the model as a database to an Analysis Services instance, process the database to load it with data, and then assign permissions to allow data access. When it’s ready to go, this multi-purpose data model can be accessed by any client application supporting Analysis Services as a data source.

Models are populated with data from external data systems, usually data warehouses hosted on a SQL Server or Oracle relational database engine (Tabular models support additional data source types). Models specify query objects, such as cubes, but also specify dimensions that can be used in multiple cubes, calculations and KPIs that encapsulate business logic, and interactions such as navigation and drill-through behaviors. Power View is an interactive data exploration, visualization, and presentation experience that encourage intuitive ad-hoc reporting. Power View is a feature of Microsoft Excel 2013, and of Microsoft SharePoint Server 2013 as part of the SQL Server Reporting Services Add-in for Microsoft SharePoint Server Enterprise Edition. Power View in SharePoint is browser-based Silverlight application. Creating, opening, and saving Power View reports (RDLX files) all take place in SharePoint Server 2013.

Power View you can interact with data:

• In the same Excel workbook as the Power View sheet.
• In data models in Excel workbooks published in a Power Pivot Gallery.
• In tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances.