Learn SSRS SQL Reporting & Business Intelligence Essentials
4.4 (157 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.
1,650 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SSRS SQL Reporting & Business Intelligence Essentials to your Wishlist.

Add to Wishlist

Learn SSRS SQL Reporting & Business Intelligence Essentials

SQL Reporting using SSRS gives you hands-on knowledge to make great SQL reports with Business Intelligence essentials
4.4 (157 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.
1,650 students enrolled
Last updated 7/2016
English
Current price: $10 Original price: $80 Discount: 88% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 6 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
Requirements
  • Basic knowledge of SQL is a nice to have
  • You can just watch the videos, but if you'd like to follow along with your own database, I recommend getting the free version of Microsoft SQL Server 2012 Express Edition from Microsoft's website
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 32 Lectures Collapse All 32 Lectures 03:14:51
+
Introduction
2 Lectures 02:29

This lecture gives you an overview of some of the topics that will be covered in this course.

Preview 01:25

+
Database Setup
5 Lectures 15:03

This is an explanation of the database schema we will be using for this course. It is highly recommended you view this video before starting other lectures.

Use the supplementary materials attached to build a copy of this database.

Preview 02:43

An explanation of the data inside each of the database tables.

Overview of Our Main Table Data
02:14

A detailed look at the Stored Procedure usp_Generate_Sales. This shows how to generate the random sales data we will be reporting on.

Generating Sales Data
02:02

A detailed look at the Stored Procedure usp_Generate_DIM_Date. This explains what a Date Dimension table is and how to create one.

Populating a Date Dimension Table for Later Use
03:51

A detailed look at the Stored Procedure usp_Generate_Metrics. This explains what Metrics are and how to create them.

Generating Metric Data
04:13

test

Database Setup
4 questions
+
SSRS
17 Lectures 02:42:01

The first lecture of the SSRS portion of the course. It is recommended that you at watch the Database Setup videos from above prior to starting this lecture.

This lecture covers how to create a new project and set up a shared datasource in SSRS.

Creating a New Project and Datasource
01:36

How to create a new RDL.

Creating a New RDL
03:57

This lecture covers how to create a simple Sales Table and it's pros and cons.

Adding a Sales Table to Get Started
05:49

This improves upon the Sales Table from the previous lecture by creating a Sales Matrix.

Using a Matrix to Better Organize Our Data
05:58

This adds interactivity to the Sales Matrix from the previous lecture.

Adding Prompts for User Interaction
17:05

SSRS Basics
3 questions

This shows you how to add Drill Throughs to our existing report.

Using Drill Throughs
03:05

This shows you how to incorporate Sub Reports into your reporting.

Making use of SubReports
05:26

This adds charts to display our data in a graphical way.

Adding Charts to Visualize Data
12:51

Sparklines are used to show many small charts on a single screen.

Displaying Many Categories with Sparklines
05:03

We add Linear Trendlines to our Sparklines to more easily view performance over time.

Using a Linear Trendline to Understand Data
12:09

Take time to properly size and scale our Matrix. Also, add in highlighting to display what cell intersection is currently selected.

Matrix Enhancement
08:11

How to create a new Bar Chart for our report.

Creating a Mini Bar Chart
09:48

How to use Gauges to make our report look better.

Using Gauges to Spice up a Report
15:48

Create a query to calculate the Standard Deviation of a dataset and apply it to a Chart.

Using Standard Deviation Lines to Detect Problems
12:07

How to use Parameters to define a "theme" for our report. Using Parameters allows us to easily make changes throughout the entire report by only changing a single value.

Preview 15:33

Use the currently logged in Windows User to drive what gets displayed in the report.

Using a User's Windows Login to Drive the Report
07:54

Toggle back and forth between display Revenue or Sales Count everywhere on the report.

Dynamically Switching Between Revenue and Count
19:41

SSRS Final
2 questions
+
Conclusion
1 Lecture 01:05
Conclusion
01:05
+
Lectures Based on Questions from Students
1 Lecture 09:14

This lecture shows you how to show a single day of data in the monthly rollup matrix.

Single Day of Sales in a Monthly Rollup
09:14
+
Source Code
6 Lectures 03:43

This is the SQL code for creating the Database Schema for the MyStore database.

Database Schema Source Code
00:36

Here is some sample data to populate the tables with.

Main Table Data
00:34

This is the Stored Procedure used to populate the DIM_DATE table.

usp_Generate_DIM_Date Stored Procedure Source Code
00:24

This is the Stored Procedure used to generate our Metric data.

usp_Generate_Metrics
00:42

This is the Stored Procedure to generate sample sales.

usp_Generate_Sales Stored Procedure Source Code
00:27

This is the Stored Procedure used to generate our Linear Trendlines.

usp_Linear_Trend
00:58
About the Instructor
William Belisle
4.4 Average rating
161 Reviews
1,665 Students
2 Courses
Business Intelligence Master

William got his start in the Business Intelligence field at one of the largest banks in the US. He has since moved on to another company but he continues to pursue his love of BI. Now with seven 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.