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.
A product decision
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.
Bring database, file, or JSON API data into a source catalog with explicit ownership.
02
Make relationships inspectable
Model the fields and relationships that explain how data can be combined.
03
Build and share a report
Compose visual answers and share an individual visualization or dashboard with deliberate access boundaries.
What is live
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
Straight answers
Before we start.
01Is 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.
02What 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.
03What 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.
The next move
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.
