Presented by Stacia Misner
Run Time: 181 Minutes
In this new eLearning course, students will get an introduction to SQL Server Reporting Services (SSRS). This course is designed for report developers who have little to no experience with the product and explains how to use the development tools effectively, how to present and enhance data in a report, and how to create dynamic reports.
Even if you have some experience with Reporting Services, this course explores aspects of Reporting Services that are not well-documented and are unintuitive. Enroll now and expand your skills and make the most of this reporting tool.
By the end of this course, you will learn how to:
- Manage key components of a report project: data sources, datasets, report items, and data regions
- Use expressions to display data or change the appearance and behavior of a report in practical ways
- Use report parameters with and without query parameters
- Use data visualization features to enhance the communication of information
- Add interactivity to reports
- Work with pagination and rendering features to manage page layout and more!
Session 1: Developing Reports
In this session, you'll learn a variety of report development techniques that take advantage of the rich set of features available in Reporting Services. You'll start by learning how to work with report server projects in SQL Server Data Tools and how to manage report server project files and properties. Then you'll learn all the data source types you can use to display data in your report, how to connect to these data source types by creating data sources, and how to design queries for these data source types to create datasets.
Next, you'll learn how to work with each type of report item, how to configure properties to control appearance and behavior of each report item, and how to work with properties specific to the tablix. Last, you'll learn how to enhance reports by adding calculations and using expressions to change properties dynamically.
Session 2: Visualizing Data
Reporting Services includes a wide variety of options for displaying information as a data visualization. This session begins by describing how to work with chart controls and how to apply basic formatting to charts. A key performance indicator is a special type of data visualization that you can add to a report to monitor progress to goals.
This session shows you the many options available for using a gauge as a key performance indicator and also how to use the indicator report item. In addition, you'll learn about working with spatial data in general, how to use the map wizard to create a map, and how to fine-tune the appearance of a map by configuring properties for the map.
Session 3: Enhancing Reports with Interactive Features
For users who access and view reports online most of the time, you can add interactive features to make it easier for them to use your reports. In this session, you'll learn how to allow the user to change the sort order of data, add tooltips, or make it possible to expand and collapse sections of your report. You'll also learn how to employ navigation aids to help the user easily move to information located in the same report or to access information contained in a related report or web page.
For users who regularly print or export reports as PDF documents, you'll learn how the structure of a page depends on rendering and how to use various report properties that influence the layout of items on a page and pagination.
Stacia Misner is a SQL Server MVP, SSAS Maestro, MCIT-BI, and MCTS-BI. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 25 years, with a focus on improving business practices through technology. Since 2000, Stacia has been providing consulting and education services for Microsoft’s business intelligence technologies. During that time, she has also authored several books covering the Microsoft BI stack. She is a frequent speaker at PASS, DevConnections, SQLSaturdays, and similar international events.
Need to be invoiced or interested in registering 2 or more people? Contact our customer service team directly for assistance.
Phone: 800-262-1954 or 913-967-1719