Data integration and ETL
Moving data between systems is the least glamorous part of analytics and the part that breaks most often. These posts cover the tools that do it, from ETL platforms and connectors to orchestration and governance, alongside hands-on pieces on the specific jobs people get stuck on: combining tables in Excel, or giving an AI agent a pipeline it can drive.
21 posts · page 1 of 2
- 7 min
A CLI Your Agent Can Drive
Command line tools are written for people: aligned columns, color, a prompt before anything destructive, an error in a sentence. Every one of those is a hazard for a program. mammoth-cli was built for both readers: deterministic output, no prompts off a terminal, stable error codes, and a mutation class on every command.
Jasper Flour · 15 August 2026 - 4 min
Write the Logic Once
The same threshold is hardcoded in nine pipelines. Somebody changes it in seven. Parameters and snippets exist so that the value and the logic live in one place, and every pipeline that uses them tells you when it has not caught up yet.
Jasper Flour · 14 August 2026 - 6 min
Files That Are Not Tables
Most data does not arrive as a clean rectangle. It arrives as a PDF invoice, a spreadsheet with a title row and three tables on one tab, or a scan of something printed. Converting one is easy. Converting the same thing every month, the same way, is the actual problem.
Jasper Flour · 14 August 2026 - 4 min
Data Has to Go Somewhere
Getting data in is the part everyone plans for. Getting it back out, into the warehouse or the storage account or the BI tool or the system that triggers something, is where integration projects quietly stall.
Jasper Flour · 14 August 2026 - 4 min
A Refresh That Tells You When It Breaks
Automation that fails loudly is annoying. Automation that fails silently is dangerous, because the report still renders and the number is still wrong. The interesting part of a scheduled refresh is not the happy path. It is what happens the week the source changes shape.
Jasper Flour · 14 August 2026 - 7 min
Manual vs Automated Data Workflows
Data workflow automation is revolutionizing how businesses handle their information. Gone are the days of tedious manual data processing and time-consuming spreadsheet manipulation. Companies are now turning to automated solutions to streamline their data pipelines, boost efficiency, and make better decisions. But what exactly is data workflow automation, and how does it compare to traditional
Jasper Flour · 27 July 2026 - 11 min
Data Pipeline Software: 8 Tools You Should Know (in 2026)
Most data pipeline tools are built for data engineers. They assume you know Python, understand DAGs, and have time to manage infrastructure. That works great if you have a dedicated data engineering team. It doesn't work if your analysts, finance team, or operations managers are the ones who actually need the data to move. This
Jasper Flour · 13 April 2026 - 12 min
15 Best Data Wrangling Tools & Software (in 2026)
Struggling with messy data? We compared 15 data wrangling tools on ease of use, pricing, and scale. So you can find the right fit without needing an engineer.
Jasper Flour · 16 March 2026 - 10 min
The 15 Best Data Transformation Tools & Software (in 2026)
We compared 15 data transformation tools on capability, pricing, and ease of use for business teams and data engineers. See which platforms are worth your time.
Jasper Flour · 16 March 2026 - 15 min
The 12 Best Data Preparation Tools (in 2026)
The 12 best data preparation tools, compared for teams who don't want to write code or wait on data engineers. Includes pricing, features, and tradeoffs.
Gaurav Dudhoria · 16 March 2026 - 8 min
Data Harmonization Tools: 7 Best in 2026 (Compared)
The best data harmonization tools, compared by capability, ease of use, and who they're built for. Includes free and enterprise options.
Jasper Flour · 16 March 2026 - 12 min
How to Connect Snowflake to Excel: 4 Best Methods
Step-by-step instructions to connect Snowflake to Excel using ODBC, the Excelerator Add-In, Power Query, or Mammoth Analytics. Covers Windows and Mac.
Jasper Flour · 5 March 2026
Connect your sources directly.
Tested connectors for the common sources, plus anything with a REST API, cleaning and combining on the way in.
- 14-day Pro trial
- No credit card
- Viewers always free