[Post] business intelligence system feasibility analysis report: pentaho technology Overview

Business IntelligenceSystem feasibility analysis report:PentahoTechnical Overview 1. Comparison of business intelligence systems: Download(48.72 KB) Bi comparison   Ii. pentahoCommunityTechnology Overview 2.1 resource address All Kit Download: http://sourceforge.net/projects/pentaho/ 2.2 Kettle ETL Solution: Data Integration, suitable for ETL work in various scenarios. It includes several parts: Spoon-design conversion and job integration Development Environment conversion ( Transform Ation, focusing on data processing): Data processing rules (conversion of source and target data ). Job: Flow Control for Multiple conversions and other operations. The carte-job execution engine has built-in tomcat to regularly execute and monitor the job server. Supports incremental extraction and Extraction Using timestamps or incremental tables. Supports multiple data sources, Excel, and various Database Graphical drag and drop, supported Java Script Complex data processing; database management and conversion files to facilitate switching between the test environment and the generation environment (modifying database configurations ). 2.3 bi Server Reports Display Server Bi server (tomcat-based) report portal with built-in tomcat. After you log on to the console, you can access reports with permissions. You can use the admin user to authorize the reports. Bi server console (Bi Server Manager) manages front-end roles and user passwords 2.4 Report Design Studio (Report designer) Create a report using studio, publish to Bi Server 2.5 dashboard community Edition 2.6 WEKA ( Data Mining Solution) 2.7 mordrian OLAP (Multidimensional data analyzer) 2.8 pentahoMetadata Editor ( Metadata Edit) shield underlying business data 3. pentaho community edition vs. Enterprise Edition 3.1 The difference between pentaho Enterprise Edition and Community edition is mainly manifested in dashboard. The charging standard for 3.2 pentaho Enterprise Edition is mainly based on the number of users, and the basic price is around 30 thousand US dollars. Compared with the Community edition, pentaho 3.3 Enterprise Edition provides portal and page layout functions.