Pentaho Business Analytics Data Modeling

Код: BA3000

Продолжительность очно: 2 дн.

Цена: 1,280$ - Partners
1,800$ - Customers

О курсе

This course provides an overview of using Metadata Editor and Schema Workbench to create data models used by Interactive Reporting, Analyzer, and Report Designer. Through a mixture of interactive, instructor-led activities and hands-on exercises, students learn to create metadata models with Metadata Editor, and Mondrian schema (cubes and stars) with Schema Workbench.

Note: The Business Analytics courses do not cover Data Integration or Administration. For more information on Data Integration, see course DI1000 Pentaho Data Integration Fundamentals. For more information on Administration, see course AD1000 Installation and Administration.

Для кого этот курс

Business Analyst
Data Analyst
Pentaho Support

Требуемые знания и навыки

Some knowledge of database design and dimensional modeling is preferred

Приобретаемые навыки

Through a mixture of interactive, instructor-led activities and hands-on exercises, students learn to create metadata models with Metadata Editor, and Mondrian schema (cubes and stars) with Schema Workbench.

Программа

1. Getting Started with Pentaho Business Analytics

Lesson 1 – Introducing Pentaho Business Analytics
Lesson 2 – Navigating the User Console
Lesson 3 – Overview of the Training Data
Guided Demo: Navigating the User Console
Guided Demo: Creating the Training Folder

2. Working with Data Sources in Pentaho

Lesson 1 – Creating a New Data Source
Guided Demo: Creating a New Data Source
Exercise 2-1 – Create Reports Using the New Data Source
Lesson 2: Using Metadata Editor
Guided Demo: Viewing an Existing Metadata Domain
Guided Demo: Creating a Metadata Domain
Guided Demo: Creating a Star Schema Data Source
Lesson 3: Metadata Concepts
Guided Demo: Using Metadata Concepts
Lesson 4 – Metadata Editor’s Query Editor
Guided Demo: Using the Query Editor

3. OLAP/ROLAP and Dimensional Modeling

Lesson 1 – Introduction to OLAP and ROLAP
Lesson 2 – Dimensional Modeling: Cubes and Stars
Lesson 3 – Introduction to Mondrian

4. Using Schema Workbench

Lesson 1 – Introduction to Schema Workbench
Guided Demo: Viewing an Existing Schema
Guided Demo: Viewing the Database with JDBC Explorer
Lesson 2 – Creating a Basic Cube with Schema Workbench
Guided Demo: Creating a Basic Cube
Exercise 4-1 – Create a Basic Cube
Lesson 3: Creating a Star Schema Data Model
Guided Demo: Viewing a Star Schema Data Model
Exercise 4-2 – Create a Star Schema Data Model