Business Analytics Data Modeling

Onsite Training

For groups of six or more

Request Quote

Public Training

Online

1217 Meyrin

Tokyo

Online - APAC

Rome

Fulda

Paris

Classes marked with Full are full and no additional registrations are accepted. If you cannot find another class that suits your schedule, feel free to request a class and we will do our best to accomodate your needs.


Don't see a date that works for you?

Request Class

Business Analytics Data Modeling Ratings

Averaged from 83 responses.

Training Organized
Training Objectives
Training Expectations
Training Curriculum
Training Labs
Training Overall

What do these ratings mean?

Training Course

Business Analytics Data Modeling 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. For more information on Administration, see course 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

Online

Instructor-led online training

Location May 2015 Jun 2015 Jul 2015 Aug 2015 Sep 2015
Online Jun 4 – Jun 5
Jun 25 – Jun 26
Jul 16 – Jul 17
Online - APAC Jun 18 – Jun 19

Classes in bold are guaranteed to run!

Switzerland

Location May 2015 Jun 2015 Jul 2015 Aug 2015 Sep 2015
Geneva (English language) Jun 15 – Jun 16
Aug 3 – Aug 4
Sep 21 – Sep 22

Classes in bold are guaranteed to run!

Japan

Location May 2015 Jun 2015 Jul 2015 Aug 2015 Sep 2015
Tokyo Jun 17 – Jun 18

Classes in bold are guaranteed to run!

Italy

Location May 2015 Jun 2015 Jul 2015 Aug 2015 Sep 2015
Rome (Italian language) Jun 18 – Jun 19

Classes in bold are guaranteed to run!

Germany

Location May 2015 Jun 2015 Jul 2015 Aug 2015 Sep 2015
Fulda (German language) Jun 24 – Jun 25

Classes in bold are guaranteed to run!

France

Location May 2015 Jun 2015 Jul 2015 Aug 2015 Sep 2015
Paris (French language) Jul 13 – Jul 14
Aug 31 – Sep 1

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 the Data Source Wizard to create data models from a comma-separated value (CSV) file
  • 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
  • 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

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 Documentation site.

  • 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
  • USB port

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 GoToTraining. For more information on GoToTraining requirements, see www.gotomeeting.com/online/training. 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: Getting Started with Pentaho Business Analytics

Lesson 1: Introducing Pentaho Business Analytics
Lesson 2: Overview of the Training Data
Lesson 3: Navigating the User Console

Module 2: Working with Data Sources in Pentaho

Lesson 1: Creating a New Data Source
Exercise 2-1: Create Reports Using the New Data Source
Lesson 2: Using Metadata Editor
Lesson 3: Using Metadata Concepts
Lesson 4: Metadata Editor's Query Editor

Module 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

Day 2

Module 4: Using Schema Workbench

Lesson 1: Introduction to Schema Workbench
Lesson 2: Creating a Basic Cube with Schema Workbench
Exercise 4-1: Create a Basic Cube
Lesson 3: Creating a Star Schema Data Model
Exercise 4-2: Create a Star Schema Data Model
Lesson 4: Creating a Calculated Member
Lesson 5: Using MDX Query Mode
Lesson 6: Access Control with Schema Workbench
Lesson 7: Viewing the FoodMart Sample Schema File