Description
Location Intelligence is the capacity to combining spatial data with other business data in order to gain critical insights, make better decisions and optimize important processes and applications.
www.eng.it www.spagobi.org
Open Source
Business Intelligence
www.eng.it www.spagobi.org
Location Intelligence
when Business Intelligence
meets Cartography
Andrea Gioia ([email protected])
www.eng.it www.spagobi.org
Agenda
Location Intelligence
• What is LI?
• Internal & external barriers
• Internal & external drivers
• Who is it for?
Location Intelligence in SpagoBI
• What we want
• What we do
• Where we are going
DEMO
www.eng.it www.spagobi.org
Definition
Location Intelligence is the capacity to
combining spatial data with other business
data in order to gain critical
insights, make better
decisions and optimize
important processes
and applications
Source: http://en.wikipedia.org/wiki/Thematic_map
www.eng.it www.spagobi.org
Thematic maps
Thematic maps are maps that tell a story
about a place more than merely describe
where something is located in space
Source: From Place to Space: The Psychological Achievement in Thematic Mapping, Barbara Petchenik. 1979 -
American Cartographer 1 Barbara Petchenik (1979).
www.eng.it www.spagobi.org
An old idea (1) …
Dr. John Snow, Physician
1852
Cholera Map
www.eng.it www.spagobi.org
An old idea (2) …
Charles Joseph Minard, Engineer
1869
Napoleon’s Russian Campaign 1812
www.eng.it www.spagobi.org
…in a new context
Location Intelligence
GIS
visualization
spatial analysis
workflow management
information dissemination
data management
BI
visualization & distribution
data analysis
OLAP
metadata management
data integration
Spatial Data
vector data
raster data
Business Data
DWH
ODS
www.eng.it www.spagobi.org
Two worlds coming together
Location Intelligence
GIS
visualization
spatial analysis
workflow management
information dissemination
data management
BI
visualization & distribution
data analysis
OLAP
metadata management
data integration
Spatial Data
vector data
raster data
Business Data
DWH
ODS
?
www.eng.it www.spagobi.org
Internal Integration barriers
www.eng.it www.spagobi.org
Strategic barriers: cooperation vs competition
It’s not easy to balance
cooperation at the technology level
and
competition at the market level
www.eng.it www.spagobi.org
Cultural barriers: ignorance & misperceptions
BI folks usually overestimate
complexity of GIS
GIS folks usually underestimate
complexity of BI
www.eng.it www.spagobi.org
External adoption barriers
www.eng.it www.spagobi.org
Perception barriers: tactical vs strategic buying
• High perceived TCO
• No dedicated budget
• Other analytical priorities
• Difficult change management
• Internal skills shortage
www.eng.it www.spagobi.org
External drivers
Growing awareness of
location-enabled services
The availability of high-quality,
current and complete data
The rise of web services as a
better-faster-cheaper
deployment model
www.eng.it www.spagobi.org
Internal drivers
Better business decisions
“Everything is related to everything
else, but near things are more related
than distant things”
First law of geography - Waldo Tobler
Spatial data are pervasive
“80% of all data stored in corporate
databases have a spatial component”
An introduction to GIS: linking maps to databases -
Franklin&Al.
Valorize a dormient asset
www.eng.it www.spagobi.org
Technical architectures
Geo DWH
Bridge
Catalogue
i
n
t
e
g
r
a
t
i
o
n
c
o
s
t
s
www.eng.it www.spagobi.org
Who is it for?
?
Entity Authentication
fraud detection
risk profiling and scoring
advanced analytics
Sustainable Compliance
risk assessment
improved monitoring
compliance auditing & reporting
Operations
customer serviceability
cost avoidance
network planning
Information Integration
improved data integrity
a “one client view”
reducing cascading errors
Marketing Services
property-level campaigns
neighborhood context
repeat marketing tracking
Customer Service
pre-sales qualification
dispatch efficiencies
multi-product eligibility
Address Management
address validation
data cleansing
data maintenance
Portfolio Analysis
predictive analytics
pricing and loss reserving
assessing policy saturation
Marketing
micro-marketing
assessing penetration levels
identifying competitive threats
Government
&
Services
Insurance
&
Finance
Communications
&
Media
And much more: industry, retailer, real estate, utility,
transportation …
Who is it not for?
www.eng.it www.spagobi.org
Examples (1)
Source: http://www.zoocasa.com/
www.eng.it www.spagobi.org
Examples (2)
Source: http://sanfrancisco.crimespotting.org/
www.eng.it www.spagobi.org
Examples (3)
Source: http://www.istat.it/popolazione/graficidinamici/census/index.html
I’m here
www.eng.it www.spagobi.org
What we want: SpagoBI LI strategy
Improve the coordination effort in the Location
Intelligence area
Disseminate BI knowledge in GIS world and vice-
versa
Promote a standard based integration between
Business Intelligence Suites and Geographical
Systems
Strengthen connections between OSBI & OS-GIS
communities
Foster OS Location intelligence enterprise adoption
Break internal and external LI
adoption barriers
through
integration & evangelization
www.eng.it www.spagobi.org
What we do: SpagoBI LI Engines
GeoEngine
Architecture: Catalogue
Main functionalities
map’s internal repository
map thematization (choropleth)
layers management
multi KPI management
on-the-fly KPI re-aggregation
inline chart
data detail view
cross navigation
map navigation controls
map print & exportation
save map analysis state
Geo Report Engine
Architecture: Bridge, GeoDWH
Main Functionalities:
integration with external GIS (WMF & WFS)
map thematization (choropleth & proportional)
advanced layers management
multi KPI management
on-the-fly KPI re-aggregation
inline cross navigation (popup)
data detail view
standard cross navigation (new win)
advanced map navigation controls
map print & exportation
save map analysis state
www.eng.it www.spagobi.org
GeoEngine
SVG Map
Catalogue
DWH
GeoEngine
SQL, MDX
Custom WS
www.eng.it www.spagobi.org
GeoReportEngine
DWH
GeoReportEngine
GIS
SQL, MDX
WMS, WFS
www.eng.it www.spagobi.org
Where we are going: SpagoBI LI roadmap
New functionalities:
• Geo dashboards
• Inline filters
• Spatial OLAP
• New thematizations
• Multivariate Geo analysis
• 4D Geo analysis (space + time)
• …
New initiatives:
• Blog
• GeoBI
www.eng.it www.spagobi.org
With whom: the partnership with INOVA
INOVA is an Italian IT enterprise,
focused on the realization of on-line
and off-line information systems
INOVA have strong knowledge in the
BI and GIS domains.
INOVA manages the OS project
GeoReport, which is the heart of the
new SpagoBI GeoReportEngine
INOVA and SpagoBI work together to
accelerate the enterprise adoption of
Location Intelligence solutions
Links
http://www.inovaos.it
http://www.geobi.org
www.eng.it www.spagobi.org
Demo
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Login
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
NOTE: Sales Director. Thanks to his role, he can
freely decide on which area the analysis has to
be focused.
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Login
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
NOTA: Sales Manager with responsibility
for the North area. Because of his role, he
cannot freely decide on which area the
analysis has to be focused.
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
www.eng.it www.spagobi.org
Q&A
www.eng.it www.spagobi.org
Thanks
www.eng.it www.spagobi.org
Links
www.slideshare.net
/spagoworld
www.spagobi.org
www.spagoworld.org
/blog
www.eng.it
www.eng.it www.spagobi.org
Licence
Attribution-NonCommercial-ShareAlike
Source: http://creativecommons.org/licenses/by-nc-sa/3.0/
doc_488870247.pdf
Location Intelligence is the capacity to combining spatial data with other business data in order to gain critical insights, make better decisions and optimize important processes and applications.
www.eng.it www.spagobi.org
Open Source
Business Intelligence
www.eng.it www.spagobi.org
Location Intelligence
when Business Intelligence
meets Cartography
Andrea Gioia ([email protected])
www.eng.it www.spagobi.org
Agenda
Location Intelligence
• What is LI?
• Internal & external barriers
• Internal & external drivers
• Who is it for?
Location Intelligence in SpagoBI
• What we want
• What we do
• Where we are going
DEMO
www.eng.it www.spagobi.org
Definition
Location Intelligence is the capacity to
combining spatial data with other business
data in order to gain critical
insights, make better
decisions and optimize
important processes
and applications
Source: http://en.wikipedia.org/wiki/Thematic_map
www.eng.it www.spagobi.org
Thematic maps
Thematic maps are maps that tell a story
about a place more than merely describe
where something is located in space
Source: From Place to Space: The Psychological Achievement in Thematic Mapping, Barbara Petchenik. 1979 -
American Cartographer 1 Barbara Petchenik (1979).
www.eng.it www.spagobi.org
An old idea (1) …
Dr. John Snow, Physician
1852
Cholera Map
www.eng.it www.spagobi.org
An old idea (2) …
Charles Joseph Minard, Engineer
1869
Napoleon’s Russian Campaign 1812
www.eng.it www.spagobi.org
…in a new context
Location Intelligence
GIS
visualization
spatial analysis
workflow management
information dissemination
data management
BI
visualization & distribution
data analysis
OLAP
metadata management
data integration
Spatial Data
vector data
raster data
Business Data
DWH
ODS
www.eng.it www.spagobi.org
Two worlds coming together
Location Intelligence
GIS
visualization
spatial analysis
workflow management
information dissemination
data management
BI
visualization & distribution
data analysis
OLAP
metadata management
data integration
Spatial Data
vector data
raster data
Business Data
DWH
ODS
?
www.eng.it www.spagobi.org
Internal Integration barriers
www.eng.it www.spagobi.org
Strategic barriers: cooperation vs competition
It’s not easy to balance
cooperation at the technology level
and
competition at the market level
www.eng.it www.spagobi.org
Cultural barriers: ignorance & misperceptions
BI folks usually overestimate
complexity of GIS
GIS folks usually underestimate
complexity of BI
www.eng.it www.spagobi.org
External adoption barriers
www.eng.it www.spagobi.org
Perception barriers: tactical vs strategic buying
• High perceived TCO
• No dedicated budget
• Other analytical priorities
• Difficult change management
• Internal skills shortage
www.eng.it www.spagobi.org
External drivers
Growing awareness of
location-enabled services
The availability of high-quality,
current and complete data
The rise of web services as a
better-faster-cheaper
deployment model
www.eng.it www.spagobi.org
Internal drivers
Better business decisions
“Everything is related to everything
else, but near things are more related
than distant things”
First law of geography - Waldo Tobler
Spatial data are pervasive
“80% of all data stored in corporate
databases have a spatial component”
An introduction to GIS: linking maps to databases -
Franklin&Al.
Valorize a dormient asset
www.eng.it www.spagobi.org
Technical architectures
Geo DWH
Bridge
Catalogue
i
n
t
e
g
r
a
t
i
o
n
c
o
s
t
s
www.eng.it www.spagobi.org
Who is it for?
?
Entity Authentication
fraud detection
risk profiling and scoring
advanced analytics
Sustainable Compliance
risk assessment
improved monitoring
compliance auditing & reporting
Operations
customer serviceability
cost avoidance
network planning
Information Integration
improved data integrity
a “one client view”
reducing cascading errors
Marketing Services
property-level campaigns
neighborhood context
repeat marketing tracking
Customer Service
pre-sales qualification
dispatch efficiencies
multi-product eligibility
Address Management
address validation
data cleansing
data maintenance
Portfolio Analysis
predictive analytics
pricing and loss reserving
assessing policy saturation
Marketing
micro-marketing
assessing penetration levels
identifying competitive threats
Government
&
Services
Insurance
&
Finance
Communications
&
Media
And much more: industry, retailer, real estate, utility,
transportation …
Who is it not for?
www.eng.it www.spagobi.org
Examples (1)
Source: http://www.zoocasa.com/
www.eng.it www.spagobi.org
Examples (2)
Source: http://sanfrancisco.crimespotting.org/
www.eng.it www.spagobi.org
Examples (3)
Source: http://www.istat.it/popolazione/graficidinamici/census/index.html
I’m here
www.eng.it www.spagobi.org
What we want: SpagoBI LI strategy
Improve the coordination effort in the Location
Intelligence area
Disseminate BI knowledge in GIS world and vice-
versa
Promote a standard based integration between
Business Intelligence Suites and Geographical
Systems
Strengthen connections between OSBI & OS-GIS
communities
Foster OS Location intelligence enterprise adoption
Break internal and external LI
adoption barriers
through
integration & evangelization
www.eng.it www.spagobi.org
What we do: SpagoBI LI Engines
GeoEngine
Architecture: Catalogue
Main functionalities
map’s internal repository
map thematization (choropleth)
layers management
multi KPI management
on-the-fly KPI re-aggregation
inline chart
data detail view
cross navigation
map navigation controls
map print & exportation
save map analysis state
Geo Report Engine
Architecture: Bridge, GeoDWH
Main Functionalities:
integration with external GIS (WMF & WFS)
map thematization (choropleth & proportional)
advanced layers management
multi KPI management
on-the-fly KPI re-aggregation
inline cross navigation (popup)
data detail view
standard cross navigation (new win)
advanced map navigation controls
map print & exportation
save map analysis state
www.eng.it www.spagobi.org
GeoEngine
SVG Map
Catalogue
DWH
GeoEngine
SQL, MDX
Custom WS
www.eng.it www.spagobi.org
GeoReportEngine
DWH
GeoReportEngine
GIS
SQL, MDX
WMS, WFS
www.eng.it www.spagobi.org
Where we are going: SpagoBI LI roadmap
New functionalities:
• Geo dashboards
• Inline filters
• Spatial OLAP
• New thematizations
• Multivariate Geo analysis
• 4D Geo analysis (space + time)
• …
New initiatives:
• Blog
• GeoBI
www.eng.it www.spagobi.org
With whom: the partnership with INOVA
INOVA is an Italian IT enterprise,
focused on the realization of on-line
and off-line information systems
INOVA have strong knowledge in the
BI and GIS domains.
INOVA manages the OS project
GeoReport, which is the heart of the
new SpagoBI GeoReportEngine
INOVA and SpagoBI work together to
accelerate the enterprise adoption of
Location Intelligence solutions
Links
http://www.inovaos.it
http://www.geobi.org
www.eng.it www.spagobi.org
Demo
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Login
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
NOTE: Sales Director. Thanks to his role, he can
freely decide on which area the analysis has to
be focused.
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
www.eng.it www.spagobi.org
DEMO: Sales Director
Sales
Director
Analytical documents
“Sales by area”
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Login
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
NOTA: Sales Manager with responsibility
for the North area. Because of his role, he
cannot freely decide on which area the
analysis has to be focused.
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
www.eng.it www.spagobi.org
DEMO: Sales Managers
Sales
Managers
Analytical documents
“Sales by city”
www.eng.it www.spagobi.org
Q&A
www.eng.it www.spagobi.org
Thanks
www.eng.it www.spagobi.org
Links
www.slideshare.net
/spagoworld
www.spagobi.org
www.spagoworld.org
/blog
www.eng.it
www.eng.it www.spagobi.org
Licence
Attribution-NonCommercial-ShareAlike
Source: http://creativecommons.org/licenses/by-nc-sa/3.0/
doc_488870247.pdf