know.bi blog

PCM17 - Business Use Cases Room

Nov 18, 2017 10:24:11 AM / by Bart Maertens

PCM17 - Business Use Cases Room

Read our overview of the Keynotes 

Read our overview of the talks in the Technical room

Using a BI tool to improve the management of health data in Mozambique - Devan Manharlal

Devan Manharlal explaining how Mozambique uses Pentaho to analyze health data

Devan kicked off the talks in the business room by sharing his experiences in building a health data in Mozambique.
Part of the scope of the project was the geographical allocation of e.g. nurses over Mozambique, which poses some specific challenges in a developing country like Mozambique.
The reasons Pentaho was chosen are mainly because the need for 

  • an open source BI platform
  • a Java based platform, since there's local Java expertise
  • support different database engines 
  • investment in usage, not licensing 

The project team faced some specific challenges in the implementation, e.g. people are heavy paper users, therefore all reports (including a 220 page report) need to be printable.  

A couple of issues the team faced during the implementation: 

  • Connectivity
  • Hardware & network maintenance
  • Support
  • Skilled IT staff
  • Training & building capacity

Lessons learned: 

  • Collaboration
  • Transparency: data needs to be as open as possible
  • Creativity matters
  • Data mining or analytics to integrate data

How to gain control over SAP data with Pentaho - Stefan Müller

Stefan Mueller explaining how IT-Novum integrates SAP data with PDI 

Stefan Mueller started his talk with an introduction of IT-Novum as an open source integrator and SAP partner. 

To support their customers in this combination of open source and SAP, IT-Novum created 4 plugins to use SAP data in PDI: 

  • Erp input
  • Erp RFC executor
  • Bw dso input
  • Bw infocube input

All steps support metadata injection. Stefan wasn't clear on whether the steps will end up in the PDI marketplace, but ensured the audience the steps can be supported commercially to the user community. 

Environmental data management and analysis - Kamil Nešetřil

Kamil Nesetril explains how Pentaho is used for hydrogeological analysis

Kamil, who is a researcher at the Technical University of Liberec (Czech Republic) introduced their hydrogreological information system, available at dataearth.cz
To design ground water models, lots of data need to be integrated and analysed. This data comes in both structured and unstructured forms, but always with a strong geographical angle.
The data is loaded into star/snowflake schemas. The project uses the entire Pentaho stack, but because of the nature of the data, are heavy users of the PDI Gis plugins. 

These schemas are then used to perform analytics on e.g. water iron levels, water quality, geographical mappings etc. 

Essent Belgium: Migrating from on-premises Microsoft BI to AWS (cloud-) based Pentaho BI - Bart Maertens

me ;-)

With the NOVA project, Essent Belgium is in the process of migrating the entire software stack from on-premise Microsoft based applications to open source based software in the cloud (AWS). 

I talked about the agile project structure, the as-was and as-is architectures. In the new architecture, DMS and PDI are used to load data from over 10 source systems over landing and logical layers to a Redshift data warehouse. 

From the logical layer, data is split of (Nifi) to an analytics layer, where a team of data scientists build models using R and Spark. 

Let's talk! if you'd like to here more about this project. 

 

 

 

Topics: pentaho, pdi, ctools, pcm17, pcm, community

Bart Maertens

Written by Bart Maertens

I am a principal consultant at know.bi with over 15 years of experience in business intelligence and analytics. I am the founder and proud leader of the know.bi pack.