# Create Analytics sheet

While a Lumel Planning sheet allows for integrated planning, budgeting, forecasting, writebacks, and more, a Lumel BI sheet allows you to visualize, analyze, and report on your data.

This section describes the steps to create a BI sheet for your semantic model that [you have connected to.](https://docs.fabricplan.com/create-planning-analytics-and-data-apps/pages/TIz8xPnGj3TbMAA2RgWZ#id-2.-connect-to-a-semantic-model)

## 1. Create a Lumel Intelligence sheet

1. [Create a Plan item](https://docs.fabricplan.com/create-planning-analytics-and-data-apps/pages/TIz8xPnGj3TbMAA2RgWZ#id-1.-create-a-new-epm-item) and [connect to a semantic model](https://docs.fabricplan.com/create-planning-analytics-and-data-apps/pages/TIz8xPnGj3TbMAA2RgWZ#id-2.-connect-to-a-semantic-model) as explained in the previous section. The screen looks as shown below.

<figure><img src="/files/GeffPnVcU7E2chSyrf51" alt=""><figcaption><p>Plan item</p></figcaption></figure>

2. To create an analytics sheet for the data, click on the '+' icon beside the planning sheet and select **Intelligence.**

<figure><img src="/files/D2sEwQxQZ9IJ9p9iv1GQ" alt=""><figcaption><p>Add BI sheet</p></figcaption></figure>

3. A pop-up appears. Enter a name and an optional description and click on **Create.**

<figure><img src="/files/0t9rdG7xUMjqiL597dHr" alt=""><figcaption><p>Create BI sheet</p></figcaption></figure>

4. A BI sheet is created as shown, to which you can start adding visualizations and perform analyses.

<figure><img src="/files/72gzwPfb7eB0zlEah3mf" alt=""><figcaption><p>Lumel BI sheet</p></figcaption></figure>

## 2. Add Visualization & Assign Fields

To get started with the report, add the required visualization to the canvas. Lumel BI offers the following visualization options to add:

* Lumel Planning Sheet
* Charts
* KPI cards
* Table
* Matrix
* PowerTable
* Super Filter

Let's demonstrate by adding a **Matrix** visualization first.

1. Click on **Matrix** to add a matrix visualization to the canvas.

<figure><img src="/files/g2j5OzBYImggmeXP7CUW" alt=""><figcaption><p>Add Matrix</p></figcaption></figure>

2. You can resize the visualization by clicking and dragging in a corner, as well as reposition it by clicking the gripper icon.

<figure><img src="/files/sh8x1PBLMfluSKsCnPHB" alt=""><figcaption><p>resize and reposition</p></figcaption></figure>

3. To create the visual, drag and drop the necessary data fields from the **Data** pane into the **Visualizations** pane.

<figure><img src="/files/XkxGq4BxouphkxJ9rJ6Q" alt=""><figcaption><p>Assign data fields</p></figcaption></figure>

You have now created your first BI sheet with a Matrix visualization. Within this visual, you can analyze data, create inline charts, perform conditional formatting, and much more.

<figure><img src="/files/CAy5bHqIfw3MQy5927ur" alt=""><figcaption><p>Working with the Matrix visual</p></figcaption></figure>

4. Click on **Save** to save the BI sheet.

<figure><img src="/files/1iWw1q1iLLhHr0i6YACy" alt=""><figcaption><p>Save BI sheet</p></figcaption></figure>

{% hint style="danger" %}
Make sure the BI sheet is saved to avoid losing the created visualizations.
{% endhint %}

## 3. Adding Other Visualizations

Similar to adding Matrix, you can also include other visualizations in the BI sheet. The steps are the same as illustrated above, which involves:

1. Clicking on the required visualization
2. Assigning the required fields

The below illustration demonstrates how you can add a chart to the BI sheet.

<figure><img src="/files/7iTZcyGwqlbFhtIs4tDN" alt=""><figcaption><p>Adding Chart</p></figcaption></figure>

The Chart visual provides intuitive, context-aware customization options that enable you to interact directly on the charts and adjust settings without having to navigate through complex menus.

A Lumel BI sheet can include multiple visualizations as shown below:

<figure><img src="/files/DlFZ2xcl02XGrtHuKtaW" alt=""><figcaption><p>BI sheet with Matrix, Chart and SuperFilter</p></figcaption></figure>

In the next section, we'll discuss how to integrate a Planning sheet into the BI sheet. This allows you to include your simulations, scenarios, forecasts, Infobridge-queried data, and so on in your BI sheet, allowing for more consolidated planning and data analysis.


---

# 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.fabricplan.com/create-planning-analytics-and-data-apps/create-analytics-sheet.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.
