10990 Analyzing Data with SQL Server Reporting Services

Module 1: Introduction to Business Intelligence and Data Modelling
In this module students will be introduced to the key concepts in business intelligence, and the Microsoft BI product suite.
Lessons

Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services

Lab : Exploring an enterprise BI solution
After completing this module, you will be able to:

Describe key concepts in business intelligence
Describe the Microsoft BI platform
Describe key concepts in reporting services

Module 2: Reporting Services Data
Describe various Report Services data sources and how these are configured.
Lessons

Data connections
Connection strings
Filters and parameters

Lab : Configuring a data connection
After completing this module, you will be able to:

Describe data connections and connection strings
Describe filters and parametersModule 3: Implementing reportsCreate reports with report designer or report builder

Lessons

Creating a report with the report wizard
Creating a report
Showing data graphically

Lab : Creating a reportAfter completing this module, you will be able to:

Create a report using the report wizard
Show data graphically

Module 4: Creating a Map Report
This module describes how to configure reports with report builder or report designer.
Lessons

Implementing filters and parameters
Implementing sorting and grouping
Publishing a report

Lab : Creating a map report
After completing this module, you will be able to:

Implement filters and parameters
Implement sorting and grouping
Publish a report

Module 5: Creating Mobile Reports
This module describes how to create SQL Server mobile reports.
Lessons

Overview of SQL Server mobile reports
Preparing data for mobile reports
Mobile report publisher

Lab : Mobile reports
After completing this module, you will be able to:

Describe SQL Server mobile reports
Prepare data for mobile reports
Publish mobile reports