Pentaho Business Analytics Data Modeling

Course ID : BA3000

Duration In-class (в days) : 2 дн.

Price : 1,280$ - Partners
1,800$ - Customers

Overview

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.

Audience for this course

Business Analyst
Data Analyst
Pentaho Support

Objective

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

Prerequisites for this course

Some knowledge of database design and dimensional modeling is preferred

Outcomes

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.

Outline

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