Analyzing Data with SQL Server Reporting Services

1 0800 Data with SQL Server Reporting ServicesDuration: 3 Days Course Code: M10990 Overview:This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in anorganization. The course discusses how to use the Reporting Services development tools to create and manage reports and implementself-service BI Audience:The primary audience for this course is database professionals who need to fulfil a BI developer role tocreate reports. Primary responsibilities will include implementing reports and mobile secondary audiences for this course are power information :After completing this course, students will be able to:Aggregate report dataDescribe Reporting Services and it s componentsShare Reporting Services reportsDescribe Reporting Services data sourcesAdminister Reporting servicesImplement paginated reportsExpand and integrate Reporting servicesWork with Reporting Services dataDescribe mobile reportsVisualize data with Reporting servicesDevelop mobile :Before attending this course, students must have.

2 Basic knowledge of the Microsoft Windows operating system andits core knowledge of Transact-SQL, such as that taught 0800 :Module 1: Introduction to Reporting ServicesLab : Create a parameterized reportLessons linelinelineUsing parameters in report designerIntroduction to Reporting servicesThis module introduces Microsoft SQL ServerUsing parameters in report builderReporting Services componentsReporting Services , its components, and theReporting Services toolstools used to work with it. After completing this module, students will beData sourceslineable to:Connection stringslineDatasetsLessons Give a context for Reporting a report with the report wizardlineDescribe the components of ReportingCreating a reportIntroduction to Reporting a reportReporting Services componentsExplain Reporting Services filtersReporting Services toolsFilter data in reportsReport parametersData sourcesUse parameters in reportsImplementing report filters and parametersConnection stringsGroup and sort data in dataDatasetsCreate report and chartsCreating a report with the report wizardUse drill down and drill , sparklines, indicators, gauges.

3 Creating a reportExplain mapsPublishing a reportDescribe report caching, reportSorting and groupingData filterssnapshots, and report sub-reportsReport parametersConfigure report and drill throughImplementing report filters and parametersSecure access to reports by usingSchedulesFormatting dataauthentication, permissions, and SSLR eport caching, snapshots, and commentsImages and subscription and deliveryDatabars, sparklines, indicators, gauges,Use report Services configurationAdministering Reporting servicesand mapsmanager to reconfigure SSRS Services configurationSorting and groupingMonitor and optimize the performance ofReporting Services performanceReport sub-reportsSSRS on a given set of Server and embedded codeDrilldown and drill throughWork with expressions and embeddedExtending Reporting Reporting servicesReport caching, snapshots.

4 And commentsExtend Reporting Services functionalityOverview of mobile reportsReport subscription and deliverywith external data for mobile reportsAdministering Reporting servicesIntegrate Reporting Services with otherMobile report publisherReporting Services and publishing mobile reportsReporting Services performanceDescribe considerations for mobileDrillthrough in mobile reportsExpressions and embedded Reporting servicesPrepare data for publication in mobileLab : Administering Reporting servicesIntegrating Reporting of mobile reportsUse SQL Server mobile report publisherAuthorize access to reportsPreparing data for mobile reportsto create mobile portal brandingMobile report publisherDescribe how to design and publishDesigning and publishing mobile reportsmobile completing this module, students will beDrillthrough in mobile reportsExplain how to drillthrough from mobileable : Exploring Reporting servicesGive a context for Reporting 5.

5 Visualizing Data with ReportDescribe the components of ReportingExploring Services configurationlineExplain Reporting Services data in reportsAfter completing this module, students will beAs the amount of data being generatedUse parameters in reportsable to:continues to grow, the need to make sense ofGroup and sort data in meaning increases. You use dataCreate report a context for Reporting to make data easier toUse drill down and drill the components of Reportingunderstand, and faster to interpret. DataExplain highlight comparisons, showDescribe report caching, report snapshots,Explain Reporting Services , and convey scale much faster than aand report data in reportstable of numbers could.

6 The detail isConfigure report parameters in reportsimportant, but visualizations are a highlySecure access to reports by usingGroup and sort data in way of conveying meaning andauthentication, permissions, and SSLC reate report quickly and accurately. drill down and drill report Services configuration managerExplain reconfigure SSRS report caching, report snapshots,Lessons Monitor and optimize the performance ofand report on a given set of Server 0800 report to Reporting servicesWork with expressions and embeddedSecure access to reports by usingReporting Services , permissions.

7 And SSLR eporting Services toolsExtend Reporting Services functionality sourcesexternal report Services configuration managerConnection stringsIntegrate Reporting Services with otherto reconfigure SSRS and optimize the performance ofCreating a report with the report wizardDescribe considerations for mobile on a given set of Server a reportPrepare data for publication in mobileWork with expressions and embedded a Reporting Services functionality withData filtersUse SQL Server mobile report publisher toexternal parameterscreate mobile Reporting Services with otherImplementing report filters andDescribe how to design and publish considerations for mobile dataExplain how to drillthrough from mobilePrepare data for publication in mobileImages and , sparklines, indicators, gauges,Use SQL Server mobile report publisher toand mapsModule 9: Extending and Integratingcreate mobile and groupingReporting ServicesDescribe how to design and publish mobileReport and drill throughExplain how to drillthrough from mobileSchedulesAlthough Reporting Services is a caching, snapshots, andtool, its built-in capabilities might not alwayscommentsmeet your needs.

8 This module covers theModule 2: Reporting Services Data SourcesReport subscription and deliverymethods for extending the functionality oflineAdministering Reporting servicesReporting Services with expressions andReporting Services configurationcustom code. You will also learn about theAlmost every report that you publish by usingReporting Services performancemethods for working with Reporting ServicesSQL Server Reporting Services (SSRS) will beExpressions and embedded codeprogrammatically, and integrating Reportingbuilt using data that s obtained from one orExtending Reporting servicesServices reports into other applications.

9 More source systems. This lesson explainsIntegrating Reporting serviceslinehow to configure SSRS to interact with sourceOverview of mobile reportsdata systems by working with data sources. Preparing data for mobile reportsLessons lineMobile report publisherlineDesigning and publishing mobile reportsIntroduction to Reporting servicesLessons Drillthrough in mobile reportsReporting Services componentslineReporting Services toolsIntroduction to Reporting servicesLab : Manage formattingData sourcesReporting Services componentslineConnection stringsReporting Services toolsReport designerDatasetsData sourcesReport builderCreating a report with the report wizardConnection stringsCreating a reportDatasetsAfter completing this module, you will be ablePublishing a reportCreating a report with the report wizardto.

10 Data filtersCreating a reportlineReport parametersPublishing a reportDescribe data report filters and parametersData filtersWork with connection dataReport parametersDescribe and chartsImplementing report filters and parametersCreate a report with the report , sparklines, indicators, gauges,Formatting dataCreate a report using report builder orand mapsImages and chartsreport and groupingDatabars, sparklines, indicators, gauges,Publish a report to Reporting sub-reportsand mapsFormat data in and drill throughSorting and groupingUse images and charts in your sub-reportsUse databars, sparklines, and indicatorsReport caching, snapshots, and commentsDrilldown and drill throughin subscription and deliverySchedulesExplain what a KPI is and how it s Reporting servicesReport caching, snapshots, and commentsReporting Services configurationReport subscription and deliveryModule 6.