Microsoft SQL Server Reporting Services (SSRS)

What you'll learn:

Requirements:

Description:

"Brilliant! This tutorial will definitely save you hours of figuring out things yourself." -- Koos ten Bras

"Excellent course, well presented and clear examples." - Peter Cawthorne

This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful.

We will download a version of SQL Server which includes SSRS - for free. We'll also download a database called AdventureWorks, which we will use in our reports.

We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:

• Select report components (matrix, table, chart and other data visualisation component),
• Identify the data source and parameters,
• Design a grouping structure,
• Create drilldown reports and drillthrough reports.

As part of implementing a report layout, we will:

• Find out how to format, including formatting colours, dates and numbers;
• Configure the page;
• Implement headers and footers;
• Implement matrices, tables, chart, images, indicators, maps and groupings in reports;
• Create a range of reports using different data regions;
• Define custom fields;
• Implement global collections;
• Define expressions; and
• Implement data visualisation components.

As part of implementing interactivity in a report, we will:

• Create drilldown reports;
• Create drillthrough reports;
• Add interactive sorting;
• Investigate parameters, including multi-value parameters;
• Create dynamic reports in SSRS using parameters;
• Implement show/hide property;
• Add actions (jump to report and URL);
• Add Fixed headers and a document map.

By the end of this course, you should be confident in creating your own reports in SSRS.

It will assist with the "Build a report with SQL Server Reporting Services (SSRS)" section of Microsoft exam 70-766 "Implementing Data Models and Reports with Microsoft SQL Server".

Who this course is for:

• This course is for you if you want to know how to create reports in SSRS.
• No prior experience with T-SQL is required, although the more knowledge you have it, the better.
• Having SharePoint on your computer is not necessary; we will use the stand-alone version of SQL Server. However, I will show the differences and similarities between Report Builder (SharePoint) and SSDT (the stand-alone version).
• In this course we will cover several aspects which are tested in Microsoft's 70-466 exam "Implementing Data Models and Reports with Microsoft SQL Server".
• This course is not for you if you only want to know about managing your existing SSRS reports in SharePoint.
• Machine Learning A-Z™: Hands-On Python & R In Data Science
• React - The Complete Guide (incl Hooks, React Router, Redux)
• Microsoft Excel - Excel from Beginner to Advanced
• Microsoft Excel - Advanced Excel Formulas & Functions

Course Details:

• 6 hours on-demand video
• 13 articles
• 5 downloadable resources
• Full lifetime access
• Access on mobile and TV
• Certificate of completion

Microsoft SQL Server Reporting Services (SSRS) udemy courses free download

Build reports in SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity. Exam 70-466