Visão Geral

Este Curso Business Intelligence using Pentaho Overview, ensina como desenvolver um painel de Business Intelligence (BI) usando a ferramenta Pentaho BI do zero. Este curso explora os fundamentos da integração do Pentaho Data, criando um OLAP Cube, integrando a suíte Pentaho BI com o Hadoop e muito mais através das melhores práticas. Nosso Curso de Treinamento Online Pentaho também oferece projetos em tempo real para aprimorar suas habilidades e passar com sucesso no exame de certificação Pentaho Data Integration.

Publico Alvo

• Profissionais de Teste
• Analista de Negócios Analista de Dados
• Arquiteto de Soluções
• Arquiteto de Soluções Mainframe 
• Profissionais de BI 
• Programador DW 
• Graduados que desejam construir sua carreira em Business Intelligence & Data Analytics

Pre-Requisitos

• Conceitos básicos de banco de dados
• Conceitos de armazenamento de dados
• conhecimento de qualquer linguagem de programação
• familiaridade básica com termos de TI.

Materiais

Conteúdo Programatico

Introduction to Pentaho Tool

1. Pentaho user console
2. Overview of Pentaho Business Intelligence and Analytics tools
3. Database dimensional modelling
4. Using Star Schema for querying large data sets
5. Understanding fact tables and dimensions tables
6. Snowflake Schema
7. Principles of Slowly Changing Dimensions
8. Knowledge of how high availability is supported for the DI server and BA server
9. Managing Pentaho artifact
10. Knowledge of big data solution architectures

Introduction to Pentaho BI Suite

1. Describe Pentaho
2. Pentaho BI (CE vs. EE)
3. Pentaho Data Integration (PDI)
4. Pentaho Report Designer (PRD)
5. Pentaho Metadata Editor (PME)
6. Pentaho Schema Workbench (PSW)
7. Dashboard Capabilities

Data Architecture

1. Designing data models for reporting
2. Pentaho support for predictive analytics
3. Design a Streamlined Data Refinery (SDR) solution for a client

Clustering in Pentaho

1. Understanding the basics of clustering in Pentaho Data Integration
2. Creating a database connection
3. Moving a CSV file input to table output and Microsoft Excel output
4. Moving from Excel to data grid and log

Pentaho Report Designer - Basic

1. PRD Layout
2. Understanding its Basic Features
3. Designing Basic Report Containing Graphical Chart
4. Conditional Formatting
5. Studying the PRPT File Format
6. Studying the PRPT File Format

Pentaho Report Designer – Advanced

1. Working with Group
2. Group Header
3. Group Footer
4. Data Source Connection
5. Query Designer
6. API Based Reporting

PPentaho Data Integration – Introduction

1. Define Extract, Transform, Load (ETL) Concepts
2. PDI GUI Layout
3. Repository
4. Wizard
5. Marketplace
6. Supported Data Types for Connectivity

Pentaho Data Integration – Transformation

1. What is Transformation?
2. Variable
3. Step
4. Hop
5. Various Input Steps
6. Various Output Steps
7. Transformation Steps
8. Scripting
9. Big Data Steps
10. Integration with Hadoop HDFS and NOSQL MongoDB
11. PDI and Map Reduce

Pentaho Data Integration – Job and More

1. What is PDI-job?
2. Integrating Report
3. Entries
4. Job Orchestration
5. Logging
6. Understanding Repository
7. Database Repository
8. File Based Repository
9. Example with Job Containing Multiple Entries

Pentaho BA Server and USER Console

1. Pentaho Business Analytics
2. User Console Navigation
3. JPivot
4. Analysis Tools
5. Using Data Sources
6. Integrating Report on BI

Security

1. Securing data
2. Integrating user security with other enterprise systems
3. Extending BA server content security
4. Pentaho’s support for multi-tenancy
5. Using Kerberos with Pentaho