BI Cubes - PowerPlay

Time
Start: Tuesday, March 29, 2011 (9:00am)
End: Tuesday, March 29, 2011 (4:00pm)

Price
$500.00 a person
$1,300.00 for a group of 3 or more

Location
Online

Registration

Course Overview
Law firm finance and marketing analysts will learn how Business Intelligence can tell them how their firm has been performing from several perspectives. Users will learn about the application of Redwood’s analytic solution, specifically, how to identify the data that is available in their cubes and how to build views on that data. You will learn relevant functionality (PowerPlay) that retrieves, lists, and formats data according to your requirements. This course is designed to help understand what is contained in each module of cubes from the Billing & Collections, Business Development, and Profit modules. In addition, participants will learn how to choose which cubes to use for what type of analysis they need to perform. This course is delivered by an instructor in a virtual classroom.

Course Objectives

Introduce Business Intelligence
Teach navigation of view structures to allow for identification of data that is resident in cubes
Illustrate working modes built into the solution
Establish reporting fundamentals and formatting methodologies
Understand which cube to use to analyze what pieces of information
Understand the Billing & Collections module is made up of Work Period cube, Bill Period cube, Inventory cube, and Daily Inventory cube. It focuses on billing, collections, and the opportunities associated with both.
Understand the Business Development module is made of the Client Development cube, Trends cube, and Cross Sell cubes. These cubes have more of a marketing focus, allowing for growth analysis.
Understand the Profit module contains the Curves cube, Profit cube and Productivity cube. All of which focus on profitability outlining revenue versus costs and including relevant realization and speed measures.

PC/hardware specifications:

High speed Internet connection
Phone
PC with:
- Network access to Redwood demo cubes on the Redwood server
- Local access to PowerPlay

Course Level
This course covers basic and intermediate levels in content

Prerequisites
None

Advance Preparation
None

CPE credit
6

Course Outline (Course may not follow this exact curriculum. Content covered in online sessions depend on attendees interests and will dictate amount of time spent on each section)

Overview

Redwood Analytics Corporate Overview
Business Intelligence Concepts
Terminology

Module 1: Introduction to Business Intelligence and PowerPlay

Starting PowerPlay
PowerPlay Files
Navigation tools
Cross tab set up functions

Module 2: PowerPlay Functionality

Configuring your cross tab: Sorting, Ranking, Suppressing
Adding multi-dimensional views: Layering, Nesting and Multiple Measures
Calculations

Module 3: Formatting

Value’s attributes, appearance and labels
Custom Exceptions
Measures and Categories
Blanks
Report Titles
Graphing
Printing
Share Dimensions

Module 4: Reporter

When to use and why
View formatting
Intro to Subsets
Parentage Subsets
Advanced Subsets

Module 5: Billing and Collections

Work Period Cube
Bill Period Cube
Inventory Cube
Daily Inventory Cube

Module 6: Business Development

Cross Sell Cube
Client Development Cube
Client Trends Cube

Module 7: Profitability

Profit Cube
Curves Cube
Productivity Cube

Appendix

Preference Recommendations
PowerPlay Cube Terminology
Explorer-Reporter Modes
PowerPlay Cautions and Recommendations
Cube Dimension Summary
Cube Definitions: Glossary of Terms

Course Registration
Redwood offers public live and online training, as well as private on-site training.

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

Refund and Complaint Policy
For more information regarding administrative policies such as complaint and refund, please contact our office at 856-231-8989