Audience profile
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.
Prerequisites
- M20761 Querying Data with Transact SQL
Course outline
INTRODUCTION TO REPORTING SERVICES
- Introduction to reporting services
- Reporting services components
- Reporting services tools
Lab : Exploring reporting services
REPORTING SERVICES DATA SOURCES
- Data sources
- Connection strings
- Datasets
Lab : Configuring data access with report builder
Lab : Configuring data access with report designer
CREATING PAGINATED REPORTS
- Creating a report with the report wizard
- Creating a report
- Publishing a report
Lab : Creating reports
WORKING WITH REPORTING SERVICES DATA
- Data filters
- Report parameters
- Implementing report filters and parameters
Lab : Create a parameterized report
VISUALIZING DATA WITH REPORT SERVICES
- Formatting data
- Images and charts
- Databars, sparklines, indicators, gauges, and maps
Lab : Manage formatting
SUMMARIZING REPORT DATA
- Sorting and grouping
- Report sub-reports
- Drilldown and drill through
Lab : Summarizing report data
SHARING REPORTING SERVICES REPORTS
- Schedules
- Report caching, snapshots, and comments
- Report subscription and delivery
Lab : Sharing reporting services reports
ADMINISTERING REPORTING SERVICES
- Administering reporting services
- Reporting services configuration
- Reporting services performance
Lab : Administering reporting services
EXTENDING AND INTEGRATING REPORTING SERVICES
- Expressions and embedded code
- Extending reporting services
- Integrating reporting services
Lab : Extending and integrating reporting services
INTRODUCTION TO MOBILE REPORTS
- Overview of mobile reports
- Preparing data for mobile reports
- Mobile report publisher
Lab : Introduction to mobile reports
DEVELOPING MOBILE REPORTS
- Designing and publishing mobile reports
- Drillthrough in mobile reports
Lab : Developing mobile reports
