Most analytics teams do not work with one perfect data source.
Survey responses tell one part of the story. External files may hold customer attributes, operational records, offline research, or additional classifications. Analysts may also need derived variables that group respondents into reusable reporting segments without changing the original survey data.
QuestionPro BI datasets help bring these pieces together.
Survey Datasets, Survey Composite Datasets, and External Datasets give BI users three practical ways to enrich, classify, and manage data for dashboard reporting.
Why Dataset Flexibility Matters
Dashboards are only as useful as the data behind them.
When useful variables live outside the survey, teams need a way to map those values back to respondent records. When reporting requires new categories, teams need a way to create derived fields without editing the original survey. When data starts completely outside QuestionPro, teams need a clean import workflow for standalone files.
The dataset workflows in QuestionPro BI address all three situations.
The Three Dataset Workflows
Each dataset type solves a different BI data-management problem.
- Survey Datasets map external variables directly to responses from an existing survey data source.
- Survey Composite Datasets create derived variables from survey response data using rule-based criteria, AND/OR logic, operators, values, and default category values.
- External Datasets import standalone Excel or CSV files when the data source lives outside QuestionPro surveys.
Together, they give BI teams a flexible foundation for dashboards, segmentation, reporting, and ongoing data maintenance.
Survey Datasets: Enrich Existing Survey Responses
Survey Datasets are useful when the survey already exists, but the analysis needs additional variables that were not collected directly in the questionnaire.
Users start from Datasets, create a new dataset, select Map to Survey, choose the survey data source, and download a template. The template keeps the response ID structure intact so uploaded variables can be matched to the correct respondent records.
After upload, teams can review imported variables, rename or delete fields, select variables for focused inspection, search by variable or response ID, and update the dataset through reupload or upsert workflows.
Survey Composite Datasets: Create Reusable Derived Variables
Survey Composite Datasets are designed for rule-based classification.
Instead of uploading new values from a file, users create variables from survey response criteria. A composite variable can use survey questions, operators, selected values, AND conditions, OR condition groups, and default category values.
This is useful when teams need to classify respondents into segments, reporting categories, behavioral groups, or other analytical buckets while preserving the original survey data.
- Create a composite dataset from an existing survey data source.
- Create a variable inside the dataset.
- Add criteria based on survey questions and values.
- Use AND logic for combined conditions.
- Use OR groups for alternate criteria paths.
- Set a default category value when no criteria match.
- Rename, sync, edit, or delete variables after creation.
This makes composite datasets especially useful for reusable segmentation fields that need to appear consistently across BI dashboards.
External Datasets: Import Standalone Structured Data
External Datasets are used when the data does not start from a QuestionPro survey.
Users create a dataset from Fresh Data, choose a CSV or Excel template, download the file structure, complete it with records, and upload the prepared file into QuestionPro BI.
Once imported, the dataset can be reviewed and maintained just like other BI datasets. Users can rename variables, remove fields, select variables for focused review, search records, and keep the dataset current through reupload or upsert options.
A Practical Use Case
Imagine a customer insights team building a dashboard for a multi-market tracking study.
The survey captures satisfaction, brand perception, and product feedback. The team also has customer tier information from a separate system, wants to classify respondents into rule-based strategic segments, and needs to bring in a standalone operational file for additional reporting context.
The team can use Survey Datasets to map customer tier values to survey responses, Survey Composite Datasets to create reusable segment variables, and External Datasets to import the standalone operational file.
The result is a BI workspace where survey data, external attributes, derived variables, and imported files can support richer dashboard analysis.
Why This Matters for BI Teams
The value is not just in importing data. The value is in keeping data usable after import.
These workflows let teams review variables, rename fields, remove unnecessary data, inspect records, search within datasets, and update data when business conditions change.
- Use Survey Datasets when external variables need to be mapped to survey responses.
- Use Survey Composite Datasets when new analytical categories should be created from survey criteria.
- Use External Datasets when standalone CSV or Excel files need to become reusable BI data sources.
Together, they help BI teams move from disconnected files and manual data handling to organized, reusable datasets inside QuestionPro BI.
The Bottom Line
Modern reporting rarely depends on one source of data.
QuestionPro BI dataset workflows give teams practical ways to enrich survey responses, create derived variables, and import standalone external files.
For teams building dashboards and reports, that means cleaner data management, stronger segmentation, and more flexible analysis without leaving the BI workspace.
