# Data Integration and Analytics design tools

Use Pentaho design tools to develop and refine how your data values are reported, modeled, transformed, and stored.

These tools include:

* **Pentaho Data Integration (PDI)**

  Provides access to an Extraction, Transformation, and Loading (ETL) engine that captures the right data, cleanses the data, and stores data using a uniform format that is accessible and relevant to end users and IoT technologies.
* **Report Designer**

  Generate detailed, pixel-perfect reports using virtually any data source. It enables business intelligence professionals to create highly detailed, print-quality reports based on adequately prepared data.
* **Aggregation Designer**

  Provides a simple interface that allows you to create aggregate tables from levels within the dimensions you specify. Use this tool to improve the performance of your Pentaho Analysis (Mondrian) OLAP cubes.
* **Metadata Editor**

  Simplifies report building. Use the Metadata Editor to build Pentaho metadata domains and models. A Pentaho Metadata Model maps the physical structure of your database into a logical business model.
* **Schema Workbench**

  Edit and create multidimensional (Mondrian) models. You can create Mondrian models graphically or define them by hand-coding XML files.