Increasing the value of Business Intelligence using Geospatial

® Increasing the value of Business Intelligence using Geospatial Standards George Percivall, Chief Architect and Executive Director of the OGC Interoperability Program, OGC Location Intelligence for Enterprise, June 2012 © 2012 Open Geospatial

Geospatial Business Intelligence (Geo. BI) • Business Intelligence and location – Data Warehouses, Business Analytics, Dashboards, Scorecards. – Typically location treated as a dumb attribute (coded sales zones as opposed to sales zones as geographic boundaries). – BI customers looking to derive business benefit from location data; data discovery and unstructured data. • OGC development of Geo. BI – Applying geospatial interoperability standards to BI technology through the addition of location as an intelligent dimension. – Use OGC standards in BI for improved decision making – Broader use of products that implement OGC standards © 2012 Open Geospatial 2

OGC At A Glance • A non-profit, international voluntary consensus standards organization that is leading the development of standards for geospatial and location based services. • Founded in 1994. • 445 members and growing • 35 implementation standards • Hundreds of product implementations in the market • Broad user community implementation worldwide • Alliances and collaborative activities with ISO and many other SDO’s © 2011, Open Geospatial Consortium 3

Changing Markets for Location Information Figure published in Imaging Notes, Fall 2008 - http:

Location Information in all stages of BI • ETL – Words with geo meaning e. g. , Paris – Explicit coordinates, e. g. , latitude-longitude • OLAP/OLTP – Spatial analysis based on geometric relations Standards critical at each stage for • Interoperability • Extracting maximum value • Reporting – Tabular reports – Visualization, e. g, maps. © 2012 Open Geospatial 5

Location in ETL • Currently processing of location at ETL stage is difficult • Standards allow for more accurate ingest – Addresses and Points of Interest (Po. Is) – Administrative divisions • Increasing support for native spatial data storage in BI databases • Develop support of the spatial component with standards from the (geo)statistical domain (Net. CDF, SDMX, …) • Access to ever growing number of sources of Geo. Info – OGC Web Service Standards for interoperable ETL inputs – OGC GML Simple Feature Access Encoding Standard

Location in OLAP/OLTP • Geo. BI’s worth determined by spatial analytics • Spatial data required for spatial processing – Points, lines, polygons • OGC Standards – SQL Simple Features – Web Processing Service • Develop Geo-MDX with spatial extensions

Spatial OLAP SOLAP “platform for spatio-temporal analysis of multidimensional data with aggregation of cartographic as well as tabulardisplays. ” – Accessible via OGC WPS

Location in Reporting • Traditional BI presents results in reports, or dashboards. • Geo. BI adds maps to this mix. – “decision support services” providing “situational awareness”. – Rich tradition of visualization analysis through maps. • OGC established standards for cartographic maps – OGC Web Map Service – OGC KML Encoding Standard – OGC Styled Layer Descriptor and Symbology Encoding (SLD) • Further actions – Adapt SLD for complex thematic mapping based on OLTP and OLAP data structures – Develop symbol sets and best practices for BI-oriented maps

OGC White Paper on Geo. BI • Authors – Oracle – Spatialytics – 1 Spatial – OGC staff http: //www. opengeospatial. org/pressroom/papers

1 Spatial

Map views in Oracle BI Suite

For Details on OGC Standards… • OGC Standards – Freely available – www. opengeospatial. org/standards • OGC Reference Model (ORM) – Overview of OGC Standards Baseline – Resource for defining architectures for specific applications – www. opengeospatial. org/standards/orm George Percivall, gpercivall at opengeospatial. org Copyright © 2010, Open Geospatial Consortium, Inc.