Microsoft BI - SQL Server Reporting Service (SSRS) Course

Name: Microsoft BI - SQL Server Reporting Service (SSRS) Course
Rating: 4.7 (7 reviews)

Course Covers SSRS from Basics to Advanced Levels

Created byAmit Kumar

Last updated 12/2021

English

What you'll learn

MSBI - Microsoft Business Intelligence
SSRS - SQL Server Reporting Services
Able to be expert in data analytics
The career path will be wider so that a student can achieve a successful position in IT industry

Course content

1 section • 16 lectures • 5h 7m total length

Introduction to my first SSRS Package26:30
Introduction to SSRS Report17:27
Shared Data Sets and Shared Data Sources10:10
Parameterized report in detail17:35
Understanding Cascading Reports11:56
Explore cascading reports in SQL Server Reporting Services by building a parameterized report with dependent parameters: company and quarter. See how selecting a company filters quarters and enables multiple values.
Deal with Font, Alignment, Formatting etc.22:28
IIF Condition, Nested IIF, SWITCH Statement, LookUp22:36
Explore IIF conditions, nested IIF, and switch statements in SSRS, and learn to use lookups to join datasets and dynamically format report elements.
Configuring Report Headers and Footers14:33
Deal with Matrix, Sorting7:05
Design a matrix in SSRS to display company and quarter data like a pivot, apply sorting with group properties, and handle zero or missing values.
Stored Procedures7:29
Learn how to use the stored procedure usp_company in an SSRS report by configuring the data source and dataset, and passing a company parameter to filter results.
Deal with Report Properties27:48
Dynamic Formating21:02
Explore value formatting in SSRS by applying custom formats, currency, and thousand separators, and set dynamic, condition-based decimal rules using text box properties and expressions.
Introduction to Charts25:50
Learn to create ssrs charts, including column and line types, assign values and categories for quarterly data, add data labels and colors, and use chart areas for amount and balance.
SubReport Rectangle Box17:08
Construct a shared dataset and multiple reports in SSRS, embed a subreport inside a rectangle, and pass parameters to control visibility of text boxes for dynamic output.
Deploy and Provide Security35:16
Deploy and secure SSRS reports by configuring deployment, using the report manager and browser for viewing, and managing permissions, folder structures, data sources, and datasets for end users.
Snapshot and history22:58
Learn to create and manage snapshots and history in SSRS, and configure schedules to run reports automatically. Store the outputs as snapshots and history to review past results and trends.

Requirements

Basic Knowledge on SQL
Basic knowledge on Data Warehousing

Description

Course Covers SSRS which is applicable for students from Basics to Advanced Levels.

This course is all about creating reports in Microsoft SQL Server Reporting Services (SSRS). No prior Programming or BI knowledge is needed, but some knowledge of SQL would be helpful.

We will download a version of SQL Server which includes SSRS - for free.

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.

Who this course is for:

Beginners
BI professional
Business Analysts
Programmers
Project Managers