Pentaho Analyzer leverages OLAP technology and multi-dimensional query expressions (MDX) to dynamically retrieve data from relational databases (RDBMS). Analyzer is most often used to query data in an organization’s data warehouse, which generally consolidates data from multiple source systems into a common place for information analysis and reporting.
Pentaho Data Integration (PDI) is a popular tool used for building and populating data warehouses and usable data models. PDI can load data from applications, databases, and spreadsheets within your company, as well as from external and public data sources. Tools like PDI are typically managed by your system administrator.