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