Pentaho Business Analytics Data Modeling

Код
ВА3000
Продолжительность
2 дн.
Цена
1,280Partners
1,800Customers
О курсе

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
Цель

When you complete this course, you should be able to:

  • Describe the different storage networking architectures
  • Use the Data Source Wizard to create data models from a comma-separated value (CSV) file
  • Use Metadata Editor to create a metadata domain and publish the domain to the Pentaho server
  • Create Metadata Concepts to format elements in a metadata domain
  • Use Metadata Editor’s Query Editor to test metadata models
  • Describe Online Analytic Processing (OLAP), Relational Online Analytic Processing (ROLAP), and Dimensional Modeling
  • Describe the purpose and function of a Mondrian schema
  • Use Schema Workbench to create a basic cube for Pentaho Analyzer
  • Use Schema Workbench to create a star schema with hierarchies, levels, and calculated members
  • Write and execute a basic MDX query to test a Mondrian schema within Schema Workbench
  • Describe how Schema Workbench uses roles to control access to Mondrian schemas
Требуемые знания и навыки

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