# Connected data. Clearer decisions.

> A collaborative analytics workspace built and operated by SwitchCase Studios, from data sources and visual models to reports and controlled embeds.

- Page type: Product / work story
- Canonical page: https://switchcasestudios.com/work/switchlens
- Summary: See how SwitchCase Studios built and operates SwitchLens, a collaborative analytics workspace for data sources, visual modeling, reports, dashboards, and controlled embeds.
- Product or related link: [Explore SwitchLens](https://switchlens.app/)
- Product entity: SwitchLens
- Live product: [Try SwitchLens](https://switchlens.app/)
- Product summary: A collaborative analytics workspace that connects databases and files, makes relationships visible, and turns models into reports.
- Product features: Data sources, Visual modeling, Report studio, Controlled embeds

## At a glance
- **SQL + files:** Connected in one source catalog
- **4 moves:** Connect, model, build, share
- **Public + private:** Controlled visualization embeds

## Analytics should clarify the path to an answer—not add another data maze.
Reporting becomes difficult before a chart appears. Sources live in different systems, relationship logic gets buried, and a published visual can lose the context people need to trust it.

SwitchLens treats the workflow as one product system: connect PostgreSQL, MySQL, MariaDB, SQL Server, CSV, TXT, XLS, and XLSX sources; curate fields and model relationships; build tables, charts, KPIs, and dashboards; then publish individual visualizations to the intended audience.

## The decision behind SwitchLens
### Constraint
The same canonical data source may be useful in more than one workspace, while models and reports need their own working context.

### Design choice
Datasource ownership is kept separate from workspace availability; relationships, calculated fields, filters, and report layouts remain workspace-local.

### Trade-off
Separating source ownership from where it can be used adds explicit assignment and access decisions instead of copying a connection into every workspace.

### In practice
Teams can reuse a governed source while keeping each workspace’s modeling and reporting choices in view.

## A conceptual product flow
1. **01 — Connect a source.** Bring database, file, or JSON API data into a source catalog with explicit ownership.
2. **02 — Make relationships inspectable.** Model the fields and relationships that explain how data can be combined.
3. **03 — Build and share a report.** Compose visual answers and share an individual visualization or dashboard with deliberate access boundaries.

## Product preview
![SwitchLens report editor showing data fields, chart controls, and a revenue chart built from sample data](https://switchcasestudios.com/assets/images/previews/switchlens-studio.webp)

Report Studio · Public product preview with sample data

Image dimensions: 1280 × 840.

## Explore this work
- [Explore product and delivery consulting](https://switchcasestudios.com/services/product-rescue)

## Production capabilities
- PostgreSQL, MySQL, MariaDB, and SQL Server connections
- CSV, TXT, XLS, and XLSX file sources
- Visual fields, keys, calculations, and relationships
- Tables, charts, KPIs, and multi-visual dashboards
- Personal and team workspaces with explicit roles
- Public and private single-visual embeds

## Frequently asked questions
### Is SwitchLens a client project?
No. It is an owned SwitchCase Studios product. The studio remains responsible for its product direction, experience, engineering, releases, security boundaries, billing, and operation.

### What data sources does SwitchLens support?
The current product supports PostgreSQL, MySQL, MariaDB, SQL Server, CSV and TXT files, and XLS or XLSX workbooks. Source quantities and automated refresh capabilities vary by plan.

### What can SwitchLens embed?
SwitchLens currently publishes one visualization at a time through an iframe. Authors can deliberately choose from available public or private audience modes; it does not present an entire interactive report as one embed.

## Contact
Building an analytics product people need to trust?

SwitchCase can turn complex data rules into a focused product that stays understandable from source connection through controlled distribution.

[Contact SwitchCase Studios](https://switchcasestudios.com/#contact)