__resources_and_news How to manage a database through metadata? {"category": "Blog", "topics": "Database, Metadata, Annotation", "shortDescription": "Good data management needs good metadata management. ", "author": "Abbie Sawyer"}
__resources_and_news What is database normalization? {"category": "Blog", "topics": "Database, Normalization", "shortDescription": "How normalization can clean up the data and power analytics", "author": "Abbie Sawyer"}
__resources_and_news How to build a Power BI dashboard with your app’s data? {"category": "Blog", "topics": "Export data, Power BI, 3rd party App", "shortDescription": "Analyze and visualize your Apdata in Power BI", "author": "Abbie Sawyer"}
__resources_and_news How to create a searchable database without writing codes? {"category": "Blog", "topics": "Searchable database, No code", "shortDescription": "This is a tutorial about how to build a no-code searchable database", "author": "Crystal Lee"}
__resources_and_news How to open a CSV without Excel {"category": "Blog", "topics": "Open a CSV, without Excel", "shortDescription": "Here are several ways for you to open a CSV", "author": "Vincent Jiang"}
__resources_and_news Top interview questions for data analysts {"category": "Blog", "topics": "Data analyst, interview questions, 2021", "shortDescription": "Here's our research on the top interview questions for data analysts.", "author": "Vincent Jiang"}
__resources_and_news How to apply RFM analysis to improve your email marketing campaign? {"category": "Tutorial", "topics": "RFM, Email response rate", "shortDescription": "How to elevate email response rate through RFM analysis", "author": "Crystal Lee"}
__resources_and_news What does a data analyst do in 2021? {"category": "Blog", "topics": "Data analyst, 2021", "shortDescription": "Companies are hiring more data analysts to help them extract insights", "author": "Vincent Jiang"}
Testing blog {"category": "Tutorial", "topics": "testing blog", "shortDescription": "This is a testing blog", "author": "Tab"}
__resources_and_news How to pull data from an API {"category": "Tutorial", "topics": "Combine CSV, API", "shortDescription": "This article covers how to transfer data through an API", "author": "Vincent Jiang"}
__resources_and_news How to combine multiple CSV files into one file {"category": "Tutorial", "topics": "Combine CSV, Batch CSV", "shortDescription": "This article will give you a walkthrough on how to combine multiple csv files together for better management", "author": "Crystal Lee"}
__resources_and_news How to do advanced searches for Zendesk tickets? {"category": "Tutorial", "topics": "Zendesk, advanced search, ticket", "shortDescription": "how to do advanced searches for Zendesk tickets?", "author": "Crystal Lee"}
__resources_and_news How to bulk edit CSV files {"category": "Blog", "topics": "Bulk edit, CSV, CSV database", "shortDescription": "Bulk edit CSV files with no coding", "author": "Vincent Jiang"}
__resources_and_news How to backup your Shopify data? {"category": "Tutorial", "topics": "Shopify, data, backup", "shortDescription": "how to backup your Shopify data?", "author": "Crystal Lee"}
__integration_samples __embed-table_samples How to export data as an embed table? Click the "Export" button on the right-hand side of the toolbar Choose "Export to Embed Table" Here you can specify the number of rows to display on your website. Currently, Acho limits the maximum number of
__integration_sync __embed-table_sync Exporting data from Acho to an embed table is easy and intuitive. Simply go to a table under a project, click the "Export" button, and choose "Embed Table". Then enter the number of rows to export, and generate an embed link. The last step
__integration_samples __metabase_samples To set up Metabase for the first time, please contact us. To export data to Metabase, please visit Connect to Metabase
__integration_sync __metabase_sync Setting up a connection between Acho and Metabase is quick and easy. Simply go to a table under a project, click the "Export" button, and choose "Metabase". Then click "Export" to sync the table to your Metabase. The last step is to use go
__integration_sync __square_sync Setting up a connection between Square and Acho is quick and easy. Simply verify your connection and select the tables to sync, then it will take a few minutes to set up the initial sync (depending on your network speed and database size). Once
__integration_samples __api_samples How to import data from API? Go to the Resources page Click Add Resource Click the API tab Specify the remote file, resource name, the URL link. As for authentication, Acho currently supports three methods: None: If API is for the public to use,
__integration_sync __api_sync Setting up a connection between API and Acho is quick and easy. Simply verify your connection, choose your authentication(none, basic authentication, api key authentication) and it will take a few minutes to sync(depending on your network speed and database size). Then you
__integration_samples __sqlserver_samples How to connect to SQL Server? Acho allows you to connect to any SQL Server database (Self-hosted, GCP Cloud SQL, AWS PostgreSQL, AWS Aurora...). You can follow the steps below to set up the connection. Go to the Resources page and click the Add
__integration_sync __sqlserver_sync Setting up a connection between SQL Server and Acho is quick and easy. Simply verify your connection and it will take a few minutes to sync (depending on your network speed and database size). Once the connection has been established, you can choose the
__integration_samples __multiplecsv_samples Auto-detect file format By default, Acho auto-detects the column delimiter and the data types (schema). If you data looks good, simply click the Upload button to start the process. Configure a CSV file manually In case your CSV file does not have a row
