Business Reports with SQL Server Reporting Services (SSRS)
What you'll learn
- 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
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 beginner's guide to SSRS.
What You Will Learn
installing SQL Server 2019
Installing SQL Server Management Studio
Download And Setup Adventure Works Database
Download And Install SQL Server Reporting Services (SSRS)
Introduction To The SSRS Portal
Download 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-time setup. If you are a beginner 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.
All you need to get started is your personal computer and good internet connectivity to download the required software for this course.
Who this course is for:
- Beginners who are curious about getting started with data analytics and reporting
Experience as a Developer
I have always loved to build things. Back in University, I was introduced to my first programming course, Visual Basic 6, and was fascinated by how much you could build just by typing in a few lines of code and watching your app come to life! I pursued my curiosity further by picking up Java and learning the concepts of object-oriented programming.
Upon graduating, I took a full-time job as a software developer in a card payments company where I learned how to program with C++. I also became interested in mobile development and learned how to use cross platform frameworks such as Cordova. Today, I design and build enterprise software primarily using the .NET Core and .NET Framework as well as ASP.NET (Web forms and MVC)
Experience as an Instructor
I love to teach, for me it is personally satisfying to help someone navigate through the unknown and eventually gain mastery in the chosen area. While I have taught many classes offline and in-person, Udemy gives me an opportunity to bring some of that experience online. A major advantage with me is that I teach from a real-world perspective and this gives my students the best chance at being able to apply the knowledge they gain from my courses practically. This makes it easy for them become productive (if they already work in tech) or positions them to get a job in tech if they are just starting out in their careers.