> 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/business-analytics-path-sandbox/business-analytics/level-2-associate.md).
# Level 2 — Associate
Level 2 of the Business Analytics path: four BI Developer courses — Schema Workbench, Metadata Editor, Report Designer and CTools. 84 lessons across 31 modules.
{% hint style="warning" %}
**🧪 SANDBOX — draft content**, built from the four rebuilt courses in Pentaho Content Manager — `bi-developer-sw-associate` 0.1.9, `bi-developer-me-associate` 0.1.10, `bi-developer-rd-associate` 0.1.8 and `bi-developer-ct-associate` 0.1.8. Module and lesson names, the reading-or-workshop kinds and the times come straight from each lab's manifest; the prose is drafted from the courses' own module summaries. Items marked REPLACE-ME need an owner's confirmation.
{% endhint %}
Level 1 taught you to use the Business Analytics tools — Interactive Reports, Analyzer and dashboards in the User Console. Level 2 is where you build what those tools run on, and what they can't do: the Mondrian cubes Analyzer slices, the metadata domains Interactive Reports query, print-quality parameterised reports in Report Designer, and fully custom CTools dashboards. Four courses, taken in order — Schema Workbench, Metadata Editor, Report Designer, CTools — each with its own labs and its own embedded exam.
{% columns %}
{% column %}
:file-lines:
84 lessons
across 31 modules in 4 courses
{% endcolumn %}
{% column %}
:flask:
47 workshops
hands-on labs
{% endcolumn %}
{% column %}
:clock:
~44h 05m
self-paced, over several weeks
{% 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 %}
***
Before you start
{% columns %}
{% column %}
{% hint style="success" icon="circle-check" %}
**What you'll need**
Level 1 — Practitioner course accreditation, or equivalent day-to-day use of Interactive Reports, Analyzer and Dashboard Designer. The courses model and report on the SteelWheels SampleData schema, so comfort with relational tables, keys and basic SQL will make the labs quicker — but every step is shown. The CTools course goes furthest from the point-and-click tools: it helps to have seen a little HTML, CSS and JavaScript.
{% endhint %}
{% endcolumn %}
{% column %}
{% hint style="warning" icon="tag" %}
**Built against**
REPLACE-ME — confirm the Pentaho Server, Schema Workbench, Metadata Editor and Report Designer versions the hosted labs run, so screens and menus match the guide step for step.
{% endhint %}
{% endcolumn %}
{% endcolumns %}
***
{% hint style="info" icon="cube" %}
#### What you'll build
Everything sits on the same SteelWheels data. In Schema Workbench: the SteelWheels cube explored, the Classic Models cube built step by step, the Miniature Models cube built independently — then extended with time and geographic dimensions and calculated members, queried in MDX, locked down with four Mondrian roles, translated into French and sped up with aggregate tables. In Metadata Editor: the OrdersME star-schema domain built from scratch, enriched with inherited properties and reusable concepts, secured with row-level constraints, and the Trailhead Outfitters capstone — a MySQL sales database modelled from an empty domain to a published, secured domain and proven with three users in Interactive Reports. In Report Designer: a Regional Sales report capstone — grouped, totalled, conditionally formatted, parameterised, charted with drill-down sub-reports, and published to the repository with hyperlinks. In CTools: a Carrier dashboard built three ways (CDF, CDE, CGG) over CDA data sources, and a Retail Sales analysis dashboard as the closing use case.
{% 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 server fill:#ede9fe,stroke:#6d28d9,color:#3b0764,text-align:left,rx:6,ry:6
classDef model fill:#ccfbf1,stroke:#0f766e,color:#134e4a,text-align:left,rx:6,ry:6
classDef browser fill:#fef3c7,stroke:#b45309,color:#78350f,text-align:left,rx:6,ry:6
DATA[("SteelWheels SampleData
relational tables ")]:::input
SWB["Schema Workbench
a Mondrian schema: cubes,
dimensions, measures, MDX,
roles, aggregate tables "]:::model
ME["Metadata Editor
a metadata domain: physical layer,
business model, concepts,
row-level security "]:::model
RD["Report Designer
print-quality reports: groups,
totals, parameters, charts,
sub-reports "]:::tool
CT["CTools
custom dashboards: CDA data
sources, CDF and CDE with
CCC charts, CGG "]:::tool
SRV["Pentaho Server
everything is published
to the repository "]:::server
AN["Analyzer
queries the cube "]:::browser
IR["Interactive Reports
query the domain "]:::browser
PUC["User Console
runs the reports and dashboards "]:::browser
DATA -->|"model it "| SWB
DATA -->|"model it "| ME
SWB -.->|"a data source for "| RD
ME -.->|"a data source for "| CT
RD --> SRV
CT --> SRV
SWB --> SRV
ME --> SRV
SRV -->|"the cube "| AN
SRV -->|"the domain "| IR
SRV -->|"reports, dashboards "| PUC
```
What each of the four courses builds, where it is published, and which Level 1 tool runs on it.
***
What you'll learn
{% columns %}
{% column %}
* Model OLAP data as a Mondrian schema — cubes, dimensions, hierarchies, levels and measures — and choose between star and normalised designs
* Take a basic cube to production grade with shared time dimensions, member properties, degenerate dimensions and calculated members
* Query cubes directly in MDX to validate and troubleshoot a schema, and centralise reusable member collections as Named Sets
* Secure a cube with Mondrian roles, grants and rollup policies; localise it by user locale; speed it up with aggregate tables
* Build a metadata domain in Metadata Editor — physical layer, business model, relationships and business views — then enrich it with inherited properties and reusable concepts
* Lock a published domain down with metadata security and row-level data constraints, so roles see different rows and columns
{% endcolumn %}
{% column %}
* Design print-quality reports in Report Designer: JDBC data sources and queries, data elements and groups, totals and conditional formatting, headers and footers
* Make reports interactive with parameters, charts, drill-down and multiple sub-reports, then publish them to the repository with hyperlinks
* Build custom dashboards with the Community Tools: CDA data sources, CDF and CDE dashboards with CCC charts, and CGG-generated graphics
* Publish cubes, domains, reports and dashboards to the Pentaho Server and prove them where Level 1 left off — in Analyzer, Interactive Reports and the User Console
{% endcolumn %}
{% endcolumns %}
***
Course outline
:file-lines: reading · :flask: hands-on workshop
{% hint style="info" icon="circle-info" %}
Full lessons unlock once you're enrolled — this is the outline only. One tab per course, in the order you take them; times are the lab guides' own estimates.
{% endhint %}
{% tabs %}
{% tab title="1 · Schema Workbench" %}
Hands-on workshop for the OLAP / Mondrian schema BI Developer. Build, extend, and publish Mondrian schemas with Pentaho Schema Workbench — cubes, dimensions, hierarchies, levels, measures, calculated members, named sets — and query them with MDX.
17 lessons · 8 modules · ~12h 50m
| Module | Reading | Workshops | Time |
|---|
| Getting Started | 1 | — | ~25m |
| Key Concepts & Terminology | 1 | — | ~20m |
| Schemas | 1 | 3 | ~4h |
| Extend Model | 1 | 2 | ~2h 20m |
| MDX Query | 1 | 2 | ~1h 10m |
| Data Security | 1 | 1 | ~2h 30m |
| Localization | 1 | 1 | ~1h 20m |
| Performance | — | 1 | ~45m |
| Total | 7 | 10 | ~12h 50m |
{% stepper %}
{% step %}
### :rocket: Getting Started
`1 reading · ~25m`
How to get the most out of this guide, and how to set your machine up — whether you are on a lab VM or installing Pentaho Server and Schema Workbench on your own laptop.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Before You Start | ~25m |
{% endstep %}
{% step %}
### :lightbulb: Key Concepts & Terminology
`1 reading · ~20m`
OLAP vs. OLTP, multidimensional cubes, star vs. normalised schemas, and the ROLAP Mondrian engine — the mental model behind every lab.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Key Concepts & Terminology | ~20m |
{% endstep %}
{% step %}
### :cubes: Schemas
`1 reading · 3 workshops · ~4h`
The building blocks of a Mondrian schema, then three guided builds against the SteelWheels SampleData: explore the prebuilt SteelWheels cube, build the Classic Models schema step by step, then prove your skills by constructing the Miniature Models schema independently.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Schemas | ~30m |
| | |
| :flask: | SteelWheels | ~45m |
| :flask: | Basic Model | ~1h 30m |
| :flask: | Standard Model | ~1h 15m |
{% endstep %}
{% step %}
### :diagram-project: Extend Model
`1 reading · 2 workshops · ~2h 20m`
Take a basic cube to production grade: shared time dimensions, geographic annotations for maps, member properties, degenerate dimensions, and calculated members (UnitPrice, Top 10 Customers) that embed business logic in the semantic layer.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Extend Model | ~20m |
| | |
| :flask: | Extended Model | ~1h 30m |
| :flask: | Calculations | ~30m |
{% endstep %}
{% step %}
### :code: MDX Query
`1 reading · 2 workshops · ~1h 10m`
Query cubes directly with MDX to validate and troubleshoot your schemas — SELECT / FROM / WHERE, axes vs. slicers, member references — then centralise reusable member collections with Named Sets.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of MDX Query | ~15m |
| | |
| :flask: | MDX Query | ~25m |
| :flask: | Named Sets | ~30m |
{% endstep %}
{% step %}
### :lock: Data Security
`1 reading · 1 workshop · ~2h 30m`
Lock cubes down with Mondrian's role-based security: roles and role mappers, then the grant hierarchy (Schema, Cube, Hierarchy, Member) and rollup policies, applied hands-on as four progressively restrictive roles on the Miniature Models schema.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Data Security | ~30m |
| | |
| :flask: | Mondrian Security | ~2h |
{% endstep %}
{% step %}
### :language: Localization
`1 reading · 1 workshop · ~1h 20m`
Serve a global audience from a single schema. Tokenize the Classic Models schema, deploy English and French property files, and configure Mondrian's dynamic schema processor so cubes translate automatically by user locale.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Localization | ~20m |
| | |
| :flask: | FR Localization | ~1h |
{% endstep %}
{% step %}
### :gauge-high: Performance
`1 workshop · ~45m`
Speed up the cube with aggregate tables: build two pre-computed roll-ups from ORDERFACT, switch Mondrian's aggregate matching on, declare them with AggName in the schema, and prove from the generated SQL that queries hit the small tables.
See the full breakdown
| Lesson | Time |
|---|
| :flask: | Aggregate Tables | ~45m |
{% endstep %}
{% endstepper %}
{% endtab %}
{% tab title="2 · Metadata Editor" %}
Hands-on workshop for the BI Developer. Build business-friendly semantic models with Pentaho Metadata Editor — physical layer, business models, relationships, business views, properties, reusable concepts, and security — then publish XMI domains for ad-hoc Interactive Reporting.
13 lessons · 6 modules · ~9h 15m
| Module | Reading | Workshops | Time |
|---|
| Getting Started | 2 | — | ~35m |
| Domains & Models | 1 | 3 | ~2h 50m |
| Properties | 1 | 1 | ~55m |
| Concepts | 1 | 1 | ~1h 20m |
| Security & Data Access | 1 | 1 | ~1h 35m |
| Capstone Project | — | 1 | ~2h |
| Total | 6 | 7 | ~9h 15m |
{% stepper %}
{% step %}
### :rocket: Getting Started
`2 readings · ~35m`
Meet Pentaho Metadata Editor (PME) and the metadata domain — the physical layer and business model layer that turn raw database tables into a business-friendly semantic layer for ad-hoc reporting.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Before You Start | ~25m |
| :file-lines: | Components | ~10m |
{% endstep %}
{% step %}
### :sitemap: Domains & Models
`1 reading · 3 workshops · ~2h 50m`
The anatomy of a metadata domain, then three guided builds against the SteelWheels SampleData: explore the prebuilt SteelWheels domain, build the OrdersME star-schema domain from scratch, and assemble queries with the Query Builder.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Domains & Models | ~20m |
| | |
| :flask: | SteelWheels | ~45m |
| :flask: | OrdersME | ~1h 30m |
| :flask: | Query Builder | ~15m |
{% endstep %}
{% step %}
### :sliders: Properties
`1 reading · 1 workshop · ~55m`
Enrich the business model: business tables, columns, and relationships, plus the metadata properties (friendly names, formats, aggregation) that inherit from physical → business → view. Built on the OrderStarCustomer domain.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Properties | ~10m |
| | |
| :flask: | OrderStarCustomer | ~45m |
{% endstep %}
{% step %}
### :tags: Concepts
`1 reading · 1 workshop · ~1h 20m`
Define reusable metadata Concepts (Number, Currency, ID, Hidden, Date) once in the Concept Editor and apply them across columns so formatting and behaviour stay consistent — then validate in an Interactive Report.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Concepts | ~20m |
| | |
| :flask: | Concept Editor | ~1h |
{% endstep %}
{% step %}
### :shield-halved: Security & Data Access
`1 reading · 1 workshop · ~1h 35m`
Lock the model down with metadata security and row-level data constraints, so different roles see different rows and columns from the same published domain.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Security & Data Access | ~20m |
| | |
| :flask: | Row-Level Security | ~1h 15m |
{% endstep %}
{% step %}
### :trophy: Capstone Project
`1 workshop · ~2h`
Put it together end-to-end: model Trailhead Outfitters' MySQL sales database from an empty domain to a published, secured data source, and prove it with three users in Interactive Reports.
See the full breakdown
| Lesson | Time |
|---|
| :flask: | Capstone: Trailhead Outfitters | ~2h |
{% endstep %}
{% endstepper %}
{% endtab %}
{% tab title="3 · Report Designer" %}
Hands-on workshop for Pentaho Report Designer: data sources, report elements and groups, calculations, formatting, parameters, charts, sub-reports, and publishing to the BA repository.
38 lessons · 11 modules · ~14h 05m
| Module | Reading | Workshops | Time |
|---|
| Before You Start | — | 1 | ~20m |
| Navigating Report Designer | 1 | 1 | ~1h 10m |
| Data Sources & Queries | 1 | 1 | ~35m |
| Report Elements & Groups | 1 | 2 | ~55m |
| Calculations | 1 | 3 | ~1h |
| Formatting the Report | 1 | 3 | ~50m |
| Report Parameters | 1 | 2 | ~45m |
| Charts & Sub Reports | 1 | 4 | ~1h 30m |
| Publishing Reports | 1 | 3 | ~1h |
| Capstone Project | — | 1 | ~30m |
| Reference | 9 | — | ~5h 30m |
| Total | 17 | 21 | ~14h 05m |
{% stepper %}
{% step %}
### :rocket: Before You Start
`1 workshop · ~20m`
How to get the best from this lab guide — read this five-minute orientation before you begin the course.
See the full breakdown
| Lesson | Time |
|---|
| :flask: | Before You Start | ~20m |
{% endstep %}
{% step %}
### :compass: Navigating Report Designer
`1 reading · 1 workshop · ~1h 10m`
Tour the Report Designer workspace: welcome screen, toolbars, tabs, palettes, and previewing sample reports.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Report Designer | ~10m |
| | |
| :flask: | Navigating Report Designer | ~1h |
{% endstep %}
{% step %}
### :database: Data Sources & Queries
`1 reading · 1 workshop · ~35m`
Connect Report Designer to your data: JDBC connections, queries, and the data sets that drive every report.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Data Sources & Queries | ~20m |
| | |
| :flask: | Connect to a JDBC Data Source | ~15m |
{% endstep %}
{% step %}
### :table: Report Elements & Groups
`1 reading · 2 workshops · ~55m`
Lay out data elements on the canvas and group rows into report sections with headers and footers.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Report Elements & Groups | ~15m |
| | |
| :flask: | Adding Data Elements and Report Groups | ~20m |
| :flask: | Practice: Data Elements and Report Groups | ~20m |
{% endstep %}
{% step %}
### :calculator: Calculations
`1 reading · 3 workshops · ~1h`
Add formulas and functions to reports: conditional formatting driven by data, and group / report totals.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Calculations | ~15m |
| | |
| :flask: | Conditional Formatting | ~15m |
| :flask: | Totals | ~10m |
| :flask: | Practice: Calculations | ~20m |
{% endstep %}
{% step %}
### :paintbrush: Formatting the Report
`1 reading · 3 workshops · ~50m`
Polish the report: headers, footers, fonts, spacing, and the visual details that make reports read well.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Report Formatting | ~10m |
| | |
| :flask: | Formatting Report Headers & Footers | ~15m |
| :flask: | Formatting the Report | ~15m |
| :flask: | Practice: Formatting | ~10m |
{% endstep %}
{% step %}
### :sliders: Report Parameters
`1 reading · 2 workshops · ~45m`
Let report users filter at run time with parameters — prompts, defaults, and parameter-driven queries.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Report Parameters | ~10m |
| | |
| :flask: | Report Parameters | ~15m |
| :flask: | Practice: Parameters | ~20m |
{% endstep %}
{% step %}
### :chart-column: Charts & Sub Reports
`1 reading · 4 workshops · ~1h 30m`
Visualise data with charts, embed sub-reports, and build drill-down interactions between them.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Charts & Sub Reports | ~15m |
| | |
| :flask: | Charts & Sub Reports | ~15m |
| :flask: | Drilldown Charts | ~15m |
| :flask: | Multiple Sub Reports | ~15m |
| :flask: | Practice: Charts & Sub Reports | ~30m |
{% endstep %}
{% step %}
### :cloud-arrow-up: Publishing Reports
`1 reading · 3 workshops · ~1h`
Publish finished reports to the BA repository and link reports together with hyperlinks.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Publishing | ~10m |
| | |
| :flask: | Publishing Reports | ~20m |
| :flask: | Hyperlinks | ~15m |
| :flask: | Practice: Publishing | ~15m |
{% endstep %}
{% step %}
### :trophy: Capstone Project
`1 workshop · ~30m`
Build, chart, parameterise, and publish a management-ready regional sales report — every module in one project.
See the full breakdown
| Lesson | Time |
|---|
| :flask: | Regional Sales Report | ~30m |
{% endstep %}
{% step %}
### :book: Reference
`9 readings · ~5h 30m`
Appendices from the course manual: data sources, chart types, environment variables, and report templates.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Data Sources Reference | ~1h |
| :file-lines: | Charts Reference | ~1h |
| :file-lines: | Environment Variables Reference | ~50m |
| :file-lines: | Report Templates Reference | ~25m |
| :file-lines: | Report Functions Reference | ~30m |
| :file-lines: | Common Formulas Reference | ~25m |
| :file-lines: | Style Properties Reference | ~35m |
| :file-lines: | Output Parameterization Reference | ~25m |
| :file-lines: | Course Files | ~20m |
{% endstep %}
{% endstepper %}
{% endtab %}
{% tab title="4 · CTools" %}
Hands-on workshop for the dashboard BI Developer. Build interactive Pentaho Community Tools (CTools) dashboards in the Pentaho User Console — Community Data Access (CDA), the Community Dashboard Framework (CDF), the Community Dashboard Editor (CDE) with CCC charts, and the Community Graphics Generator (CGG).
16 lessons · 6 modules · ~7h 55m
| Module | Reading | Workshops | Time |
|---|
| Getting Started | 2 | 2 | ~1h 50m |
| Community Data Access | 1 | 2 | ~1h 25m |
| Community Dashboard Framework | 1 | 2 | ~1h 20m |
| Community Dashboard Editor | 2 | 1 | ~2h 05m |
| Community Graphics Generator | 1 | 1 | ~30m |
| Use Cases | — | 1 | ~45m |
| Total | 7 | 9 | ~7h 55m |
{% stepper %}
{% step %}
### :rocket: Getting Started
`2 readings · 2 workshops · ~1h 50m`
Meet the CTools stack — CDA, CDF, CDE, CCC, and CGG — installed on top of the Pentaho Server. Enable the CDE/CDA plugins, then build your first dashboard to see how the pieces fit together.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Before You Start | ~25m |
| :file-lines: | Getting Started | ~25m |
| | |
| :flask: | First Steps | ~30m |
| :flask: | My First Dashboard | ~30m |
{% endstep %}
{% step %}
### :database: Community Data Access
`1 reading · 2 workshops · ~1h 25m`
CDA is the data layer for CTools dashboards: a single abstraction over many sources with parameter-driven queries, joins/unions, preview, and exports. Create CDA data sources and feed them to dashboard components.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Community Data Access | ~15m |
| | |
| :flask: | Creating a CDA | ~45m |
| :flask: | CDA Data Sources | ~25m |
{% endstep %}
{% step %}
### :cubes: Community Dashboard Framework
`1 reading · 2 workshops · ~1h 20m`
CDF is the code-first dashboard framework — HTML/CSS/JavaScript with managed component and dashboard lifecycles. Understand the framework that CDE is built on by assembling CDF dashboards directly.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Community Dashboard Framework | ~20m |
| | |
| :flask: | CDF Dashboard | ~30m |
| :flask: | CDF Dashboards | ~30m |
{% endstep %}
{% step %}
### :pen-ruler: Community Dashboard Editor
`2 readings · 1 workshop · ~2h 05m`
CDE is the graphical dashboard editor: a Layout / Components / Data Sources workflow over the CDF framework. Build the Carrier Dashboard with responsive Bootstrap layouts, CCC charts, parameters, and selectors — no hand-coding required.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Community Dashboard Editor | ~10m |
| :file-lines: | UI Overview | ~25m |
| | |
| :flask: | Carrier Dashboard | ~1h 30m |
{% endstep %}
{% step %}
### :chart-pie: Community Graphics Generator
`1 reading · 1 workshop · ~30m`
CGG renders CCC charts server-side as images — for reports, for browsers with limited SVG support, and via URL. Generate the Carrier Dashboard's charts with CGG.
See the full breakdown
| Lesson | Time |
|---|
| :file-lines: | Overview of Community Graphics Generator | ~10m |
| | |
| :flask: | Carrier Dashboard Charts | ~20m |
{% endstep %}
{% step %}
### :database: Use Cases
`1 workshop · ~45m`
Put it together end-to-end: build a complete Retail Sales analysis dashboard that combines CDA data sources, CDE layout and components, and CCC charts.
See the full breakdown
| Lesson | Time |
|---|
| :flask: | Sales Analysis Dashboard | ~45m |
{% endstep %}
{% endstepper %}
{% endtab %}
{% endtabs %}
***
{% columns %}
{% column %}
{% hint style="warning" icon="file-certificate" %}
**Course accreditation**
Course accreditation applies to Levels 1 and 2. Each of the four courses has its own exam embedded in its guide (an 80% pass mark — REPLACE-ME: confirm how many attempts a learner gets). Finish the lessons and workshops and pass it, and you'll automatically be able to download your course accreditation. It states your name, the course, and the Pentaho version you studied against. Unlike certification, this exam is self-paced and not proctored.
{% endhint %}
{% endcolumn %}
{% column %}
{% hint style="warning" icon="award" %}
**Certification**
Certification is only available at Level 3 — Certified — not this level. It's a separate, proctored credential that organisations look for when engaging Pentaho consultants: the more advanced courses feed into it, the capstone project is peer reviewed by the Pentaho team, and the exam itself is proctored — unlike the embedded exam for course accreditation.
{% endhint %}
{% endcolumn %}
{% endcolumns %}
***
Back to the Business Analytics path
---
# 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/business-analytics-path-sandbox/business-analytics/level-2-associate.md?ask=&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.