Course Description
Introduction to SSRS is designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work, and to prepare you to build your own real-world applications using this SQL Server subsystem.
Click here for a downloadable PDF
Outline
Module 00 | Course Introduction
09m 06s total
Module 00A | Course Introduction
09m 06s
Module 01 | Introduction to Reporting Services
17m 01s total
Module 01A | Introduction to Reporting Services
17m 01s
Module 02 | Introduction to the Reporting Environment
33m 02s total
Module 02A | Introduction to the Reporting Environment
33m 02s
Module 03 | Building your First Report
25m 31s total
Module 03A | Building your First Report
25m 31s
Module 04 | Bringing Data into your Reports
45m 76s total
Module 04A | Building a Dataset
18m 02s
Module 04B | Dataset Storage
08m 32s
Module 04C | Previewing Data Options
19m 42s
Module 05 | Using Basic Toolbox Items
53m 38s total
Module 05A | Line, Textbox, Rectangle
31m 19s
Module 05B | Working with Images
22m 19s
Module 06 | Understanding the Table and Matrix
36m 94s total
Module 06A | Tables
18m 48s
Module 06B | Matrix
18m 46s
Module 07 | Building a Report with Parameters
50m 74s total
Module 07A | Working with Parameters
23m 07s
Module 07B | Working with Stored Procedures
10m 19s
Module 07C | Cascading Parameters
17m 48s
Module 08 | Making Reports Dynamic
58m 64s total
Module 08A | Introduction
24m 18s
Module 08B | Expressions
24m 06s
Module 08C | Date Expressions
10m 40s
Module 09 | Reporting on an Analysis Services Data Source
19m 15s total
Module 09A | Reporting on an Analysis Services Data Source
19m 15s
Module 10 | Visualizations for Dashboard Development
125m 83s total
Module 10A | Chart Visualizations
33m 41s
Module 10B | Map Visualizations
24m 10s
Module 10C | Databars and Sparklines
18m 47s
Module 10D | Other Visuals
18m 31s
Module 10E | Subreports and Drillthrough Reports
21m 09s
Module 10F | Indicators
10m 45s
Module 11 | Administration
18m 15s total
Module 11A | Administration
18m 15s
Module 12 | Report Delivery
19m 37s total
Module 12A | Report Delivery
19m 37s
Module 13 | Self-Service Reporting
25m 56s total
Module 13A | Self-Service Reporting
25m 56s
Instructor
MITCHELL PEARSON
Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.
Click Here To Learn More About Mitchell 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 (Some features discussed are Enterprise/Developer edition only)
- SQL Server Database Engine
- SQL Server Reporting 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/6OQIGwL4ngk/Pragmatic%20SSRS%20Installation%20Guide.docx) to ensure all items are installed correctly
- AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
- AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
What to Know Before Class
This class assumes that you have no previous knowledge of SSRS. In some of the coding modules, it is useful (but not mandatory) that students have some basic Visual Basic experience. Attendees will also need to know how to run a query inside of SQL Server.