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

GeoSpatial Business Analytics: Better Decisions for Retail Companies with Spatial Data Location Intelligence Empowers analytical capabilities for Italian Healthcare

• Nicola Sandoli

Business Development Manager

• Marco Vignoli

Location Intelligence Expert

@sandolinic

ICONSULTING

INNOVATIVE SPECIALIZED DEVELOPING SKILLS VENDOR INDEPENDENT

2

3

4

1

WHO WE ARE

# Data Warehouse # Business Intelligence # Performance Management

• 300+ projects – 100+ customers
• Professorship in prestigious Italian Universities

and Business Schools

• Spin-off of a Research University Consortium
• 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)
• ISOLDE (Naples - June)

@marco_vignoli

@sandolinic

Silos Point of View

@sandolinic

“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.” What Location Intelligence is ?

Golfarelli, Mantovani, Ravaldi, Rizzi: Lily: A Geo-Enhanced Library for Location Intelligence 15th International Conference, DaWaK 2013, Prague, Czech Republic @marco_vignoli

@sandolinic

Big Data Analytics - Location Intelligence

Crime & Police Healthcare Unstructured Data and Sentiment Analysis Rural Affairs Government Subsidies Traffic & Transportation

Geo-MKT & Territory Potential

Indoor Network of Territory Sensors

@marco_vignoli

@sandolinic

INFORMATION DISCOVERY

LIBRARY

WRITE BACK ACTION SIMULATION PREDICTION REAL TIME

GEO

GEO SPATIAL & TRADITIONAL DATA INTEGRATION GEO PREDICTIVE ALGORITHMS BUSINESS ANALYSIS SOURCES WEB & MOBILE

ENTERPRISE DATAWAREHOUSE

Location Intelligence Framework

@marco_vignoli

@sandolinic

Demo

GeoSpatial Business Analytics: Better Decisions for Retail Companies with Spatial Data 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

• Geomarketing:

http://www.iconsulting.biz/downloads/Business_case_territory_pot_analysis.pdf

• Indoor Analysis:

http://www.iconsulting.biz/downloads/Business_case_indoor_analysis.pdf

@marco_vignoli

@sandolinic

Location Intelligence Architectures

BI FRONT END GIS FRONT END BI SERVER GIS SERVER BRIDGE DWH GIS DB BI FRONT END BI SERVERS DWH SPATIAL DATA GIS DB GEO DWH

@marco_vignoli

@sandolinic

Location Intelligence Architectures

PRESENTATION LAYER Standard report Maps report

(Mapviewer + ISEE)

OBIEE

TSM_ID TSM_DES TME_ ID TME_DE S IMDM_I D IMDM_DE S ROUTE_I D ROUTE_DE S TSM_GEO TME_GEO IMDM_GE O ROUTE_GE O 1 Colchester 11 Colchest er 111 Ipswich 1111 Anglia SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…) 2 Norwich 21 Norwich 111 Ipswich 1111 Anglia SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…) 3 Barking 31 Barking 222 Romford 1111 Anglia SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…) 4 Romford 31 Romford 222 Romford 1111 Anglia SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…) SDO_GEO M(…)

GEOGRAPHIC DIMENSION Geographic Identifiers and Descriptions Geographic shapes

DATA WAREHOUSE LAYER (classic Star Schema)

COST DIMENSION SPEED DIMENSION COST FACT TABLE TRACK GEOMETRY FACT TABLE TIME DIMENSION

@marco_vignoli

@sandolinic

• Nicola Sandoli

Business Development Manager n.sandoli@iconsulting.biz @marco_vignoli

• Marco Vignoli

Location Intelligence Expert m.vignoli@iconsulting.biz