One definitive source catalog
A canonical source can serve personal and team workspaces without cloning the credentials and connection material behind it.
Back to selected work
Owned product case study
SwitchLens keeps the path from raw data to a shared answer visible.
A collaborative analytics workspace designed, built, and operated by SwitchCase Studios—connecting databases and files to visual models, useful reports, dashboards, and controlled embeds.
- SQL + files
- Connected in one source catalog
- 4 moves
- Connect, model, build, share
- Public + private
- Controlled visualization embeds
The product brief
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.
What the product had to solve
Models that do real work
Curated fields, labels, keys, and multi-column relationships stay visible and become part of how the query planner produces an answer.
Approachable report authoring
Drag-and-drop tables, charts, KPIs, and dashboards keep field roles, filters, sorts, and formatting understandable while a report evolves.
Publishing with boundaries
Individual visuals can be embedded for a deliberate public or private audience instead of turning every report into an unrestricted link.
The operating path
How SwitchCase approached it
- Connect
Bound the source before building on it
Select the databases, schemas, tables, sheets, or files that belong in the reporting system and keep ownership explicit.
- Model
Make relationships inspectable
Expose fields, types, labels, keys, calculated values, and relationship paths where analysts can understand the model they are using.
- Build
Move from question to useful visual
Use direct manipulation and guided starting points to compose tables, charts, KPIs, and multi-visual dashboards without hiding the logic.
- Share
Publish only what the audience should use
Create a controlled iframe for an individual visualization and evaluate its public or authenticated audience when the viewer loads it.
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.
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.
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.