Public Administration: customer outcomes

State Taxation Agency

The debt recovery office of the State agency that administers taxation required a set of standard reports as part of a program to migrate away from a proprietary BI application. A set of 90 customised reports were developed in close consultation with the IT developers. Knowledge was transferred as part of the process to allow the agency to maintain and develop additional reports.

Roles/responsibilities
Analysis, design and development of reports

Business Analytics Platform
BI frontend
Pentaho Enterprise Edition

Datawarehouse
ETL: Oracle Warehouse Builder
RDBMS: Oracle 9.2

Source system
Oracle (custom)

Federal Environmental Protection Agency

The Federal department responsible for policies and programs for the protection and conservation of the environment, including natural and cultural heritage sites needed…

Roles/responsibilities
Analysis, design and development of reports

Business Analytics Platform
BI frontend
Pentaho Enterprise Edition

Datawarehouse
ETL: Oracle Warehouse Builder
RDBMS: Oracle 9.2

Source system
Oracle (custom)