Introduction to SSRS

£395.00

What Will You Learn?

  • How to create complex reports
  • Key concepts of Reporting Services from basic reporting, parameters, deploying and scheduling

Category:

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.

INSTRUCTOR

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

WHAT TO KNOW BEFORE THE 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.


Duration: 9:02:32
**Newly Redesigned for SQL Server 2016** This class 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. This course will cover all the key concepts of Reporting Services from basic reporting, parameters, deploying, and scheduling.
Introduction to SSRS - What you need to get started
Module 00 - Course Introduction
09:06
Module 01 - Introduction to Reporting Services
17:01
Module 02 - Introduction to the Reporting Environment
33:02
Module 03 - Building your First Report
25:31
Module 04A - Bringing Data into your Reports (Building a Dataset)
18:02
Module 04B - Bringing Data into your Reports (Dataset Storage)
08:32
Module 04C - Bringing Data into your Reports (Previewing Data Options)
19:42
Module 05A - Using Basic Toolbox Items (Line, Textbox, Rectangle)
31:19
Module 05B - Using Basic Toolbox Items (Working with Images)
22:19
Module 06A - Understanding the Table and Matrix (Tables)
18:48
Module 06B - Understanding the Table and Matrix (Matrix)
18:46
Module 07A - Building a Report with Parameters (Working with Parameters)
23:07
Module 07B - Building a Report with Parameters (Working with Stored Procedures)
10:19
Module 07C - Building a Report with Parameters (Cascading Parameters)
17:48
Module 08A - Making Reports Dynamic (Introduction)
24:18
Module 08B - Making Reports Dynamic (Expressions)
24:06
Module 08C - Making Reports Dynamic (Date Expressions)
10:40
Module 09 – Reporting on an Analysis Services Data Source
19:15
Module 10A – Visualizations for Dashboard Development (Chart Visualizations)
33:41
Module 10B – Visualizations for Dashboard Development (Map Visualizations)
24:10
Module 10C – Visualizations for Dashboard Development (Databars and Sparklines)
18:47
Module 10D – Visualizations for Dashboard Development (Other Visuals)
18:31
Module 10E – Visualizations for Dashboard Development (Subreports and Drillthrough Reports)
21:09
Module 10F – Visualizations for Dashboard Development (Indicators)
10:45
Module 11 - Administration
18:15
Module 12 - Report Delivery
19:37
Module 13 - Self-Service Reporting
25:56
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 (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