--- title: "BI tools integrations" canonical: "https://docs.cuesystem.com/space/TAM/873463848/BI%20tools%20integrations" format: markdown --- > ℹ️ IN DEVELOPMENT CUE Solution api for processing analytical data using external systems such as PowerBI. > Macro (toc) Here you can download data template files in the form of an **excel spreadsheet** for evaluating the analytical data provided by CUE Solution. In the template in the configuration tab you fill in a **few parameters** (url, from, to and maximum number of items) and then just refresh the data that will be downloaded online from the url. > ℹ️ Please pay attention before first use [https://cue.atlassian.net/wiki/spaces/TAM/pages/669614132](https://cue.atlassian.net/wiki/spaces/TAM/pages/669614132) ![image](media://a528881c-7fe8-4ec8-bbea-8fe42d498056) ## Templates > ℹ️ The method of data collection is described in [https://cue.atlassian.net/wiki/spaces/TAM/pages/161808385](https://cue.atlassian.net/wiki/spaces/TAM/pages/161808385) - **ApiAnalytics:** This spreadsheet contains data about each event stored in a CUE Solution collected by API (event synchronization). - **ApiOrdersAnalytics:** This spreadsheet contains the same data as ApiAnalytics template, but also orders are included in the statistics if this functionality is enabled. - **BasicOverview: **This spreadsheet contains data about each event stored in a touchONE-admin database collected by panels. ## Columns - **Name:** File name - **Version:** File version - **Extension:** File extension - **Create date:** The date the template file was created - **URL:** Url from which you can download analytical data for the given template. The URL contains a unique token. *Be careful! Anyone who knows this token has access to all statistical data.* ## Actions - **Generate new token:** If you need to change the token for security reasons - **Download file:** Download the template to your computer - **Copy link:** Copy the URL to the clipboard for use in the spreadsheet > Macro (children)