No products in the cart.
Overview
This course is an overview of how to implement a SQL Server 2016 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. It also reviews Data Modeling, mobile reports and report mapping for filtering and sorting parameters and grouping.
Audience Profile
The primary audience for this course is database professionals who want to learn about creating reports. Primary responsibilities will include implementing reports and mobile reports. The secondary audiences for this course are power information workers.
At Course Completion
After completing this course, students will be able to:
• Describe key features of data modelling within business intelligence
• Describe various report services data sources and how these are configured
• Create reports with report designer and/or report designer
• Configure reports with report designer and/or report builder
• Create SQL Server mobile reports
Outline
Module 1 – Introduction: SSRS and the SSRS-verse
- Lesson 1: What Is SSRS and How Is It Used?
- Lesson 2: SSRS and Business Intelligence
- Lesson 3: OLTP and OLAP
- Lesson 4: SSRS Architecture and Tools
Module 2 – Data Objects
- Lesson 1: Data Sources
- Lesson 2: Data Sets
Module 3 – Building and Deploying a Basic Report
- Lesson 1: Report Designer Solutions
- Lesson 2: Data Binding
- Lesson 3: The Tablix Table and List
- Lesson 4: Simple Formatting
- Lesson 5: Working with Expressions
- Lesson 6: Using Grouping for Formatting and Aggregation
- Lesson 7: Overview of Report XML
- Lesson 8: Deployment to the Web Portal
- Lesson 9: Report Designer vs. Report Builder
Module 4: Working with Summarized Data
- Lesson 1: Hierarchical Group Objects
- Lesson 2: Expression Scope
- Lesson 3: Document Maps
- Lesson 4: Recursive Hierarchies
- Lesson 5: The Matrix Data Region
- Lesson 6: Adjacent Groups
Module 5: Working with Parameters
- Lesson 1: Query Parameters and Report Parameters
- Lesson 2: Server-Side vs Client-Side Filtering
- Lesson 3: Parameter Dropdowns
- Lesson 4: Cascading Parameters
- Lesson 5: Optional Parameters
Module 6: Advanced Parameters and Bookmarks
- Lesson 1: Drilldown
- Lesson 2: Drillthrough
- Lesson 3: Using Parameters to Sort
- Lesson 4: Using Parameters to Show/Hide Matrix Groups
- Lesson 5: Subreports vs Nested Data Regions
- Lesson 6: Go to Bookmark Action
Module 7: Formatting
- Lesson 1: Headers and Footers
- Lesson 2: Rich Text Formatting
- Lesson 3: Placeholders
- Lesson 4: Conditional Formatting
- Lesson 5: Repeating and Freezing Column Headers
- Lesson 6: Formatting for Excel
Module 8: Data Visualizations
- Lesson 1: Charts
- Lesson 2: Databars
- Lesson 3: Sparklines
- Lesson 4: Gauges
- Lesson 5: Indicators
- Lesson 6: Maps
- Lesson 7: KPI Reports
Module 8: Web Portal Basics
- Lesson 1: Web Portal Overview
- Lesson 2: Creating Folders
- Lesson 3: Managing Shared Objects
- Lesson 3: Web Portal Report Properties
- Lesson 4: Report Comments
- Lesson 5: Branding the Web Portal
Module 9: Caching and Snapshots
- Lesson 1: Report Processing Steps
- Lesson 2: Caching Reports & Filtering
- Lesson 3: Snapshot Reports & Filtering
- Lesson 4: Historical Snapshots
Module 10: Automating Report Execution and Distribution
- Lesson 1: Simple Subscriptions
- Lesson 2: Data-Driven Subscriptions
- Lesson 3: Shared Schedules
Module 11: Administering Reporting Services
- Lesson 1: Configuration Managers
- Lesson 2: Securing the Web Portal
- Lesson 3: Monitoring Performance
Module 12: Mobile Reports
- Lesson 1: Mobile Reports Overview
- Lesson 2: Understanding and Preparing Mobile Reports Data
- Lesson 3: Navigators and Visualizations
- Lesson 4: Parameters and Drillthrough
Prerequisites
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
SQL101: Introduction to Transact SQL
or
SQL250: Transact-SQL for Developers
FAQ
What if I have to reschedule my class due to conflict?
Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.
How do I enroll for this class?
Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.
What happens once I purchase a class?
You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.
What is your late policy?
If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.
What happens when I finish my class?
You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.