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? A3. What is the postal code of your organization’s mailing address? 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? B4 Can the majority of your volunteer leaders, 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? B5. To what extent, if any, do your key funders, donors or sponsors know about your 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 survey volunteers about their plans. .