Downloads

Free tools for SQL, DAX and Power Query

Small tools that run in your browser and use the LearnSQL sample data. Nothing to install, nothing is stored, and every tool shows the code it builds so you can learn from it.

9free tools4 groups
3languages coveredSQL, DAX and Power Query M
400functions linkedfrom the function reference
0sign-ups needednothing stored on our side
Charts and dataSQLBeginner

Chart lab: turn a SQL query into a chart

Pick a business question or write your own SELECT, run it on the sample databases, and see the result as a chart, a table and the SQL.

  • Pick a question
  • Run it
  • Read the chart
Open · about 2 minutes →
Charts and dataSQLBeginner

Data stories: six charts from real business data

Six short stories, each with a live chart built from a real query on the sample data and the SQL underneath.

  • Read the story
  • Look at the chart
  • Open the SQL
Open · about 5 minutes →
GeneratorsMDAXSQLIntermediate

Date table generator

Build a date table with calendar and fiscal columns, week numbers and working-day flags as Power Query M, DAX, T-SQL or MariaDB SQL.

  • Set the range
  • Choose columns
  • Copy the code
Open · about 1 minute →
GeneratorsDAXSQLMIntermediate

Measure builder

Pick a business question, map its columns to your model, and get the DAX measure, an equivalent T-SQL query and a Power Query step.

  • Pick a question
  • Map your columns
  • Copy the measure
Open · about 2 minutes →
Code helpersDAXBeginner

DAX formatter and formula checker

Format a DAX formula into a standard layout and check it for common mistakes, all in your browser.

  • Paste a formula
  • Format it
  • Check it
Open · about 1 minute →
Code helpersMIntermediate

Power Query M explainer

Paste a Power Query M query and get every step explained in plain English, with reference links, folding hints and a re-indent button.

  • Paste your query
  • Read each step
  • Fix the slow parts
Open · about 2 minutes →
Code helpersSQLBeginner

SQL formatter and query outline

Format a SQL Server or MariaDB query, see in plain words what it does, and get a list of common mistakes to check.

  • Paste a query
  • Format and explain
  • Check for mistakes
Open · about 1 minute →
LearningSQLBeginner

Visual SQL query builder

Pick a database and tables, add joins, columns, filters and totals, and get the SQL for SQL Server or MariaDB, with a plain-English explanation and a live run.

  • Choose a start table
  • Add joins, columns and totals
  • Run or copy
Open · about 5 minutes →
LearningSQLIntermediate

SQL recipes for accounting and finance

Ready-to-run SQL for month-end close, receivables, payables, cash, margin, budgets, controls, payroll, nonprofit and inventory, on live sample data.

  • Search or filter
  • Read the recipe
  • Copy the SQL
Open · about 5 minutes →
Tools by languageSome tools cover more than one
Functions you can look up from the toolsThe function reference behind the formatters and explainers