Business Analytics Data Modeling

Onsite Training

For groups of six or more

Request Quote

Public Training

Online EMEA (French language)

Online

Online - EMEA

Fulda

Classes marked with Confirmed are guaranteed to run. Sign up now while there is still space available!


Don't see a date that works for you?

Request Class

Training Course

Business Analytics Data Modeling provides an overview of using Metadata Editor and Schema Workbench to create data models used by Report Designer and Analyzer.

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.

This course helps prepare you for the Pentaho Data Integration Certification Exam.

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

Back to Courses

Description

Id: BA3000
Level: Introductory
Audience: Business Analyst, Data Analyst
Delivery Method: Instructor-led online, Private on-site
Duration: 2 Day(s)
Cost: $1,300.00 USD
Credits: 2
Category: Business Analytics

Duration

2 Days

Upcoming Classes

Mexico

Location Apr 2014 May 2014 Jun 2014 Jul 2014 Aug 2014
Mexico City (Spanish language) May 7 – May 8

Classes in bold are guaranteed to run!

Online

Instructor-led online training

Location Apr 2014 May 2014 Jun 2014 Jul 2014 Aug 2014
Online EMEA (French language) May 7 – May 8
Jun 18 – Jun 19
Online May 8 – May 9
May 22 – May 23
Jun 12 – Jun 13
Online - EMEA May 29 – May 30

Classes in bold are guaranteed to run!

Germany

Location Apr 2014 May 2014 Jun 2014 Jul 2014 Aug 2014
Fulda, (German language) Jul 3 – Jul 4

Classes in bold are guaranteed to run!

Course Benefits

  • Decrease your time-to-market by learning how to build data models for use in Pentaho Business Analytics
  • Equip yourself with best practices and techniques for building data models
  • Interactive, hands-on training materials significantly improve skill development and maximize retention

Skills Achieved

  • At the completion of this course, you should be able to:
  • Use Pentaho Metadata Editor to build metadata models and domains that allow you to create business-language definitions for complex database tables, set security parameters on report data, and control data formatting
  • Describe Online Analytic Processing (OLAP), Relational Online Analytic Processing (ROLAP), and Dimensional Modeling
  • 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
  • Describe how aggregate tables can improve schema performance
  • Use the Data Source Wizard to build data models, and then edit the data models with Metadata Editor and Schema Workbench

This course is the third course in the Business Analytics learning path. Some knowledge of database design and dimensional modeling is preferred.

Completion of BA1000 Business Analytics User Console is required prior to registering for this course.

Some knowledge of database design and dimensional modeling is preferred.

Students attending classroom courses in the United States are provided with a PC to use during class. Students attending courses outside the US should contact the Authorized Training Provider regarding PC requirements for Pentaho courses.

In general, if your training provider requires you to bring a PC to class, it must meet the following requirements. You can also verify your system against the Compatibility Matrix: List of Supported Products topic in the Pentaho InfoCenter:

  • Windows XP, 7 desktop operating system (for Macintosh support, please contact your Customer Success Manager)
  • RAM: at least 4GB
  • Hard drive space: at least 2GB for the software, and more for solution and content files
  • Processor: dual-core AMD64 or Intel EM64T
  • DVD drive

Online courses require a broadband Internet connection, the use of a modern Web browser (such as Microsoft Internet Explorer or Mozilla Firefox), and the ability to connect to the WebEx Training Center. For more information on WebEx Training Center requirements, see www.webex.com. Online courses use Pentaho’s cloud-based exercise environment. Students are provided access to a virtual machine used to complete the exercises.

For online courses, students are provided with a secured, electronic course manual. Printed manuals are not provided for online courses. When an electronic manual is provided, students are encouraged to print the exercise book before class begins, though this is not required.

Students attending this course on-site should contact their Customer Success Manager for hardware and software requirements. You can also email us at training@pentaho.com for more information regarding on-site training requirements.

Day 1

Module 1: Creating Reporting Data Sources with Metadata Editor

Lesson 1: Creating Metadata Domains with Metadata Editor
Lesson 2: Using Metadata Concepts

Module 2: OLAP/ROLAP and Dimensional Modeling

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

Module 3: Creating Analysis Data Sources with Schema Workbench, Part 1

Lesson 1: Introduction to Schema Workbench
Lesson 2: Creating a Basic Cube
Exercise 3-1: Create a Basic Cube

Day 2

Module 4: Creating Analysis Data Sources with Schema Workbench, Part 2

Lesson 1: Creating a Star Schema
Exercise 4-1: Create a Star Schema
Lesson 2: Creating Calculated Members
Exercise 4-2: Create a Calculated Member
Lesson 3: Access Control with Schema Workbench
Lesson 4: Using Aggregate Tables in Schema Workbench

Module 5: Using the Data Source Wizard to Build Data Models

Lesson 1: Using the Data Source Wizard to Build Data Models
Exercise 5-1: Use the Data Source Wizard to Build Data Models
Exercise 5-2: Use Metadata Editor and Schema Workbench to Edit Data Models