Who answers?
Provider, business owner, technical owner, refresh schedule, and escalation path.
Flagship product · data knowledge
SyncDesk
Know every connection, field, calculation, owner, and change.
SyncDesk is a structured knowledge workspace for data connections. It documents where data comes from, where it goes, who owns it, what it contains, how business logic is calculated, what changed, and which OpsDesk issue is linked.
Connection context and change history live together, locally.01 · Challenge
A metric is never just a metric.
A number in a dashboard may begin in an Excel column, move through an API, become a calculated field, and change after a business decision. Without durable context, the next discrepancy becomes archaeology.
The goal was not another wiki page. It was a working catalog where connections, schema, logic, history, and operational issues remain linked.
What does it mean?
Fields, data types, metric logic, source mappings, and known limitations.
Why did it change?
Date-based manifest updates linked directly to affected metrics and connections.
02 · Knowledge model
From source to business meaning.
SyncDesk organizes knowledge around five connected objects. Each can stand alone, but the value comes from their links.
Business context
eCommerce, CRM, media, support, or finance.
→
Data movement
Source, destination, owner, provider, coverage.
→
Available fields
Columns, dimensions, metrics, types, samples.
→
Calculated meaning
Formula, dependencies, output, caveats.
→
Dated history
What changed, why, who approved, what is affected.
03 · Manifest
A commit history for business logic.
Versions use dates instead of abstract v1.1 labels. Every manifest update can tag the exact connection, metric, dimension, or calculated field affected by the change.
Calculated dimension: Vendor Group
Updated the normalization rule after the business introduced a new distributor hierarchy.
CASE
WHEN vendor_tier = 'Strategic' THEN parent_vendor
WHEN vendor_name IS NULL THEN 'Unknown'
ELSE vendor_name
ENDTagged dependencies
ecom.xlsx → vendor_name
SFMC Intelligence → Vendor Group
Marketing Command Center → Sales by vendor
Owner: Analytics Operations
Approved by: eCommerce lead
Effective from: 2026-07-19Date is the version
History reads naturally and remains aligned to release, incident, or decision timing.
Fields are first-class links
Opening a metric shows its definition, setup, dependencies, and every manifest entry that tagged it.
Discrepancies link to OpsDesk
Knowledge explains the system; OpsDesk owns the operational investigation and follow-up.
04 · Result
A data wiki that behaves like a product.
SyncDesk gives analysts and project teams a practical place to capture source details, owners, refresh windows, schema, calculated logic, discrepancies, runbooks, and dated changes. The shared JSON workspace keeps SyncDesk and OpsDesk compatible.
Search by connection, owner, provider, field, or purpose
Knowledge is organized around how people investigate data, not around one long documentation page.
Open a field and see its history
Definitions and dates are no longer separated from the decisions that changed them.
One restorable workspace
OpsDesk and SyncDesk data travel together in the same JSON backup and can be restored later.
Human-readable export
Excel, CSV, and Markdown reports communicate the catalog while JSON remains the complete restore format.