snippet-of-schedule.yml

# http://2009.foss4g.org/schedule.yml
workshops:
  workshop_01:
    title: "Geospatial BI with FOSS: an introduction to GeoMondrian and Spatialytics"
    user: Advanced User
    presenters:
      1: presenter_01 # Thierry Badard 
      2: presenter_02 # Etienne Dubé
    short_description:
      'This workshop offers a practical introduction to two new Open Source projects in the Geospatial Business Intelligence field: GeoMondrian, a Spatial OLAP server based on Mondrian (Pentaho Analysis Services), and Spatialytics, a web-mapping client for building Geo BI solutions (dashboards and web Spatial OLAP clients) based on OpenLayers.'
    description:
      'Open Source Business Intelligence (BI) software has begun permeating the market thanks to offers from companies such as Pentaho, Jaspersoft, Talend and Spago Solutions. Geospatial BI, combining GIS and BI technologies, has 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, Online Analytical Processing (OLAP) and data mining. It is in this perspective that we, the GeoSOA Research Group at Laval University, started to work on integrating geospatial functionality in existing open source BI software. This has led to the release of GeoKettle, a spatial ETL tool based on Pentaho Data Integration (Kettle) and targeted for analytic data warehousing, and more recently GeoMondrian, a Spatial OLAP server which extends the open source Mondrian OLAP server with GIS data types and functions. On the client side, Spatialytics has been developed, initially during a Google Summer of Code project mentored by Dr. Thierry Badard under the umbrella of the OSGeo and later as part of works within our research group. Spatialytics provides a client visualization component for Spatial OLAP data, using GeoMondrian as a data source and OpenLayers as the web mapping front-end. It enables the creation of drillable, interactive thematic maps based on multidimensional OLAP cubes and can be embedded in Geo BI web applications such as geo-analytical dashboards.
      This workshop proposes a practical introduction to GeoMondrian and Spatialytics. A short intro to the fundamental concepts of data warehousing and OLAP will be part of the program, so deep knowledge of this field is not required to participate. From an already constructed spatial data warehouse, the attendees will learn how to build a cube schema, which is a relational-to-multidimensional mapping used by Mondrian (and by extension GeoMondrian) for querying the relational data warehouse (in SQL) by the means of multidimensional MDX queries. The users will then have a chance to issue simple queries on this cube, with focus given on the geospatial extensions to MDX offered by GeoMondrian. Finally, the attendees will experiment with Spatialytics, for the visualization of the cube’s data using its spatial dimensions. This will also demonstrate its integration in the familiar OpenLayers web mapping client, with easy to use navigation widgets for drilling across the cube’s hierarchical presentation of data and configurable choice of thematic mapping styles. At the end, the attendees should have a working knowledge of GeoMondrian and Spatialytics, in order to build rich Geo BI applications.'
    user_prerequisites:
      'Good knowledge of SQL and Simple Feature for SQL geospatial extensions (e.g. PostGIS)
      Basic knowledge of OpenLayers
      Knowledge of data warehousing and OLAP (MDX language) is an asset but is not required'
    room: G04
    capacity: 120
    start_time: 2009-10-20 09:00 +11
    end_time: 2009-10-20 12:00 +11
    
  workshop_02:
    title: Getting Started with MapServer
    user: Beginner User
    presenters:
      1: presenter_03 # Jeff McKenna
      2: presenter_04 # Tyler Mitchell 
      3: presenter_05 # Pericles Nacionales 
...