Learn SSRS Reporting in 120 minutes

Learn Visualization techniques to tell a simple story using complex data

Created byRakesh Gopalakrishnan

Last updated 12/2017

English

What you'll learn

Create reports using Microsoft SQL Server Reporting Services
Complete the MSBI suite (if you have taken my Databases and ETL courses)
Apply these techniques in any of your projects, to build highly customized reports.
Building graphs, maps, charts and other visualization
Be comfortable building Tables, Matrices, lists and deploying to SSRS server

Course content

1 section • 13 lectures • 1h 31m total length

Hello SSRS1:21
Some Pre-Requisites and Resources
A little about me and the course3:17
Hello and welcome to this course. Join me on this journey of SSRS. Please feel free to connect with me and ask questions on the forum as you progress along this course.
Introduction1:27
Let's have a brief look how to get started with SSRS.
Setting up your environment1:53
We will be installing SQL Server Database Engine, some sample databases (ex. AdventureWorks DB) and Installing and configuring SQL Reporting services.
My First SSRS report (Wizard Based)6:23
We create our first SSRS report using the inbuilt Wizard. We have a look at the various settings, Visual Studio and SSRS tools.
My First SSRS report (Non-Wizard Based)9:40
We take a Step forward and learn about creating a completely manual SSRS report.
Adding Parameters to SSRS reports4:42
We now improve on the report that we just created. We look at various ways to add parameters and various techniques to have an user input the parameter values at runtime.
Understanding SSRS cascading and multiple Parameters7:40
Let's take it up a notch! Let me walk you through cascading parameters and multiple parameters driving the data in Reports.
SSRS expressions12:01
Let's look at how to dynamically create custom column values, colors, fonts, values, and almost anything using simple expressions. This will broaden your view on SSRS and you will realize how powerful and flexible SSRS is.
Tables, Matrices and Lists16:32
I will walk you through some techniques to display data. I will show how to display simple tables, which rows and columns, then I will walk you though Matrix reports (which is like a pivot table in Excel), and finally, I will show you how to create a template and govern where you data should be displayed (example: Newsletter, Business Cards etc.)
SSRS Graphs and Visualization6:45
What is reporting without graphs. We walked through various techniques to display data. But did you know SSRS can display data as graphs/Charts/Maps etc.? Let me walk you through some visualization concepts.
SSRS Subreports6:33
Did you ever have a need to connect 2 reports and show it in a single dashboard? I am sure you did. In this lecture, I will show you how to mimic a "Iframe" and embed 1 report in another.
SSRS Tips & Tricks / Conclusion12:53
In this last lecture, we look at Map and deployment techniques. We also walk through some BI Stack tools and next steps.

Requirements

This course does not require any Pre-Requisite knowledge. You will however need a Windows Machine. If you are using a MAC machine, you will need a Virtual Machine with Windows OS installed.

Description

After completing this course, you will be comfortable creating simple to complex reports, Graphs and Maps. This course will complete the BI tool set consisting of SQL, ETL and Reporting (you can refer to my SQL Server and ETL courses, if you want to learn more). This course, will walk you through basic installation and environment setup to different SSRS techniques to create reports and visualization. We also cover concepts like displaying data using Tables, Matrices and Lists. We will walk through how to create highly dynamic reports. We walk through the powerful concepts of SSRS expressions, where you can dynamically render Colors, Fonts, Data and control the Report look and feel.

After taking all 3 courses, students will know what will be expected of a DB developer, ETL Developer or a Reporting Analyst type job. The complete BI Tool Suite course will help you get prepared for interviews and jobs. It will show you all facilities that these tools provide.

By taking all the 4 courses in this toolset, I can assure you that you will have a very good understanding of how the different Microsoft Business Intelligence tools interact with one another, and how a typical day in the life of Database developer, ETL Developer, Analyst or Reporting Analyst look like.

Who this course is for:

This course is for anyone, who wants to learn Visualization using SQL Server Reporting Services (SSRS). SSRS is one of tools in the Microsoft Business Intelligence (MSBI) tool Suite.
This course will complete the set of lectures in the Microsoft BI Tool Suite (SQL, ETL and Visualization). Please refer my other courses, if you wish to learn SQL and ETL.