Home / Courses / Microsoft Technology / 10990A: Analyzing Data with SQL Server Reporting Services

SQL

10990A: 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 parameters

 

Module 3: Implementing reports

Create reports with report designer or report builder.

Lessons

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

Lab : Creating a report

After 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

Course Registration

 

3 days
$1,675.00

 

Course Outline

 

Request