MOC 10990C - Analyzing Data with SQL Server Reporting Services

Course Number: MOC10990C-W

Duration: 5 days

Format: Live, online

Overview

This Analyzing Data with SQL Server Reporting Services training class teaches is for individuals who wish to learn how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course teaches students how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

The target audience for this SQL Server Reporting Services course is database professionals who need to fulfill a BI developer role to create reports. The secondary audience for this course is power information workers.

Objectives

  • Describe reporting services and it’s 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.

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL, such as that taught in 20761.

Attendee Setup Instructions

For details about what is required when attending this class, please refer to the these instructions (will open in a seperate browser window).

Outline

  • Introduction to Reporting Services
    • Introduction to reporting services
    • Reporting services components
    • Reporting services tools
    • Lab: Exploring reporting services
      • Exploring reports
      • Reporting services configuration
  • Reporting Services Data Sources
    • Data sources
    • Connection strings
    • Datasets
    • Lab: Configuring data access with report builder
      • Configuring data access with report builder
    • Lab: Configuring data access with report designer
      • 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
      • 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
  • Working with Reporting Services Data
    • Data filters
    • Report parameters
    • Implementing report filters and parameters
    • Lab: Create a parameterized report
      • Using parameters in report designer
      • Using parameters in report builder
  • Visualizing Data with Report Services
    • Formatting data
    • Images and charts
    • Databars, sparklines, indicators, gauges, and maps
    • Lab: Manage formatting
      • Report designer
      • Report builder
  • Summarizing Report Data
    • Sorting and grouping
    • Report sub-reports
    • Drilldown and drill through
    • Lab: Summarizing report data
      • Sorting and grouping in report builder
      • Sorting and grouping in report designer
  • Sharing Reporting Services Reports
    • Schedules
    • Report caching, snapshots, and comments
    • Report subscription and delivery
    • Lab: Sharing reporting services reports
      • Create a shared schedule
      • Configure caching
      • Subscribe to a report
  • Administering Reporting Services
    • Administering reporting services
    • Reporting services configuration
    • Reporting services performance
    • Lab: Administering reporting services
      • Authorize access to reports
      • Web portal branding
  • Extending and Integrating Reporting Services
    • Expressions and embedded code
    • Extending reporting services
    • Integrating reporting services
    • Lab: Extending and integrating reporting services
      • Custom code – report designer
      • Custom code – report builder
      • URL access
  • Introduction to Mobile Reports
    • Overview of mobile reports
    • Preparing data for mobile reports
    • Mobile report publisher
    • Lab: Introduction to mobile reports
      • Format data for a mobile report
      • Create a mobile report
      • Create KPIs
  • Developing Mobile Reports
    • Designing and publishing mobile reports
    • Drillthrough in mobile reports
    • Lab: Developing mobile reports
      • Add a dataset with parameters
      • Design a mobile report
      • Publish a mobile report
      • Add a drillthrough to a custom URL

Schedule

Date / Time Price (USD)  
Nov 1 - 5
10 AM - 6 PM ET
$2,975 Register
Dec 6 - 10
10 AM - 6 PM ET
$2,975 Register
Jan 10 - 14
10 AM - 6 PM ET
$2,975 Register
Feb 14 - 18
10 AM - 6 PM ET
$2,975 Register
Mar 21 - 25
11 AM - 7 PM ET
$2,975 Register
Apr 25 - 29
11 AM - 7 PM ET
$2,975 Register
Jun 6 - 10
11 AM - 7 PM ET
$2,975 Register
Jul 11 - 15
11 AM - 7 PM ET
$2,975 Register
Aug 8 - 12
11 AM - 7 PM ET
$2,975 Register
Sep 12 - 16
11 AM - 7 PM ET
$2,975 Register
Oct 17 - 21
11 AM - 7 PM ET
$2,975 Register
Nov 28 - Dec 2
10 AM - 6 PM ET
$2,975 Register
Dec 19 - 23
10 AM - 6 PM ET
$2,975 Register
$2,975 USD
Nov 1 - 5
10 AM - 6 PM ET
Register
Dec 6 - 10
10 AM - 6 PM ET
Register
Jan 10 - 14
10 AM - 6 PM ET
Register
Feb 14 - 18
10 AM - 6 PM ET
Register
Mar 21 - 25
11 AM - 7 PM ET
Register
Apr 25 - 29
11 AM - 7 PM ET
Register
Jun 6 - 10
11 AM - 7 PM ET
Register
Jul 11 - 15
11 AM - 7 PM ET
Register
Aug 8 - 12
11 AM - 7 PM ET
Register
Sep 12 - 16
11 AM - 7 PM ET
Register
Oct 17 - 21
11 AM - 7 PM ET
Register
Nov 28 - Dec 2
10 AM - 6 PM ET
Register
Dec 19 - 23
10 AM - 6 PM ET
Register
Learn faster

Our live, instructor-led lectures are far more effective than pre-recorded classes

Satisfaction guarantee

If your team is not 100% satisfied with your training, we do what's necessary to make it right

Learn online from anywhere

Whether you are at home or in the office, we make learning interactive and engaging

Multiple Payment Options

We accept check, ACH/EFT, major credit cards, and most purchase orders



Recent Training Locations

Alabama

Birmingham

Huntsville

Montgomery

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

Los Angeles

Oakland

Orange County

Sacramento

San Diego

San Francisco

San Jose

Colorado

Boulder

Colorado Springs

Denver

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Jacksonville

Miami

Orlando

Tampa

Georgia

Atlanta

Augusta

Savannah

Hawaii

Honolulu

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Frederick

Hagerstown

Massachusetts

Boston

Cambridge

Springfield

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Minneapolis

Saint Paul

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Las Vegas

Reno

New Jersey

Princeton

New Mexico

Albuquerque

New York

Albany

Buffalo

New York City

White Plains

North Carolina

Charlotte

Durham

Raleigh

Ohio

Akron

Canton

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Oklahoma City

Tulsa

Oregon

Portland

Pennsylvania

Philadelphia

Pittsburgh

Rhode Island

Providence

South Carolina

Charleston

Columbia

Greenville

Tennessee

Knoxville

Memphis

Nashville

Texas

Austin

Dallas

El Paso

Houston

San Antonio

Utah

Salt Lake City

Virginia

Alexandria

Arlington

Norfolk

Richmond

Washington

Seattle

Tacoma

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Calgary

Edmonton

British Columbia

Vancouver

Manitoba

Winnipeg

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan