PDP Url

Analyzing Data with Microsoft SQL Server Reporting Services (MS-10990)

Rating:
96% of 100
Want to become the go-to BI Developer in your organization? Our Data Science Training program is perfect for database professionals wanting to offer premium report implementing and mobile reporting services as BI Developers.

Virtual

Learning Style

Intermediate

Difficulty

5 Days

Course Duration

5

SATV Value

Course Info

Download PDF

Certificate

See Sample

Subscribe Buy Individually
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1273 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
Want to become the go-to BI Developer in your organization? Our Data Science Training program is perfect for database professionals wanting to offer premium report implementing and mobile reporting services as BI Developers.

Course Information

About this course:

Our Data Science Training program is aimed at database professionals who want to work in the industry and offer numerous services as Business Intelligence Developers. With the assistance of accredited instructors, you will be able to offer data analysis services using Microsoft SQL Server 2016.

Our instructors provide professional Microsoft SQL Server Training so you can utilize a range of development tools to report, implement, and manage of SQL Reporting Services. All of the teachings and skills learnt from the course turn you into expert Business Intelligence service providers in the industry.

Course Objective:

After completing this course, students will be able to:

  • Describe reporting services and it’s components

  • Describe reporting services data sources

  • Implement paginated reports

  • Work with reporting services data

  • Visualize data with reporting services

  • Aggregate report data

  • Share reporting services reports

  • Administer reporting services

  • Expand and integrate reporting services

  • Describe mobile reports

Audience:

  • Database professional wanting to work professionally as BI developers to efficiently design reports are the ideal candidates for this training program.

  • implementing reports and mobile reports are the most basic and essential roles you will be learning.

  • The secondary audiences for this course are power information workers.

Prerequisite:

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Outline

Frequently Asked Questions

1. What are the prerequisites to the Analyzing Data with Microsoft SQL Server Reporting Services (MS-10990) course?

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

20761C: Querying Data with Transact-SQL.

2. What is the Difficulty level of the Analyzing Data with Microsoft SQL Server Reporting Services (MS-10990) certification training?

Intermediate Level.

3. How will the Analyzing Data with Microsoft SQL Server Reporting Services (MS-10990) certification training benefit me in my current job role?

  • The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.
  • The secondary audiences for this course are power information workers.
  • How to implement a SQL Server Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
  • Provides value added skills and expertise to excel seamlessly and robustly in your job role along with the confidence of being product specialist.
  • provides a real-world, hands-on practical approach for you to apply the knowledge and skills learned in the course.
  • provides on-the-job reference material to boost knowledge and skills retention.

4. What is the Analyzing Data with Microsoft SQL Server Reporting Services (MS-10990) course objective?

  • Describe reporting services and its components
  • Describe reporting services data sources
  • Implement paginated reports
  • Work with reporting services data
  • Visualize data with reporting services
  • Aggregate report data
  • Share reporting services reports
  • Administer reporting services
  • Expand and integrate reporting services
  • Describe mobile reports

5. How many tools are provided by Microsoft to create reporting services reports?

Microsoft provides three tools that you use to create Reporting Services reports:

  • Report Builder
  • Report Designer
  • SQL Server Mobile Report Publisher

6. What are the job roles responsible to create reports?

  • End user
  • Data steward
  • Business analyst
  • BI developer

7. How many data processing extensions for different source system types are included by SSRS?

  • SQL Server Database Engine
  • SQL Server Analysis Services
  • Microsoft SharePoint® list
  • Microsoft Azure SQL Database
  • Oracle
  • SAP NetWeaver Business Intelligence
  • Hyperion Essbase
  • Teradata
  • OLE DB data sources
  • Open Database Connectivity (ODBC) data sources
  • XML

8. What are connection strings?

“Connection string” is a widely used computing term that refers to the information that is required to configure a connection from an application to a data source, stored as a delimited string. A connection string typically appears in the format that’s shown in the following code example:

