We may earn an affiliate commission when you visit our partners.
SQL Server Reporting Services Part 2 (SSRS)
Raphael Asghar
Raphael Asghar
The following course SQL Server Reporting Services (SSRS) part 2 is designed for those individual that are in the IT industry, SQL DBAs, developers, or want to learn how to design, manage, and deploy rich interactive reports for their business needs. This course is a follow up course to SQL Server Reporting Services (SSRS part 1), which is a requisite along with SQL Server Integration Services (SSIS) course. The student at the end of this course will be able to deploy SSSR reports to the web portal for end users to view and interact with, build the easy to use report builder for the non techie individuals in the company to interact with, create and design complicated mobile reports that can be viewed not only on the PC computer but also on tablets and the phone.
Register for this course and see more details by visiting:
OpenCourser.com/course/17jzh7/sql
What's inside
Learning objective
At the end of this course, the student will be able to understand how to configure, design, manage and deploy ssrs report to the web portal for users to view reports. he will be versed in managing and configuring the report builder for end users, design and create technically advanced mobile reports publisher and initiate the security measures needed to secure the ssrs environment and much more
At the end of this course, the student will be able to understand how to configure, design, manage and deploy ssrs report to the web portal for users to view reports. he will be versed in managing and configuring the report builder for end users, design and create technically advanced mobile reports publisher and initiate the security measures needed to secure the ssrs environment and much more
Syllabus
At the end of this course, the student will be able to deploy paginated reports to the web portal, design with report builder, create mobile reports, and secure the SSRS environment, provide KPIs.
Read more
Syllabus
At the end of this course, the student will be able to deploy paginated reports to the web portal, design with report builder, create mobile reports, and secure the SSRS environment, provide KPIs.
Read more
Introduction
INSTALLING DATA TOOLS
INSTALLING DATA TOOLS PART 2
REPORT SERVER CONFIGURATION PART 1
REPORT SERVER CONFIGURATION PART 2
WHAT ARE THE SSRS DATABASES
USING THE WEB PORTAL TO VIEW REPORTS PART 1
USING THE WEB PORTAL TO VIEW REPORTS PART 2
FOLDER MANAGEMENT
SSRS SECURITY PART 1
SSRS SECURITY PART 2
CREATING YOUR OWN ROLE
SYSTEM ADMIN AND SYSTEM USER ACCOUNTS
SUBSCRIPTION PART 1
SUBSCRIPTION PART 2
DEPLOY SUBSCRIPTION
BACKUP REPORTSERVER
REPORT BUILDER DOWNLOAD
REPORT BUILDER USING WIZARD
REPORT BUILDER FROM SCRATCH
WHAT ARE KPIS?
KPI CACHING
KPI: VIEWING A JOB
SQL SSRS MOBILE REPORT PART 1
SQL SSRS MOBILE REPORT PART 2
REAL LIFE DEMO
FROM DATA TO MOBILE PUBLISHER PART 1
FROM DATA TO MOBILE PUBLISHER PART 2
IMPORTING DATA FROM ACCESS DATABASE PART 1
IMPORTING DATA FROM ACCESS DATABASE PART 2
CREATING A MOBILE REPORT
CREATING A PAGINATED REPORT FROM SCRATCH PART 1
CREATING A PAGINATED REPORT FROM SCRATCH PART 2
CREATE A REPORT FOR USA UNIVERSITY PART 1
CREATE A REPORT FOR USA UNIVERSITY PART 2
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Examines SQL Server Reporting Services (SSRS), which is standard in the IT industry
Taught by Raphael Asghar, who is recognized for his work in data management
Provides hands-on labs and interactive materials that help learners build projects
Develops technical skills that are core for SQL DBAs and developers
This course requires SQL Server Integration Services (SSIS) as a prerequisite
Save this course
Save SQL Server Reporting Services Part 2 (SSRS) to your list so you can find it easily later:
Save
Save
Reviews summary
Not well received by students
According to students, SQL Server Reporting Services Part 2 (SSRS) is not well received. Students complain that the instructor talks too fast and they have difficulty following the lectures.
Instructor talks too fast.
"Horrible talks to fast"
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 SQL Server Reporting Services Part 2 (SSRS) with these
activities:
Review your notes from the SQL Server Integration Services (SSIS) course
Show steps
This activity is a prerequisite to the course and will help refresh your knowledge of SSIS before starting SSRS.
Browse courses on
SQL Server Integration Services (SSIS)
Show steps
-
Locate the notes from the SQL Server Integration Services (SSIS) course.
-
Read over the notes and take time to refresh your understanding of the concepts.
Review 'SQL Server 2008 Reporting Services Unleashed'
Show steps
This book will help you lay a strong foundation of SQL Server Reporting Services so that you can follow along in the course more easily.
View
The Definitive Guide to DAX: Business...
on Amazon
Show steps
-
Read the first three chapters of the book.
-
Complete the exercises in the first three chapters.
Join a study group for SQL Server Reporting Services
Show steps
This study group will help you learn from your peers and get help with the course material.
Browse courses on
SQL Server Reporting Services
Show steps
-
Find a study group for SQL Server Reporting Services.
-
Attend the study group meetings.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Practice creating SSRS reports
Show steps
These exercises will help you develop the skills you need to create SSRS reports.
Show steps
-
Create a simple SSRS report using the Report Wizard.
-
Create a more complex SSRS report using the Report Builder.
-
Deploy an SSRS report to a web server.
Follow a tutorial on creating SSRS mobile reports
Show steps
This tutorial will help you learn how to create SSRS mobile reports.
Browse courses on
Reporting Services
Show steps
-
Find a tutorial on creating SSRS mobile reports.
-
Follow the steps in the tutorial.
Write a blog post about your experience with SQL Server Reporting Services
Show steps
This blog post will help you solidify your understanding of the course material and share your knowledge with others.
Browse courses on
SQL Server Reporting Services
Show steps
-
Choose a topic for your blog post.
-
Write a draft of your blog post.
-
Edit and publish your blog post.
Create a dashboard using SQL Server Reporting Services
Show steps
This project will help you apply the skills you have learned in the course to create a real-world dashboard.
Browse courses on
SQL Server Reporting Services
Show steps
-
Choose a dataset for your dashboard.
-
Create a report that includes the data you want to display on your dashboard.
-
Create a dashboard that includes the report you created in step 2.
Participate in a hackathon to create an SSRS report
Show steps
This hackathon will help you apply the skills you have learned in the course to create a real-world SSRS report.
Show steps
-
Find a hackathon that is focused on creating SSRS reports.
-
Register for the hackathon.
-
Create an SSRS report for the hackathon.
Review your notes from the SQL Server Integration Services (SSIS) course
Show steps
This activity is a prerequisite to the course and will help refresh your knowledge of SSIS before starting SSRS.
Browse courses on
SQL Server Integration Services (SSIS)
Show steps
Show steps
Show steps
- Locate the notes from the SQL Server Integration Services (SSIS) course.
- Read over the notes and take time to refresh your understanding of the concepts.
Review 'SQL Server 2008 Reporting Services Unleashed'
Show steps
This book will help you lay a strong foundation of SQL Server Reporting Services so that you can follow along in the course more easily.
View
The Definitive Guide to DAX: Business...
on Amazon
Show steps
Show steps
Show steps
- Read the first three chapters of the book.
- Complete the exercises in the first three chapters.
Join a study group for SQL Server Reporting Services
Show steps
This study group will help you learn from your peers and get help with the course material.
Browse courses on
SQL Server Reporting Services
Show steps
Show steps
Show steps
- Find a study group for SQL Server Reporting Services.
- Attend the study group meetings.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Practice creating SSRS reports
Show steps
These exercises will help you develop the skills you need to create SSRS reports.
Show steps
Show steps
Show steps
- Create a simple SSRS report using the Report Wizard.
- Create a more complex SSRS report using the Report Builder.
- Deploy an SSRS report to a web server.
Follow a tutorial on creating SSRS mobile reports
Show steps
This tutorial will help you learn how to create SSRS mobile reports.
Browse courses on
Reporting Services
Show steps
Show steps
Show steps
- Find a tutorial on creating SSRS mobile reports.
- Follow the steps in the tutorial.
Write a blog post about your experience with SQL Server Reporting Services
Show steps
This blog post will help you solidify your understanding of the course material and share your knowledge with others.
Browse courses on
SQL Server Reporting Services
Show steps
Show steps
Show steps
- Choose a topic for your blog post.
- Write a draft of your blog post.
- Edit and publish your blog post.
Create a dashboard using SQL Server Reporting Services
Show steps
This project will help you apply the skills you have learned in the course to create a real-world dashboard.
Browse courses on
SQL Server Reporting Services
Show steps
Show steps
Show steps
- Choose a dataset for your dashboard.
- Create a report that includes the data you want to display on your dashboard.
- Create a dashboard that includes the report you created in step 2.
Participate in a hackathon to create an SSRS report
Show steps
This hackathon will help you apply the skills you have learned in the course to create a real-world SSRS report.
Show steps
Show steps
Show steps
- Find a hackathon that is focused on creating SSRS reports.
- Register for the hackathon.
- Create an SSRS report for the hackathon.
Career center
Learners who complete SQL Server Reporting Services Part 2 (SSRS) will develop knowledge and skills
that may be useful to these careers:
Business Intelligence Analyst
Business Intelligence Analyst
Business intelligence analysts help companies make better decisions by providing them with data-driven insights. They use their skills in data analysis, data visualization, and reporting to identify trends, patterns, and opportunities. This course can be a valuable tool for aspiring business intelligence analysts, as it provides them with the skills and knowledge they need to succeed in this role.
Data Analyst
Data Analyst
Data analysts are responsible for collecting, cleaning, and analyzing data to help businesses understand their customers, products, and operations. They use their skills in data analysis, statistics, and programming to identify trends, patterns, and opportunities. This course can help data analysts build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in data analysis and reporting.
Database Administrator
Database Administrator
Database administrators are responsible for managing and maintaining databases. They ensure that databases are running smoothly, that data is secure, and that data is backed up in case of a system failure. This course can help database administrators build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in database management and administration.
Data Scientist
Data Scientist
Data scientists use their skills in data analysis, statistics, and machine learning to solve complex business problems. They use data to build models that can predict future outcomes, identify trends, and patterns, and make recommendations. This course can help data scientists build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in data analysis, machine learning, and data visualization.
Software Engineer
Software Engineer
Software engineers design, develop, and maintain software applications. They use their skills in programming, software design, and testing to build software that meets the needs of users. This course can help software engineers build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in software development and testing.
Web Developer
Web Developer
Web developers design, develop, and maintain websites. They use their skills in HTML, CSS, JavaScript, and other web technologies to build websites that are user-friendly, visually appealing, and functional. This course can help web developers build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in web development and design.
Information Systems Manager
Information Systems Manager
Information systems managers plan, implement, and manage information systems for organizations. They use their skills in information technology, project management, and business analysis to ensure that information systems are aligned with the needs of the organization. This course can help information systems managers build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in information systems management and administration.
IT Project Manager
IT Project Manager
IT project managers plan, execute, and manage IT projects. They use their skills in project management, information technology, and business analysis to ensure that IT projects are completed on time, within budget, and to the satisfaction of stakeholders. This course can help IT project managers build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in project management and IT.
Information Security Analyst
Information Security Analyst
Information security analysts protect organizations from cyber threats. They use their skills in information security, risk management, and compliance to identify, assess, and mitigate security risks. This course can help information security analysts build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in information security and risk management.
Computer Systems Analyst
Computer Systems Analyst
Computer systems analysts design, develop, and implement computer systems for organizations. They use their skills in systems analysis, design, and programming to build systems that meet the needs of users. This course can help computer systems analysts build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in systems analysis and design.
Network Administrator
Network Administrator
Network administrators design, implement, and manage networks for organizations. They use their skills in networking, security, and troubleshooting to ensure that networks are reliable, secure, and efficient. This course can help network administrators build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in network management and administration.
Database Developer
Database Developer
Database developers design, develop, and maintain databases. They use their skills in database design, SQL, and programming to build databases that meet the needs of users. This course can help database developers build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in database development and design.
Data Warehouse Architect
Data Warehouse Architect
Data warehouse architects design, develop, and implement data warehouses for organizations. They use their skills in data modeling, data integration, and data warehousing to build data warehouses that meet the needs of users. This course can help data warehouse architects build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in data warehousing and data modeling.
Data Governance Analyst
Data Governance Analyst
Data governance analysts develop and implement data governance policies and procedures for organizations. They use their skills in data management, data governance, and compliance to ensure that data is used in a consistent and ethical manner. This course can help data governance analysts build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in data governance and data management.
Data Quality Analyst
Data Quality Analyst
Data quality analysts assess and improve the quality of data for organizations. They use their skills in data analysis, data quality, and data management to identify and correct data errors and inconsistencies. This course can help data quality analysts build the skills and knowledge they need to succeed in this role, as it provides them with hands-on experience in data quality analysis and data management.
For more career information including salaries, visit:
OpenCourser.com/course/17jzh7/sql
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server Reporting Services Part 2 (SSRS).
Covers the basics of securing SQL Server Reporting Services. It provides step-by-step instructions for implementing security features such as role-based access control and data encryption.
Provides a step-by-step guide to installing, configuring, and using SSRS. It valuable resource for anyone who is new to SSRS or who wants to learn more about its latest features.
Covers the basics of performance tuning for SQL Server Reporting Services. It provides step-by-step instructions for identifying and resolving performance issues.
Provides a comprehensive overview of SSRS, from its architecture and design to its deployment and management. It valuable resource for anyone who wants to learn more about SSRS or who is looking for a reference guide.
Provides a comprehensive overview of SSRS, from its architecture and design to its deployment and management. It valuable resource for anyone who wants to learn more about SSRS or who is looking for a reference guide.
Provides a comprehensive overview of SSRS, from its architecture and design to its deployment and management. It valuable resource for anyone who wants to learn more about SSRS or who is looking for a reference guide.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/17jzh7/sql
Share
Similar courses
Here are nine courses similar to
SQL Server Reporting Services Part 2 (SSRS).
Building Your First SSRS Report
OpenCourser.com/course/uzbiay/building
Building Your First SSRS Report
Most relevant
What's New in SQL Server 2016 Reporting Services
OpenCourser.com/course/a7iksn/what
What's New in SQL Server 2016 Reporting Services
Most relevant
Administering SSRS 2017
OpenCourser.com/course/s7d15h/administering
Administering SSRS 2017
Most relevant
SQL Server Reporting Services Playbook
OpenCourser.com/course/vfzybt/sql
SQL Server Reporting Services Playbook
Most relevant
SQL Server Reporting Services 2014: Data Sourcing Playbook
OpenCourser.com/course/gzfbi7/sql
SQL Server Reporting Services 2014: Data Sourcing Playbook
Most relevant
Troubleshooting and Optimizing SSRS Reporting
OpenCourser.com/course/myxepl/troubleshooting
Troubleshooting and Optimizing SSRS Reporting
Most relevant
Building Interactive SSRS Reports
OpenCourser.com/course/wo4x2m/building
Building Interactive SSRS Reports
Most relevant
Build and Deploy SSRS Mobile Reports
OpenCourser.com/course/mnfrt6/build
Build and Deploy SSRS Mobile Reports
Most relevant
SSRS Data Sourcing Playbook
OpenCourser.com/course/1o5vnp/ssrs
SSRS Data Sourcing Playbook
Most relevant
Effort
6.5 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Good to know
Examines SQL Server Reporting Services (SSRS), which is standard in the IT industry
Taught by Raphael Asghar, who is recognized for his work in data management
Provides hands-on labs and interactive materials that help learners build projects
Develops technical skills that are core for SQL DBAs and developers
This course requires SQL Server Integration Services (SSIS) as a prerequisite
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser