Insights from the
data trenches.
Expert insights on data engineering, analytics, and BI from our team.
Is Tableau free? Tableau Public is — but it's public-only — and Tableau Creator runs about $900 a seat per year. Here's what's free, what isn't, and a free local desktop alternative.
Find your topic.
The archive.
Exploring WebGL Data Visualization in ET1
Why we're prototyping GPU-rendered WebGL visualizations in ET1 — and how they sidestep the DOM and SVG ceilings of the open-source charting stack we've leaned on for years.
Hardening dev3lop.com With a Fleet of Agents
How we hardened dev3lop.com with a coordinated fleet of specialized AI agents — a shared-memory brain, area locks, adversarial verification, and re-runnable scripts — plus the bug-hunting prompts behind each one.
Launching the Workspace Agent Marketplace
We are launching a free workspace-agent marketplace with portable templates, implementation specs, and consulting support for secure production rollout.
ET1.3 Change Log | Version #3
We’ve introduced a wide range of new features since our last update, and we’re excited to highlight the most impactful improvements to the ET1 analytics...
ET1.2 Change Log | Version #2
We have been completely booked and unable to actively blog! This means we have moved all ET1 development into the nights, blogs are reduced to...
ET1.1 Training Menu Update
We overhauled the ET1.1 help menu for clearer tool descriptions, better spacing, in-app tutorials, and responsive layouts—so learning ETL on smaller screens is practical.
ET1.1 Change Log | Version #1
Never have I ever tried to reverse engineer figjam! However once I was done, I realized there's a lot more within my grasp....
ET1.1 Charts Node
In ET1.1 Neon you can now pipeline your data to Charts. - Pie Chart - Donut Chart - Polar Chart - Bar Chart This covers an array of classic data...
ET1.1 Neon Output Node
The Neon Output Node depends on serverless postgresql backend to ensure your data tooling thrives with cool features. Like unblocking postgresql's upsert...
ET1.1 Neon Input Node
The Neon Input Node is our first managed database access node, and an intuitive approach to giving people access to a serverless PostgreSQL which users...
Login to ET1.1 with Auth2
We are excited to announce the GitHub OAuth Login page is now active in (https://dev3lop.com/et1-overview/)). Picture a world where your most sensitive...
ET1 Concat Node
Bring your columns together as one with the Concat Node in ET1. This node is similar to concat() in Excel and allows you to easily bring more than 1...
ET1 Constant Node
The Constant Node creates a constant value per row in your data pipeline. This node is extremely handy when transforming data in your ETL processes. The...
ET1 Find/Replace Node
Automatically finding and replacing data is possible using the Find/Replace Node! Find and replace works inside of sentences, words, numbers, and anywhere...
ET1 Manual Table Node
Create a table manually using the Manual Table Node. Manual Table node falls under the (https://dev3lop.com/et1-data-input-node-overview/) category. Built...
ET1 CSV Input Node
The CSV Input Node, what a classic, flat files living on your computer can be consumed and the data can be extracted here in ET1. CSV is a common file...
ET1 Github CSV Node
ET1's Github CSV Node is designed to help end users extract data from Github CSV URLs which are in public repositories. A public repository on Github is...
ET1 JSON Input Node
When extracting data from a JSON file, try the JSON Input Node. JSON (JavaScript Object Notation) is a common data source. With ET1's JSON Input Node you...
ET1 Trim/Normalize Node
Trim/Normalize Node is built to help you quickly clean your data pipelines and like the (https://dev3lop.com/et1s-column-renamer/), built to make data...
ET1 Joiner Node
On your magic quest to join data? We call it the Joiner node. A simple joining solution that helps people join data at a row level. In ET1, Joiner is...
Create a KPI with ET1
Need a KPI? Aggregating the entire column into 1 value? ET1 has this capability built into the aggregation node. By using the...
ET1 Group By Overview
Eager to group data? The Group By feature can be found in the Aggregation Node. Add the aggregation node to the canvas and send data downstream to this...
ET1 Measure Filter Node
When you have numbers, you have a need for a Measure Filter Node. Numbers are here, lets talk about it. Filtering with a number or decimal is straight...
ET1 Split Node
The Split node lets ET1 user split one or more column into multiple columns. This particular node is great for the times you have multiple rows of data...
ET1 Unique Filter Node
The Unique Filter Node or Unique Tool finds unique values per row in your data pipelines, or allows people to quickly review duplicates only. Plus, you...
Append Fields with ET1's Joiner
Seeking to append fields like the Alteryx Desktop software? The (https://dev3lop.com/et1s-joiner-node/) and...
ET1 Duplicate Columns Node
Dealing with duplicate columns? This particular node is designed to remove similarly named column headers. If "State"="State" then we remove the last...
ET1 Aggregation Node Overview
Aggregation, what a classic. Aggregating your data is a landmark trait for any data steward, data wrangler, or data analyst. In ET1, you can easily...
ET1's DAG Streaming System
Familiar with graphs? How about DAGs? This is not a paradigm shift, but think of DAG as a cool way for tiny team in Austin/Dallas Texas to build an...
About ET1, A Tool to Help Uncomplicate Data
It is undeniable that data can be overwhelming, and those who work with it daily are adept at navigating this complexity. ET1 is designed to assist...
ET1 Data Combination Tools
Are you combining the data? We have you covered. ET1 has all the right tools. The Three Musketeers of Data Combination 1. 🤝 Join (The Matchmaker) -...
ET1 Basic Training
ET1 helps you extract, transform, and load data in a single user-friendly canvas. Data automation in a single canvas. Each node is simple and easy to use...
ET1's Data Input Node Overview
CSV, JSON, and Public CSV endpoints or manual tables. These help you kick start your data pipeline. Once your data comes into the data input, it begins...
Filtering Nodes in ET1
The filtering nodes help you reduce the number of rows, drill into the exact information needed, and create a data set that will add value VS confuse your...
Evolving the Perceptions of Probability
What does the CIA’s “estimation probability” have to do with data visualization and a Reddit poll? Think of it like this: the CIA, and many government...
Adaptive Autoscaling for Variable Event Rates
In the fast-evolving landscape of real-time data, managing unpredictable event rates is more than just a technical feat—it's a strategic advantage. At...
Event-Driven Microservices with Persistent Logs
Imagine a digital ecosystem where applications respond to business events instantly, where data is always consistent and traceable, and where scaling...
Real-Time Feature Extraction for Online ML Scoring
In the era of relentless digital acceleration, decision-makers are under mounting pressure to leverage every data point—instantly. The competitive...
Sessionization in Clickstream Event Processing
Imagine unlocking a granular understanding of your users—not just what pages they visit, but the organic, session-based journey each person takes across...
Streaming Join Optimization Across Heterogeneous Sources
The era of high-velocity, multi-source data is redefining enterprise analytics and intelligence. As more organizations invest in robust data engineering...
Sub-Second Alerting Pipelines for Operational Signals
In today’s hyper-competitive, digitally transformed landscape, operational latency is the new technical debt—and every second (or millisecond) delayed in...
Checkpointing and Recovery for Continuous Dataflows
In the era of real-time analytics and lightning-fast data pipelines, ensuring resilience and reliability is not just advantageous—it’s imperative. For...
Edge Device Event Aggregation and Uplink Streaming
Edge computing solutions are rapidly reshaping how businesses manage high-velocity data ecosystems. With countless IoT devices and sensors generating a...
High-Throughput Change Data Capture to Streams
In today’s data-driven world, enterprises demand more than raw data—they require real-time insights and uninterrupted information pipelines that keep pace...
Hot Path vs Cold Path Real-Time Architecture Patterns
In today’s data-fueled world, the shelf life of information is shrinking rapidly. Decisions that once took weeks now happen in minutes—even seconds....
Sliding and Tumbling Window Metric Computation
In the fast-evolving landscape of data-driven decision-making, tracking time-based metrics reliably is both an art and a science. As seasoned consultants...
Stream-Table Duality for Operational Analytics
The relentless pace of digital business transformation demands more than just new data sources—it requires new ways of...