# How to Integrate a BI Tool with Your Project in ACC?

This tutorial will walk you through the process of integrating a BI (Business Intelligence) tool with your project. BI tools enable you to analyze and visualize your data effectively, providing valuable insights for informed decision-making.

## <mark style="color:red;">Creating Google BigQuery Account​</mark> <a href="#creating-google-bigquery-account" id="creating-google-bigquery-account"></a>

Once you have set up the BI Tool within your project, the next step is to create a Google BigQuery account. Follow these steps:

{% stepper %}
{% step %}
Click the **Go to console** button.

<figure><img src="/files/n4SxCf4Pwf3gbom2Gq6p" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
You'll be directed to the console setup. Follow the on-screen instructions.

<figure><img src="/files/cReJhUlMa8GKSMWLuUo7" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
On the next page, click the **Create Project** button.

<figure><img src="/files/jrAXVLFTtQVR8PP5qf6l" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Enter a project name and select the location for storing data. Then, click the **Create** button.

<figure><img src="/files/FBSCL6cXGu5ahbqazzBW" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
After project creation, you'll need to generate a project ID for your Google project. The **business-intelligence** field should match the project name on ACC. The location from which this project receives data is displayed in the breakdown menu.

<figure><img src="/files/y6iBLBhcnvkkkdbyDnSV" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Once the project is created, a `service-account.json` file is generated. This file is crucial for transferring data to Google BigQuery. Make sure to add the information from this file using the CLI.

Below are the environment variables that must be added to the CLI:

* `BI_TOOL_TOKEN`: Enter an alphanumeric value of 16 characters following the token in "Token x16."
* `BIGQUERY_PROJECT_ID`: BigQuery project ID.
* `BIGQUERY_DATASET`: The name of the dataset on BigQuery.
* `GOOGLE_APPLICATION_CREDENTIALS`: JSON.

<figure><img src="/files/TUj3fH02bQk3DHDaAu01" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="/files/rLrQRjEm2IcweRVZOe80" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="/files/Wxg6tfvDg0ph6Cyxoum1" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="/files/nYcgKusQmclnldeQogO2" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/3dCvPwRAUHkUPjRr3Lwy" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="/files/zldQpkUklS7CN0y8W8BZ" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="/files/xgfHAeGW22eYFOmdDLJw" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="/files/1g567JDlbNknLKTsbSsQ" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="/files/Jp8HjOnhpacZfUnH55wX" alt="" width="272"><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Click on the location where the data is received to display data on the page. This page dynamically shows data based on data transfer frequency.

To customize incoming data for reports, you can write queries in the relevant field.

<figure><img src="/files/Ewa9vNIw1QFw6qDf0sXn" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

## <mark style="color:red;">ACC Setup Requirements​</mark> <a href="#acc-setup-requirements" id="acc-setup-requirements"></a>

{% stepper %}
{% step %}
Navigate to the App Store in the left-side menu and find the BI Tool application in the application catalog. Clicking on the application card will direct users to the project selection step.

<figure><img src="/files/S4uUMApn8cu5WAhCr1Zc" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Choose the project in which the BI Tool application will be installed, and then click on **Configure Application Values**. Clicking this button will direct users to the application value entry step.

<figure><img src="/files/zHFqru7EIyIwSsAZJVhv" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
At this stage, users should input the application values required for configuring the application. Enter the necessary values and click **Save and Continue**.

<figure><img src="/files/pEdKRvADeo4wC9LbY34Y" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Once the application values have been entered, they will be reviewed in the final step, and users can initiate the application installation by clicking the **Install** button.

<figure><img src="/files/WToZaFvlsTdFSz6Bd7HG" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/bqRO49ex6bQcXGg3Tows" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
The BI Tool frontend and backend applications will be installed in the selected project. Users can monitor the deployment status of these applications on the project's detail page.

<figure><img src="/files/xMWcDh08TjAOrK86OXtN" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}


---

# 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://docs.akinon.com/tutorials/acc/how-to-integrate-a-bi-tool-with-your-project-in-acc.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.
