Loading...

M10990 – Analyzing Data with SQL Server Reporting Services

Home / M10990 – Analyzing Data with SQL Server Reporting Services

In this course students will learn how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. Students will discover how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

 

Students Will Learn To:

  • 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.

Course Outline:

Course Outline:

Introduction to Reporting Services

  • Introduction to reporting services
  • Reporting services components
  • Reporting service tools

Reporting Services Data Sources

  • Data sources
  • Connection strings
  • Datasets

Creating Paginated Reports

  • Creating a report with the report wizard
  • Creating a report
  • Publishing a report

Working with Report Services Data

  • Data Filters
  • Report parameters
  • Implementing report filters and parameters

Visualization Data Report Services

  • Formatting data
  • Images and charts
  • Databars, sparklines, indicators, gauges, and maps

Summarizing Report Data

  • Sorting and grouping
  • Report sub-reports
  • Drilldown and drill through

Sharing Reporting Services Reports

  • Schedules
  • Report caching, snapshots, and comments
  • Report subscription and delivery

Administering Reporting Services

  • Administering reporting services
  • Reporting services configuration
  • Reporting services performance

Extending and Integrating Reporting Services

  • Expressions and embedded code
  • Extending reporting services
  • Integrating reporting services

Introduction to Mobile Reports

  • Overview of mobile reports
  • Preparing data for mobile reports
  • Mobile report publisher

Developing Mobile Reports

  • Designing and publishing mobile reports
  • Drillthrough in mobile reports

Labs:

Lab 1: Exploring reporting services

Lab 2: Configuring data access with report builder

Lab 3: Configuring data access with report designer

Lab 4: Creating reports

Lab 5: Create parameterized reports

Lab 6: Manage formatting

Lab 7:  Summarizing report data

Lab 8: Sharing reporting services reports

Lab 9:  Administering reporting services

Lab 10:  Extending and Integrating reporting services

Lab 11:  Introduction to mobile reports

Lab 12:  Developing mobile reports

Course Audience & Prerequisites:

Audience:

The primary audience for this course is database professionals who need to fulfill 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:

Course Offerings:

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.

  • Course Outline
  • Course Audience & Prerequisites
  • Course Offerings
  • Related Courses

Course Outline:

Introduction to Reporting Services

  • Introduction to reporting services
  • Reporting services components
  • Reporting service tools

Reporting Services Data Sources

  • Data sources
  • Connection strings
  • Datasets

Creating Paginated Reports

  • Creating a report with the report wizard
  • Creating a report
  • Publishing a report

Working with Report Services Data

  • Data Filters
  • Report parameters
  • Implementing report filters and parameters

Visualization Data Report Services

  • Formatting data
  • Images and charts
  • Databars, sparklines, indicators, gauges, and maps

Summarizing Report Data

  • Sorting and grouping
  • Report sub-reports
  • Drilldown and drill through

Sharing Reporting Services Reports

  • Schedules
  • Report caching, snapshots, and comments
  • Report subscription and delivery

Administering Reporting Services

  • Administering reporting services
  • Reporting services configuration
  • Reporting services performance

Extending and Integrating Reporting Services

  • Expressions and embedded code
  • Extending reporting services
  • Integrating reporting services

Introduction to Mobile Reports

  • Overview of mobile reports
  • Preparing data for mobile reports
  • Mobile report publisher

Developing Mobile Reports

  • Designing and publishing mobile reports
  • Drillthrough in mobile reports

Labs:

Lab 1: Exploring reporting services

Lab 2: Configuring data access with report builder

Lab 3: Configuring data access with report designer

Lab 4: Creating reports

Lab 5: Create parameterized reports

Lab 6: Manage formatting

Lab 7:  Summarizing report data

Lab 8: Sharing reporting services reports

Lab 9:  Administering reporting services

Lab 10:  Extending and Integrating reporting services

Lab 11:  Introduction to mobile reports

Lab 12:  Developing mobile reports

Audience:

The primary audience for this course is database professionals who need to fulfill 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:

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.

M20761 – Querying Data with Transact-SQL

Learn how to write basic Transact-SQL queries for Microsoft SQL Server 2016. This course will provide a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines—namely, database administration, database development, and business intelligence. Students will learn about: T-SQL elements, writing SQL queries, querying JOINs, sorting and filtering data, SQL Server 2016 data types, T-SQL DML, built-in functions, grouping and aggregating data, subqueries, and set operators. This course incorporates material from the Official Microsoft Learning Product 20761: Querying Data with Transact-SQL.