SQL Server Reporting Services 2012/14- Creating Reports with SSRS and Excel (QS-SSRS2012-14)

About this course:

In this course, you will learn about Microsoft SQL Server Reporting Services and creating and distribution of reports with the help of SQL server reporting services. Important topics like designing reports with the help of Power Pivot and self-service date models. You will be teach to use Power views as well as Power Map to create the reports. In this training course, you will be provided additional learning materials for self-learning on DAX and Power Query. 

Furthermore, the curse is created for clients who want to gain the basic hands-on training on how to create basic reports, modify those reports by adding relevant graphs, and other important elements. Students will also get to learn about parameters and how to use them as query parameters and filters in this course.

The course also aims to teach about Report Builder 3.0 features and tools, and how to use them. Moreover, this course is designed with labs to teach about the use of Microsoft SQL Server Reporting Services to those who want to enhance their skills for the sake of knowledge and career. Currently, SQL Report developers are earning up to $18,714 average salary per year.

Course Objective: 

Students will be able proficient in the following:

• Self-service BI and Reporting Services along with its key features
• SQL Server Reporting Services for the incorporating solution for self-service reporting
• Data mining
• Use of charts for enhancing reports
• Create analytical data models with the help of PowerPivot in Microsoft Excel
• Execute and Deliver Report
• Use of Power View in Microsoft Excel

Audience: 

The course is designed for data analyst and report developers

Prerequisites: 

 The students who are interested in this course should have expertise in SQL Server 2014 features and technologies used to implement databases.