Maxtrain.com - info@maxtrain.com - 513-322-8888 - 866-595-6863
SQL Server Reporting Services (SSRS) – Authoring, Deploying, and Managing Reports Training Course
Description
SQL Server Reporting Services (SSRS) Training Introduction
Welcome to our SQL Server Reporting Services (SSRS) Training course. This comprehensive program is designed to elevate your expertise in leveraging SSRS, a powerful tool for enhancing data-driven decision-making across your organization. By mastering SSRS, you’ll unlock new capabilities in business intelligence and report management, crucial for any data-intensive environment.
In this course, you’ll develop essential skills in data modeling, learn to configure and use SSRS data sources, and create dynamic reports using both the Report Designer and Report Builder tools. As we progress, you’ll also explore mobile report development, gaining the ability to design responsive SQL Server mobile reports that are accessible on a variety of devices.
This training aims to not only familiarize you with the foundational and advanced aspects of SSRS but also ensure you can implement these solutions effectively to provide actionable insights within your business.
By the end of this course, you will have a thorough understanding of SSRS’s framework and be proficient in deploying robust reporting solutions. This knowledge will empower you to contribute significantly to your organization’s strategic goals through precise data analysis and reporting.
SQL Server Reporting Services (SSRS) Course Objectives
- Master Data Modeling: Learn to structure data effectively for optimal reporting.
- Utilize SSRS Tools: Gain expertise in Report Designer and Report Builder for creating detailed and visually appealing reports.
- Configure Data Sources: Understand how to set up and manage data sources within SSRS.
- Develop Mobile Reports: Acquire skills in crafting and deploying mobile-friendly reports, accessible on various devices.
- Implement BI Solutions: Apply SSRS to support and enhance self-service Business Intelligence initiatives.
Prerequisites
- In addition to their professional experience, students who attend this training should have technical knowledge equivalent to one the following courses:
Audience
- 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.
SQL Server Reporting Services (SSRS) Outline
Introduction: SSRS and the SSRS-verse
- What Is SSRS and How Is It Used?
- SSRS and Business Intelligence
- OLTP and OLAP
- SSRS Architecture and Tools
Data Objects
- Data Sources
- Data Sets
Building and Deploying a Basic Report
- Report Designer Solutions
- Data Binding
- The Tablix Table and List
- Simple Formatting
- Working with Expressions
- Using Grouping for Formatting and Aggregation
- Overview of Report XML
- Deployment to the Web Portal
- Report Designer vs. Report Builder
Working with Summarized Data
- Hierarchical Group Objects
- Expression Scope
- Document Maps
- Recursive Hierarchies
- The Matrix Data Region
- Adjacent Groups
Working with Parameters
- Query Parameters and Report Parameters
- Server-Side vs Client-Side Filtering
- Parameter Dropdowns
- Cascading Parameters
- Optional Parameters
Advanced Parameters and Bookmarks
- Drilldown
- Drillthrough
- Using Parameters to Sort
- Using Parameters to Show/Hide Matrix Groups
- Subreports vs Nested Data Regions
- Go to Bookmark Action
Formatting
- Headers and Footers
- Rich Text Formatting
- Placeholders
- Conditional Formatting
- Repeating and Freezing Column Headers
- Formatting for Excel
Data Visualizations
- Charts
- Databars
- Sparklines
- Gauges
- Indicators
- Maps
- KPI Reports
Web Portal Basics
- Web Portal Overview
- Creating Folders
- Managing Shared Objects
- Web Portal Report Properties
- Report Comments
- Branding the Web Portal
Caching and Snapshots
- Report Processing Steps
- Caching Reports & Filtering
- Snapshot Reports & Filtering
- Historical Snapshots
Automating Report Execution and Distribution
- Simple Subscriptions
- Data-Driven Subscriptions
- Shared Schedules
Administering Reporting Services
- Configuration Managers
- Securing the Web Portal
- Monitoring Performance
Mobile Reports
- Mobile Reports Overview
- Understanding and Preparing Mobile Reports Data
- Navigators and Visualizations
- Parameters and Drillthrough
$2995.00
|
5 Days Course |