pentaho agile BI

By attending Pentaho Agile BI workshop, Participants 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

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.

It is recommended that Participants need some 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

  • 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
  • Why should you take an Agile approach?
  • What are the expected benefits?
  • How does Agile BI fit into IT?
  • Business Intelligence defined
  • Why BI projects fail – the problems
  • Abandonment
  • Logging in and using the Pentaho User Console
  • The workspace
  • Toggle bar
  •  
  • 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
  • What is a metadata model
  • Saving a metadata model
  • Using the report wizard
  • Saving the report
  • Scheduling/e-mailing the report
  • 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