Call : (+91) 968636 4243
Mail :

Pentaho Agile BI

( Duration: 1 Day )

With Pentaho Agile Business Intelligence, users can collapse a multi-step and lengthy BI project cycle into a single integrated process, collaborate and iterate easily, and quickly drive to full deployment. By enabling analysts and end-users to rapidly examine, manipulate, model and visualize business data, Agile BI accelerates the discovery of new information and helps organizations establish the value of BI projects before committing to long-term investments.

Using a combination of instructor-led presentations and hands-on exercises, Pentaho Agile BI training course presents Agile BI using the Pentaho unified data integration, data modeling and data visualization development environment.

By attending Pentaho Agile BI workshop, delegates will:

  • Learn how to simplify complex BI implementations using a single design environment that unifies data integration, data modeling, and data visualization
  • Learn enabling seamless collaboration between developers and business users using Agile-enabled tools
  • Use Agile BI to dramatically reduce “time-to-value” and to ease the difficulty of building and deploying Business Intelligence solutions

Attend a training on Pentaho Business Analytics or equivalent knoeledge is recommended. Some knowledge of relational database systems is preferred but it is also not mandatory.

  • Business Analysts
  • Solution Developers



What is Business Intelligence?

  • Business Intelligence defined
  • Why BI projects fail – the problems
  • Abandonment

What is Agile BI?

  • Why should you take an Agile approach?
  • What are the expected benefits?
  • How does Agile BI fit into IT?

Using Pentaho Data Integration to Create an Analytic Environment

  • PDI basics
  • Logging in/ Repository
  • Data Connections
  • What are steps/Drag and Drop
  • Hops – Data Flow
  • Input Steps: CSV, Excel, Flat Files Access
  • Output Steps: CSV, Excel, Table Output
  • Creating a database table from a spreadsheet

Saving the Analytic Environment

  • Logging in and using the Pentaho User Console
  • The workspace
  • Toggle bar

Analyzer Reports

  • Available field pane
  • Types of fields
  • Field panel
  • Types of filters
  • Calculations, totals and sorting
  • Displaying grand totals and subtotals
  • Displaying totals as average, min, and max
  • Creating new calculated fields
  • Charting
  • Help

Ad-Hoc Reporting

  • What is a metadata model
  • Saving a metadata model
  • Using the report wizard
  • Saving the report
  • Scheduling/e-mailing the report

Creating Customized Dashboards

  • The road to production
  • Setting expectations
  • When are you ready for a formal BI project?
  • Earning the right to invest in BI based on demonstrated value
  • What are the required investments? What will they cost?
  • Dimensional modeling
  • Deployment scenarios
  • Hosting / on-premise
  • Staffing scenarios
  • Connectivity
  • Implementing production ETL (server-side PDI)
  • Roles / responsibilities / tasks

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.