OpenDash™

Overview

OpenDash™ is a 6-week project that creates a "cradle to grave" pilot data mart implementation using the Pentaho BI platform which includes reporting, OLAP, dashboard and ETL components. It is an excellent project for those wanting to exploit the full breadth of the Pentaho OSBI suite on a quick-win implementation schedule. At project conclusion, you will have a deployed pilot Pentaho application ready for your users. You will also have source code created from OpenBI's best practice application development templates that can be extended to other applications.

Deliverables

End-User Functionality	Dashboards 3 pages of up to 12 embedded analytic components Analytic components Each may be a dial, chart and/or simple report Context-sensitive drilling to OLAP functionality, as appropriate Reports 4 Parameterized Reports Developed with Pentaho Report Designer End-user parameter selection, as appropriate End-user OLAP interface using browser-based JPivot functionality 4 OLAP Views ready for end-user slice-and-dice Pentaho servlet application for end-user report execution and OLAP End-user report management workspaces enabling: Background report execution Subscribable scheduled report execution Historical report instance retrieval User-created OLAP views
Data	Newly designed star schema data mart Up to 2 fact and 10 dimension tables Up to 12 pre-identified, source data tables/files Up to 2 weeks of data analysis to identify data rules for exception identification ETL Up to 15 working transformations and 1 ETL process job Data exceptions will be written to “bad files”
Platform Technologies	Pentaho BI Server JFreeReport: Reports JFreeChart: Charts Pentaho Analysis Services (aka Mondrian/JPivot): ROLAP Server & End-user OLAP tool Pentaho Data Integration (aka Kettle): ETL JBoss Application Server
Look & Feel	Pentaho supplied theme, but layout customized to dashboard design Architecture enables subsequent theme and layout changes
Security	LDAP or MSAD integration for authentication and role authorization