SQL Server Reporting Services Part 1 (SSRS)
4.4 (1,254 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,421 students enrolled

SQL Server Reporting Services Part 1 (SSRS)

Learn how to create from simple to complex reports for your business decision making needs
Bestseller
4.4 (1,254 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,421 students enrolled
Created by Raphael Asghar
Last updated 3/2017
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Install SQL Server 2016, Microsoft Visual Studio 2015, create from scratch simple to complex reports that allow the upper management and end users to make important business decisions based on the reports generated
Course content
Expand 32 lectures 06:03:43
+ SQL SERVER REPORTING SERVICES (SSRS)
32 lectures 06:03:43
Download site for SQL 2016 Server
13:49
Correction of next Video
01:12
Download and install SQL Server Data Tools
08:28
Download and attach database AdverntureWorks2016
12:19
Creating a first simple SSRS report
19:22
The basics of formatting a simple report
18:37
Freezing the header columns of report
15:43
Creating a table using the table item object part 1
10:29
Creating a table using the table item object part 2
10:21
Create a Header and a Footer
17:12
How to group columns and use drill down
14:37
Grouping and creating subtotal and totals
13:08
Creating Grand Totals for numbers
04:52
Creating multiple drill down on columns part 1
13:13
Creating multiple drill down on columns part 2
07:34
Importing images
09:15
What is a matrix report
09:22
Creating charts
12:09
What are indicators
13:16
Using and creating a powerful list report
16:01
What are parameters
09:03
Creating a parameter
19:53
Creating a cascading parameter part 1
10:01
Creating a cascading parameter part 2
10:59
Using conditional formatting on a report
11:50
Creating and using templates
10:00
Creating and using templates part 2
10:08
Creating sub reports
14:41
Creating an embedded sub report
05:15
What is the benefit of a bookmark
05:53
Requirements
  • All material, applications, documents, SQL scripts will be provided by the instructor via a zip file that is requested. Student need to take Learn T-SQL course before taking this course (and or SQL Admin part 1, 2, 3 not mandatory but helpful)
Description

After completing this course, the student will be able to install SQL Server 2016, install Microsoft Visual Studio and create from scratch reports from simple to complex reports that aid in upper management in making important business decisions; and at the same time, aid the end user to view, interact with, and distribute reports in various platforms.  He will be versed in creating, formatting, designing, and submitting reports that the users will benefit from each business day.  The student will learn how to navigate through Microsoft visual Studio, learn how to to save .rdl files, create templates, render reports in various format, apply different methods of creating rich reports, help the end user with avoiding redundant input of data, examine ways to insure end user has aggregates for reports and be able to communicate the needs of the company via reports.  This knowledge will make the student become well versed in the ability to help the organization in moving forward with summary visual data.

Who this course is for:
  • Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions
  • Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions. Students will need Learn T-SQL course created by me to help understand the T-SQL scripts created for each report.