Redwood Advanced Reporting

Time
Start: Wednesday, October 14, 2009 (9:00am)
End: Thursday, October 15, 2009 (5:00pm)

Price
$1,795

Promotion
Bring a guest and receive a 50% discount on second registration

Location
Lexis Nexis
Four Penn Center
1600 John F. Kennedy Blvd
Suite 1655
Philadelphia, PA  19103

Registration
Register Online

Course Overview
The Redwood Advanced Reporting course is designed to educate the report writer on advanced functionality of the reporting tool to produce production ready reports via Redwood’s data warehouse or other databases. During the course users will learn how to create reports using Query Builder, use SQL statements to create and edit queries in addition to using Visual Basic expressions in Report Builder.  This one day course is delivered by an instructor in a “group-live” environment.

Course Objectives 

  • Understand the approach and scope to report building
  • Understand report design and page layout
  • Write and edit queries using SQL
  • Understand and create joins
  • Built Parameters
  • Create a production ready report

 

Course Level
This course covers advanced levels in the content

Prerequisites
Understanding of either Redwood data warehouse or Firm’s cube structure
Have SQL knowledge

Advance Preparation
None

CPE Credits
8

Course Outline

Module 1: Queries and Parameters

  • Write and edit queries with Query Builder
  • Create joins between tables
  • Write and edit your own queries
  • Understand and utilize multiple types of parameters
  • Build and utilize cascading parameters
  • Manage, save, and reuse previously built parameters from the Parameter Library

 

Module 2: Advanced Report Builder

  • Build a report from a query
  • Apply conditional formatting to a cell or row
  • Understand and utilize the Visibility Property for cells, rows, or tables
  • Understand the difference between group header and detail rows
  • Utilize hard-coded parameters within a report
  • Format and edit report headers and footers
  • Understand and use the common Visual Basic expressions used in Report Builder

 

Module 3: Report Scope and Build

  • Review the approach to report requests
  • Understand data sources and how to access
  • Conceptual understanding of whether a reporting is the solution or Cubes
  • Business needs for a report
  • Include calculations and where those calculations need to be made
  • Page layout and Formatting
  • Case Study: Design a report

 

Course Registration
Registration can be done by clicking here, or contacting christopher.katchuk@lexisnexis.com


For questions, or to schedule an on-site, send an email request to christopher.katchuk@lexisnexis.com we will contact you to schedule.