Call us on 07035368449 or Request a call back Today !

Microsoft SQL Server Reporting Services

5 Day Microsoft Reporting Services Course  – Create interactive reports easily

What is Reporting Services ?

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It is part of a suite of Microsoft Services. It provides a full range of ready-to-use tools and services to help you create, deploy and manage reports

About the course

This 5 day course will give delegates a thorough study on using SQL Server Reporting Services (SSRS). The course will teach participants how to implement a Reporting Services solution. Participants will learn how to use the Reporting Services development tools to create reports and additionally how to use the Reporting Services management and administrative tools. The course will involve plenty of hands-on exercices to facilitate the learning process and enable participants to quickly gain confidence in using Reporting Services

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the SQL Server Reporting Services.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architect

Recommended Prerequisites: Basic knowledge of Business Intelligence and relational database systems.

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to SQL Server Reporting Services (SSRS)

  • What is Reporting Service
  • Who uses SSRS?
  • The 4 main Visual Studio Windows
  • Business Intelligence Reporting Solutions

Reporting Services Architecture

  • How Reporting Services works
  • Reporting Engine Architecture
  • Data Tier
  • Application Tier
  • Server Tier
  • SSRS Tools: Report Designer, Report Manager, Reporting Services Configuration Manager
  • SSRS Processors & Extensions:Processing & Rendering Extensions (HTML, CSV, XML, Image, PDF, Excel, Word)
  • SSRS Delivery Extensions
  • SSRS Databases:Report Server, Report ServerTempDB

Day 2

Report Planning and Design

  • Report Builder 3.0
  • Business Intelligence Design Studio
  • SQL Server Data Tools
  • SSRS Report Planning
  • Designing Reports with Wizards
  • Designing Custom Reports
  • Authoring a report
  • Using report items
  • Selecting and formatting report items
  • Report Function and Formatting
  • Images and Textboxes
  • Enterprise Ad-hoc Reports

Advanced Report Design

  • Headers and Footers
  • Table and Matrix Groups
  • Adding Totals to Table and Matrix Reports
  • How to create report templates
  • Text Boxes, Padding & Embedded Formatting
  • Designing Master/Detail Reports
  • Creating Drill down reports
  • Creating Sub Reports
  • Creating Drill through and Link Action Reports
  • Navigating Reports:Bookmarks, URLs
  • Expression Builder
  • Fields!Globals!Paramters! and Report Items
  • SSRS Operators:string concatenation, aritmetic, comparison
  • SSRS Functions: Maths, String, Data, IIf, Switch
  • Conditional Formatting
  • Using List Regions to combine Report Items

Report Layout and Formatting

  • Report Layout Types:Table, Matrix, List, Chart, Gauge, Dashboard
  • Tablix Regions
  • Tablix Properties
  • Table Groups
  • Group Expressions
  • Interactive Sort
  • Page Breaks
  • Drill Downs
  • Formatting Report Data
  • Dynamic Formatting
  • Multicolumn Reports
  • Gauge Reports

Day 3

Adding Interactivity to your SSRS Report

  • Implementing Interactive Sorting
  • Adding Fixed Headers
  • Working with Parameters
  • Prompting for User Input
  • Using a Report Parameter as a filter
  • Using a Dataset for Report Parameter values
  • Adding a Query Parameter to a Dataset
  • Creating Cascading Parameters
  • Displaying Parameter Selections in a Report

Developing Report Models

  • Preparing to Develop a Report Model
  • Generating a Report Model
  • Refining a Report Model
  • Managing a Report Model

Day 4

Managing Report Server

  • Review of Deployment Options
  • Deploying a Report Project
  • Uploading a Report
  • Using Rs Utility
  • Using Folders to Organise Content
  • Creating a Linked Report
  • Configuring Data Source Properties
  • Configuring Report Execution Properties

Developing Expressions

  • Adding Calculations to a Report
  • Adding a Calculated Field
  • Creating a Text Box Expression
  • Using a Report Item Expression
  • Using Built In Fields
  • Using Aggregate Functions
  • Changing Report Item Properties by using Expressions
  • Working with Variables
  • Using Expressions for Dynamic Connections and Datasets
  • Developing Expressions for Hierarchical Data

Day 5

Data Management

  • Navigating around Report Manager
  • Organising Reports, Data Sources and Datasets
  • Adding Data Cells
  • Displaying or Hiding Report Manager Details
  • Running Reports
  • Managing Folders and Files
  • Managing Reports and Data Sources
  • Creating a Standard Subscription
  • Parts of a Subscription
  • Managing Reports and Data Sources
  • Managing Site Settings
  • Creating Linked Reports
  • Managing Generic-site Settings
  • Report Caching
  • Report Snapshots

Report Security

  • Configuring Report Server Security
  • Learn basic authentication
  • Assigning User Permissions
  • Implementing Data Security
  • Configuring Report Server Security Policies
  • Assigning User Permissions
  • Configuring Item-Level Security

Performing Administrative Tasks

  • Using Management Tools
  • Configuring the Report Server
  • Monitoring the Report Server

Your Trainer

Our international certified trainers are highly experienced SQL Server Reporting Services practitioners who have real-world expertise.

Key Information

I – All course material including a copy of SQL Server 2012 Reporting Services book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed SQL Server Reporting Services.

III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.

IIII – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 07035368449

Your Name (required)

Your Email (required)

Subject

Courses

Your Message

Reporting Services Course

₦220,000per course