Advanced SSRS

$95.00

What Will You Learn?

  • How to create complex reports that use Analysis Services as a data source and custom code assemblies
  • How to master advanced topics of reporting services like scaled-out deployment, .Net integration and monitoring reporting services usage

Description

Advanced report developers must hold unique traits to set themselves and their work apart from others. This course is designed to take you to the next level in your understanding of SQL Server Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience.

Instructor

MANUEL QUINTANAMANUEL QUINTANA

Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.

 

What to Know Before the Class

This class assumes attendees have a strong understanding of SSRS fundamentals. For example, students should already know and use the majority of the toolbox items before attending this class. It is not mandatory, but ideally attendees should have an instance of SharePoint to follow some sections of the class.


Duration: 7:49:45
Report Developers must hold unique traits to set themselves and their work apart from others. This class is designed to take you to the next level in your understanding of SQL Server 2016/2017 Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands on experience. With the hands-on labs, you will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies. This course will cover all the advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage.
Advanced SSRS - What you need to get started
Module 00 - Class Introduction
06:06
Module 01 - Report Design Patterns
19:36
Module 02A - Using SSAS as a Data Source (Designing a Basic Report - Multidimensional)
15:53
Module 02B - Using SSAS as a Data Source (Designing a Basic Report - Tabular)
16:14
Module 02C - Using SSAS as a Data Source (Building a Dynamic Report)
34:20
Module 02D - Using SSAS as a Data Source (Tips and Tricks)
18:34
Module 03A - .Net Integration (Why Use Custom Code)
05:39
Module 03B - .Net Integration (Embedded Custom Code)
25:19
Module 03C - .Net Integration (External Assemblies)
20:44
Module 04A - Advanced SSRS Expressions (Advanced Functions)
35:51
Module 04B - Advanced SSRS Expressions (Launch Office Tools From Your Reports)
15:04
Module 04C - Advanced SSRS Expressions (Launching Bing Maps)
08:40
Module 05A - Report Manager (Linked Reports)
07:59
Module 05B - Report Manager (Object Visibility)
04:49
Module 05C - Report Manager (My Reports)
06:43
Module 06A - Report Builder (Train the Trainer)
10:59
Module 06B - Report Builder (Using Report Parts)
09:23
Module 07 - SSRS Configuration (Setting up your SSRS Server)
19:39
Module 08A - Report Utilization (Setting up the Solution)
12:38
Module 08B - Report Utilization (Usage Reports)
06:53
Module 09A - Security (Assigning Report Server Permissions)
16:25
Module 09B - Security (Creating Custom Security Roles)
04:43
Module 10A - Performance Tuning (Report Snapshots)
21:13
Module 10B - Performance Tuning (Report Caching)
11:51
Module 10C - Performance Tuning (SSRS Performance Counters)
13:22
Module 11- Planning a Web Farm Architecture
19:24
Module 12A - Data Driven Subscriptions (Building a Basic Subscription)
16:35
Module 12B - Data Drive Subscriptions (Using Data Driven Subscriptions)
12:41
Module 13 - Accessing Your Report Server Remotely
06:59
Module 14A - Miscellaneous (Creating Report Templates)
07:03
Module 14B - Miscellaneous (Using Document Maps)
04:49
Module 14C - Miscellaneous (Reporting On Recursive Data)
06:31
Module 14D - Miscellaneous (Refreshing Report Data From Word, PowerPoint, Etc)
05:59
Module 14E - Miscellaneous (Using Reports to Start SQL Agent Jobs)
04:34
Module 15A - Power BI Integration (Deploying SSRS Report Visuals to Power BI)
10:43
Module 15B - Power BI Integration (Power BI Report Server)
05:50
Class Survey

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide (https://file.ac/4hcCTUOoLgk/Pragmatic%20SSRS%20Master%20Installation%20Guide.docx)to ensure all items are installed correctly
    • **Optional** Full Visual Studio .Net Components. Used for only one module so this is not mandatory.
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
  • AdventureWorks Cube installed on the Analysis Services instance