# Data & Context Studio

> Connect your sources, prepare your data and define what it means, so analysis, AI and pricing execution work from a shared commercial foundation. Data & Context Studio is part of every Revomo subscription.

Source: https://revomo.ai/product/data-context-studio/

---

## Turn commercial data into decision-ready context.

Connect your sources, prepare your data and define what it means, so analysis, AI and pricing execution work from a shared commercial foundation.
See the Studio in action[Discuss your data](https://revomo.ai/contact/?plan=Data%20%26%20Context%20Studio)

- **01**Connect & prepare
- **02**Build & transform
- **03**Define context
- **04**Govern & trace
- **05**Power every capability

Data Hub */* Datasets */* **Invoice lines**

Sync now New record

Pricing review Drag here to set row groups Jump to column

| Invoice | Customer | Product | Qty | List price | Net price | Discount % | Margin % |
1 | INV-20418 | Northline Supply | 2" PVC coupling | 500 | $5.20 | $4.62 | 11.2% | 31.4% |
2 | INV-20418 | Northline Supply | 3/4" tee | 1,200 | $1.32 | $1.18 | 10.6% | 34.0% |
3 | INV-20421 | Harbor Mechanical | 1" ball valve | 40 | $13.10 | $11.80 | 9.9% | 27.9% |
4 | INV-20422 | Ridgeway Plumbing | 2" elbow 90° | 300 | $3.45 | $3.05 | 11.6% | 29.2% |
5 | INV-20425 | Ridgeway Plumbing | 1/2" coupling | 2,000 | $0.58 | $0.51 | 12.1% | 30.8% |
6 | INV-20427 | Summit Builders | 2" PVC coupling | 250 | $5.20 | $4.78 | 8.1% | 33.6% |
7 | INV-20430 | Lakeside Contractors | 1" ball valve | 25 | $13.10 | $12.05 | 8.0% | 29.4% |
8 | INV-20431 | Northline Supply | 4" cleanout | 60 | $9.80 | $8.62 | 12.0% | 26.1% |
9 | INV-20433 | Harbor Mechanical | 3/4" tee | 800 | $1.32 | $1.21 | 8.3% | 36.2% |
10 | INV-20436 | Summit Builders | 2" elbow 90° | 150 | $3.45 | $3.12 | 9.6% | 30.1% |
11 | INV-20438 | Lakeside Contractors | 1/2" coupling | 1,500 | $0.58 | $0.53 | 8.6% | 32.4% |
12 | INV-20440 | Northline Supply | 1" ball valve | 60 | $13.10 | $11.66 | 11.0% | 27.1% |
13 | INV-20441 | Harbor Mechanical | 4" cleanout | 24 | $9.80 | $8.92 | 9.0% | 28.3% |
14 | INV-20443 | Summit Builders | 3/4" tee | 1,000 | $1.32 | $1.19 | 9.8% | 34.7% |
15 | INV-20444 | Ridgeway Plumbing | 2" PVC coupling | 400 | $5.20 | $4.68 | 10.0% | 32.0% |
16 | INV-20446 | Lakeside Contractors | 2" elbow 90° | 200 | $3.45 | $3.19 | 7.5% | 31.5% |
17 | INV-20447 | Harbor Mechanical | 2" PVC coupling | 350 | $5.20 | $4.73 | 9.0% | 32.6% |
18 | INV-20449 | Summit Builders | 1/2" coupling | 2,400 | $0.58 | $0.52 | 10.3% | 31.6% |
19 | INV-20451 | Northline Supply | 3/4" tee | 900 | $1.32 | $1.17 | 11.4% | 33.4% |

Page Size: **50 ** **1** to **50** of **18,412** · Page **1** of **369**

**Edit column: Net price** $ USD

Basic settings
Name *Net price* Description *Invoice price after on-invoice discounts, excluding rebates and freight. USD per pricing unit, dated by invoice date.* Semantic tags *** measure:price:net_invoice***
Data type *Money * Currency *USD *

Validation and behavior

Validation rules ***Numeric range · greater than 0****Comparison · not above List price***

**Strict type validation** Invalid imported values go to staging instead of silently becoming empty.

**Allow record editing**

Used By (2) Margin by customer*reads from* Fittings cost-plus*looks up*

Source records, business definitions and dependencies in one workspace.

01 · Connect & prepare

### Bring your commercial data together.

Connect systems and files, review their structure, and resolve data issues before they flow into commercial decisions.

Staging

#### Bad rows wait to be fixed, not lost.

A value that fails its type or a validation rule holds the row with its original text. Fix one row or many at once, and rows that pass move into the dataset.

**Staging** Vendor costs
Issues | Unit cost | Effective start |
1 issue · not a number | 12,40 | 2026-04-01 |
1 issue · not a valid date | 4.10 | 31/02/2026 |
1 issue · not a number | n/a | 2026-04-01 |

**Bulk update: Unit cost**
Literal match Regular expression Value mapping

Find exact value *,* Replace with *.*

Cancel Apply update

Profiling

#### See gaps and inconsistencies before they reach a price.

Profile a dataset to see each column’s missing and unique share, its distribution or most frequent values, with an AI summary of what to look at first.

**Profile** Invoice lines

Unique (%)
10.0

Missing (%)
19.9

Value distribution
****************************************

0% 25% 50%

**Product group** Text

Distinct
148

Missing (%)
77.1

Most frequent values
- Fittings ****412**
- Valves ****281**
- FITTINGS ****57**
- (missing) ****687**

warning

Product group is missing on 77.1% of rows, and “FITTINGS” looks like a second spelling of “Fittings”.

Recommendation: standardize product group values before grouping prices by them.

Import and schema

#### Review the structure before the first row lands.

Prepare a file, check the detected types, and accept or edit suggested names, types, descriptions and tags for each column.

**Import** Vendor costs

- Choose source
- Review mapping
- Import data

**Column mapping** 4 new source columns AI suggest
Select Columns for Import | Column Name | Data Type | Tags |
ITM_NO | Item number*AI* | Text*AI* | identifier:product:sku |
MTL_STD_CST | Standard cost*AI* | Money*AI* | measure:cost:standard |
EFF_DT | Effective start*AI* | Date*Auto* | |
VND | Vendor*AI* | Text*Auto* | |

Integrations

#### Keep connected sources current.

Connected datasets refresh on their own schedule, and columns that appear in a source can be added and backfilled.

**Integration connections**

How it works: files, suggestions, connectors and staging
Workbooks
Imports read CSV and TSV files. For an Excel workbook, choose the sheets you need in File Manager (with the header row), and each becomes a CSV file ready to import.

Column suggestions
Suggestions are drawn from each column’s header and up to five sample values. Every suggestion stays editable, and none carries a confidence score.

Connectors
Databricks, Salesforce and Google Drive connect today. Syncs run manually or on a schedule (hourly to monthly, or cron); Salesforce syncs incrementally, the others refresh in full.

Staging
Each column can parse strictly (failing values go to staging) or leniently (failing values become empty). An import with rows in staging is a partial load, and the count says so.

02 · Build & transform

### Build the data your decisions depend on.

Combine sources, calculate measures and create reusable views on a visual canvas, with each transformation open to inspection. Below, one example: a sales data model.

Data Hub */* Views */* **Sales Data Model**

1 Enrichment 2 Cost layering 3 Periods 4 Rebates 5 Metrics 6 Output

18 columns 412,806 rows

- Invoice ID
- SKU
- Customer ID
+3 more columns

**Products** Dataset

24 columns 6,214 rows

- SKU
- Brand
- Category
+1 more columns

**Customers** Dataset

16 columns 3,480 rows

- Customer ID
- Segment
- Region
+1 more columns

**Sales Reps** Dataset

9 columns 64 rows

- Sales Rep ID
- Territory
- Channel

**Standard Cost History** Dataset

11 columns 58,930 rows

- SKU
- Effective Start
- Effective End
+1 more columns

**Replacement Cost History** Dataset

14 columns 74,520 rows

- SKU
- Snapshot Date
- FOB
+3 more columns

**Orders** Dataset

12 columns 96,140 rows

- Order ID
- Order Date
- Payment Terms

**Quotes** Dataset

10 columns 21,305 rows

- Quote ID
- Customer Code
- Quote Date

**Quote Lines** Dataset

13 columns 188,442 rows

- Quote ID
- SKU
- Quoted Quantity
+1 more columns

**Rebate Programs** Dataset

8 columns 42 rows

- Program ID
- Program Name
- Accrual Basis

**Rebate Accruals** Dataset

9 columns 15,876 rows

- Program ID
- Customer Code
- Accrual Date
+1 more columns

**Products Joined** Combine two input streams

41 columns 412,806 rows

- Brand
- Category
- Country of Origin

**Customers Joined** Combine two input streams

56 columns 412,806 rows

- Segment
- Region
- Buying Group

**Sales Reps Joined** Combine two input streams

64 columns 412,806 rows

- Territory
- Channel

**Standard Cost Joined** Combine two input streams

74 columns 412,806 rows

- Standard Cost
- Effective Start
- Effective End

**Month End Date** Add calculated columns

75 columns 412,806 rows

- Month End Date

**Snapshot Month End** Add calculated columns

15 columns 74,520 rows

- Snapshot Month End

**Replacement Cost Joined** Combine two input streams

88 columns 412,806 rows

- FOB
- Duty
- Tariff
+1 more columns

**Orders Joined** Combine two input streams

99 columns 412,806 rows

- Order Date
- Payment Terms

**Quote Headers and Lines** Combine two input streams

22 columns 188,442 rows

- Quote Date
- Quoted Quantity
- Quoted Discount

**Quotes Joined** Combine two input streams

120 columns 412,806 rows

- Quote Date
- Quoted Quantity
- Quoted Discount

**Year and Quarter** Add calculated columns

122 columns 412,806 rows

- Invoice Year
- Invoice Year Quarter

**Revenue and Unit Metrics** Add calculated columns

129 columns 412,806 rows

- Extended Net Revenue
- Premier Brand Revenue
- Specialty Category Revenue
+1 more columns

**Customer Quarter Revenue** Group and summarise rows *Ready 2h ago*

3 columns 9,812 rows

- Customer ID
- Year Quarter
- Extended Net Revenue

**Accruals with Program** Combine two input streams

16 columns 15,876 rows

- Program Name
- Accrual Basis
- Accrual Amount

**Accrual Year Quarter** Add calculated columns

17 columns 15,876 rows

- Accrual Year Quarter

**Accruals with Revenue** Combine two input streams

19 columns 15,240 rows

- Customer Quarter Revenue
- Accrual Amount
- Year Quarter

**Allocation Rate per Program** Add calculated columns

20 columns 15,240 rows

- Allocation Rate

**Total Allocation Rate** Group and summarise rows

3 columns 9,107 rows

- Customer
- Year Quarter
- Total Allocation Rate

**Total Allocation Joined** Combine two input streams

130 columns 412,806 rows

- Total Allocation Rate

**Allocated Rebate** Add calculated columns

131 columns 412,806 rows

- Allocated Rebate

**Sales Data Model** View output *Ready 2h ago*

131 columns 412,806 rows

- Invoice ID
- Net Invoice Price
- Allocated Rebate
+1 more columns

View whole pipeline Reset

+ −

Sales Data Model

11 source datasets feed 20 transformation steps that produce one table, a row per invoice line.
Stage 2 of 6 · Cost layering

##### Use the cost that applied when the transaction happened.

Match each invoice line to its effective cost before calculating margin.
What enters
Invoice lines, standard cost history with effective dates, and monthly replacement-cost snapshots.

What happens
Standard cost joins where the invoice date falls between Effective Start and Effective End; replacement cost (FOB, duty, tariff, freight) joins on the snapshot for the invoice month.

Why it matters
Margin reflects the cost in effect at the sale, not today’s cost.

Key step · Join **Standard Cost Joined**
Left Join

- SKU *=* SKU
- Invoice Date *>=* Effective Start
- Invoice Date *

The canvas follows Revomo’s view builder. The data is illustrative, and the stage guide and explanations are added for this page.

- **Every operation you need** Join, filter, aggregate, union, pivot, sort and calculate, with any step stored as a table.
- **Time-aware joins** Join conditions compare as well as match, so a cost or price applies only within its effective dates.
- **Every step open** Each node shows its columns and row count; open it to see its configuration or preview its data.

Formulas and lookups

#### Calculate across datasets, views and price lists.

Formula columns live in views and price lists. A lookup pulls a value from another dataset, view, price list or ruleset, and a plain-English description can draft the formula for you to check.

**New column** Target price · Money

'Unit cost' / (1 - lookup (source= "datasets" , name= "Subcategory strategy" , result= "Target margin" , match_by=[ 'Subcategory' : 'Subcategory' ]))

Check passed Drafted from a description
Subcategory | Unit cost | Target margin | Target price |
Couplings | $4.32 | 30% | **$6.17** |
Tees | $1.05 | 35% | **$1.62** |
Cleanouts | $9.10 | 28% | **$12.64** |

Also in the model
- **Keys** Choose the columns that identify a record; an impact check shows how many rows are unique before you save, and duplicates leave the live table and are exported for audit. With no key in the source, number rows automatically.
- **Records** Add records through a typed form, lock columns that shouldn’t change, and update or remove records. Price list and staging grids edit inline.
- **Explore and export** Filter any column by its values, chart a selection, save layouts for yourself or a role, and export to CSV with real column names.

How it works: views and formulas
Operations
Views combine datasets, price lists and other views with joins (inner, left, right, full, cross, matching-only and without-match), filters, aggregates, unions, pivots, sorts and formula columns.

Join conditions
Each condition compares two columns with ==, !=, >, <, >= or <=, which is how effective-dated matching is written.

Formulas
Datasets hold imported rows; formula columns belong to views and price lists. A formula is checked when you save it, and the view builder can also draft a pipeline from a stated goal for you to review.

03 · Define context

### Give your data shared business meaning.

Define measures, units and relationships so teams and AI can interpret commercial data in context.

- **Source field** NET_PR_2
- **Business definition** Net price, on Invoice lines
- **Relationships** Customers, Products, by key
- **Used in** Commercial model, analysis

**Commercial Context Graph** Net price

Databricks · invoice_lines `NET_PR_2` decimal(12,4) Source field Invoice lines Net price Money · USD Defined here measure:price:net_invoice Standard Cost History Standard Cost Money · USD Defined here measure:cost:standard Sales Data Model Net price Money · USD Reads from Invoice lines Sales Data Model Margin % Percentage Calculated measure:margin:gross Fittings cost-plus Realized net Money · USD Looks up Net price Margin by customer Margin % Percentage References the view Fittings · Q4 distributor Realized net Money · USD Inherits from the model Fittings · Q4 OEM Realized net Money · USD Inherits from the model
Customers Joined on Customer ID

Products Joined on SKU

Source system · Databricks · invoice_lines

##### NET_PR_2
decimal(12,4)
About

The ERP column, read on each daily sync and imported into Invoice lines as Net price.

Used by
- **Invoice lines · Net price** imported

Dataset · Invoice lines

##### Net price
Money · USD
Business definition

Invoice price after on-invoice discounts, excluding rebates and freight. USD per pricing unit, dated by invoice date.
Semantic tag
`measure:price:net_invoice`
Validation
Greater than 0 (blocking); not above List price

Comes from
- **Databricks · invoice_lines · NET_PR_2** imported

Used by
- **Sales Data Model · Net price** reads from

Dataset · Standard Cost History

##### Standard Cost
Money · USD
Business definition

Material cost at standard, per unit, in effect for the invoice date.
Semantic tag
`measure:cost:standard`
Validation
Greater than 0 (blocking)

Used by
- **Sales Data Model · Margin %** calculated from

View · Sales Data Model

##### Net price
Money · USD
Business definition

Read from Invoice lines · Net price, where it is defined: Invoice price after on-invoice discounts, excluding rebates and freight.

Relationships
- **Customers** joined on Customer ID
- **Products** joined on SKU

Comes from
- **Invoice lines · Net price** reads from

Used by
- **Sales Data Model · Margin %** calculated from
- **Fittings cost-plus · Realized net** looks up

View · Sales Data Model

##### Margin %
Percentage
Formula

('Net price' - 'Standard Cost') / 'Net price'
Semantic tag
`measure:margin:gross`

Comes from
- **Sales Data Model · Net price** calculated from
- **Standard Cost History · Standard Cost** calculated from

Used by
- **Margin by customer · Margin %** references

Commercial model · Fittings cost-plus

##### Realized net
Money · USD
Formula

lookup(source="views", name="Sales Data Model", result="Net price", match_by=['SKU':'SKU'])

Comes from
- **Sales Data Model · Net price** looks up

Used by
- **Fittings · Q4 distributor · Realized net** inherits
- **Fittings · Q4 OEM · Realized net** inherits

Analysis · Margin by customer

##### Margin %
Percentage
Comes from
- **Sales Data Model · Margin %** references

Price list · Fittings · Q4 distributor

##### Realized net
Money · USD
Comes from
- **Fittings cost-plus · Realized net** inherits

Price list · Fittings · Q4 OEM

##### Realized net
Money · USD
Comes from
- **Fittings cost-plus · Realized net** inherits

The Commercial Context Graph for Net price, from the source field to every use, built from what the workspace records: the column’s definition, tag and rules, the joins in the view, and lineage. Select any column to see its meaning and connections. Illustrative data.

Validation rules

#### Write down what a valid value is.

Add a numeric range, allowed values, a pattern, a comparison with another column, or a value that must exist in another dataset. A blocking rule stops a value that fails; other rules let it through and flag it.

**Validation rules** Invoice lines

Semantic tags

#### Tag what each column means.

Tags come from a built-in commercial vocabulary plus your own, so a column reads as net revenue, a unit cost or a customer identifier wherever it appears.
- measure:price:net_invoice Net price
- measure:cost:standard Standard cost
- identifier:customer:sold_to Customer ID
- time:event:invoice_date Invoice date
[How commercial context works](https://revomo.ai/commercial-context/)

How it works: definitions and relationships
Definitions
Each column carries a description, a type (with currency for money), semantic tags and validation rules. Copilot reads them when it answers.

Relationships
Relationships are carried by keys, joins and lookups in your model. The labels in the example describe the commercial relationship; they are not a separate stored graph.

04 · Govern & trace

### Control access. Understand every change.

Manage permissions, inspect dependencies and review recorded changes across your commercial data.

Lineage

#### See what depends on this data before you change it.

Lineage shows what a dataset, view, commercial model, price list or ruleset depends on, and what depends on it, across the workspace.

**Lineage** Vendor costs

reads from

*View***Margin by customer**

looks up

*Commercial model***Fittings cost-plus**

inherits from

*Price list***Fittings · Q4 distributor**

*Price list***Fittings · Q4 OEM**

Used By (4): a change to Vendor costs can affect 1 view, 1 commercial model and 2 price lists.

Record history

#### Know what changed, when and by whom.

Turn on history for a dataset and every row change is recorded: the field, the old and new value, who changed it and when.

**History** PVC-C200

Unit cost $4.10 **$4.32***+0.22*

- Sep 24 · 14:31 J. Rivera Updated Unit cost $4.25 **$4.10***−0.15*
- Sep 15 · 09:00 System Updated Unit cost $4.18 **$4.25***+0.07*

Enable history tracking On in this dataset’s Data Lifecycle settings, kept for the history retention set there.

Permissions

#### Grant each role what it needs.

Permissions are set per feature, so a role can edit price lists without changing the commercial model behind them.

**Pricing manager** Role

Audit

#### Keep the record of who did what.

- **Audit log** Searchable and exportable record of actions across the workspace.
- **Item sharing** Share an individual item with named users or roles.
- **Separation** Organizations keep data apart, and workspaces partition it within one.
[Governance and security](https://revomo.ai/enterprise/)

How it works: lineage and history
Lookups bind by name
A lookup refers to its source by name, so renaming or deleting a dataset, view or column can leave a dependent formula empty. Check its dependents in Lineage first; Lineage shows them, it does not block the change.

History
History is off until you enable it for a dataset, and it keeps changes for the retention period you set.

05 · Power every capability

### Prepare once. Put it to work across Revomo.

Use shared data and definitions across analytics, planning, pricing and AI-assisted work.

- [**Analytics & Insights**Analyses read the same datasets, views and definitions.](https://revomo.ai/product/analytics-insights/)
- [**Planning & Forecasting**Plans use the same products, customers and units.](https://revomo.ai/product/planning-forecasting/)
- [**Predictive Modeling**Models train on columns whose meaning is described.](https://revomo.ai/product/predictive-modeling/)
- [**Decision Optimization**Constraints are written against defined measures.](https://revomo.ai/product/decision-optimization/)
- [**Price Management**Price lists compute from datasets with formulas and lookups.](https://revomo.ai/product/price-management/)
- [**Quoting & Deal Pricing**Guidance draws on the same customer and price records.](https://revomo.ai/product/quote-management/)
- [**Contract Pricing & Renewals**Customer terms sit beside the same items and prices.](https://revomo.ai/product/contract-management/)
- [**Rebates & Incentives**Accruals use the same volume and price data.](https://revomo.ai/product/incentives-management/)

Revomo Copilot

#### Ask about the data in your own terms.

Copilot reads schemas, definitions, tags, rules and lineage through its tools, within the asking user’s permissions.

**Revomo Copilot**

get dataset schema Completed

check impact analysis Completed

Two price lists: **Fittings · Q4 distributor** and **Fittings · Q4 OEM**. Both inherit from the Fittings cost-plus model, which looks up Standard cost in Vendor costs.

[Revomo Copilot](https://revomo.ai/copilot/)

Automation

#### Act when a refresh changes something that matters.

After a dataset refreshes or a source syncs, an automation can check a watched value against a threshold, then alert someone or recalculate a price list.

**Cost change watch** Automation

[AI Agents & Automation](https://revomo.ai/ai-agents-automations/)

Automations run each time data refreshes or syncs, not as a live stream. Price lists and rulesets carry their own review, approval and revisions in [Price Management](https://revomo.ai/product/price-management/). Data & Context Studio is part of the Commercial Data & Context foundation that every Revomo subscription includes ([pricing](https://revomo.ai/pricing/)).

### See how your data becomes commercial context.

Walk through how your sources, definitions and rules come together in Data & Context Studio.
[Book a data walkthrough](https://revomo.ai/contact/?plan=Data%20%26%20Context%20Studio)[Explore the platform](https://revomo.ai/platform/)
