|
 |
Some of the features you can use in exploring the NASA workforce information with PowerPlay.
| Drilling Down |
Click on any blue hyperlinked row or column label to expand that item into the next lower level within its hierarchy. For example, when viewing the data by occupation, clicking on "Clerical" will change the view to show constituent components, in this case a break out by civil service job series.
|
| Top Level
 |
At any time, users can return to the top summary level, of the current dimensions by clicking this icon.
|
| Changing Measures |
Measures are the quantifiable performance measures that are being used to analyze the NASA workforce, for example headcount, average salary, aggregate salary, average years of Federal service, etc. To change measures, use the drop-down list in the upper left-hand corner.
Changing How Values Are Displayed
Information can be shown as a number value or a percentage of the row total, column total or grand total. In pie charts, for example, you would typically want each segment of the pie to represent the percentage of the entire pie. This allows for a more immediate, visual understanding of the workforce data that is displayed.
|
| Changing Dimensions |
Displayed rows and column dimensions can be changed by selecting these dimensions from the drop down list boxes associated with the rows and columns respectively. For example, if you wish to see Pay Grades instead of Occupations in the columns of the crosstab, simply choose All Pay Grades from the drop down list.
|
| Sorting Column Data
|
The first click on this icon will cause the column data to re-sort in descending order; the second click auses an ascending sort; and the third click will return the data in the default sort order.
|
| Charting the Data |
By default, the data is displayed in a crosstab of rows and columns. It can also be displayed in any of the following
chart formats:
 |
Pie Chart
To drill down, click on a segment, its label, or the corresponding label in the legend. If there are many small segments that would be obscured in the chart, they are consolidated under "Other." However, you can still see their actual values in the legend.
|
 |
Bar Chart
A simple bar chart compares variables, shows variance, or tracks performance by graphing the summary row of the crosstab. For example, a crosstab showing the promotions in each occupation over two years, would generate a bar for each occupation. Each bar would represent the proportionate share of each occupation to the total count of promotion actions.
|
 |
Clustered Bar Chart
A clustered bar chart compares variables, shows variance, or tracks performance by graphing both the summary row and the summary column of the crosstab.
For example, a crosstab showing the promotions in each occupation over two years, would generate a bar grouping for each occupation, each one having two bars, one for each year. Each bar would represent the proportionate distribution of promotions by occupation for each year.
|
 |
Stacked Bar Chart
A stacked bar chart shows the parts that contribute to the total. In the promotions by occupation over years example, each year becomes a partition in a single bar per occupation.
|
 |
Multi-line Chart
A multiline chart compares variables, shows variance, or tracks performance, often over time.
In the promotions by occupation by years example, years would be along the x-axis, and there would be a single line per occupation. This view would make it easy to spot a year-over-year change.
|
 |
Crosstab Charts
At any time, you may return to the original crosstab view by clicking this icon.
|
 |
You may also choose an Indented Crosstab display by clicking on this icon. This feature removes the grid lines shown in the original crosstab, presenting a more condensed view of the data.
|
|
| More Display Features |
 |
Swaps the rows and columns in your report.
|
 |
Suppresses the zeros and null values in your report.
|
 |
Prepares a bookmark for your report by adding the necessary URL information under Bookmarks or Favorites. This is useful if you have found a position in a large cube that you wish to return to easily. Note that once the URL is created, you must bookmark the page with the appropriate browser command.
|
 |
Exports data from a PowerPlay Web report for use in another application. The displayed crosstab data is saved in .csv file format and can then be viewed in any application that supports .csv files, such as Microsoft Excel.
|
| |
You can limit the number of rows and columns displayed in your report by clicking the following new icons:
|
 |
Limits the number of rows per page.
|
 |
Limits the number of columns per page.
|
 |
Opens the Help application in a separate window.
|
|
| |
New Features in PowerPlay Web 6.0 |
| Nested Crosstabs |
Rows and columns can now be nested to show parent-child relationships, intersecting multiple dimensions or measures nested within categories. The product has been tested to 17 levels of nesting but there are no programmatic limits to the number of levels of nesting. Nested categories can be viewed in either stacked or indented formats.
|
| Automatic Exception Detection
 |
PowerPlay Web examines row and column values, applying statistical analysis to highlight favorable and unfavorable outliers.
|
| 80/20 Filter
 |
The 80/20 filter quickly and easily eliminates from your report rows and columns to that are not statistically significant. This allows the user to focus on the significant 80% of rows and columns that have the most impact on a chosen measure.
|
|
|
