With the recent release of Pentaho’s BI Server 3.5.2 and Tom Barber’s (aka magicaltrout) post I thought I would put together a quick tutorial on how to use a new feature of 3.5.2 which allows end users to email reports directly from the Pentaho User Console (PUC).
Emailing Reports from the Pentaho User Console.
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
Customising the Pentaho User Console – Part 3.
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 3 of the series “Customising the Pentaho User Console (PUC)” Version 3.5.x. Here is a list of what I have covered in other parts:
- Login page and dialog
- Messages
- Main toolbar, menu bar and logo panel (covered in this post)
- Launch page
In this post I will show you how to customise the main-toolbar, menu-bar, logo-panel and other features for the PUC.
Creating Cascade Parameters with Pentaho Report Designer 3.5.
Posted under Open Source, Pentaho, Report Designer, Tutorials
Cascade parameters provide a way of managing large amounts of data in reports. You can define a set of related parameters so that the list of values for one parameter depends on the value chosen in another parameter.
In this example I will be using the Steel Wheels sample data to create a report which will display a list of customers using two parameters: a drop down parameter which will contain a distinct list of countries which will then filter another drop down parameter which contains cities which belong to the country.
Customising the Pentaho User Console – Part 2.
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 2 of the series “Customising the Pentaho User Console (PUC)” Version 3.5.x. Here is a list of what I have covered in other parts:
- Login page and dialog
- Messages (covered in this post)
- Main toolbar, menu bar and logo panel
- Launch page
In this post I will show you how to customise messages for the login dialog and PUC.
Customising the Pentaho User Console – Part 1.
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
For the past couple of weeks I have been playing around with customising the Pentaho User Console (PUC) Version 3.5.x and to follow it up I thought I would put together a multi-part post on the topic. Each post will cover one aspect of customising the PUC, these include:
- Login page and dialog (covered in this post)
- Messages
- Main toolbar, menu bar and logo panel
- Launch page
In this post I will show you how to customise the default login dialog and how to create a new login page.
Free Tools to Create Sparklines.
Posted under Open Source, Pentaho, Visualisation
Sparklines are an invention by Edward Tufte and are a great way to provide a bare-bones and space efficient time-series context for measures (Few, Stephen. 2006. Information Dashboard Design). If you would like to read more up on Sparklines I suggest you get Edward Tuftes book Beautiful Evidence – there is a whole chapter dedicated to Sparklines.
Below is a list of open source and free tools which support or are dedicated to creating Sparklines or Microcharts.
VisualPlace – A Victorian Government Map Mashup.
Posted under News, Visualisation
In December 2009 the Victorian Government released a “proof of concept” mashup with demographic and government services data known as VisualPlace.
VisualPlace is a six month Proof of Concept testing innovative ways of capturing, exploring and visualising government information and services through maps. VisualPlace brings together information from a wide variety of sources from service locations to demographic data to allow you to create custom maps.
Parameter Types with Pentaho Report Designer 3.5.
Posted under Open Source, Pentaho, Report Designer, Tutorials
Pentaho Report Designer 3.5 came with nine new pre built parameters. Below is a quick overview of the nine parameters. Each overview includes:
- Screenshot and description
- How to setup your parameter query
- How to setup your report query to accept the parameter
Creating Parameters with Pentaho Report Designer.
Posted under Open Source, Pentaho, Report Designer, Tutorials
With the release of Pentaho Report Designer 3.5 users can create parameters through the designer rather than having to build a xaction which at times could be messy and confusing. Here is a tutorial on how you can create a basic parameter with Pentaho Report Designer 3.5.
If you aren’t already aware Doug Moran (Pentaho’s Community Leader) has already created a set off screen casts showing off features of Pentaho Report Designer 3.5.
Pentaho and the R Project.
Posted under BI Server, Open Source, Pentaho, R
I’m not sure if everyone is aware of this as the recording was released last year but the team at OpenBI have been able to integrate R and Pentaho Business Intelligence Server. The screen cast, which you can view here, was demoed with version 2.0 of the server but I don’t see why it wouldn’t work with version 3.5 (correct me if I’m wrong). The screen cast goes into detail on how the connection between Pentaho and R-Project works and what packages/libraries you will need to get it setup and running.
For those of you who don’t know:
R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS
Along with Weka, R is definitely a tool that I believe all analysts should have handy when performing statistical related tasks.
Enjoy.