Learn SSRS SQL Reporting & Business Intelligence Essentials from Udemy

What's inside

Learning objectives

By the end of this course, you will be able to create great ssrs reports.
You will learn how to extract data from a database
You will learn how to organize large amounts of data into concise reports

You will learn how to use graphical display objects to make reports that stand out
You will learn how to work smarter, not harder, by learning techniques that cut down on repetitive work

By the end of this course, you will be able to create great ssrs reports.
You will learn how to extract data from a database
You will learn how to organize large amounts of data into concise reports
You will learn how to use graphical display objects to make reports that stand out
You will learn how to work smarter, not harder, by learning techniques that cut down on repetitive work

Syllabus

Introduction

This lecture gives you an overview of some of the topics that will be covered in this course.

Quick Notes About the Course

A video showing the complete installation process for all software that you will need in order to complete the class. You do not need to follow along on your own. If you prefer you can just watch the videos without installing anything.

Database Setup

This is an explanation of the database schema we will be using for this course. It is highly recommended you view this video before starting other lectures.

Use the supplementary materials attached to build a copy of this database.

An explanation of the data inside each of the database tables.

A detailed look at the Stored Procedure usp_Generate_Sales. This shows how to generate the random sales data we will be reporting on.

A detailed look at the Stored Procedure usp_Generate_DIM_Date. This explains what a Date Dimension table is and how to create one.

A detailed look at the Stored Procedure usp_Generate_Metrics. This explains what Metrics are and how to create them.

test

SSRS

The first lecture of the SSRS portion of the course. It is recommended that you at watch the Database Setup videos from above prior to starting this lecture.

This lecture covers how to create a new project and set up a shared datasource in SSRS.

How to create a new RDL.

This lecture covers how to create a simple Sales Table and it's pros and cons.

This improves upon the Sales Table from the previous lecture by creating a Sales Matrix.

This adds interactivity to the Sales Matrix from the previous lecture.

SSRS Basics

This shows you how to add Drill Throughs to our existing report.

This shows you how to incorporate Sub Reports into your reporting.

This adds charts to display our data in a graphical way.

Sparklines are used to show many small charts on a single screen.

We add Linear Trendlines to our Sparklines to more easily view performance over time.

Take time to properly size and scale our Matrix. Also, add in highlighting to display what cell intersection is currently selected.

How to create a new Bar Chart for our report.

How to use Gauges to make our report look better.

Create a query to calculate the Standard Deviation of a dataset and apply it to a Chart.

How to use Parameters to define a "theme" for our report. Using Parameters allows us to easily make changes throughout the entire report by only changing a single value.

Use the currently logged in Windows User to drive what gets displayed in the report.

Toggle back and forth between display Revenue or Sales Count everywhere on the report.

SSRS Final

Conclusion

This section includes lectures that have been created based on questions or feedback from students who took this course.

This lecture shows you how to show a single day of data in the monthly rollup matrix.

Some people were asking for the source code for Stored Procedures and the Database Schema to be made more accessible. Here it is!

This is the SQL code for creating the Database Schema for the MyStore database.

Here is some sample data to populate the tables with.

This is the Stored Procedure used to populate the DIM_DATE table.

This is the Stored Procedure used to generate our Metric data.

This is the Stored Procedure to generate sample sales.

This is the Stored Procedure used to generate our Linear Trendlines.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Efficiently extract data from databases to create reports

Organize large data into well-designed reports

Use graphical representations to enhance report clarity

Employ parameters to modify reports effortlessly

Automate repetitive tasks to save time

Leverages industry-leading technology

Reviews summary

Introduces sql reporting basics

According to students, this course gives a solid introduction to the basics of SSRS but falls short by not covering topics such as deployment and report subscribing processes.

Provides a fundamental overview of SSRS concepts.

"Good course tells about the basics of SSRS..."

Q&A not impressive.

"The Q&A process wasn't impressive either."

No coverage of deployment or report subscribing.

"...but doesn't tell anything about the deployment or various report subscribing processes."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Learn SSRS SQL Reporting & Business Intelligence Essentials with these activities:

Review SQL

Show steps

Review the basics of SQL to ensure you have a strong foundation for this course.

Browse courses on SQL

