Microsoft BI - SQL Server Reporting Service (SSRS) Course

Course Covers SSRS from Basics to Advanced Levels

4.50 (1 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
Microsoft BI - SQL Server Reporting Service (SSRS) Course
9
students
5 hours
content
Dec 2021
last update
$19.99
regular price

What you will 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

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.

Content

SQL Server Reporting Service (SSRS)

Introduction to my first SSRS Package
Introduction to SSRS Report
Shared Data Sets and Shared Data Sources
Parameterized report in detail
Understanding Cascading Reports
Deal with Font, Alignment, Formatting etc.
IIF Condition, Nested IIF, SWITCH Statement, LookUp
Configuring Report Headers and Footers
Deal with Matrix, Sorting
Stored Procedures
Deal with Report Properties
Dynamic Formating
Introduction to Charts
SubReport Rectangle Box
Deploy and Provide Security
Snapshot and history

Charts

Price

Microsoft BI - SQL Server Reporting Service (SSRS) Course - Price chart

Rating

Microsoft BI - SQL Server Reporting Service (SSRS) Course - Ratings chart

Enrollment distribution

Microsoft BI - SQL Server Reporting Service (SSRS) Course - Distribution chart
4423544
udemy ID
12/1/2021
course created date
1/2/2022
course indexed date
Bot
course submited by