OpenDash – Pentaho
Get your Pentaho project off the ground
OpenDash™ is a fixed-length project that creates a "cradle to grave" pilot data mart implementation using the Pentaho BI platform. It includes reporting, OLAP, dashboard and ETL components.
This is an ideal project for those seeking to exploit the full breadth of the Pentaho BI suite on a quick-win implementation schedule. At project conclusion, you will have a deployed pilot Pentaho application ready for your users. Deliverables include source code created from OpenBI's best practice application development templates. These templates can be extended to meet additional application requirements.
The following is the presumed scope of a 6-week effort. Many clients tailor components to better suit their pilot’s needs, by adding things like data sources, analytical subject areas, integration of R analytics, and ad-hoc, end-user reportwriting capabilities.
Contact us today to explore whether an OpenDash™ variant is right for you.
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 User Console 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
- Tomcat Application Server
- Pentaho Community Dashboard Framework
|
| 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
|
