Microsoft BI – SQL Server Reporting Service (SSRS) Course

Microsoft BI – SQL Server Reporting Service (SSRS) Course, available at $19.99, has an average rating of 4.5, with 16 lectures, based on 1 reviews, and has 13 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners or BI professional or Business Analysts or Programmers or Project Managers It is particularly useful for Beginners or BI professional or Business Analysts or Programmers or Project Managers.

Enroll now: Microsoft BI – SQL Server Reporting Service (SSRS) Course

Summary

Title: Microsoft BI – SQL Server Reporting Service (SSRS) Course

Price: $19.99

Average Rating: 4.5

Number of Lectures: 16

Number of Published Lectures: 16

Number of Curriculum Items: 16

Number of Published Curriculum Objects: 16

Original Price: ₹3,299

Quality Status: approved

Status: Live

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

Who Should Attend

Beginners
BI professional
Business Analysts
Programmers
Project Managers

Target Audiences

Beginners
BI professional
Business Analysts
Programmers
Project Managers

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.

Course Curriculum

Chapter 1: SQL Server Reporting Service (SSRS)

Lecture 1: Introduction to my first SSRS Package

Lecture 2: Introduction to SSRS Report

Lecture 3: Shared Data Sets and Shared Data Sources

Lecture 4: Parameterized report in detail

Lecture 5: Understanding Cascading Reports

Lecture 6: Deal with Font, Alignment, Formatting etc.

Lecture 7: IIF Condition, Nested IIF, SWITCH Statement, LookUp

Lecture 8: Configuring Report Headers and Footers

Lecture 9: Deal with Matrix, Sorting

Lecture 10: Stored Procedures

Lecture 11: Deal with Report Properties

Lecture 12: Dynamic Formating

Lecture 13: Introduction to Charts

Lecture 14: SubReport Rectangle Box

Lecture 15: Deploy and Provide Security

Lecture 16: Snapshot and history

Instructors

Amit Kumar
Technology Consultant, Corporate BI and Analytics Trainer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 1 votes
5 stars: 0 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