Overview of Pentaho Business Analytics
This training helps you develop knowledge and skills for the most effective use of the Pentaho.
- Please find below the objectives of this session:
- Understanding of Pentaho User Server and Console
- Configuring your BA Server Instance
- Defining BA Server Data Sources
- Creating Reports Using Pentaho Interactive Reporting
- Creating Reports Using Pentaho Report Designer
- Creating Analysis Reports
- Creating Dashboards
- Working with Pentaho Mobile BI
- Customize Pentaho BA to Meet Your Business Needs
Duration
5 Days
Prerequisite for Pentaho Business Analytics
No Prior knowledge is required to use Pentaho BI Suite.
Course Outline for Pentaho Business Analytics
Pentaho User Console
- Adding content to favorites
- Creating a new solution folder
- Renaming a solutions folder
- Showing basic folder properties
- Uploading content to a solution folder
Configuring Your BA Server Instance
- Accessing the Administration perspective
- Creating a new user
- Creating a new role
- Managing system roles
- Configuring authentication through the LDAP server
- Managing the mail server configuration
- Scheduling the cleanup of aged generated files
Defining BA Server Data Sources
- Creating a new native JDBC data source
- Creating a new JNDI JDBC data source
- Updating an existing JDBC data source
- Creating a new analysis data source
- Build a new data-source from a CSV file by using wizard
Defining Business Models with the Pentaho Metadata Editor
- Using a JNDI connection for development
- Managing JDBC database connections
- Defining the physical layer
- Defining concepts
- Deriving business models from the physical layer
- Adding new calculated columns to model entities
- Defining joins between business tables entities
- Creating business view categories
- Testing metadata layer results
- Applying security to the domain model elements
- Publishing metadata definitions to BA Server
Pentaho Reporting
- Creating Reports Using Pentaho Interactive Reporting
- Creating a simple interactive report
- Editing an existing report
- Adding groups and totals to reports
- Changing the labels in an interactive report
- Adding filters to limit a reports output
- Adding prompts to get user input
- Export reports in the Excel or PDF format
Creating Reports Using Pentaho Report Designer
- Configuring JNDI connections for development
- Managing JDBC connections
- Managing ETL connections
- Using layouts to simplify report development
- Using style sheets to constantly manage fields formats
- Changing field properties at runtime with formulas
- Using input parameters
- Using groups to define report aggregations
- Using functions to add calculated fields
- Using subreports to embed content
- Embedding microcharts in reports with sparklines
- Adding charts to our report
Creating Analysis Reports
- Creating and publishing a Mondrian schema
- Creating a new analysis report from scratch
- Adding subtotals to rows categories
- Adding graphical indicators to tables cells
- Adding a simple calculated measure
- Creating visualizations with Pentaho Analyzer
- Export reports in the Excel or PDF format
Creating Dashboards
- Creating a simple dashboard from scratch
- Adding prompts to get user input
- Creating a multiple-content dashboard
- Linking different content and enabling interaction
- Creating dashboards using CDE
Scheduling Content
- Scheduling task execution
- Updating schedule properties
- Deleting schedules
- Executing a scheduled task ahead of time
- Filtering schedules in the schedule entries list
- Running users tasks in the background
- Checking schedule execution
- Stopping running executions
- Preventing the creation of schedules by content
- Working with Pentaho Mobile BI
- Accessing BA server from a mobile device
- Accessing folders and files
- Adding files to favorites
- Changing the default startup screen
Customizing Pentaho BA to Meet Your Business Needs
- Add a company logo to the Pentaho UserConsole login page
- Using themes to customize Pentaho User Console
- Adding new languages to Pentaho User Console
- Check Pentaho Business Analytics Server-logs from Pentaho
UserConsole
- Easily managing content in Pentaho Solution
Customer Specific Topics
- Features of Pentaho version 8.1
- Pentaho and Hadoop Framework Fundamentals
- Upgrading to latest Version of Pentaho
- Integration with Hadoop HDFS and NOSQL MongoDB
- Big Data Steps
- Map Reduce – Mappings
- Concepts of JVM