# 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="/files/MruIuFZD6xPGthAl2jv7" 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="/files/zufMwqTvUJRuefvQeyhh" 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="/files/WhSztqjW3AtqDxhFYIt3" 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](/welcome/technical-guides/smartico-data-warehouse.md). 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="/files/mh0Z1EHvZE7hWw4bYDw9" 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="/files/JHCA9e55F9F1mSrAviV4" 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="/files/UHWtYgChm37VhsSxFVEO" 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="/files/Nd48DrajG3OCrhJP5c3C" alt=""><figcaption></figcaption></figure></div>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.smartico.ai/welcome/products/ai-agents/ai-agent-data-analyst.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.