Kevin Haas

Map Analytics with Javascript and Pentaho

Blog Post created by Kevin Haas Employee on Sep 18, 2017

This post was written by Greg Graham and originally published on Friday, May 19, 2017


We’ve been seeing an increase in customers looking for cost-effective ways to include analytical mapping solutions in their analytical applications. To do this within the Pentaho Business Analysis ecosystem we can develop custom dashboards with the latest Javascript charting libraries, including LeafletJS used by Tableau.  These custom dashboards leverage Pentaho’s robust data services using Community Data Access (CDA) to provide fully interactive and integrated mapping and charting solutions right to your web browser or device.


The following demonstration walks through the use of LeafletJS and JQuery DataTables to create interactive displays of financial and test score data from School Districts in Illinois.  You can also see the demo on Inquidia's site here.

            C:\Users\GregoryGraham\AppData\Local\Microsoft\Windows\INetCache\Content.Word\2017-05-19 10_29_45-School Districts in Illinois 2014.png


The data were gathered from the Illinois State Board of Education and the US Census Bureau and joined using Pentaho Data Integration.  GEOJSon files containing map boundaries of Illinois elementary, secondary and unified school districts were obtained from the US Census Bureau Tigerline system.  Selections in the data table are highlighted in the map, and vice versa.




Additionally, we’ve produced a user-driven charting laboratory in another view that allows the user to make scatterplots of the same data selected in the Data Table on axes chosen by the user.
C:\Users\GregoryGraham\AppData\Local\Microsoft\Windows\INetCache\Content.Word\2017-05-19 10_46_12-School Districts in Illinois 20142.png


This demo presents just of a taste of the integrated mapping, analytics and visualization techniques that we’ve developed through the years.  Integrating them with a mature web BI platform such as Pentaho enables us to deliver cost-effective, geographical analytical applications to our clients that provide a highly-tailored user experience with a robust and scalable data platform.  Drop us a line today to see how we can help you meet your mapping analytics challenges!


See the demo here!