Show steps

Refer to your class notes or online resources to review the basics of SQL.
Practice writing SQL queries to extract data from a database.

Join an SSRS Study Group

Show steps

Join an SSRS study group to collaborate with peers and enhance your learning.

Browse courses on SSRS

Show steps

Find or create an SSRS study group.
Meet with your study group regularly.

Explore SSRS Documentation

Show steps

Explore the SSRS documentation to learn about advanced features and best practices.

Browse courses on SSRS

Show steps

Visit the Microsoft SSRS documentation website.
Read through the tutorials and articles on SSRS.
Experiment with the features described in the documentation.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Create Basic SSRS Reports

Show steps

Create basic SSRS reports to practice the skills you learn in this course.

Browse courses on SSRS

Show steps

Create a new SSRS report project.
Add a data source to your report.
Create a simple table or matrix report.

Attend an SSRS Workshop

Show steps

Attend an SSRS workshop to learn from experts and network with other professionals.

Browse courses on SSRS

Show steps

Find an SSRS workshop that aligns with your interests.
Register for the workshop.

Develop a Custom SSRS Report

Show steps

Develop a custom SSRS report that meets a specific business need.

Browse courses on SSRS

Show steps

Identify a business need for a custom report.
Design the report layout and functionality.
Develop the report using SSRS.

Participate in an SSRS Hackathon

Show steps

Participate in an SSRS hackathon to test your skills and collaborate with others.

Browse courses on SSRS

Show steps

Find an SSRS hackathon that aligns with your interests.
Register for the hackathon and form a team.

Mentor Junior SSRS Developers

Show steps

Mentor junior SSRS developers to share your knowledge and contribute to the community.

Browse courses on SSRS

Show steps

Identify junior SSRS developers who could benefit from your guidance.
Offer your mentorship and support.

Career center

Learners who complete Learn SSRS SQL Reporting & Business Intelligence Essentials will develop knowledge and skills that may be useful to these careers:

Data Analyst

As a Data Analyst, you will be responsible for collecting, cleaning, and analyzing data to help businesses make better decisions. This course will give you the skills you need to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. With a strong foundation in SQL Reporting and Business Intelligence, you'll be able to identify trends and patterns in data, and communicate your findings to stakeholders in a clear and concise way.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

As a Business Intelligence Analyst, you will be responsible for using data to help businesses improve their performance. You will need to be able to identify trends and patterns in data, and develop insights that can help businesses make better decisions. This course will give you the skills you need to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out.

See salaries and explore the career path for Business Intelligence Analyst

Database Administrator

As a Database Administrator, you will be responsible for managing and maintaining databases. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Database Administrator

IT Auditor

As an IT Auditor, you will be responsible for auditing IT systems and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for IT Auditor

Information Security Analyst

As an Information Security Analyst, you will be responsible for analyzing information security data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Information Security Analyst

Financial Analyst

As a Financial Analyst, you will be responsible for analyzing financial data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Financial Analyst

Marketing Analyst

As a Marketing Analyst, you will be responsible for analyzing marketing data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Marketing Analyst

Operations Analyst

As an Operations Analyst, you will be responsible for analyzing operations data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Operations Analyst

Risk Analyst

As a Risk Analyst, you will be responsible for analyzing risk data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Risk Analyst

Compliance Analyst

As a Compliance Analyst, you will be responsible for analyzing compliance data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Compliance Analyst

Sales Analyst

As a Sales Analyst, you will be responsible for analyzing sales data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Sales Analyst

Fraud Analyst

As a Fraud Analyst, you will be responsible for analyzing fraud data and making recommendations to businesses. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Fraud Analyst

Data Scientist

As a Data Scientist, you will be responsible for using data to solve complex problems. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Data Scientist

Report Writer

As a Report Writer, you will be responsible for creating reports that communicate data to stakeholders. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Report Writer

Business Analyst

As a Business Analyst, you will be responsible for analyzing business processes and identifying areas for improvement. You will need to be able to extract data from a database, organize it into concise reports, and use graphical display objects to make reports that stand out. This course will give you the skills you need to build a strong foundation in SQL Reporting and Business Intelligence.

See salaries and explore the career path for Business Analyst