THE ANALYST’S WORKBENCH

Less busywork.
More insight.

Your everyday toolkit for SQL, Power BI, Excel, and everything in between.

24 / TOOLS

Free to use.
No account. No setup.

Find your next shortcut

24 tools
SQLSQL

SQL Formatter

Format SQL queries into cleaner, more readable code directly in your browser.

Open tool
SQLSQL

SQL Query Explainer

Break a SQL query into its major clauses and get a plain-English structural explanation.

Open tool
DAXPower BI & DAX

DAX Measure Generator

Generate common Power BI DAX measures using your own table and column names.

Open tool
DAXPower BI & DAX

DAX Formula Explainer

Identify common DAX functions in a formula and understand what each part typically does.

Open tool
DAXPower BI & DAX

Power BI Date Table Generator

Generate a reusable DAX calendar table for Power BI with year, quarter, month and sorting columns.

Open tool
ƒxExcel

Excel Formula Generator

Generate common Excel formulas for lookups, conditional logic, text handling and aggregations.

Open tool
{ }Data cleaning

CSV ↔ JSON Converter

Convert CSV data to JSON or JSON arrays to CSV locally in your browser.

Open tool
%Calculators

Percentage Change Calculator

Calculate the absolute difference and percentage increase or decrease between two values.

Open tool
Q&ACareer

Interview Question Generator

Generate practice interview questions across SQL, Power BI, Excel, statistics and business analytics.

Open tool
{ }Data cleaning

CSV Data Profiler

Inspect missing values, data types, distinct counts, and numeric distributions.

Open tool
{ }Data cleaning

Dataset Comparison

Compare two datasets by business keys and find added, removed, and changed records.

Open tool
{ }Data cleaning

Duplicate Finder & Remover

Find duplicate business keys and export a cleaned dataset.

Open tool
SQLSQL

SQL JOIN Visualizer

See which rows survive a join and how one-to-many matches expand your results.

Open tool
SQLSQL

SQL IN-Clause Builder

Turn a list of values into an escaped and deduplicated SQL IN expression.

Open tool
{ }Data cleaning

JSON Flattener

Convert nested JSON into a flat table with explicit array handling.

Open tool
SQLSQL

SQL Query Builder

Build a SELECT query with a join, filter, grouping, aggregation, and sorting.

Open tool
{ }Data cleaning

Regex Tester

Highlight regular-expression matches and preview replacement text.

Open tool
%Calculators

Date & Business-Day Calculator

Count calendar and business days, or calculate a deadline using your holidays.

Open tool
%Calculators

CAGR & Growth Calculator

Calculate annualized growth between values or project growth across years.

Open tool
%Calculators

Weighted Average Calculator

Calculate a weighted mean and see the contribution of each observation.

Open tool
MPower BI & DAX

Power Query Code Generator

Generate Power Query M patterns for cleaning, types, deduplication, merging, and appending.

Open tool
{ }Data cleaning

Data Dictionary Generator

Create a downloadable starting data dictionary from CSV columns and observed values.

Open tool
SQLSQL

SQL Practice Playground

Run real SQLite queries against a sample database directly in your browser.

Open tool
%Calculators

Reconciliation Calculator

Compare totals by category and flag differences across two datasets.

Open tool
Your work stays with you.

Tool inputs are processed in your browser. No uploads, accounts, or paid API keys.

How privacy works ↗