We may earn an affiliate commission when you visit our partners.
Course image
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.

Enroll now

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

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

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

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
This activity is a prerequisite to the course and will help refresh your knowledge of SSIS before starting SSRS.
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'
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.
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
This study group will help you learn from your peers and get help with the course material.
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
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
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
This blog post will help you solidify your understanding of the course material and share your knowledge with others.
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
This project will help you apply the skills you have learned in the course to create a real-world dashboard.
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
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.

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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.

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.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to SQL Server Reporting Services Part 2 (SSRS).
Building Your First SSRS Report
Most relevant
What's New in SQL Server 2016 Reporting Services
Most relevant
Administering SSRS 2017
Most relevant
SQL Server Reporting Services Playbook
Most relevant
SQL Server Reporting Services 2014: Data Sourcing Playbook
Most relevant
Troubleshooting and Optimizing SSRS Reporting
Most relevant
Building Interactive SSRS Reports
Most relevant
Build and Deploy SSRS Mobile Reports
Most relevant
SSRS Data Sourcing Playbook
Most relevant
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