SQL Server Reporting Services 2016 The Future of
- Slides: 21
SQL Server Reporting Services 2016 The Future of Data Analysis. Arthur Luz | MCSA & MCT - SQL Server arthurjosemberg@gmail. com http: //arthurluz. wordpress. com
Sponsors
Who am I? SQL Server MCSA and MCT and Datazen Especialist Senior BI Analyst at Comp Line Services Solutions BI and Database Consultant and Instructor in One Way Solution and BI do Brasil Official Instructor at Hepta Novintec Technical Writer at SQL Magazine
Schedule ü ü ü ü ü What is Microsoft Datazen? SSRS 2016 - Architecture Installation and Configuration – Native Mode Control panel - Demonstration Creating Data Sources Creating Data Sets - Report Builder Developing KPIs – Control panel Developing Dashboards – SQL Server Mobile Report Publisher News for SSRS 2016 – Paginated Reports
What is Microsoft Datazen? Analysis of Power x Setting Spead Web and Mobile Access Centralized Construction of the Dashboards Security in Data Access
Architecture on Premise CREATE “Datazen” Publisher MANAGE SQL Server 2016 Reporting Services (native mode) q “Datazen” Server now a component of SSRS SQL Server Report Builder Report Designer in SQL Server Data Tools CONSUME “Datazen” Windows App “Datazen” Phone App “Datazen” Android App “Datazen” i. OS App Report Server Web portal (paginated and mobile reports) SSRS reports rendered as PDF SQL Server 2016 Reporting Services (Share. Point Integrated mode) Pin paginated report elements to Power BI dashboards Share. Point We b
Architecture for Cloud CREATE Microsoft Excel MANAGE Power BI CONSUME Power BI Web Portal • Power BI Desktop • Microsoft Excel Power BI Desktop • Mobile reports Windows App • Paginated reports Android App i. OS App “Datazen” Publisher SQL Server Report Builder SQL Server BI “Reporting Services” • Power BI Desktop Report Server Web portal (all BI report types) • Mobile reports Report Designer in SQL Server Data Tools • Paginated reports Share. Point We b
Installation and Configuration Datazen Installation through integration for SQL Server mobile reports in Installation Center SSRS 2016 Configuration through SSRS Configuration Manager.
New Control panel Now!!! Before…
New Control panel SSRS 2016
Data Sources and Data Sets Data sources are created in SSRS equal in previous versions. Data Sets (no more Data View) now are created in Microsoft Report Builder.
Creating Data Sources and Data Sets
Developing KPIs – Control Panel KPIs are created in SSRS Control panel. It’s equal Datazen Server, except for the Data View now are in Control panel too.
Demonstration KPIs in SSRS 2016
Datazen Publisher x Mobile Report Publisher Now in SQL Server Mobile Report Publisher. Before in Microsoft Datazen Publisher.
Demonstration SQL Server Mobile Report Publisher
News for Report Services 2016 Monitor the most Modern chart and gauge styles Modern web portal important metrics Customizable parameter layout Modern HTML 5 browser trends in one place More chart types. SQL Server support Pin on-premises Updated data source support Plugin-free printing Reporting Services report Modern Report Builder Share. Point 2016 support elements to Power BI look-and-feel Visual Studio 2015 support dashboards
Demonstration Paginated Reports
Questions? !. . . Thanks for your presence!
Email - arthurjosemberg@gmail. com Linkedin – Arthur Luz Twitter - @arthurjosemberg Skype - arthurjosemberg Blog – arthurluz. wordpress. com
- Iis internet information services
- Grant showplan
- Sql 2016 master data management
- Sql server 2016 management studio
- Trace flag 2861
- Sql server 2000 dts designer components
- Sql server 2016 security features
- Microsoft sql server 2005 analysis services
- Microsoft sql server machine learning services
- Microsoft master data services
- Sql server analysis services 2012
- Future perfect e future perfect continuous esercizi
- Future perfect e future continuous
- Networking with windows server 2016
- Nouveauté windows server 2016
- Kerboodle
- Cluster dhcp
- Testout server pro 2016
- Sql azure reporting
- Ms epm
- Objectives of printing
- Difference between pl sql and mysql