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 the SQL Server Reporting Services (SSRS) Training course, where you’ll embark on a comprehensive journey to master the capabilities of SSRS and harness its full potential for driving data-driven decision-making within your organization.
Throughout this course, you will gain proficiency in utilizing SSRS to create and manage reports, ultimately enabling the implementation of self-service Business Intelligence (BI) solutions.
This training program covers a wide spectrum of SSRS topics, including essential aspects such as data modeling, report services data sources, and the art of crafting reports using both Report Designer and Report Builder. Moreover, you’ll delve into the realm of mobile report development, equipping you with the skills necessary to create compelling SQL
Server mobile reports that can be accessed from various devices. By the conclusion of this course, you will be well-prepared to design and deploy SSRS solutions with precision and efficiency, enhancing your ability to deliver valuable insights to your organization.
Join us on this journey of discovery, and by the course’s end, you’ll not only have a strong grasp of SSRS but also the expertise to wield it effectively in real-world scenarios, making you a valuable asset in the realm of data analysis and reporting.
Course Objectives
- Understand the key features of data modeling in the context of business intelligence.
- Learn about various report services data sources and their configurations.
- Create reports using both Report Designer and Report Builder.
- Configure reports for optimal performance.
- Develop SQL Server mobile reports for on-the-go data analysis.
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 |