property name=value; [propertyname=value;…]

A connection string might be made up of many properties and values. When an application attempts to connect to a data source, the connection string is passed as an argument to the software component that’s responsible for establishing the connection. This software component is often referred to as a data provider or database driver. Although the contents of the connection string vary according to the data source type and the environment where the connecting application is running, all connection strings might contain several different types of information, such as:

  • The location of the data source.
  • Authentication credentials.
  • Properties to further configure the data source.

9. How to specify a report type and design a report?

After designing the query for the data, you need in your report, the next step is to choose a report type—tabular or matrix. You do this on the Select a Report Type page of the Report Wizard. Tabular reports display data in rows, while matrix reports show data fields grouped in rows and columns, with aggregated values in the intersecting cells, like a PivotTable or crosstab. When you have chosen your report type, you then need to design the report on the Design the Table or Design the Matrix page. To design the report, select your required field in the Available fields list and add it to the report in the Page, Column, Row, or Detail area. You can select more than one field for each section of the report. Reorder fields by using the up and down arrows on the page.

10. What are data filters?

Filters exclude certain rows from a dataset. You might want to show data that relates to a specific region, or country, whereas the dataset contains data for the whole country or region. There are two ways you filter data for a report:

  • Filter data at source.
  • Filter data within the report.

11. What is a KPI and how are KPIs used?

A key performance indicator, or KPI, is a measure of performance. Each KPI comprises a goal, and a result. KPIs provide a popular management tool you use to measure important aspects of a business, a team, or a person’s performance. KPIs are often represented visually to make them easy and fast to understand. This means that anyone can see, at a glance, whether you are on target to meet the goal, or whether there are problems. KPIs make it possible to:

  • Assess whether projects are on target or behind schedule.
  • Manage a number of different goals at the same time, as progress is seen very quickly.
  • Prioritize actions, either according to the importance of the project, or by assessing how far away it is from the goal.

12. What is a subreport?

A subreport is a report within a report—it’s a separate report, normally stored in the same folder as the parent report, and always on the same reporting server. The subreport is embedded within the parent report. You can pass parameters, allowing subreports to contain relevant data. You can also embed more than one subreport within a report. You can think of the parent report as a container for other reports. Although the user is not aware that they are viewing a subreport, a second report is being displayed. Subreports are invoked for every row in the report, and so have a performance overhead.

13. What is drilldown and drillthrough?

When a user clicks to reveal more detailed information in a report, this is referred to as drilldown. Users often want to view summary information, and only explore details for specific groupings when they see an issue or an anomaly. Reporting Services supports this drilldown functionality—you hide or show groups in a report by clicking a toggle button that’s associated with a field in the parent group.

Drillthrough
refers to the action when a user clicks a link in a summary report to find more detailed information. When a user clicks, the report that contains the detail is displayed. The detailed report might use the same dataset as the summary report—or a different dataset.

Drillthrough actions

There are three different actions that you can add:

  • Go to a report.
  • Go to a bookmark.
  • Go to a URL.
If the drillthrough action is to another report, that report must already exist and be on the same report server. However, it might be located in a different folder to the summary report. Actions can be added to many different items including images, text boxes, and data points on a chart. The item must, however, have an Action property.

14. Why do we need mobile reports?

  • Better experience for mobile users.
  • KPI and dashboard components.
  • Draw together data from many sources.
  • Data for Reporting Services mobile reports.
  • Consistent look and feel across desktop, mobile, and tablet.

More Information

More Information
Brand Microsoft
Subjects IT Ops & Management
Lab Access No
Technology Microsoft
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 5 Days
Language English
SATV Value 5
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Prerequisites
Sale
Querying Data with Microsoft Transact-SQL (MS-20761)
Querying Data with Microsoft Transact-SQL (MS-20761)
60%
  • Virtual Classroom
  • 5 Days
Now Only $2,595.00 Regular Price $2,995.00

Contact A Learning Consultant


click here