Habanero Data Solutions

SQL Reporting Services

Approved by Habanero Data
SQL Server
next available COURSE:
Duration :
5 Day/s
5 Day/s
$ 750
₦ 350,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

About this 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

Our international certified trainers have highly experienced Microsoft practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed SQL Reporting Services

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

For more information on our training, please enquire using the form above or call +2348103382376

SQL Reporting Services

Contact Our Team Today!

    What's Included

    Find out what’s included in the training programme.

    Delivery Options

    Everything you need to know


    Course Schedule

    Find out the next available dates

    SQL Reporting Services

    Available Dates

    Available Places

    Book or Enquire

    July 13, 2020

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +234 8103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.