# Instructions for using the OLAP On line Analytic Processing

Document Sample

```					Instructions for using the OLAP (On-line Analytic
Processing) Cube
The OLAP (online analytic processing) cube is a powerful, easy to use analytical tool that
generates results quickly. OLAP cube technology allows users to “slice and dice” their
data in an unlimited variety of ways. Simply select the "dimensions" you want then click
and drag them to the x or y axis of the cube.

The survey is divided into four dimensions. These are (A) Respondent Profile (B) Intent
to Grow (C) Capacity and (D) Managing Change. There are a number of variables in
each dimension. For instance, Respondent Profile contains 6 variables shown in yellow
colored cells that you will see when you first open the cube. These are: City, Respondent
Occupation, Number of Volunteers, Number of Staff, Type of Organization and Annual
Budget.

You may find it helpful to print a copy of the survey in order to see the original questions
asked of participants or you may refer to the question list at the end of these instructions.

The variables for dimensions B through D are contained in a Field List. Click on the icon
in the top row that looks like a list to see the other variables. The icon is located second
from the end of the row.

Example 1 - Examine One Variable at a Time
Your objective is to determine the number and percentage of organizations subdivided by
budget size responded to the survey. Here are some steps you might take:

1. The opening page shows the total number of respondents. To see the number and
percentage of organizations by the size of their budget, drag the “Annual Budget”
cell (yellow color) to the section labeled Drop Row Fields Here. You can now see
the budget distribution of all the organizations responding to the survey.
2. Drag the “Annual Budget” back to the top row, then drag any other item (yellow
cells) to see the results for each variable.

Example 2 – Examine Two Variables at a Time
Your objective is to determine how organizations of different budget sizes responded to
the question, “Does your organization have a written goal or objective to increase the
number of people from the community you engage in volunteer activities?” Here are
some steps you might take:

1. Repeat step one in the previous example. This will show you the number
organizations by their budget size.
2. Open the Field List and click on “Written Goal Inc Vol” then drag it to the area
labeled “Drop Row Fields Here”. You can now see the number of organizations
that responded yes or no to the question based on the size of their budget.

You now have the basic tools to use the cube. Simply click and drag variables of interest
to and from the row or columns area to resort the data.

Example 3 – Examine Subsets of Variables
You can choose to see only part of the data. Notice that each of the yellow cells has a
down arrow button. Click on the arrow to show a checklist of the items for the specific
variable you chose. You can now resort the data by adding or removing check marks
from this list.

Export the Data to Excel
You can select export any table you created by clicking on the Excel icon located in the
top row of the OLAP cube. This action will open a new Excel file and import the data on
your screen. You can now manipulate the data or create a new written report.
Survey Questions
A1. How many paid full time equivalent staff currently work in your organization or
group?

A2. How many volunteers (board and service delivery) contributed to your organization
or group in the past fiscal or reporting year?

A4. What is the approximate annual budget of your organization or group?

A5. Which of the following best describes the primary focus of your organization or
group

A6. Which of the following best describes your primary role in the organization or
group?

B1. Does your organization have a written goal or objective to …

a. Increase the number of people from the community
you engage in volunteer activities?
b. Find new ways to engage people from the community?

B2. Does your organization or group have a written plan that…

a.        Describes how you will increase the number
of people from the community you engage
in volunteer activities?
b.        Describes new ways to engage people from
the community?

B3. Can the majority of your paid staff members, if any, describe either your plans to
increase the number of people from the community or to find new ways to engage people
from the community?

increase the number of people from the community or to find new ways to engage people
from the community?

plan?

C1. Does your organization or group have sufficient human resources (staff or volunteer
leaders) to effectively manage the volunteers you have now?
C2. Do the people who manage your volunteers have sufficient ‘know how’ to do the job
effectively?

C3. Does your organization or group have sufficient funds to effectively manage
volunteers?

C4. Does your organization or group have sufficient physical facilities to effectively
manage volunteers?

C5. Does your organization or group have sufficiently well developed policies and
procedures to effectively manage volunteers?

C6. How compatible or similar to the Canadian Code for Volunteer Involvement
(CCVI) are your policies and procedures?

C7. Does your organization or group have sufficient work tools (e.g. training resources,
adequate software, Internet access) to effectively manage volunteers?

C8. What percentage increase in the number of volunteers serving your organization
could you accommodate given your current resources of staff, money, workspace and
tools?

D1. How well does your organization respond to change imposed from outside the
organization? For example, suppose your funding was reduced.

D3. To what extent does your organization engage in a process to plan for change? For
example, you seek information from funders about policy or funding changes or you

.

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 19 posted: 3/13/2009 language: Azerbaijani pages: 4