course:
duration: 1 day
description:

This course is designed for anyone who is going to author reports in PowerPlay. The course covers advanced use of PowerPlay to create sophisticated reports. Topics covered include working with subsets, advanced calculations, rolling periods of time and designing reports for distribution.
prerequisites:

PowerPlay Basics is recommended as well as experience with database concepts and terminology.
course content
Module 1: Introduction and review
› Review concepts from introductory course
Module 2: Layering, Nesting and Intersecting
› Layering
› Nesting
› Intersecting
Module 3: Subsets
› Parentage subsets
› Advanced subsets
› Find in cube subsets
Module 4: Advanced Calculations
› Average, Share of and Sum
› Group calculations
› % of Base
› Cumulative % of base
› Accumulate
› Rollup
Module 5: Explorer Mode
› Difference between Explorer and Reporter
› Drilling down, slicing and dicing and changing displays
› Values as a % of
› Nesting
Module 6: Exceptional Hiliting
› Hi-liting rows
› Hi-liting cells
Module 7: Techniques for deploying reports
› Export reports to different formats
› Working with Excel
› Powerpoint and Word
› HTML

Dimensional Strategies Inc. 1998
Print this page Email this page to a colleague Info