Microsoft SQL Server Reporting Services (SSRS) (Udemy.com)

Build reports in SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity. Exam 70-466

( 338 Reviews )

Created by: Phillip Burton

Produced in 2021

What you will learn

Create reports in SQL Server Reporting Services (SSRS).
We will develop your skills, bit by bit.
You can also download a free version of SQL Server which will allow you to practice creating reports on your own.
We will design a report, implementing report layouts and add interactivity into your reports.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 84 / 100

Course Description

Reviews:
"Brilliant! This tutorial will definitely save you hours of figuring out things yourself." -- Koos ten Bras
"Excellent course, well presented and clear examples." - Peter Cawthorne
This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful.
We will download a version of SQL Server which includes SSRS - for free. We'll also download a database called AdventureWorks, which we will use in our reports.
We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:

Select report components (matrix, table, chart and other data visualisation component),
Identify the data source and parameters,
Design a grouping structure,
Create drilldown reports and drillthrough reports.

As part of implementing a report layout, we will:

Find out how to format, including formatting colours, dates and numbers;
Configure the page;
Implement headers and footers;
Implement matrices, tables, chart, images, indicators, maps and groupings in reports;
Create a range of reports using different data regions;
Define custom fields;
Implement global collections;
Define expressions; and
Implement data visualisation components.

As part of implementing interactivity in a report, we will:

Create drilldown reports;
Create drillthrough reports;
Add interactive sorting;
Investigate parameters, including multi-value parameters;
Create dynamic reports in SSRS using parameters;
Implement show/hide property;
Add actions (jump to report and URL);
Add Fixed headers and a document map.

By the end of this course, you should be confident in creating your own reports in SSRS.
It will assist with the "Build a report with SQL Server Reporting Services (SSRS)" section of Microsoft exam 70-766 "Implementing Data Models and Reports with Microsoft SQL Server".
Who this course is for:

This course is for you if you want to know how to create reports in SSRS.
No prior experience with T-SQL is required, although the more knowledge you have it, the better.
Having SharePoint on your computer is not necessary; we will use the stand-alone version of SQL Server. However, I will show the differences and similarities between Report Builder (SharePoint) and SSDT (the stand-alone version).
In this course we will cover several aspects which are tested in Microsoft's 70-466 exam "Implementing Data Models and Reports with Microsoft SQL Server".
This course is not for you if you only want to know about managing your existing SSRS reports in SharePoint.

Time: 6h

Instructor Details

Phillip Burton

4.2 Rating
338 Reviews

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

More courses by Phillip Burton

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)

- Provider: Udemy
- Time: 29.5h

$11.99

SQL Server Integration Services (SSIS) - An Introduction

SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)

- Provider: Udemy
- Time: 4h

$11.99

70-462: SQL Server Database Administration (DBA)

70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

70-778, DA-100: Analyzing and Visualizing Data with Power BI

70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)

- Provider: Udemy
- Time: 24h

$11.99

SQL Server SSAS (Multidimensional MDX) - an Introduction

SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)

- Provider: Udemy
- Time: 8h

$11.99

SQL Server Essentials in an hour: The SELECT statement

SQL Server Essentials in an hour: The SELECT statement (2021)
4.5 (183 Reviews)

- Provider: Udemy
- Time: 1h

$11.99

All courses by Phillip Burton

Reviews

4.2

338 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Bhanukiran Edupuganti on 11/15/2020

great tutorial but not in an advanced manner need much more advanced techniques

By Venkat on 11/8/2020

Expectation met

By Manfred Zoller on 11/8/2020

Yes, I am enjoying the easy to follow and clear explanations.

By Dawn on 10/21/2020

I am only on Section 3 lesson 21 and I am really enjoying it! The teacher is very easy to listen to and sticks to the point of the lesson. I have purchase a lot of courses that at the end I was taken in so many different directions I was more confused then ever. Thank you, I am looking forward to finishing this courses and taking more!

By Jenny Medina on 10/19/2020

This course was a good start to learning SSRS.

By Luc Bruyninckx on 10/17/2020

At the moment it is very clear and good explained. Only the newer versions reacts different. Some optons are disappeared.

By Rajni J on 10/14/2020

Good to understand easily

By Florian Jaraczewski on 10/14/2020

What other courses will I next to pass 70-466 exam?

By McKenzie Bell on 9/27/2020

The instructor has great course material, he provides an understandable walk -through. He makes learning fun because of his patience and engagement. Best course yet

By Ezequiel Ansaldi on 9/17/2020

Not the most interactive/attention keeping course, but being new to SSRS I don't have a lot to compare it to. With that said, compared to the SQL Udemy course I had taken before this (different instructor) it definitely wasn't as good in the aforementioned aspects.
I also had issues where the videos seemed disjointed from another and would sometimes cut out at the end, as with poor video editing, even though they were still talking. Also personally using Visual Studio 2019 throughout the course, there were some noticeable differences between what he showed and my own version of visual studio.
All in all I did learn a bit, but the experience wasn't as smooth or good as it could've been. I would recommend that the instructor remake the entire course with the newest version of visual studio, since as of right now it seems to be patched together from various changes and updates that have left the course rather clunky.

By Diptee Ayachit on 9/15/2020