How does Acho work?
Last updated
Last updated
Acho is a data application development platform for teams to productize business data into valuable applications that can help scale business operations, and improve customer experiences. Acho has 3 fundamental pieces.
The data infrastructure
The data preparation layer (transformation, cleaning, orchestration, and automaton)
The data application layer
The first thing you would do on Acho Studio is to connect to your database. We have built connectors that will help you verify database connections instantly. See this list of data sources that we currently support.
Flat Files (CSV, TSV, TXT, Excel)
Databases (MySQL, SQL Server, Postgre SQL, MongoDB)
Applications (Salesforce, HubSpot, Shopify, Google Analytics, Google Sheets, etc.)
API (custom API endpoints)
Each integration is connected to Acho Studio. Check out our Data Connector for more info on pulling data into Acho.
A data prep project on Acho Studio is where you can access your data resource and build on top of it. Each project contains many "tabs". Similar to your browser, you may use these tabs to access your data feed. On each tab, you will find many "actions" on the toolkit bar. These actions such as filter, join, replace etc. are similar to a SQL query. When you apply one of these actions, we will send in a query and change your table according to the action and values that you have input. You may apply as many actions as you want, and reset/undo them in sequence. Also, don't worry about losing tables in the process. All tables will be saved every step along the way.
After data has been connected, you can come to the Data Flow and make sure that there are no delays, breakages, or missing data in your pipelines. By leveraging the built-in data observation features, you can quickly identify where the pipelines may require extra attention and debug them within your Data Prep projects.
The Data App builder is the last stop of your data journey on Acho. Within the data app builder, you can practically build any system with your data connected. It's rather simple to get started with tables and charts. Though it can get pretty advanced when you start building more interactive applications with more services for your users. Feel free to check out our live demo page for some of the possible applications you can build.