Data Analysis with SQL Server Reporting Services Training

Education Objectives:

-Identify reporting services and components

-Identify reporting services data sources

-Applying to paginated reports

-Working with reporting services data

-Visualize data with reporting services

-Aggregated report data

-Share reporting services reports

-Manage reporting services

-Extend and integrate reporting services

-Disclose mobile reports

-Develop mobile reports.

Course Content:

• Module 1: Introduction to Reporting Services:

This module introduces Microsoft SQL Server Reporting Services, its components and the tools used to work with it.

Introduction to reporting services

Reporting services components

Reporting services tools

Explore reports

Reporting services configuration

• Module 2: Reporting Services Data Sources:

Almost every report you publish using SQL Server Reporting Services (SSRS) is generated using data from one or more source systems. This course explains how to configure SSRS to interact with source data systems by working with data sources.

Data sources

Connection strings

datasets

Configure data access with the report builder

Configure data access with the report builder

• Module 3: Creating Paginated Reports:

Now you will learn BI and data modeling and how to access data from Report Designer and Report Builder and see how to create reports. This module shows how to use the Report Wizard as well as how to create different types of reports in both applications.

Create reports with the report wizard

Report generation

Report publishing

• Module 4: Working with Reporting Services Data:

It is common for business requirements to change according to the information they need and how they want the data to be presented. When viewing a detailed report, senior management may request higher-level, summarized or filtered versions of the same report. Report Builder and Report Designer support these scenarios by filtering, sorting, detailing, grouping and parameterizing reports. In this module you will see how to use filters and parameters to make reports more dynamic and useful for business users.

Data filters

Report parameters

Apply report filters and parameters

• Module 5: Visualizing Data with Report Services:

As the amount of data being generated continues to grow, so does the need to make sense of it. You use data visualization to make data easier to understand and faster to interpret. Data visualizations highlight comparisons, show trends and convey scale much faster than a table of numbers. Detail is important, but visualizations are a highly effective way to communicate meaning and insights quickly and accurately.

Data formatting

Pictures and charts

Data bars, small charts, indicators, gauges and maps

• Module 6: Summarizing Report Data:

As the amount of data we need to handle increases, so does the need to manage it by grouping and summarizing it. In this module, you will learn how to create group structures, summarize data, and enable interactivity in your reports so that users see the level of detail or summary they need.

Sorting and grouping

Report sub-reports

Drill down and drill down

• Module 7: Sharing Reporting Services Reports:

When you publish a Reporting Services report, users can view it interactively. In some cases, it may be advantageous to run reports automatically to improve performance through caching and snapshots, or to send reports to users using email or other mechanisms. To run reports automatically, you need to understand how Reporting Services manages scheduling. This module covers report scheduling, caching and report lifecycle as well as automatic subscription and delivery of reports.

Caching programs, reporting snapshots and comments

Notify subscription and delivery

• Module 8: Managing Reporting Services:

System administrators take responsibility for the configuration and day-to-day operations of IT systems. In SQL Server Reporting Services (SSRS), administrative tasks include configuring the web portal and web service, branding the web portal, and carefully controlling access to sensitive reports. Administrators also monitor and optimize performance.

Managing reporting services

Reporting services configuration

Reporting services performance

• Module 9: Extending and Integrating Reporting Services:

Although Reporting Services is a powerful tool, its built-in capabilities may not always meet your needs. This module covers methods to extend the functionality of Reporting Services with expressions and custom code. You will also learn how to work programmatically with Reporting Services and integrate Reporting Services reports into other applications.

Phrases and embedded code

Expand reporting services

Integrated reporting services

• Module 10: Introduction to Mobile Reports:

This module introduces the design and publishing of reports intended for use on mobile devices such as smartphones and tablets. Microsoft SQL Server Reporting Services (SSRS) includes support for mobile reports, but the tools used to design and publish mobile reports are different from the tools used for paginated reports described in previous modules of this course.

Overview of mobile reports

Data preparation for mobile reports

Mobile report publisher

Formatting data for a mobile report

Create a mobile report

Create KPIs

• Module 11: Developing Mobile Reports:

In this module, you will learn about the types of items that you can add to your Microsoft SQL Server Reporting Services mobile reports. You will also learn how to work with dataset parameters and how to add drill-down actions to your reports.

Designing and publishing mobile reports

Detailing in mobile reports

• People who have knowledge about Dashboard or who design Dashboard and want to improve themselves,
• People who want to make dynamic and automatically updating reports,
• People who want to automate reporting,
• People who do reporting and want to improve themselves in this field,
• Data Analysts and Data Analyst Candidates,
• Data Management and Reporting people,
• People who want to make better decisions by analyzing their data,
• People who want to make graphs from data,
• People in business life and candidates who want to enter business life.

Basic knowledge of Microsoft Windows operating system and its basic functions.

Transact-SQL working knowledge. (MS 20761C)