> For the complete documentation index, see [llms.txt](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module4/ex6.md).

# 4.6 Query Service and Tableau

Open Tableau.

![start-tableau.png](/files/I384cGfLmL7bK7GtPeft)

In **Connect To a Server** select **PostgreSQL**:

![tableau-connect-postgress.png](/files/WXoSgCP2Ac489bgqZEKf)

Go to Adobe Experience Platform, to **Queries** and to **Credentials**.

![query-service-credentials.png](/files/oSayJFAVjn03UIfrYuVc)

From the **Credentials** page in Adobe Experience Platform, copy the **Host** and paste it in the **Server** field, copy the **Database** and paste it in the **Database** field in Tableau, copy the **Port** and paste it in the field **Port**in Tableau, do the same for **Username** and **Password**. Next, click **Sign In**.

Sign In:

![tableau-connection-dialog.png](/files/L2wrNs9AQjrq346UlU5U)

Click search (1) and enter your **ldap** into the search field, identify you table from the result set and drag (3) it onto the location named **Drag tables here**. When finished, click on **Sheet 1** (3).

![tableau-drag-table.png](/files/IiHsrlgrJyGRe28Do8PC)

To visualize our data on the map we need to convert longitude and latitude to dimensions. In **Measures** select **Latitude** (1) and open the field's dropdown and select **Convert to Dimension** (2). Do the same for the **Longitude** measure.

![tableau-convert-dimension.png](/files/8FuTz7iTw3CPgdQxY4ch)

Drag the **Longitude** measure to the **Columns** and the **Latitude** measure to **Rows**. Automatically the map of **Belgium** will appear with little dots representing the cities in out data set.

![tableau-drag-lon-lat.png](/files/KPqR7N1b2ABmr0K9fMJ4)

Select **Measure Names** (1), open the dropdown and select **Add to Sheet** (2):

![tableau-select-measure-names.png](/files/8MpUWLdpjD3PkmbyGmPl)

You will now have a map, with dots of various sizes. The size indicates the number of call center interactions for that specific city. To vary the size of the dots, navigate to the right panel and open **Measure Values** (using the drop down icon). From the drop down list select **Edit Sizes**. Play around with different sizes.

![tableau-vary-size-dots.png](/files/xW5TSaU8XeESQjFvhusH)

To further display the data per **Call Topic**, drag (1) the **Call Topic** dimension onto **Pages**. Navigate through the different **Call topics** using the **Call Topic** (2) on the right side of the screen:

![tableau-call-topic-navigation.png](/files/c2UXlM5Bodfs7oRnv1AK)

You've now finished this exercise.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.adobesandbox.com/comprehensive-technical-tutorial-archive/module4/ex6.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.