Collect data from multiple Forms instances in a single BI data set

%3CLINGO-SUB%20id%3D%22lingo-sub-1306768%22%20slang%3D%22en-US%22%3ECollect%20data%20from%20multiple%20Forms%20instances%20in%20a%20single%20BI%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306768%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20survey%20with%20MS-Forms%20involving%2030%20organizations%20and%20about%2010%20users%20for%20each%20organization.%20The%20survey%20consists%20of%2010%20questions.%20Not%20all%20organizations%20will%20have%20all%20the%2010%20questions.%205%20organizations%20will%20only%20have%208%20of%20the%2010%20questions.%20The%20organizations%20do%20not%20need%20to%20know%20that%20the%20others%20are%20also%20involved%20in%20the%20survey.%20To%20analyze%20the%20data%2C%20I%20thought%20of%20aggregating%20the%20answers%20via%20Flow%20into%20a%20BI%20dataset%20and%20do%20the%20analysis%20grouped%20by%20organization.%20My%20questions%20are%3A%3CBR%20%2F%3Ea)%20to%20split%20the%20data%20by%20organization%20do%20I%20have%20to%20create%2030%20modules%20(one%20module%20for%20each%20organization)%20or%20can%20I%20somehow%20create%201%20module%20to%20distribute%20to%20all%2030%20organizations%3F%3CBR%20%2F%3Eb)%20should%20I%20create%20two%20types%20of%20Forms%20(one%20with%208%20and%20the%20other%20with%2010%20questions)%20or%20can%20I%20somehow%20make%20them%20dynamic%3F%3CBR%20%2F%3Ec)%20can%20I%20aggregate%20all%20the%20answers%20of%20all%2030%20organizations%20with%20a%20single%20Flow%20into%20a%20single%20BI%20dataset%3F%3CBR%20%2F%3Ed)%20if%20I%20cannot%20do%20c)%20how%20can%20I%20aggregate%20all%20the%20answers%20in%20one%20BI%20dataset%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1306768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi.

 

I need to create a survey with MS-Forms involving 30 organizations and about 10 users for each organization. The survey consists of 10 questions. Not all organizations will have all the 10 questions. 5 organizations will only have 8 of the 10 questions. The organizations do not need to know that the others are also involved in the survey. To analyze the data, I thought of aggregating the answers via Flow into a BI dataset and do the analysis grouped by organization. My questions are:
a) to split the data by organization do I have to create 30 modules (one module for each organization) or can I somehow create 1 module to distribute to all 30 organizations?
b) should I create two types of Forms (one with 8 and the other with 10 questions) or can I somehow make them dynamic?
c) can I aggregate all the answers of all 30 organizations with a single Flow into a single BI dataset?
d) if I cannot do c) how can I aggregate all the answers in one BI dataset?

 

Thanks

0 Replies