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