Udemy - SQL Server Reporting Services (SSRS)

What you'll learn
Students will learn MSBI(Microsoft Business Intelligence)
Students will learn SSRS(SQL Server Reporting Services)
SSRS Reports examples
SSRS using SSDT 2019 latest version
SSRS 2019 Installation using Visual Studio 2019
SSRS Basic to advanced concepts with examples
Requirements
SQL Basic Knowledge would be preferred
Description
This course covers basic to advanced SSRS topics
SSRS Installation and Setup
How to create report , develop and deploy the complex reports
How to troubleshoot the reports if any error
Data Sources , Data sets, performance improvements , Report Manager Setup, Report Server configuration
Graphical Reports, Table Reports, Matrix Reports, Guage reports, SSRS with API interaction
SSRS with dot net code integration
Page numbers setup
SSRS Parameters configuration
SSRS Interview questions with answers
SSRS Log files
SSRS User Statistics
SSRS Reports delivery
SSRS:
It's a reporting platform; it's used to generate the reports from any data source (any RDBMS).Provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports
SSRS Dev Roles:
· Understanding the database structure.
· Writing the queries, views, stored procedures and UDF's.
· Authoring reports
Defining Data sources.
Designing reports.
· Customizing the reports.
SSRS expression
Scripting (.net languages)
SSRS Admin Roles:
· Installation
· Configuration
· Managing Reports
Development
Security
· Delivering reports
Subscriptions
Rendering formats
· Monitoring and troubleshooting the ssrs environment.
Enterprise reports:
Complete business standards and rules followed.
Formatting and other requirements collected.
Report developers will prepare these reports with complexity.
Shared among the business users in the enterprise.
Standard data analysis and decision making purpose.
Ad-hoc reports:
No business standard and no rules followed.
No formatted and other requirements.
Non-technical business managers will prepare these reports.
Not shared among business users in the enterprise.
Ad-hoc data analysis purpose.
Embedded Reports:
Embedding the report to any third party application such as Java,.Net etc..
Who this course is for:
Any IT Student