GeoSpatial Business Analytics: Better Decisions for Retail Companies - PowerPoint PPT Presentation

GeoSpatial Business Analytics: Better Decisions for Retail Companies with Spatial Data  Nicola Sandoli Business Development Manager Location Intelligence Empowers analytical capabilities for Italian Healthcare  Marco Vignoli Location Intelligence Expert

ICONSULTING WHO WE ARE  Spin-off of a Research University Consortium  300+ projects – 100+ customers  Professorship in prestigious Italian Universities and Business Schools  2013 : Oracle Spatial and Graph Excellence Award – Washington D.C. (USA)  2014 : - UK Trade & Investment - Market Entrant Awards - GeoSpatial World Forum (Geneva - May) - Location Intelligence Conference (Washington - May) # Data Warehouse - ISOLDE (Naples - June) # Business Intelligence 4 # Performance Management 3 2 1 DEVELOPING @sandolinic VENDOR INNOVATIVE SPECIALIZED SKILLS INDEPENDENT @marco_vignoli

Silos Point of View @sandolinic

What Location Intelligence is ? “Location intelligence is a set of tools and techniques to integrate a geographical dimension into BI platforms, aimed at enhancing their capability of better monitoring and interpreting business events .” Golfarelli, Mantovani, Ravaldi, Rizzi: Lily: A Geo-Enhanced Library for Location Intelligence 15th International Conference, DaWaK 2013, Prague, Czech Republic @sandolinic @marco_vignoli

Big Data Analytics - Location Intelligence Healthcare Traffic & Transportation Crime & Police Indoor Geo-MKT & Unstructured Data and Sentiment Territory Potential Analysis Rural Affairs Government Network of Territory Sensors Subsidies @sandolinic @marco_vignoli

Location Intelligence Framework WEB & MOBILE BUSINESS ANALYSIS INFORMATION WRITE BACK SIMULATION PREDICTION ACTION DISCOVERY LIBRARY ENTERPRISE GEO DATAWAREHOUSE GEO PREDICTIVE REAL TIME ALGORITHMS GEO SPATIAL & TRADITIONAL DATA INTEGRATION SOURCES @sandolinic @marco_vignoli

Demo GeoSpatial Business Analytics: Better Decisions for Retail Companies with Spatial Data  Geomarketing : http://www.iconsulting.biz/downloads/Business_case_territory_pot_analysis.pdf  Indoor Analysis: http://www.iconsulting.biz/downloads/Business_case_indoor_analysis.pdf Location Intelligence Empowers analytical capabilities for Italian Healthcare  Healthcare: http://www.iconsulting.biz/downloads/Business-case_Healthcare.pdf  Location Intelligence: http://www.iconsulting.biz/ic/en/location-intelligence.html @sandolinic @marco_vignoli

Location Intelligence Architectures BI FRONT END BI FRONT END GIS FRONT END BRIDGE BI SERVER GIS SERVER BI SERVERS GIS DB DWH DWH GIS DB GEO DWH SPATIAL DATA @sandolinic @marco_vignoli

Location Intelligence Architectures PRESENTATION LAYER OBIEE Maps report Standard report (Mapviewer + ISEE) DATA WAREHOUSE LAYER (classic Star Schema) G EOGRAPHIC D IMENSION C OST T IME S PEED Geographic Identifiers and Geographic shapes D IMENSION D IMENSION D IMENSION Descriptions TSM_ID TSM_DES TME_ TME_DE IMDM_I IMDM_DE ROUTE_I ROUTE_DE TSM_GEO TME_GEO IMDM_GE ROUTE_GE ID S D S D S O O 1 Colchester 11 Colchest 111 Ipswich 1111 Anglia SDO_GEO SDO_GEO SDO_GEO SDO_GEO er M(…) M(…) M(…) M(…) 2 Norwich 21 Norwich 111 Ipswich 1111 Anglia SDO_GEO SDO_GEO SDO_GEO SDO_GEO M(…) M(…) M(…) M(…) 3 Barking 31 Barking 222 Romford 1111 Anglia SDO_GEO SDO_GEO SDO_GEO SDO_GEO M(…) M(…) M(…) M(…) 4 Romford 31 Romford 222 Romford 1111 Anglia SDO_GEO SDO_GEO SDO_GEO SDO_GEO M(…) M(…) M(…) M(…) C OST F ACT T RACK G EOMETRY T ABLE F ACT T ABLE @sandolinic @marco_vignoli

 Nicola Sandoli Business Development Manager n.sandoli@iconsulting.biz  Marco Vignoli Location Intelligence Expert m.vignoli@iconsulting.biz @sandolinic @marco_vignoli