EncartaLabs

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, attendees 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

Prior exposure to Pentaho Business Analytics before taking this class, but not mandatory. Some knowledge of relational database systems is preferred but it is also not mandatory.

  • Business Analysts
  • Solution Developers

COURSE AGENDA

1

What is Business Intelligence?

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

What is Agile BI?

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

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
4

Saving the Analytic Environment

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

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
6

Ad-Hoc Reporting

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

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 4,000 Modules 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 http://encartalabs.com/course-catalogue-all.php

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

Top