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

Introduction to SSRS

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • How to create complex reports
  • Key concepts of Reporting Services from basic reporting, parameters, deploying and scheduling
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

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.

REVIEWS

Amazing! I got this through my employer, but I might get it for personal use if I ever lose access. The classes are just that much better than anything on Udemy or Lynda.

Steve H.

Awesome class. One of the best I have taken.

Anonymous

Great trainings and organization.

Anonymous

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