Microsoft 10990: Analysing Data with SQL Server Reporting Services

• Describe reporting services and its components
• Describe reporting services data sources
• Implement paginated reports
• Work with reporting services data
• Visualize data with reporting services
• Aggregate report data
• Share reporting services reports
• Administer reporting services
• Expand and integrate reporting services
• Describe mobile reports
• Develop mobile reports

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

• Database Administrators
• IT Infrastructure Leads
• Systems Administrators
• Senior SQL Administrators
• Microsoft Power Platform Consultants
• Senior Operation Analysts
• IT Systems Administrators
• Data Engineers
• IT Support Managers
• SQL Administrators
• SQL Developers

• Introduction to reporting services
• Reporting services components
• Reporting services tools
• Exploring reports
• Reporting services configuration
• Give a context for Reporting Services
• Describe the components of Reporting Services
• Explain Reporting Services tools
• Data sources
• Connection strings
• Datasets
• Configuring data access with report builder
• Configuring data access with report designer
• Describe data sources
• Work with connection strings
• Describe datasets
• Creating a report with the report wizard
• Creating a report
• Publishing a report
• Use the report wizard – report designer
• Use the report wizard – report builder
• Creating and publishing a report – report designer
• Creating and publishing a report – report builder
• Create a report with the report wizard
• Create a report using report builder or report designer
• Publish a report to reporting services
• Data filters
• Report parameters
• Implementing report filters and parameters
• Using parameters in report designer
• Using parameters in report builder
• Filter data in reports
• Use parameters in reports
• Formatting data
• Images and charts
• Databars, sparklines, indicators, gauges, and maps
• Report designer
• Report builder
• Format data in reports
• Use images and charts in your reports
• Use databars, sparklines, and indicators in reports
• Explain what a KPI is and how it is used
• Sorting and grouping
• Report sub-reports
• Drilldown and drill through
• Sorting and grouping in report builder
• Sorting and grouping in report designer
• Group and sort data in reports
• Create report sub-sections
• Use drill down and drill through
• Schedules
• Report caching, snapshots, and comments
• Report subscription and delivery
• Create a shared schedule
• Configure caching
• Subscribe to a report
• Explain schedules
• Describe report caching, report snapshots, and report comments
• Configure report subscriptions
• Administering reporting services
• Reporting services configuration
• Reporting services performance
• Authorize access to reports
• Web portal branding
• Secure access to reports by using authentication, permissions, and SSL encryption
• Use report services configuration manager to reconfigure SSRS servers
• Monitor and optimize the performance of SSRS on a given set of server hardware
• Expressions and embedded code
• Extending reporting services
• Integrating reporting services
• Custom code – report designer
• Custom code – report builder
• URL access
• Work with expressions and embedded code
• Extend reporting services functionality with external assemblies
• Integrate reporting services with other software
• Overview of mobile reports
• Preparing data for mobile reports
• Mobile report publisher
• Format data for a mobile report
• Create a mobile report
• Create KPIs
• Describe considerations for mobile reports
• Prepare data for publication in mobile reports
• Use SQL Server mobile report publisher to create mobile reports
• Designing and publishing mobile reports
• Drill through in mobile reports
• Add a dataset with parameters
• Design a mobile report
• Publish a mobile report
• Add a drill through to a custom URL
• Describe how to design and publish mobile reports
• Explain how to drill through from mobile reports