Importing data from Zoho Analytics
DataPrep supports importing data from
Zoho Analytics
. Zoho Analytics is a self-service BI and data analytics software that lets you visually analyze your data, create stunning data visualizations and discover hidden insights from your data.
You can import up to 10 tables at a time from a Zoho Analytics workspace.
To import data from Zoho Analytics
1. Create a workspace or open an existing workspace.
Click here
if you're new to creating workspaces in Zoho DataPrep.
2. Choose the
Zoho Apps
category from the left pane and click
Zoho Analytics
. You can also directly search the option in the search box.
3. Choose your organization from the
Choose organization
dropdown and select one of the available workspaces from the
Choose workspace
dropdown.
4.
Choose tables to import into DataPrep by selecting the check boxes. All the tables including query tables which are present in the workspace will be displayed by default. You can filter tables and query tables using the filter
menu besides the search icon.
Query table is a feature in Zoho Analytics that enables you to prepare data for easy reporting and analysis. You can combine data from one or more tables in a database to facilitate easy reporting.
Click here
to know more about Query tables.
5. Click the
Import
button.
6.
Once you have completed importing data, your dataset will open and you can start preparing your data right away.
Note: You can choose to schedule the import using the
Schedule import
option available for datasets in the
Workspace details page
or from the
Import
menu in the top bar of the DataPrep Studio page.
Click here
to know more.