# Analyzer Reports

{% hint style="info" %}

#### Introduction

Pentaho Analyzer is an interactive analysis tool that provides you with a rich Web-based, drag-and-drop user interface, which makes it easy for you to create reports based on your exploration of your data. 

You can also display Pentaho Analyzer reports in a dashboard. Unlike standard reports which tend to be static or minimally interactive after they are created, Pentaho Analyzer reports allow you to explore your data dynamically and to drill down into the data to discover previously hidden details.
{% endhint %}

{% embed url="<https://www.loom.com/share/c6a12105d1bc486dbc60849a6bb30dd5?hideEmbedTopBar=true&hide_owner=true&hide_share=true&hide_title=true>" %}
Analyzer
{% endembed %}

{% hint style="info" %}
Pentaho Analyzer presents data multi-dimensionally and lets you select what dimensions and measures you want to explore. Use Analyzer to drill, slice, dice, pivot, filter, chart data and create calculated fields. Users of Analyzer reports can query the data in a database without having to understand how the database is structured.
{% endhint %}

<figure><img src="/files/bzJI5ODHTcWdrudtaOxl" alt=""><figcaption><p>Schema Workbench - SteelWheels</p></figcaption></figure>

{% hint style="info" %}
Before you can create an Analyzer Report you must have access to a data source, (relational database table(s) or a CSV file) provided by an administrator or a user with create data source permission. The data source used for an Analyzer Report is based on a Mondrian schema (also referred to as an Analysis Model).&#x20;

Mondrian schemas are XML models that have cube-like structures which use fact and dimension tables found in a relational database (OLAP). A Mondrian schema is created using Schema Workbench or generated by the Data Source Wizard, (either through a manually entered SQL query, an auto-query written against one fact table, multiple database tables joined to a fact table, or a CSV file).
{% endhint %}

***

{% hint style="info" %}

#### Use Cases

An Analysis Report answers the following reporting criteria:

* Analyze business data quickly in an interactive environment that focuses on the interaction, exploration, and visualization of data...
* Perform advanced sorting and filtering on your data; you want to drill through reports into the underlying data...
* You want to see chart visualizations that include conditional stop-lighting...
  {% endhint %}


---

# 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://academy.pentaho.com/pentaho-business-analytics/business-analytics/analyzer-reports.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.