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.
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.
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.
Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.
Bonus:
• Get preview access to all 70+ courses & custom Learning Paths for 7 days
Instructor
