Visual reference for every functional area of the Statisticians Workbench — captured from the live application at each release
The login screen is the first page every user sees. It accepts email and password, validates credentials against the database, and redirects authenticated users to the landing page. Links to self-registration and password reset are provided below the form. Invalid credentials and empty submissions produce persistent inline error messages.
New users create an account by providing their name, email, and password. The registration form validates inputs — duplicate emails are rejected, weak passwords flagged, and required fields highlighted. On success, a verification email is sent and the user is prompted to check their inbox.
After login, users arrive at the homepage. The sidebar on the left provides navigation to all sections — Recipes, AI, Statistics, My Data, and Settings. The main area shows recent recipes, dataset cards, and platform status. Admin users see additional links for user management and platform configuration.
The recipe list and editor — the central workspace. A master-detail layout shows saved recipes on the left and the active recipe on the right. Recipes are built as a pipeline of stages — Dataset/Transform, Algorithm, Output — each with its own configuration panel.
The general-purpose AI chat panel. Connects to cloud AI providers or local LLMs. AI acts as a concierge — suggesting recipe stages, interpreting statistical output, and answering questions about datasets — but never modifies data autonomously. Every suggestion is recorded in an audit trail.
Schema-aware AI designer. Maps business requirements to table structures, relationships, and constraints. Generates DDL and suggests indexing strategies. Connected to the database connections manager for real-time schema browsing.
Federated SQL views across physical datasets. Define virtual datasets by joining tables from multiple database connections. AI assists with query construction and validation. Results are queryable like any physical dataset.
AI-assisted data cleaning panel. Detects outliers, suggests missing-value imputation strategies, and previews type coercion. Each suggestion is presented for user approval — the AI recommends, the user decides.
AI-guided recipe construction. Describe the analysis in natural language and the concierge proposes a pipeline of stages with configured algorithms. Users review, adjust, and save the generated recipe.
Statistical methods against any dataset — descriptive statistics, correlation, regression, hypothesis testing, distribution fitting. Results render as interactive Plotly charts (bar, line, scatter, histogram, box, pie) with export to PNG or CSV.
Browse and manage all datasets across all connections. View schema, preview rows, check status. Datasets feed into recipes, statistics, and AI analysis workflows.
View all previously uploaded CSV and Excel files. Each upload is tracked with status, row count, and the dataset it produced. Re-ingest or delete uploads from this panel.
Browse imported Jupyter notebooks. Notebooks are stored, linked to datasets, and displayed alongside recipe execution history. Import-only — no Jupyter server required.
Upload CSV, Excel, or JSON files. Ingested data appears in All Datasets and is immediately available for recipes, statistics, and AI analysis. Upload limits are configured per user group in admin settings.
Add, test, and manage connections to PostgreSQL, MySQL, SQL Server, and MS Access databases. Credentials encrypted at rest. Saved connections feed schema browsers and table previews throughout the platform.
Import Jupyter notebooks (.ipynb files). Uploaded notebooks are stored, linked to datasets, and displayed alongside recipe execution history. Import-only — no Jupyter server required.
Update display name, email notification settings, language preference, and dark mode toggle. Language changes persist across sessions — the backend reads the language column on every authenticated request. Password change with strength validation.
Manage saved database connections from the settings panel. View, edit, and test connections. Configure default connection and connection pooling options.
Manage AI provider connections — Anthropic, OpenAI, and OpenAI-compatible endpoints. Each connection stores an API key (encrypted), endpoint URL, and model configuration. Set a default AI connection for the chat panel and concierge.
Platform-level controls across four setup tabs: user management (list, promote, delete), group administration (create groups, assign members), feature gate toggles, and platform options.
Global AI provider management. Add, edit, and remove provider connections available to all users. Configure rate limits, model allowlists, and usage tracking.
Manage the catalogue of available AI models. Enable or disable specific models per provider. Set default models for different task types (chat, analysis, code generation).
Configure which chart and visualization types are available to users. Enable/disable specific Plotly chart types. Set default colour palettes and rendering options.
Create and manage user groups. Assign members, set group-level permissions, configure upload limits per group. Groups control access to shared recipes, datasets, and database connections.
Configure platform-wide resource limits — maximum upload size, maximum dataset count per user, session timeout duration, and concurrent connection caps. These limits apply to all users unless overridden at the group level.
Platform-level feature toggles and behavioural options — enable or disable MSSQL support, MS Access support, audit logging, and other licensed features. Configure default language, timezone, and date format for new users.
Internal system configuration — database connection pool settings, cache TTL values, background job intervals, and log verbosity. These settings typically require a backend restart to take effect.
View and manage the platform licence — current tier, feature entitlements, expiry date, and seat count. Enter or update the licence key. The licence controls which features are available across the entire instance.
When enabled, a banner appears on every page indicating the platform is in evaluation mode. Local AI resources are blocked — only cloud AI providers function. Admin-configured sample datasets are visible. Authentication still required.
Built-in restricted account demonstrating the platform. UI shows an "Example User" badge and read-only indicators throughout — write actions are disabled. A return-to-admin banner lets admins switch back.
Persistent inline error messages — validation failures, permission denials, backend errors. Errors remain visible until the user takes corrective action. Not transient toasts.