Simplifying Enterprise Business Intelligence with Pentaho

Simplifying Enterprise Business Intelligence with Pentaho

We at BizCubed want to provide our clients and people generally with the ability to use and experiment with the Pentaho platform. To accomplish this, we are going to provide a Pentaho environment and database so that people can follow along with our wiki and see their own data on the web!

BizCubed Bling

Examples of cool things that BizCubed has done with the Pentaho applications

• Chronoscope
• NIH — Some cool stuff that we wish we had thought of first! :)

Enterprise Edition

BizCubed Enterprise Edition customers can see our Enterprise Support space for additional documentation pertaining to the Enterprise Edition.

Installing and running Pentaho

• Configure an environment for running the Pentaho server
• Configure an environment for Pentaho development
• Set up environment for the Pentaho OLAP training course?

The Pentaho Suite of Applications

• BI Server
  • BI Platform
  • Troubleshooting BI Server
• GUI tools
  • Design Studio
  • Report Designer (Flow) — default in Pentaho 3.5+
  • Report Designer (Classic) — default prior to Pentaho 3.5
  • Metadata Editor
  • Schema Workbench
  • Data Integration (Kettle)
• Troubleshooting GUI tools
  • Troubleshooting Data Integration

Other parts of Pentaho

• Java
  • Install and Configure Java
• Tomcat
• User Console
• Administration Console
• Mondrian
  • MDX
• Pentaho Analysis Views
  • Pentaho Analysis Viewer (JPivot)
  • Enabling Save and Save As for analysis views
  • Pentaho Analyzer
• Ad-Hoc Reporting
• Security and Authentication
• Action sequences (xaction files)
  • Call Kettle (PDI) from action sequence
  • Add a date picker to your prompts
  • Schedule xaction on the server 3.5.x
• Web Services
• Google Maps dashboards
• Sample Data - How to create sample data on MySQL

Databases

Instructions and tips for working with different kinds of databases.

• Databases
  • Using My SQL
  • Using Oracle
• Converting between databases
• Pentaho on PostgreSQL
• JDBC drivers

Pentaho miscellany

Miscellaneous tips and tricks for Pentaho

• Pentaho logs
• Performance tuning
• Remote access over a network
• Remotely execute actions
• Output formats
• Web browsers
• Global variables
• Bursting
• Emailing and Reporting Subscription
• Java development for Pentaho
• Easy documentation of development
• Dynamic dimension with MDX

Other tools and utilities

• Useful Linux Commands — a quick reference for shell commands
• Reading text files — most useful for reading logs
• ssh
• rsync
• Regular expressions (regex)
• awk — scripting for report design and more
• sed — Unix stream editor to manipulate text files (example of use: replacing values by parameters in sql queries for reporting)
• round down

Other Resources

• Other resources for help on Pentaho or anything related
• Newsletters — receive periodic information about BizCubed and Pentaho
• Web development