Using Pentaho Business Analytics II

Training Course

Using Pentaho Business Analytics II provides an overview of using Schema Workbench and teaches additional reporting capabilities of Pentaho Report Designer. Through a mixture of interactive, instructor-led activities and hands-on, self-paced exercises, students learn to create cubes and star schemas using Pentaho Schema Workbench, and additional features of Pentaho Report Designer, such as creating report templates, creating drillable charts, using Pentaho Data Integration as a data source, and using resource files. This course helps prepare you for the Pentaho Data Integration Certification Exam.

Back to Courses

Course Placement

Before taking this class, students should complete course SLN4000 – Using Pentaho Business Analytics I or have equivalent field experience with Pentaho Business Analytics. Some basic knowledge of desktop operating systems such as Microsoft Windows or Ubuntu Linux is required. Some knowledge of database design and dimensional modeling is preferred.

Id: SLN6000
Level: Introductory
Audience: Business Analyst, Solution Developer
Delivery Method: Instructor-led online, Private on-site, Public classroom
Duration: 2 Day(s)
Cost: $1,300.00 USD
Credits: 2
Category: Solutions

Course Availability

No upcoming classes available at this time

Course Benefits

  • Improve productivity by giving your Business Intelligence team the skills they need to succeed with Pentaho Business Analytics
  • Speed time-to-market and reduce project failure rates by providing your report designers and content developers with the ability to quickly create compelling reports and dashboards using the Pentaho suite
  • Reduce your project costs and secure a return on your investment by providing your content creators with reporting best practices and techniques for minimizing maintenance and increasing the speed of content creation
  • 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:

  • Describe Online Analytic Processing (OLAP), Relational Online Analytic Processing (ROLAP), and Dimensional Modeling
  • Use Pentaho Schema Workbench to create a basic cube for Pentaho Analyzer
  • Use Pentaho Schema Workbench to create a star schema with hierarchies, levels, and calculated members
  • Describe how aggregate tables can improve schema performance
  • Create a report template with Pentaho Report Designer and deploy the template for use in Pentaho Interactive Reporting
  • Create a chart with drill-down capabilities using Pentaho Report Designer
  • Use Pentaho Data Integration as a data source in Pentaho Report Designer
  • Use resource files and localize reports in Pentaho Report Designer
  • Create a report with multiple sub-reports in Pentaho Report Designer

Before taking this class, students should complete course SLN4000 – Using Pentaho Business Analytics I or have equivalent field experience with Pentaho Business Analytics. Some basic knowledge of desktop operating systems such as Microsoft Windows or Ubuntu Linux is required. 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: OLAP/ROLAP and Dimensional Modeling

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

Module 2: Using Schema Workbench

Lesson 1 – Introduction to Schema Workbench
Lesson 2 – Creating a Basic Cube with Schema Workbench
Exercise 1 – Create a Basic Cube
Lesson 3 – Creating a Star Schema with Schema Workbench
Exercise 2 – Create a Star Schema
Lesson 4 – Adding Hierarchies and Levels
Exercise 3 – Add Hierarchies and Levels to the Schema
Lesson 5 – Adding a Time Dimension
Exercise 5 – Add a Time Dimension to the Schema
Lesson 6 – Creating Calculated Members
Exercise 7 – Create Calculated Members
Lesson 7 – Access Control with Schema Workbench
Lesson 8 – Aggregate Tables

Day 2

Module 3: Advanced Reporting Topics

Lesson 1 – Creating Report Templates in Pentaho Report Designer
Exercise 1 – Create and Deploy a Report Template
Lesson 2 – Working with Charts in Pentaho Report Designer
Exercise 2 – Create a Chart with Drilldown Capabilities
Lesson 3 – Using PDI as a Data Source in Pentaho Report Designer
Exercise 3 – Use PDI as a Data Source in a Report
Lesson 4 – Using Resource Files in Pentaho Report Designer
Exercise 4 – Use Resource Elements in a Report
Lesson 5 – Using Sub-Reports in Pentaho Report Designer
Exercise 5 – Create a Report with Multiple Sub-Reports