SQ-330 - Advanced Microsoft SQL Server 2008 Reporting Services R2 (SSRS)
Course
SQ-330
Price:
$1,895.00
Software Assurance Value:
Not Eligible
Duration:
2 Days
Description
This two-day SSRS course is based on the advanced concepts from our four-day Report Design Solutions with SQL Server 2008
R2 Reporting Services. It is a fast- paced course for students with previous experience and basic Reporting Services design skills.
It teaches practical design techniques based on industry best practices and real-world reporting applications.
Return to Top
Audience
This course is intended for report designers and BI
solution architects with some prior experience with SSRS in a business reporting
environment.
Return to Top
Prerequisites
Before attending this course, it is recommended that
students have the following skills:
- Using Business Intelligence Development Studio
and Report Builder 3.0 to create data sources, write basic queries and design
basic table or matrix reports. Completion of the Microsoft or SolidQ report
design course (or equivalent proficiency) is recommended.
Return to Top
Course Objectives
Upon completion of this course, the student will be able
to:
- Incorporate complex filtering logic with
parameters into queries and dataset filters.
- Build highly-usable composite report designs
using nested data regions and report items (charts, gauges, sparklines, data
bars and indicators.)
- Design BI solutions with business dashboards.
- Design advanced reports for Analysis Services
OLAP cubes with custom MDX queries.
- Apply expressions and custom programming
techniques to solve complex business problems.
- Use external controls, web parts and programming
code to automate reports and design custom reporting solutions.
Return to Top
Course Outline
Module 00: Introduction
Module 1: Advanced Report Design
- Table reports
- Groups, headers, footers & totals
- Interactive sort
- Matrix reports
- Column groups
- Aggregate functions
- Chart reports
- Gauge reports
Module 2: Advanced Visualization
- Line, column and bar charts
- Specialty charts
- 3-D and chrome
- Nested gauges
- Sparklines vs charts
- Scorecards
Lab A: Charts
Lab B: Gauges
Module 3: Analytical Reporting
- Integration of Analysis Services into reports
- MDX language
- Reporting on OLAP vs relational data
- Hierarchies
- Native aggregations & calculations in cube vs report
Lab: Analytical Report Design
Module 4: Dashboard Design
- Report requirement guidelines
- Understand the strengths & limitations of SSRS architecture
- Business scorecards
- KPI dashboards
- Sparkline charts
Lab A: Scorecard
Lab B: Sparkline & Chart
Module 5: Geospatial Reporting
- Use of well-known named geo shapes
- Geocoded locations
- SQL Server spatial conversion functions
- Use of Bing Maps to provide geographic details
- US maps, non-US maps and specialty maps
Lab: Map and Geospatial Reports
Module 6: Solutions, Standards and Best Practices
- Architecture
- Folder Management
- Report Execution
- URL Access
- Security
- User Education
Lab: Using Report Parts to Assemble a Dashboard
Return to Top
