Learn SSRS SQL Reporting & Business Intelligence Essentials (Udemy.com)

SQL Reporting using SSRS gives you hands-on knowledge to make great SQL reports with Business Intelligence essentials

Created by: William Belisle

Produced in 2016

icon
What you will learn

  • By the end of this course, you will be able to create great SSRS reports.
  • You will learn how to extract data from a database
  • You will learn how to organize large amounts of data into concise reports
  • You will learn how to use graphical display objects to make reports that stand out
  • You will learn how to work smarter, not harder, by learning techniques that cut down on repetitive work

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

icon
Course Description

This is a fast-paced and in-depth course for Microsoft SQL Server Reporting Services (SSRS) designed to get you building your own great reports in no time. This course will take you from the bare minimum basics all the way through advanced topics including:
  • Tables
  • Matrices
  • Prompts
  • Parameters
  • Charts
  • Drill Throughs
  • Sub Reports
  • Gauges
  • Standard Deviation
This course moves quickly to keep you interested but that doesn't mean skipping over important concepts or skimming details. With three hours of videos this course shows you everything you need to get the job done in the real world. The database we will be using focuses on a fictional consumer electronics store. This database is simple and easy to understand without a lot of extra fluff. But you'll be surprised at how many different types of reports you will be able to create. This course is hands-on. It includes all the SQL code you need to build your own copy of the database used in the lectures. It's OK if you aren't a SQL pro, the videos go line-by-line through all the queries and stored procedures used in the course. With SQL code attached in the appropriate lectures, you'll be able to follow along at home. The course is broken out into 2 main sections:
  1. Database Setup - Explains the schema of the database, the data, the Stored Procedures, and other general back-end items.
  2. SSRS - The main focus of the course, this section covers how to do all the important things to make great reports. This includes not only making functional reports, but also useful reports.
A small amount of SQL knowledge would be beneficial, but not strictly required for the course, as all SQL code is explained in the lectures. You should take this course if you are looking to improve your SSRS skill set and deliver reports that exceed your end-user's expectations. Who this course is for:
  • IT professionals who want to develop their SSRS skillset
  • Business Intelligence Analysts and Developers looking for new ways to create reports
  • Some previous experience with Microsoft BI products is helpful, but by no means required

icon
Instructor Details

placeholder

William got his start in the Business Intelligence field at one of the largest banks in the US. He has since moved on to other companies and business sectors including Education, Healthcare, e-commerce, and Transportation. Now with over 10 years of experience working with the Microsoft BI stack he knows how to get projects done.
William has made countless reports using SQL Server Reporting Services (SSRS). With his knowledge and creativity combined he is able to deliver great reporting that helps businesses make decisions. From simple dashboards to complex projects scaled out to 100s of users, William has a broad pool of experience to draw from.
Self taught and highly motivated, William brings his energy and expertise to every project.

icon
Reviews

4.3

207 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Dave Sommer on 11/8/2020

Great content

By Fernando Silva de la Garza on 10/9/2020

Buena eleccin pero faltara uno mas reciente

By Ayse Betul Dede on 9/23/2020

It was a very valuable course, overall, although I noticed that knowing SQL better would help a whole a lot better since the course has gotten more complex towards the end of SSRS chapter. So my next goal is studying SQL. But overall, it was a very good course that taught me a whole a lot about the capabilities of this software and things can be done with it. Thanks!

By Yasmeeta Paudyal on 9/12/2020

The lecture is so fast it is hard to understand

By Alicia Johnson on 8/11/2020

Yes and no. I don't need to learn how to create the reports, since the reports are already created and cannot be modified. I just need to know how to troubleshoot when a report fails to run. Is it because the datasource is missing or is it because one of the values in the report is too large to handle.

By Bsheridanjones Sheridan-Jones on 7/22/2020

Yes!

By Sue Nelson on 6/21/2020

Good match

By Petra Stevenson on 6/10/2020

I think it's generally a good match. Maybe I needed something right before that tells me what select, from, select distinct, etc. are supposed to do.

By Barry Solomon on 6/6/2020

Good pace, and does a good job of explaining without wasting too much time!

By Solomon H Ahmed on 5/11/2020

The teacher is a bit fast when explain things, otherwise everything is perfect!

By Rich Rudaski on 5/7/2020

Examples are really good.

By Samuel Igbanoi on 5/3/2020

very interesting so far