Learn SSRS SQL Reporting & Business Intelligence Essentials

Learn SSRS SQL Reporting & Business Intelligence Essentials, available at $69.99, has an average rating of 4.57, with 33 lectures, 3 quizzes, based on 1183 reviews, and has 7856 subscribers.

You will learn about 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 This course is ideal for individuals who are IT professionals who want to develop their SSRS skillset or Business Intelligence Analysts and Developers looking for new ways to create reports or Some previous experience with Microsoft BI products is helpful, but by no means required It is particularly useful for IT professionals who want to develop their SSRS skillset or Business Intelligence Analysts and Developers looking for new ways to create reports or Some previous experience with Microsoft BI products is helpful, but by no means required.

Enroll now: Learn SSRS SQL Reporting & Business Intelligence Essentials

Summary

Title: Learn SSRS SQL Reporting & Business Intelligence Essentials

Price: $69.99

Average Rating: 4.57

Number of Lectures: 33

Number of Quizzes: 3

Number of Published Lectures: 33

Number of Published Quizzes: 3

Number of Curriculum Items: 36

Number of Published Curriculum Objects: 36

Original Price: $119.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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:

Database Setup – Explains the schema of the database, the data, the Stored Procedures, and other general back-end items.
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 usefulreports.

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Quick Notes About the Course

Lecture 3: Installation of All Software Needed for the Course

Chapter 2: Database Setup

Lecture 1: Exploring Our Database Schema

Lecture 2: Overview of Our Main Table Data

Lecture 3: Generating Sales Data

Lecture 4: Populating a Date Dimension Table for Later Use

Lecture 5: Generating Metric Data

Chapter 3: SSRS

Lecture 1: Creating a New Project and Datasource

Lecture 2: Creating a New RDL

Lecture 3: Adding a Sales Table to Get Started

Lecture 4: Using a Matrix to Better Organize Our Data

Lecture 5: Adding Prompts for User Interaction

Lecture 6: Using Drill Throughs

Lecture 7: Making use of SubReports

Lecture 8: Adding Charts to Visualize Data

Lecture 9: Displaying Many Categories with Sparklines

Lecture 10: Using a Linear Trendline to Understand Data

Lecture 11: Matrix Enhancement

Lecture 12: Creating a Mini Bar Chart

Lecture 13: Using Gauges to Spice up a Report

Lecture 14: Using Standard Deviation Lines to Detect Problems

Lecture 15: Using Colors as Parameters to Save Time

Lecture 16: Using a User's Windows Login to Drive the Report

Lecture 17: Dynamically Switching Between Revenue and Count

Chapter 4: Conclusion

Lecture 1: Conclusion

Chapter 5: Lectures Based on Questions from Students

Lecture 1: Single Day of Sales in a Monthly Rollup

Chapter 6: Source Code

Lecture 1: Database Schema Source Code

Lecture 2: Main Table Data

Lecture 3: usp_Generate_DIM_Date Stored Procedure Source Code

Lecture 4: usp_Generate_Metrics

Lecture 5: usp_Generate_Sales Stored Procedure Source Code

Lecture 6: usp_Linear_Trend

Instructors

William Belisle
Business Intelligence Master

Rating Distribution

1 stars: 23 votes
2 stars: 24 votes
3 stars: 158 votes
4 stars: 462 votes
5 stars: 517 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu