Analyzing Data with SQL Server Reporting Services
Description
This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
Intended audience
The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.
The secondary audiences for this course are power information workers.
Topics
Module 1: Introduction to Reporting Services
Introduction to reporting services
Reporting services components
Reporting services tools
Lab : Exploring reporting services
Module 2: Reporting Services Data Sources
Data sources
Connection strings
Datasets
Lab : Configuring data access with report builder
Lab : Configuring data access with report designer
Module 3: Creating Paginated Reports
Creating a report with the report wizard
Creating a report
Publishing a report
Lab : Creating reports
Module 4: Working with Reporting Services Data
Data filters
Report parameters
Implementing report filters and parameters
Lab : Create a parameterized report
Module 5: Visualizing Data with Report Services
Formatting data
Images and charts
Databars, sparklines, indicators, gauges, and maps
Lab : Manage formatting
Module 6: Summarizing Report Data
Sorting and grouping
Report sub-reports
Drilldown and drill through
Lab : Summarizing report data
Module 7: Sharing Reporting Services Reports
Schedules
Report caching, snapshots, and comments
Report subscription and delivery
Lab : Sharing reporting services reports
Module 8: Administering Reporting Services
Administering reporting services
Reporting services configuration
Reporting services performance
Lab : Administering reporting services
Module 9: Extending and Integrating Reporting Services
Expressions and embedded code
Extending reporting services
Integrating reporting services
Lab : Extending and integrating reporting services
Module 10: Introduction to Mobile Reports
Overview of mobile reports
Preparing data for mobile reports
Mobile report publisher
Lab : Introduction to mobile reports
Module 11: Developing Mobile Reports
Designing and publishing mobile reports
Drillthrough in mobile reports
Lab : Developing mobile reports
האם אתה בטוח שאתה רוצה לסגור את הטופס ולאבד את כל השינויים?
