Overview SSRS

SSRS Course is designed for students to have complete understanding of Report Life Cycle. All the topics are explained by giving requirement and providing solution which help the student to understand the concepts in a better way.

Course Objectives

• Describe SQL Server mobile reports
• Prepare data for mobile reports
• Publish mobile reports
• Describe key concepts in business intelligence
• Describe the Microsoft BI platform
• Describe key concepts in reporting services
• Describe data connections and connection strings
• Describe filters and parameters
• Create a report using the report wizard
• Show data graphically
• Implement filters and parameters
• Implement sorting and grouping
• Publish a report

Module 1: Introduction to Business Intelligence and Data Modeling

In this module students will be introduced to the key concepts in business intelligence, and the

Microsoft BI product suite.

Lessons

• Introduction to business intelligence
• The Microsoft business intelligence platform
• Introduction to reporting services

Lab: Exploring an enterprise BI solution

Module 2: Reporting Services Data

Describe various Report Services data sources and how these are configured.

Lessons

• Data sources
• Connection strings
• Datasets
• Filters and parameters

Lab: Configuring a data connection

Module 3: Implementing reports

Create reports with report designer or report builder.

Lessons

• Creating a report with the report wizard
• Creating a report
• Showing data graphically in a report

Lab: Creating a report

Module 4: Configuring reports

This module describes how to configure reports with report builder or report designer.

Lessons

• Implementing filters and parameters
• Implementing sorting and grouping
• Publishing a report

Lab: Create and Publish reports that include parameters

Module 5: API Based reports

This module describes How to read for REST API / JSON File / XML Service

Lessons

• Use api as a data source
• create and publish a report

Lab: Create and Publish reports that include data from rest api

Module 6: Creating Mobile Reports

• Overview of SQL Server mobile reports
• Preparing data for mobile reports
• SQL Server Mobile report publisher

Lab: Working with mobile reports

Module 7: Deployment

• Overview of SSRS Development
• Configuration of Report Server
• Deploying SSRS project
• Configure Connections in Reporting Services
• Caching of Data Set
• Subscription

Lab: Deploying and Configuring SSRS Reports

Module 8: Administration

• Manage Folder
• Security and User Access
• Adding and Removing User
• Customized Security Access at folder and report level
• Configure Connections in Reporting Services

Lab: Administration of SSRS Reporting Server

Module 9: Overview of PowerBI

• PowerBI Desktop and Powerbi service
• Licensing in powerbi service
• Create a basic report
• publish a report and share and collabration

Lab: Create a report in powerbi