# AI Agent: Data Analyst

The **Data Analyst Agent** is your data analytics expert, capable of querying your setup data, generating SQL queries, creating visualizations, and providing data-driven insights into your platform usage and user behavior.

He has two main sources of data:

* Data from the integrated platform includes user profiles, bets, deposits, withdrawals, etc.
* Data produced by the Smartico system - campaigns, mini-games, missions, store items, jackpots, raffles, etc.

The best way to know what data is available is to ask the agent...

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-1e61786ca78b3c0054472e3e5daf83c0ef2e6d72%2Fimage.png?alt=media" alt=""><figcaption></figcaption></figure></div>

{% hint style="info" %}
Note that the available data depends on your system integration and usage.

If your integration doesn't provide 'withdrawal payment method' as part of the 'withdrawals' transactions, then you won't be able to analyse the data based on this attribute.

Or if you didn't use Jackpots, the agent will not see any tables and transactions related to the Jackpots
{% endhint %}

You can use the Data Analyst Agent to query row data and export it to CSV

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-80245ac3e7521b6570b2730de6ccc73262c43cf5%2Fimage.png?alt=media" alt="" width="375"><figcaption></figcaption></figure></div>

Whenever possible, the agent will generate the chart for ad-hoc analysis.

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-9fc66f6be1f5c5fdf199bce3640b17c3f581f9e4%2Fimage.png?alt=media" alt="" width="375"><figcaption></figcaption></figure></div>

The Data Analyst Agent is using the same dataset as the one available to you in the [Smartico Data Warehouse](https://help.smartico.ai/welcome/technical-guides/smartico-data-warehouse). You can refer to the documentation to understand the dataset, its columns, and their semantics. For each dialog, you can find the SQL query that can be used against the Smartico DWH to produce the same results.

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-dcc10c2f7ed28eef9fd1a9bcd53c5b415f65c395%2Fscreencast%202026-01-12%2022-16-48.gif?alt=media" alt="" width="375"><figcaption></figcaption></figure></div>

You can assess the Data Analyst Agent from a different place in Smartico using the "**Ask AI**" button, which will show context-based questions to help you quickly generate a report on user activities.

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-888be7672443644d304b9c2c0ac0a8e41710d390%2Fscreencast%202026-01-12%2022-26-58.gif?alt=media" alt=""><figcaption></figcaption></figure></div>

In the same way, you can analyse any other entities from the CRM or Gamification domain

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-329010a35ee1730c16ef681f06b9d9df54899bbc%2Fscreencast%202026-01-12%2022-37-58.gif?alt=media" alt=""><figcaption></figcaption></figure></div>

Or you can build a custom query and request a specific visualisation

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-089bfc6e9903b61342bfa275e4716629cc1815e5%2Fscreencast%202026-01-12%2022-43-01.gif?alt=media" alt=""><figcaption></figcaption></figure></div>