10990 Analyzing Data with SQL Server Reporting Services

10990 Analyzing Data with SQL Server Reporting Services

The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

PREREQUISITES
20761 Querying Data with Transact SQL

Top
TARGET 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.

COURSE OBJECTIVES
After completing this course, students will be able to:
- Describe key features of data modelling within business intelligence
- Describe various report services data sources and how these are configured
- Create reports with report designer and/or report designer
- Configure reports with report designer and/or report builder
- Create SQL Server mobile reports

Top
COURSE OUTLINE
1 - INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELLING
Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services
Lab : Exploring an enterprise BI solution

2 - REPORTING SERVICES DATA
Data connections
Connection strings
Filters and parameters
Lab : Configuring a data connection

3 - IMPLEMENTING REPORTS
Creating a report with the report wizard
Creating a report
Showing data graphically
Lab : Creating a report

4 - CREATING A MAP REPORT
Implementing filters and parameters
Implementing sorting and grouping
Publishing a report
Lab : Creating a map report

5 - CREATING MOBILE REPORTS
Overview of SQL Server mobile reports
Preparing data for mobile reports
Mobile report publisher
Lab : Mobile reports