Learn SSRS Reporting in 120 minutes
4.5 (54 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,131 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SSRS Reporting in 120 minutes to your Wishlist.

Add to Wishlist

Learn SSRS Reporting in 120 minutes

Learn Visualization techniques to tell a simple story using complex data
New
4.5 (54 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,131 students enrolled
Last updated 8/2017
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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.
Compare to Other SSRS Reporting Courses
Curriculum For This Course
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
About the Instructor
Rakesh Gopalakrishnan
4.4 Average rating
10,914 Reviews
116,340 Students
4 Courses
Over 100,000 Students

I am a coder, manager, educator and a gamer. I love data and analytics. In my day job, I work with database technologies including SQL , Big Data and Tableau. I am passionate about technologies and love coding and managing teams. In my spare time I like to teach Big Data analytics, Databases, Programming etc. I am currently working on certain machine learning and Data Science projects and love to explore more in the Statistics field.