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.6 (76 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.
989 students enrolled
$80
Take This Course
  • Lectures 32
  • Contents Video: 3 hours
    Other: 5 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2014 English

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.

What are the 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

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
01:25

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

Quick Notes About the Course
Preview
01:04
Section 2: Database Setup
02:43

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.

02:14

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

02:02

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

03:51

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

04:13

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

4 questions

test

Section 3: SSRS
01:36

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.

03:57

How to create a new RDL.

05:49

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

05:58

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

17:05

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

SSRS Basics
3 questions
03:05

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

05:26

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

12:51

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

05:03

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

12:09

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

08:11

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

09:48

How to create a new Bar Chart for our report.

15:48

How to use Gauges to make our report look better.

12:07

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

15:33

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.

07:54

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

19:41

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

SSRS Final
2 questions
Section 4: Conclusion
Conclusion
01:05
Section 5: Lectures Based on Questions from Students
09:14

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

Section 6: Source Code
Article

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

Article

Here is some sample data to populate the tables with.

Article

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

Article

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

Article

This is the Stored Procedure to generate sample sales.

Article

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

William Belisle, 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.

Ready to start learning?
Take This Course