Business Reports with SQL Server Reporting Services (SSRS)

[LeeAndro]

Published 09/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 25 lectures (2h 24m) | Size: 723.4 MB

Learn how to design and deploy business reports for personal use or for work
Get started with the basics of SQL Server Reporting Services
Learn the basics of SQL Server installation and SQL Management Studio
Build subscriptions to a Report for Automatic Delivery to E-Mail recipients
Adding Graphs/Charts to your report
Publishing Your Report to the SSRS Server

Basic understanding of SQL, no programming knowledge required

Class Overview

Learn how to design and deploy business reports for personal use or for work.​

In this course, you will get started with the basics of SQL Server Reporting Services - everything from installation to creating your first report. I also include some basic SQL Server installation and SQL Management Studio to provide a complete bner's guide to SSRS.

What You Will Learn

installing SQL Server 2019

Installing SQL Server Management Studio

And Setup Adventure Works Database

And Install SQL Server Reporting Services (SSRS)

Introduction To The SSRS Portal

And Install Report Builder

Creating A Datasource & Shared Datasource

Creating Your First Dataset

Creating Your First SSRS Report

Designing The Report - Header & Footer

Creating And Formatting A Report Table View

Introduction To Expressions

Introduction To Parameters

Working With Dropdown Parameters

Creating Linked Or Dependent/Cascading Dropdown Parameters

Adding Images To Your SSRS Report

Grouping, Serials & Totals In SSRS

Adding Graphs/Charts To Your Report

Publishing Your Report To The SSRS Server

Subscribing To A Report For Automatic Delivery - To A File Folder

Subscribing To A Report For Automatic Delivery - To E-Mail Recipients

Who Should Take This Class

In this day and age, automation of routine tasks is key. It is possible to create a business report, deploy it and automatically schedule it to be delivered to your intended recipients with a one- setup. If you are a bner who is interested in becoming a data analyst or database/backend developer then this course if for you.

If you are already a developer who needs to now include business reporting as part of your solution, then this class will get you started and building your first report in a matter of minutes.

Who This Course Is For

This is course is great for you if you want to get started with Data Analytics as some of the concepts taught here will be useful in more advanced data analytics courses.

If you work with colleagues that require reports sent to them on a regular schedule (e.g. 9am each morning) You can automate this task and have your reports delivered without a need to think about it. This course is also for you if you work with data and are expected to quickly produce analysis and insight into different datasets as part of a larger team or on a project.

Materials/Resources

All you need to get started is your personal computer and good internet connectivity to the required software for this course.

Bners who are curious about getting started with data analytics and reporting

HomePage:

https://anonymz.com/https://www.udemy.com/course/business-reports-with-ssrs/

DOWNLOAD

https://1dl.net/h3rk8itaukcl/fSSbo9lw__Business_R.rar.html