OVERVIEW •  Information Discovery and Location Intelligence for Ministry

of Labor –  Measuring the effectiveness of the portal Cliclavoro in

providing services to foster employment among constituents

CHALLENGES / OPPORTUNITIES •  Integration of data from heterogeneous sources: DW, social

networks, web blogs, open data •  Combination between information discovery and geo-analysis

SOLUTIONS •  Endeca Information Discovery 3.1 •  Oracle Spatial and Graph 11g •  Oracle MapViewer 11g •  Oracle DB 11g

RESULTS •  Public administration oriented

•  Finding most popular labor topics depending on the specific geographic area, to enable target-specific initiatives.

•  Finding user opinions on labor initiatives, to improve public services.

•  Analyzing types of activities performed by different user categories (e.g., company, citizen, labor agency) depending on the specific geographic area, to find areas needing support or excellence areas on the contrary

•  Customer oriented •  Discover labor vacancies that fit user needs (e.g,

user location, desired professional qualification, type of labor).

Social Location Intelligence

May 2014 Oracle Spatial Summit

May 21, 2014 Walter E. Washington Convention Center

Washington, DC USA

Elisa Turricchia Business Intelligence Specialist

Social Location Intelligence Information Discovery meets Location Intelligence for Ministry of Labor

Program Agenda

• Who is Iconsulting •  Social Location Intelligence: Live Demo •  Social Location Intelligence: The solution • Q&A

Program Agenda

• Who is Iconsulting •  Social Location Intelligence: Live Demo •  Social Location Intelligence: The solution • Q&A

Iconsulting Independent consulting company specialized in DWH, BI & PM

Strong expertise on all the market leading technologies

More than 300 projects; more than 100 customers

Professorship in main Italian Universities and Business Schools

In-house Academy providing education services to professionals who need to develop their skills

Spin-off of a major Research University Consortium

25% of our time invested in R&D

Certified Partner of the main Business Intelligence software vendors

# Data Warehouse # Business Intelligence # Performance Management

INNOVATIVE   SPECIALIZED  DEVELOPING    

SKILLS  VENDOR  

INDEPENDENT  

2 3 4 1

Iconsulting Our core business

Business Intelligence

Turning data into Information

Historicize and Organize Information Facilitating access to information

Evolution Trends (Big Data)

+ end users + informations + performance

Analytics and

Business Intelligence  

Mobile Technologies

Cloud Computing

Collaboration Technologies

Connect analysis to Action

Analyze data in Real Time

Self-service BI

Advanced visualization (mapping, etc.)

New data type (unstructured data / text)

Information Discovery on Big Data

New channels of access (Mobile)

Collaboration & Social

Iconsulting Our solutions – Public administration

• Crime Analysis • Health Service Analysis •  Job Offers/Application Analysis •  Education Services Analysis •  Traffic & Road System • Network of Territory Sensors • Rural Affairs Government Subsidies

Iconsulting Our solutions – Private sector

•  Store Performance & Territory Potential Analysis •  Indoor Analysis •  Financial Services Performance Analysis •  Automotive Dealer Performance Analysis

Social Location Intelligence

Ministry of Labor Measure the effectiveness of the portal to foster employment

• Quantative and qualitative analysis

•  Information Discovery

• Location analysis

Goal

•  Visitor segmentation based on their requested services and geographic location

•  Trend topic discovery

Social Location Intelligence Needs

•  Integration of DW information, open data and semi-structured data

• Crawling from social networks (e.g., Facebook) and web blogs

• User localization

Social Location Intelligence Requirements

•  Endeca Information Discovery 3.1

• Oracle Spatial and Graph 11g

• Oracle MapViewer 11g

• Oracle DB 11g

Social Location Intelligence Technology

D E M O N S T R A T I O N

Social Location Intelligence

Program Agenda

• Who is Iconsulting •  Social Location Intelligence: Live Demo •  Social Location Intelligence: The solution • Q&A

Social Location Analysis Text analysis component

CRAWLING  

Web  sites  and  blogs  

Social  networks  

Thread

s,  posts,  com

men

ts,  tweets  

PROCESSING  

Text  enrichment  

-­‐  ontology-­‐based  

-­‐  staEsEcal  alg.  

Ontologies  (.ow

l)   Stamming  

Tagging  

Topics(+iniEal  inform

arEon

)    DBM

S  +  ??   SENTIMENT  

INDEX  CALCULATION  

Domain-­‐based  

Storage  +  Frontend    

Inde

xes  (sub

ject,  top

ic,  d

ocum

ent)  

Social Location Analysis Location intelligence component

•  Integration of custom maps on Endeca

• Component elements: –  EQL query: request Endeca data (metrics

and attributes)

–  HTML page: invoke file for map generation; Endeca data is passed via NSDP

–  Map generator for Location Intelligence (JavaScript API)

EQL query

HTML page

Social Location Analysis Location intelligence component

Ajax API PortalPagNav() Dashboard URL

Go URL

NSDP

JDBC Geo-Data

Warehouse

JSP + JDBC

Social Location Intelligence Result

•  Discovering geographic areas where the portal is poorly used

•  Identifying potential users for target-specific campaigns

•  Finding both popular and ineffective employment initiatives

Q&A