In this two-day course, students will experience a hands-on, deep dive into reporting techniques for analyzing data using paginated reports, charts, and scorecards. We transfer skills and insights needed for real world analysis and reporting of data using course content, discussions, demonstrations, and scenario-based labs. Students can work through objectives based on reporting requirements or they can complete the work by following step-by-step instructions.
We will work with interactive reporting using parameters, creating custom reports with rectangles and lists, use conditional formatting to enhance data presentation, use complex formatting expressions, add images to reports, provide drilldown capability, connect server-hosted reports, analyze data with mini-charts, mini-gauges, and scorecards. In addition, we will also troubleshoot and resolve failing reports and features early and often.
All features covered in this course have become normal reporting requirements in today’s reporting landscape. Report Builder is available for all supported versions of Microsoft SQL Server and this course content can be applied against any of those versions.
Prior to taking this course, students should have the following skills:
2 Days/Lecture & Lab
The primary audience for this course is experienced Report Builder and SSRS report writers who are business analysts, programmer analysts, data analysts, developers, database administrators, and IT professionals. The secondary audience is persons using Report Designer (available through SQL Server Data Tools).