You are not logged in.

Analyse Survey data with Palo

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Psotkami

Trainee

  • "Psotkami" started this thread

Posts: 1

Date of registration: Jul 30th 2012

  • Send private message

1

Monday, July 30th 2012, 4:55pm

Analyse Survey data with Palo

Hey Guys,

I'm a real beginnger with palo. For my bachelor thesis, i have to transfere data of a survey, which is stored in a excel file, in to the palo database. To load the data into palo i split the excel file into several files. With the "importBiker" ETL sample i achieved to load my question dimesion as a tree in to palo.
My problem is that i have no idea how i have to structure the excel files to get the answers of the survey paricipants into the database and my cube.

The current structure of my three (Dimensions) Excel-files is as follows:

<Question_ID> <QuestionText> <Question_Categorie_ID> <Survey_ID>
____1 _________Question-1 __________1 _______________1
____2 _________Question-2___________1 _______________1
____3 _________Question-3 __________2 _______________1

Paricipant-File:
<Participant_ID> <Question_ID> <Answer_ID>
_____1____________ 1___________ Yes
_____1____________ 2___________ No
_____1____________ 3___________ 90

Survey-File:

<Survey_ID> <SurveyText>
___1 _______Survey-1
___1 _______Survey-2
___1 _______Survey-3

Do i have a misstake in my structure? If so, what do i have to change? I realy hope you can help me.

Thanks in advance.

laloune

Sage

Posts: 216

Date of registration: Dec 2nd 2009

Location: Berlin

Hobbies: Born to work :-)

  • Send private message

2

Monday, July 30th 2012, 6:15pm

Hi Psotkami,

are the questions re-used throughout several surveys ?

if yes then you should use 2 dimensions, one for surveys and the other for questions.

I would structure a cube like this:
- survey
- questions
- participants

hope it helps,
laloune

"To understand recursion, one must understand recursion"

Similar threads

Rate this thread