> For the complete documentation index, see [llms.txt](https://academy.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://academy.pentaho.com/solution-analyst-path-sandbox/solution-analyst/business-analyst.md).

# Business Analyst

The first course of the Solution Analyst path: Business Analyst. 15 lessons across 6 modules: the User Console, Interactive Reports, Analyzer, Dashboard Designer and the APAC Sales Pack capstone.

{% hint style="warning" icon="eye" %}
**SANDBOX — draft page.** Built from `analyst-ba-practitioner` 0.1.19 in Pentaho Content Manager. Module and lesson names, the reading-or-workshop kinds and the times come straight from each lab's manifest. Items marked REPLACE-ME need an owner's confirmation.
{% endhint %}

The first step on the Solution Analyst path: learn Pentaho Business Analytics the way business users work with it. By the end you'll be comfortable browsing, reporting on and presenting data in the User Console — Interactive Reports, Analyzer and Dashboard Designer — and you'll have built a complete sales pack of your own as the capstone. The four Analytics Developer courses that follow build what these tools run on.

{% columns %}
{% column %}

<p align="center"><i class="fa-file-lines" style="color:green;">:file-lines:</i><br><strong>15 lessons</strong><br><em>across 6 modules</em></p>
{% endcolumn %}

{% column %}

<p align="center"><i class="fa-flask" style="color:orange;">:flask:</i><br><strong>10 workshops</strong><br><em>hands-on labs</em></p>
{% endcolumn %}

{% column %}

<p align="center"><i class="fa-clock" style="color:cyan;">:clock:</i><br><strong>~6h 40m</strong><br><em>a full day, or a few short sessions</em></p>
{% endcolumn %}
{% endcolumns %}

{% hint style="success" icon="cloud-arrow-up" %}
Every workshop is hands-on and runs on Pentaho's hosting platform. The Lab Guide is embedded in each lab and loads automatically when you open it — nothing to install.
{% endhint %}

***

<h3 align="center">Before you start</h3>

{% columns %}
{% column %}
{% hint style="success" icon="circle-check" %}
**What you'll need**

No prior Pentaho experience — this is where the Solution Analyst path begins. Familiarity with reports, charts and spreadsheets helps. REPLACE-ME — confirm whether anything else is assumed.
{% endhint %}
{% endcolumn %}

{% column %}
{% hint style="info" icon="tag" %}
**Built against**

Pentaho Enterprise Edition **11.0.0.0-232**, the build every course on the Academy runs. The hosted labs run this exact release, so every screen, menu and dialog matches the guide step for step.
{% endhint %}
{% endcolumn %}
{% endcolumns %}

***

{% hint style="info" icon="database" %}

#### What you'll build

Everything runs on the Steel Wheels sample data. You'll browse it in the User Console, build ad-hoc reports on it with Interactive Reports — Sales Territory, Orders for NA and EMEA, Ships and Trains — slice and pivot it with Analyzer, and assemble the Vendor Sales, Inventory and Product Performance dashboards in Dashboard Designer. The capstone brings it all together for the APAC regional director: an Interactive Report with prompts and totals, an Analyzer report with a calculated measure, and a dashboard that links them. Its checks decide your course accreditation.
{% endhint %}

```mermaid
%%{init: {"theme":"base","themeVariables":{"fontFamily":"Arial, Helvetica, sans-serif","fontSize":"13px","lineColor":"#64748b","clusterBkg":"#fafaf9","clusterBorder":"#d6d3d1","edgeLabelBackground":"#ffffff"},"flowchart":{"curve":"basis","nodeSpacing":28,"rankSpacing":44,"padding":22,"wrappingWidth":600,"htmlLabels":true}}}%%
flowchart TB
  classDef input fill:#dbeafe,stroke:#1d4ed8,color:#1e3a8a,text-align:left,rx:6,ry:6
  classDef tool fill:#dbeafe,stroke:#1d4ed8,color:#1e3a8a,text-align:left,rx:6,ry:6
  classDef check fill:#fef3c7,stroke:#b45309,color:#78350f,text-align:left,rx:6,ry:6
  classDef browser fill:#fef3c7,stroke:#b45309,color:#78350f,text-align:left,rx:6,ry:6
  SW[("<b>Steel Wheels sample data</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>already published:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>a metadata domain and a cube&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;")]:::input
  PUC["<b>Pentaho User Console</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>browse data sources, open reports,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>manage schedules&nbsp;&nbsp;&nbsp;&nbsp;"]:::browser
  IR["<b>Interactive Reports</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>ad-hoc reports on the metadata domain&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>Sales Territory · Orders NA and EMEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>Ships and Trains&nbsp;&nbsp;&nbsp;&nbsp;"]:::tool
  AN["<b>Analyzer</b>&nbsp;&nbsp;&nbsp;<br/>slice, dice and pivot the cube&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>Sales Analysis · EMEA Quantity&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::tool
  DD["<b>Dashboard Designer</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>reports, charts and filters on one page&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>Vendor Sales · Inventory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>Product Performance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"]:::tool
  CAP["<b>Capstone: the APAC Sales Pack</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>an Interactive Report with prompts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>and totals, an Analyzer report with&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>a calculated measure, and a dashboard&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>that links them&nbsp;&nbsp;&nbsp;&nbsp;"]:::check
  SW --> PUC
  PUC --> IR
  PUC --> AN
  IR -->|"placed on&nbsp;&nbsp;&nbsp;"| DD
  AN -->|"placed on&nbsp;&nbsp;&nbsp;"| DD
  DD --> CAP
```

<p align="center"><em>The User Console toolset on the Steel Wheels data, and how the capstone draws on it.</em></p>

***

<h3 align="center">Skills you'll gain</h3>

<table data-view="cards"><thead><tr><th></th><th></th></tr></thead><tbody><tr><td><i class="fa-display" style="color:blue;">:display:</i> <strong>Pentaho User Console</strong></td><td>Browsing data sources · opening reports · managing schedules</td></tr><tr><td><i class="fa-chart-line" style="color:blue;">:chart-line:</i> <strong>Interactive Reports</strong></td><td>Building ad-hoc business reports — Sales Territory · Orders (NA &#x26; EMEA) · Ships and Trains</td></tr><tr><td><i class="fa-chart-pie" style="color:blue;">:chart-pie:</i> <strong>Analyzer Reports</strong></td><td>Slicing, dicing and pivoting OLAP data — Sales Analysis · EMEA Quantity</td></tr><tr><td><i class="fa-gauge-high" style="color:blue;">:gauge-high:</i> <strong>Dashboard Designer</strong></td><td>Assembling interactive dashboards — Vendor Sales · Inventory · Product Performance</td></tr><tr><td><i class="fa-trophy" style="color:blue;">:trophy:</i> <strong>Capstone — APAC Sales Pack</strong></td><td>An Interactive Report with prompts and totals · an Analyzer report with a calculated measure · a dashboard that links them, for the APAC regional director</td></tr></tbody></table>

***

<h3 align="center">Course outline</h3>

<p align="center"><i class="fa-file-lines" style="color:green;">:file-lines:</i> reading · <i class="fa-flask" style="color:orange;">:flask:</i> hands-on workshop</p>

{% hint style="info" icon="circle-info" %}
Full lessons unlock once you're enrolled — this is the outline only. Times are the lab guides' own estimates.
{% endhint %}

<table data-search="false"><thead><tr><th width="382">Module</th><th width="115" align="center">Reading</th><th width="132" align="center">Workshops</th><th width="100" align="right">Time</th></tr></thead><tbody><tr><td>Getting Started</td><td align="center">1</td><td align="center">—</td><td align="right">~5m</td></tr><tr><td>User Console</td><td align="center">1</td><td align="center">1</td><td align="right">~20m</td></tr><tr><td>Interactive Reports</td><td align="center">1</td><td align="center">3</td><td align="right">~1h 10m</td></tr><tr><td>Analyzer Reports</td><td align="center">1</td><td align="center">2</td><td align="right">~1h 5m</td></tr><tr><td>Dashboard Designer</td><td align="center">1</td><td align="center">3</td><td align="right">~2h</td></tr><tr><td>Capstone Project</td><td align="center">—</td><td align="center">1</td><td align="right">~2h</td></tr><tr><td><strong>Total</strong></td><td align="center"><strong>5</strong></td><td align="center"><strong>10</strong></td><td align="right"><strong>~6h 40m</strong></td></tr></tbody></table>

{% stepper %}
{% step %}

### <i class="fa-rocket" style="color:blue;">:rocket:</i> Getting Started

`1 reading · ~5m`

Set up your environment and orient yourself with the Pentaho Business Analytics tooling before diving into the hands-on labs.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Before You Start</td><td>~5m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-display" style="color:blue;">:display:</i> User Console

`1 reading · 1 workshop · ~20m`

Tour the Pentaho User Console (PUC) — the browser-based home for browsing data sources, opening reports, and managing schedules.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2FLqAVoPzB3HYkAyANFFKo%2Fpentaho-architecture.svg?alt=media" alt="The Pentaho architecture: Data Integration sends .ktr and .kjb files to the Data Integration Server; Schema Workbench sends .mondrian.xml, Metadata Editor .xmi and Report Designer .prpt files to the Analytics Server; the Pentaho Server saves content in the Repository and runs pipelines and queries data in the data sources"><figcaption><p>Pentaho Architecture</p></figcaption></figure>

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2FyZvwqqq1gviXU5VhsJh5%2Fmodels-and-tools.svg?alt=media" alt="Which model feeds which tool. From a data source, Metadata Editor builds a metadata model (.xmi), Schema Workbench a Mondrian schema (.mondrian.xml), and the Data Source Wizard can generate either. Interactive Reports reads the metadata model, Analyzer the schema, and Dashboard Designer panels show both. An Interactive Report opened in Report Designer becomes a .prpt, one way."><figcaption><p>Which model feeds which tool</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of PUC</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Pentaho User Console</td><td>~10m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-chart-line" style="color:blue;">:chart-line:</i> Interactive Reports

`1 reading · 3 workshops · ~1h 10m`

Build ad-hoc reports for business users with Interactive Reports. Three guided exercises: Sales Territory, Orders for NA and EMEA, and Ships and Trains.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Interactive Reports</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Sales Territory</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Orders — NA and EMEA</td><td>~20m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Ships and Trains</td><td>~20m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-chart-pie" style="color:blue;">:chart-pie:</i> Analyzer Reports

`1 reading · 2 workshops · ~1h 5m`

Slice, dice, and pivot OLAP data with Analyzer. Two exercises: Sales Analysis and EMEA Quantity.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Analyzer Reports</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Sales Analysis</td><td>~30m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>EMEA Quantity</td><td>~25m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-gauge-high" style="color:blue;">:gauge-high:</i> Dashboard Designer

`1 reading · 3 workshops · ~2h`

Assemble interactive dashboards combining reports, charts, and filters. Three exercises: Vendor Sales, Inventory, and Product Performance.

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2Fp1Odt7Ve2EPVOZQN7lSE%2Fdashboard-prompts.svg?alt=media" alt="How the two prompts reach the Vendor Sales Report. A Metadata List on Orders fetches the Customer Territory buttons, which allow multiple selections, and the Product Line buttons, which allow one. Each click sets a dashboard parameter that is the Source of the report&#x27;s region or Product Line parameter, and the panel reloads the report, whose engine applies the value as a WHERE constraint."><figcaption><p>A dashboard prompt is a parameter handed to the report</p></figcaption></figure>

<figure><img src="https://1021209504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fu2m9COjKaS0E9nT7B9bQ%2Fuploads%2FFAb4ulIfYWzWs8IiDNDP%2Fcontent-linking.svg?alt=media" alt="The Product Performance Dashboard&#x27;s parameter wiring. Product Sales Analysis, an Analyzer report, publishes Product to the Territory Sales Mix pie and the Order Status bar chart; the pie, defaulting to the 18th century schooner, publishes Territory to the bar chart, whose default is NA. The report reads the Mondrian cube; each chart re-runs its query on the Orders metadata model."><figcaption><p>Which panel publishes what</p></figcaption></figure>

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-file-lines" style="color:green;">:file-lines:</i></td><td>Overview of Dashboard Designer</td><td>~10m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Vendor Sales</td><td>~35m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Inventory</td><td>~30m</td></tr><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>Product Performance</td><td>~45m</td></tr></tbody></table>

</details>
{% endstep %}

{% step %}

### <i class="fa-trophy" style="color:blue;">:trophy:</i> Capstone Project

`1 workshop · ~2h`

Bring it all together for the APAC regional director: an Interactive Report with prompts and totals, an Analyzer report with a calculated measure, and a dashboard that links them. Its checks decide your course accreditation.

<details>

<summary>See the full breakdown</summary>

<table data-search="false"><thead><tr><th width="79"></th><th>Lesson</th><th width="90">Time</th></tr></thead><tbody><tr><td><i class="fa-flask" style="color:orange;">:flask:</i></td><td>APAC Sales Pack</td><td>~2h</td></tr></tbody></table>

</details>
{% endstep %}
{% endstepper %}

***

<h3 align="center">Exam &#x26; accreditation</h3>

{% columns %}
{% column %}
{% hint style="info" icon="clipboard-check" %}
**The course exam**

40 questions drawn at random from a pool of 50, covering the taught modules — the User Console, Interactive Reports, Analyzer and Dashboard Designer. The pass mark is 80%. It's open-book: browse any module or ask the AI assistant while you work. The Capstone Project is assessed by its own lab checks rather than by the exam.
{% endhint %}
{% endcolumn %}

{% column %}
{% hint style="warning" icon="file-certificate" %}
**Course accreditation**

Finish the lessons and workshops, pass the exam and complete the capstone's checks, and you'll automatically be able to download your course accreditation — Pentaho Business Analytics Analyst. It states your name, the course and the Pentaho version you studied against, and is valid for two years. The exam is self-paced and not proctored.

This course is the first step on the Certified Solution Analyst learning path: Business Analyst, then the four Analytics Developer courses — Schema Workbench, Metadata Editor, Report Designer and CTools — leading to the Certified Solution Analyst credential, which closes with a proctored exam delivered through Kryterion's Webassessor.
{% endhint %}
{% endcolumn %}
{% endcolumns %}

***

<p align="center"><a href="https://academy.pentaho.com/solution-analyst-path-sandbox/solution-analyst.md" class="button secondary" data-icon="arrow-left">Back to the Solution Analyst path</a></p>


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://academy.pentaho.com/solution-analyst-path-sandbox/solution-analyst/business-analyst.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
