M
Oct 1, 2026Mastering SQL INSERTs from Excel: Intelligent Foreign Key Lookups
Converting data from Excel spreadsheets into SQL INSERT statements is a routine task for many data...
Oct 1, 20265 min read0 reactions0 comments
Back to articles 
May 10, 2026
Apr 29, 2026
Apr 19, 2025
Tag archive
#datatransformation
E
Sep 16, 2026Excel to SQL: A Developer's Guide to Translating IF, VLOOKUP, and SUMIFS Logic
Excel spreadsheets are the backbone of data analysis for many businesses. They offer unparalleled...
Sep 16, 20268 min read0 reactions0 comments
E
Sep 7, 2026Excel to SQL INSERTs: Manual Formulas vs. Automated Data Transformation Tools
Moving data from an Excel spreadsheet into a database is a frequent necessity for many professionals....
Sep 7, 20267 min read0 reactions0 comments
A
Sep 3, 2026A Developer's Guide to Generating SQL INSERT Statements from Excel with Formulas
Migrating data from Excel spreadsheets into a SQL database is a common task for developers, data...
Sep 3, 20266 min read0 reactions0 comments
H
Jul 30, 2026How to Generate SQL INSERT Statements from Excel Using Formulas
Moving data from an Excel spreadsheet to a SQL database is a common task for developers, data...
Jul 30, 20267 min read0 reactions0 comments
H
Jul 17, 2026How Our AI Agents Built DataFlow Studio: Client-Side Data Transformation & Integration Canvas
Discover DataFlow Studio, a visual drag-and-drop tool for client-side data processing. Our AI agents, Jan and Klára, engineered this powerful platform, allowing developers to create complex data workflows directly in the browser.
Jul 17, 20263 min read0 reactions0 comments
Mastering Power Query in Power BI: A Complete Data Transformation Guide
Power Query is the backbone of data preparation in Power BI. Before you can build stunning dashboards...
May 10, 20267 min read1 reactions0 comments
Data Preparation in Power BI: Cleaning, Transforming, and Loading Data for Real-World Analytics
Introduction Before any dashboard delivers value, there’s a quiet but critical phase every...
Apr 29, 202613 min read1 reactions1 comments
T
Nov 6, 2025The Missing Layer: How I Completed Our Data Lakehouse Architecture (When Everyone Else Stopped at Silver)
More than five years ago, I sat in yet another meeting listening to someone say, "You know what we...
Nov 6, 20259 min read0 reactions0 comments
T
Oct 18, 2025Templating Columns in dbt: Helpful path to forward
Ship consistent, DRY models by generating column lists with Jinja, macros, and metadata. ...
Oct 18, 20256 min read1 reactions0 comments
🧠 Database for Software Developers – Data Transformation, Grouping & Aggregation (Part 1)
Welcome back to the Database for Software Developers series. In this post, we’re diving into data...
Apr 19, 20253 min read8 reactions0 comments
A
Sep 16, 2024An End-to-End Guide to dbt (Data Build Tool) with a Use Case Example
Introduction In modern data engineering, creating scalable and manageable data pipelines...
Sep 16, 20244 min read6 reactions0 comments