> ## Documentation Index
> Fetch the complete documentation index at: https://docs.segmentstream.com/llms.txt
> Use this file to discover all available pages before exploring further.

# External BI tools

> Connect SegmentStream pre-aggregated data in Google BigQuery to external BI tools like Looker Studio.

<Note>
  External BI tools are available only on the [enterprise plan](https://segmentstream.com/pricing).
</Note>

In addition to fully customisable built-in reports, you can use pre-aggregated data stored in your Google BigQuery to build custom reports using third-party BI tools like Looker Studio.

## Looker Studio integration guide

<Steps>
  <Step title="Clone the template">
    Copy the report from [the Looker Studio template](https://lookerstudio.google.com/reporting/72ea5165-865f-46ac-91c4-631ebab8c1aa/page/rUtYD).
  </Step>

  <Step title="Access data sources">
    Navigate to the data sources section: **Resource > Manage added data sources**.

    <img src="https://mintcdn.com/segmentstream/d8ABOFFwUMo4IrD2/images/attribution/bi-tools-data-sources.png?fit=max&auto=format&n=d8ABOFFwUMo4IrD2&q=85&s=af58118b85f244ea6fdd54c6670ebc1b" alt="Data sources section" width="603" height="297" data-path="images/attribution/bi-tools-data-sources.png" />
  </Step>

  <Step title="Edit data source">
    Click the **Edit** button.

    <img src="https://mintcdn.com/segmentstream/d8ABOFFwUMo4IrD2/images/attribution/bi-tools-edit.png?fit=max&auto=format&n=d8ABOFFwUMo4IrD2&q=85&s=61cadd1ef08798a5ba9624ee692f99b6" alt="Edit data source" width="1180" height="241" data-path="images/attribution/bi-tools-edit.png" />
  </Step>

  <Step title="Modify connection">
    Select **Edit Connection** at the top left corner.

    <img src="https://mintcdn.com/segmentstream/d8ABOFFwUMo4IrD2/images/attribution/bi-tools-edit-connection.png?fit=max&auto=format&n=d8ABOFFwUMo4IrD2&q=85&s=d7c934f5c175bdeaa401f3e630a09149" alt="Edit connection" width="455" height="243" data-path="images/attribution/bi-tools-edit-connection.png" />
  </Step>

  <Step title="Update project and dataset">
    Replace the existing project and dataset with the appropriate dataset from your project settings.

    <img src="https://mintcdn.com/segmentstream/d8ABOFFwUMo4IrD2/images/attribution/bi-tools-project-dataset.png?fit=max&auto=format&n=d8ABOFFwUMo4IrD2&q=85&s=24a416dbc1132cb5c540dca5480cecd4" alt="Project and dataset configuration" width="958" height="157" data-path="images/attribution/bi-tools-project-dataset.png" />

    ```sql theme={null}
    SELECT *
    FROM `YOUR_PROJECT.YOUR_DATASET.bi_report_v4`(
      PARSE_DATE('%Y%m%d', @DS_START_DATE),
      PARSE_DATE('%Y%m%d', @DS_END_DATE),
      30
    );
    ```
  </Step>

  <Step title="Reconnect">
    Click the **Reconnect** button to apply the changes.
  </Step>
</Steps>

After following these steps, you will have Looker Studio connected to your SegmentStream data. This integration lets you visualise and analyse data in more versatile ways using all the features Looker Studio offers.