Let’s face it, data as chaos, and if you deal with data each day you’re good at managing the chaos. ET1 helps people manage the chaos, without all the interesting limitations that come packaged with software created 20 years ago.
ET1 is an Easy Tool to use.
It can help you clean your data in a repeatable canvas.
It’s a visual data workbench that lets you explore, clean and explain data solutions faster than ‘legacy solutions’ that cost an arm and a leg!
What is ETL? Extract, Transform, Load.
Extract, Pull the data.
Transform, Filter, Sort, Join, Merge, Update, and essentially change the information.
Load, Send the data to a file, database, chart, report, or dashboard.
Core Functionality
The core functionality of ET1 will change and mutate over a period of time.
- Data Input: Supports CSV, JSON, and GitHub data sources
- Data Transformation: Various transformation nodes (filters, joins, aggregations, etc.)
- Data Output: Export to CSV, JSON, and Excel formats
What’s exciting is it’s easy for us to add new features because we are not a large platform!
ET1 Key Features
Here are a few features about ET1 that make the app exciting.
- Node-Based Interface:
- Drag-and-drop nodes for different operations
- Visual connections between nodes
- Real-time data previews, flow data downstream
- Node Types:
- Input: CSV, JSON, GitHub, Manual Table
- Transform: Filter, Join, Union, Pivot, Sort, etc.
- Output: CSV, JSON, Excel
- Advanced Features:
- Branching and versioning of data flows
- Node settings and configuration
- Collapsible nodes for better organization
- Context menus for node operations
- Data Processing:
- Column operations (rename, filter, normalize)
- String operations (concatenation, splitting)
- Aggregations and calculations
- Data types aren’t very interesting to solve
- Data types are for databases
- ET1 is not a database, it’s JavaScript
- Data is stored in graphs
- Data types are boring
- UI/UX:
- Responsive design, everything just flows downstream
- Interactive previews, makes it easy to see what changed
- Not scary, eager to avoid the developer style tools
- Highlight cells per data grid to visually inspect across canvas
Technical Specs
This application is not mobile friendly, mobility will not be a major focus, with that said, this will requires a computer.
There are no specific computer requirements needed, any machine should work, thanks for giving this an attempt.
The software requires no installation, and no setup.
We currently do not store any information about users, or your data. When we decide to add authorization, we will more than likely use Auth0, we are familiar with Auth0 due to our development with Canopys.
Thank you for learning about ET1.
Jump back to the ET1 Overview to continue learning about how ET1 will help your team save time and money when removing the chaos from your data.
