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?
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
- SAP NetWeaver Business Intelligence
- Hyperion Essbase
- OLE DB data sources
- Open Database Connectivity (ODBC) data sources
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.
There are three different actions that you can add:
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.
- Go to a report.
- Go to a bookmark.
- Go to a URL.
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.