Business intelligence tools can help you uncover trends in, or gain insights from, the data in your Intellum account. Intellum gives you options for exporting the data in your account to business intelligence tools for data analysis and visualization.
This article gives an overview of the export methods available for your Intellum data for analysis and visualization using business intelligence tools. For BI tools, we cover exporting reports as .csv files, subscribing to report exports, syncing report exports to Google Drive, or scheduling report exports to FTP.
Things to Note:
- Exported report data can be subscribed to, synced to Google Drive, or transferred via FTP - as needed - for use in your preferred BI tools.
Exporting data from Intellum requires that you have already created reports that include the data you need for analysis or visualization.
Contact your Customer Success Manager or an Intellum representative to discuss other methods of export, or connection, to BI tools.
Learn more about Reports & Reporting:
Reports & Reporting
This article will walk you through creating a new custom report by answering each of the questions using an example query.
Export Reporting Data | Overview
Reporting data in your Intellum account can be exported by .csv, synced to Google Drive, or delivered via FTP transfer for use in a BI tool.
Export as .CSV file
The reports you build in the platform can be exported as .csv files from the report page. Once you've created a report, built its query, and confirmed the report's data and column structure, simply click the Export button at the top of the report page.
You'll be prompted to select a file type for report generation. Select Generate report as CSV to export your report. The report will be exported and made available to you as a download that can then be uploaded to a BI tool.
When you manually export a report, you export a snapshot of the data at the time the report was pulled. To ensure changes in the data are reflected in your BI tool, we recommend you set up a subscription to reports, sync reports with Google Drive, or schedule report transfers via FTP.
Subscribe to Reports
Subscribe to a report by setting a recurring delivery option from the report page. Click the Not subscribed to this Report link found at the top of the page. You'll be prompted to select how often the report should be delivered.
Never (default, select to unsubscribe)
Weekly (Every Sunday)
Every 2 Weeks (Every Other Sunday)
Monthly (First Day of the Month)
Quarterly (First Day of the Quarter)
Bi-Annually (First Day of the First Quarter and Third Quarter)
Yearly (First Day of the Year)
The report file will be delivered via email according to the schedule selected - and can be uploaded to your BI tool as needed.
Sync Reports to Google Drive
Intellum also gives you the option to sync a report to Google Drive when you subscribe to a report. BI tools like Google's Data Studio can be connected directly to files in Google Drive to ensure consistent, and scheduled, updates to any data you analyze or visualize.
Google Drive sync must be enabled at the account-level before it is available as an option for admin. Contact your Customer Success Manager or an Intellum representative for more information.
When subscribing to a report, enable the Sync this report with Google Drive option and click the Save button.
The report file will be delivered to Google Drive according to the schedule selected - and can be uploaded or connected to your BI tool as needed.
Learn more about Admin Integrations:
Connect with Admin Integrations
Export Reports to FTP/SFTP
Any report that you build can be exported to FTP/SFTP on a scheduled basis. To do this, repeat the following steps on the report page:
- Hold down the Alt/Option key on your keyboard and click the Export button.
- Specify file format to be exported (e.g. CSV or XML).
- Specify when the report export should recur (e.g. every 2 weeks)
- Specify the date to begin the export and a time of day for the export.
- Click the Schedule button.
You can find the FTP/SFTP server address and login credentials under Developer Resources on the account Settings page - as seen below:
The report file will be exported to FTP/SFTP according to the schedule selected - and can be uploaded or connected to your BI tool as needed.