Learn SSRS Reporting in 120 minutes
4.3 (1,073 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,187 students enrolled

Learn SSRS Reporting in 120 minutes

Learn Visualization techniques to tell a simple story using complex data
4.3 (1,073 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,187 students enrolled
Last updated 12/2017
English
English [Auto-generated]
Price: Free
This course includes
  • 1.5 hours on-demand video
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
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.
Course content
Expand 13 lectures 01:31:07
+ SQL Server Reporting Services (SSRS)
13 lectures 01:31:07

Some Pre-Requisites and Resources

Hello SSRS
01:21

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. 

A little about me and the course
03:17

Let's have a brief look how to get started with SSRS.

Introduction
01:27

We will be installing SQL Server Database Engine, some sample databases (ex. AdventureWorks DB) and Installing and configuring SQL Reporting services. 

Setting up your environment
01:53

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 (Wizard Based)
06:23

We take a Step forward and learn about creating a completely manual SSRS report. 

My First SSRS report (Non-Wizard Based)
09:40

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.

Adding Parameters to SSRS reports
04:42

Let's take it up a notch! Let me walk you through cascading parameters and multiple parameters driving the data in Reports.

Understanding SSRS cascading and multiple Parameters
07:40

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.

SSRS expressions
12:01

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.)

Tables, Matrices and Lists
16:32

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 Graphs and Visualization
06:45

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 Subreports
06:33

In this last lecture, we look at Map and deployment techniques. We also walk through some BI Stack tools and next steps.

SSRS Tips & Tricks / Conclusion
12:53