NEED HELP? TALK TO AN EXPERT (904) 638-5743

Advanced SSRS

WHAT YOU'LL 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
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

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

 

Click here for a downloadable PDF

Outline

 

Module 00 | Class Introduction
06m 06s total

 

Module 00A | Class Introduction
06m 06s

 

Module 01 | Report Design Patterns
19m 36s total

 

Module 01A | Report Design Patterns
19m 36s

 

Module 02 | Using SSAS as a Data Source
85m 01s total

 

Module 02A | Designing a Basic Report – Multidimensional
15m 53s

 

Module 02B | Designing a Basic Report – Tabular
16m 14s

 

Module 02C | Building a Dynamic Report
34m 20s

 

Module 02D | Tips and Tricks
18m 34s

 

Module 03 | .Net Integration
51m 42s total

 

Module 03A | Why Use Custom Code
05m 39s

 

Module 03B | Embedded Custom Code
25m 19s

 

Module 03C | External Assemblies
20m 44s

 

Module 04 | Advanced SSRS Expressions
59m 35s total

 

Module 04A | Advanced Functions
35m 51s

 

Module 04B | Launch Office Tools From Your Reports
15m 04s

 

Module 04C | Launching Bing Maps
08m 40s

 

Module 05 | Report Manager
19m 31s total

 

Module 05A | Linked Reports
07m 59s

 

Module 05B | Object Visibility
04m 49s

 

Module 05C | My Reports
06m 43s

 

Module 06 | Report Builder
20m 22s total

 

Module 06A | Train the Trainer
10m 59s

 

Module 06B | Using Report Parts
09m 23s

 

Module 07 | SSRS Configuration
19m 39s total

 

Module 07A | Setting up your SSRS Server
19m 39s

 

Module 08 | Report Utilization
19m 31s total

 

Module 08A | Setting up the Solution
12m 38s

 

Module 08B | Usage Reports
06m 53s

 

Module 09 | Security
21m 08s total

 

Module 09A | Assigning Report Server Permissions
16m 25s

 

Module 09B | Creating Custom Security Roles
04m 43s

 

Module 10 | Performance Tuning
46m 26s total

 

Module 10A | Report Snapshots
21m 13s

 

Module 10B | Report Caching
11m 51s

 

Module 10C | SSRS Performance Counters
13m 22s

 

Module 11 | Planning a Web Farm Architecture
19m 24s total

 

Module 11A | Planning a Web Farm Architecture
19m 24s

 

Module 12 | Data Driven Subscriptions
29m 26s total

 

Module 12A | Building a Basic Subscription
16m 35s

 

Module 12B | Using Data Driven Subscriptions
12m 41s

 

Module 13 | Accessing Your Report Server Remotely
06m 59s total

 

Module 13A | Accessing Your Report Server Remotely
05m 59s

 

Module 14 | Miscellaneous
29m 56s total

 

Module 14A | Creating Report Templates
07m 03s

 

Module 14B | Using Document Maps
04m 49s

 

Module 14C | Reporting On Recursive Data
06m 31s

 

Module 14D | Refreshing Report Data From Word, PowerPoint, Etc
05m 59s

 

Module 14E | Using Reports to Start SQL Agent Jobs
04m 34s

 

Module 15 | Power BI Integration
16m 03s total

 

Module 15A | Deploying SSRS Report Visuals to Power BI
10m 43s

 

Module 15B | Power BI Report Server
05m 50s

Instructor

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

 

Click Here To Learn More About Manuel And See Certifications And Reviews

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

What to Know Before 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.

REVIEWS

I learned a lot and have been able to implement some of the things in my reports.

Anonymous

Excellent trainer.

Anonymous

Excellent!!!

- Behailu M.

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required