Data Fundamentals

Data Profiling Isn't Optional: What We Check Before You Build a Workflow

Fill rate, distinct counts, distributions — the questions worth asking about a dataset before you trust a report built on top of it.

Excel vs. PostgreSQL: When to Move Your Data to a Real Database

Excel and PostgreSQL aren't competing for the same job. Here's where the actual line is, and what changes on the day you cross it.

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.

PostgreSQL Data Types, and How DataQloo Infers Them

A column's declared PostgreSQL type is only half the story. Here's how DataQloo's Schema tab infers the more useful, semantic type underneath.

PostgreSQL vs. MySQL for Analytical Workflows

Both are solid relational databases. Here's how they actually differ for the kind of filtering and aggregation work a visual workflow tool does.

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.