Data Studio

Data Studio is XO’s data-prep layer — blend XO data with external sources, clean and transform it with no code, and publish reusable datasets that power Dashboards and Reports.

Connect sources

1. Go to XO Analytics → Studio → Sources → Add.
2. Connect XO modules and external sources (databases, spreadsheets, third-party APIs).
3. Schedule refreshes so datasets stay current.

Transform

1. Build a pipeline: join, filter, pivot, aggregate, and derive columns.
2. Clean data — dedupe, standardize formats, handle nulls.
3. Preview results at each step.

📷 Screenshot: an ETL pipeline joining sales and external marketing data.

Publish datasets

Publish the output as a dataset that Dashboards, Reports, and Embedded can consume — one clean source of truth instead of ad-hoc exports.

Best practices

• Build reusable datasets, not one-off transforms, so teams share definitions.
• Schedule refreshes to match how fresh the decision needs to be.
• Document each dataset’s meaning so metrics stay consistent.

Troubleshooting

• Refresh failed. Check source credentials and the connection; Studio logs the error.
• Join produces duplicates. Verify the join keys are unique on at least one side.

Related guides

• Reports
• Dashboards
• Embedded Analytics