OPEN SOURCE GEOSPATIAL BUSINESS INTELLIGENCE IN ACTION WITH GEOMONDRIAN AND SOLAPLAYERS!
Business Intelligence (BI) applications are efficient and profitable tools to better understand historical, current and future aspects of business operations. As it is commonly recognized that "about 80% of all data stored in corporate databases has a spatial component,” this can be used to enhance the BI user experience with map displays and spatial analysis tools. Some phenomena or trends in the data can moreover be observed and adequately interpreted only if they are represented on a map (e.g. spatial distribution or spatiotemporal evolution of a given phenomenon). Geospatial Business Intelligence (GeoBI), combining GIS and BI technologies, has thus recently stirred marked interest for the huge potential of combining spatial analysis and map visualization with proven BI tools and techniques such as data warehousing (DW), Online Analytical Processing (OLAP), reporting tools, dashboards and data mining.
A complete open source Geo-BI suite is now available and supported at http://www.spatialytics.org. It comprises: 1) GeoKettle, a spatial ETL tool based on Pentaho Data Integration (Kettle) and targeted for geo-analytical data warehousing, 2) GeoMondrian, a Spatial OLAP (SOLAP) server which extends the open source Mondrian OLAP server with GIS data types and functions and 3) SOLAPLayers, a client visualization component for SOLAP data, using GeoExt/OpenLayers as the web mapping front-end. It enables the creation of drillable, interactive thematic maps based on multidimensional SOLAP data cubes and can be embedded in web applications to produce highly customizable and easy-to-use geo-analytical dashboards or reports.
This talk will try to demistify what is GeoBI and to explain what are the benefits that users can expect when using such a set of analytical technologies. It will present and demo both SOLAPLayers and GeoMondrian open source projects through different practical and concrete use cases and examples.
Thierry Badard - Spatialytics