a

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

5 Days

No Prior knowledge is required to use Pentaho BI Suite

  • Adding content to favorites
  • Creating a new solution folder
  • Renaming a solutions folder
  • Showing basic folder properties
  • Uploading content to a solution folder
  • 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
  • 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
  • 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
  • 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
  • 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 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 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 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
  • 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
  • Easily managing content in Pentaho Solution
  • 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