Blog

Visual ETL for PostgreSQL: Clean and Prepare Data Without Complex SQL

Every Monday, someone filters cancelled orders out of a PostgreSQL export and re-totals it by hand. Here's the same report built once, on a canvas, and rerun in seconds — no SQL required.

How to Spot Duplicate Records Using Column Uniqueness Stats

"How many customers do we actually have?" is a harder question than it sounds when the same company might be entered three slightly different ways. Here's how to catch that with profiling stats alone.

How to Clean a Messy Spreadsheet Without Writing Formulas

A rep-performance report is only fair if every row actually has a rep attached to it. Here's how to exclude the rows that don't — without a single spreadsheet formula.

A Field Guide to Reading a Data Profile Report

Fill rate, unique count, null percentage, inferred type — a data profile puts real numbers in front of you before you build on a dataset. Here's what each one is actually telling you.

How to Import an Excel File Without Writing a Script

A vendor's billing spreadsheet arrives every month with the same formulas, the same formatting quirks, and the same manual cleanup. Here's how to import it once instead of re-fixing it every time.

How to Import a CSV File Into a Reusable Dataset

A CSV export that only exists as an email attachment gets re-cleaned by hand every time someone needs it. Here's how to import it once and reuse it instead.