How Business Intelligence and GIS are becoming more integrated.
How Business Intelligence and GIS are becoming more integrated.
Most people may think of geographic information systems (GIS) simply as Google maps or the navigation system for their car, but GIS tools do a lot more than help people get from A to B. Businesses are adding a spatial dimension to data to help make critical decisions in this tough economy.
We recently interviewed Yellowfin CEO Glen Rabie to find out more about this topic and why Yellowfin Business Intelligence with spatial data is so much more than just Google Maps.
Q. How does GIS integrated with BI differ from the traditional GIS approach?
A. A typical spatial specialists approach to GIS data is that it is about land use – and the optimisation of that – where to put that next store. Well on the one hand that is true and there is a place for stand-alone GIS apps to do just that, but the power of GIS is far greater. Land use changes – where you put a store or a branch today may not be that ideal in 5 years time – however what action can you take based upon your now relatively fixed network. How do you market to the changing landscape of customers and attract them to your store, how do you optimise the distribution channel that you have, how do you accurately compare one stores performance with another based on customer catchment segment analysis not necessarily proximity (still a spatial question believe it or not). This is the greater reality of GIS data and the massive potential it has for improving business performance.
Q. What are some of the newer and more innovative ways in which businesses are using GIS data beyond traditional niches?
A. When you think of GIS traditionally you think of government and urban planning. The major application in the private sector to date has been logistics. However, this is changing. One of the key uses of GIS is store/branch/dealer location. A great partner of ours eSite does just that – but there is a whole lot more. The most compelling is the use of spatial data for optimising marketing campaigns. Understanding the demographics of your desired customer and where they are located is critical if you want to maximise the return on your marketing dollar. Its not just about being able to target them but also understanding what the likely-hood of them accessing your channel is – especially if it is a bricks and mortar channel. What’s the drive time? etc.
Jet Interactive a partner of ours has a fantastic use of Yellowfin spatial. They use the spatial analytic capability of Yellowfin to provide 0800, 1300 call information. By tracking incoming calls Jet Interactive can overlay not the location of the call but all the demographic breakdown of the locations population. This is a highly valuable service to their customers who can now accurately measure the effectiveness of response rates to phone campaigns from a spatial perspective.
Q. How is GIS being integrated with traditional business Intelligence?
A.It is already happening with Yellowfin Spatial. This is location intelligence as simply another facet of our core application and designed for an Enterprise platform independent stack. It can access spatial data from a variety databases and provides map reports either through its dashboard interface or as a web service. These maps services allow developers to embed these maps into things like SharePoint or any other application. This approach is different than traditional GIS. It’s really mapping for the whole enterprise.
Q. You started out in as pure play BI presentation. Why did you get into GIS and when did you make the leap?
A. I did a little bit of urban planning whilst at University – dabbling really but I got a taste of how communities are formed and interact. Later I worked for a major bank in the BI space. We developed an impressive data warehouse but little focus was placed on the spatial side of BI. This was left to a separate department that concentrated on branch network optimisation –I did a little work with them and became fascinated by why some branches were more successful than others. Such a large part had to do with geography yet this information was never integrated into a manager’s view of branch performance. However, what really got to me was that organisations have whole departments that specialise in Geo Spatial business questions and yet these departments are rarely integrated into their general Business Intelligence and this I see as a major gap. I came to fundamentally believe that along with time – spatial data is a common and highly relevant dimension for any business.
So in the context of Yellowfin, I got really excited when in the last couple of years we had clients coming to us who really understood the interaction between BI and spatial data, and wanted to see their spatial data integrated into Yellowfin. It was with working with these customers that we really decided to take the plunge and develop our own native GIS functionality within Yellowfin to ensure its tight fit into BI. 4.0 was the first iteration of this – and not a bad start really. But with 4.1 it has really come into its own.
Q. So what are the main GIS enhancements in 4.1 and what does this mean for Yellowfin’s customers?
A. With 4.0 we enabled querying and rendering of spatial data types for Oracle and MySQL in 4.1 we have extended this to SQL Server 2008 and other databases. However – the really big breakthrough in this release was the ability to leverage Web Map Servers (WMS) for rendering spatial data. This allows us to connect to any GIS application that uses the WMS open standard for map delivery. This combined with the ability for users to build map layers – which can be turned on or off at run time– means that users have a huge amount of flexibility to built and view spatial analysis with an incredibly easy to use interface.
Q. You mentioned that there are big pay-offs for analysis with GIS. Does GIS belong integrated into core systems and applications such as CRM and ERP apps?
A. I think that just like BI and its GIS counterpart these are not core systems and are better integrated into application. Yellowfin specialises in providing an embeddable BI tool for software vendors. Our solution is easy to integrate and designed to support developers as well as end-users by allowing application vendors to rapidly bring spatial analysis to their customer base.
Q. The embedded mapping capabilities on websites often come from Google and Microsoft etc. What is Yellowfin’s niche?
A. Microsoft and Google are very much consumer-focused. They look at mapping as one more aspect of search. What they have done is pump prime the need for GIS applications. However, their technology is more geared towards fast visualisation access; it’s not a GIS system.
Yellowfin does not focus on the consumer – our target is the business user. Whilst we do use Google as a content provider for some of our maps we enable business users to actually build the content that can be visualised or analysed on the web. Analysis is where the big pay-offs on GIS arise, and this is where Yellowfin excels with its fully integrated Business and Spatial Intelligence solution.
Frequently Asked Questions About GIS and Business Intelligence
What is the difference between GIS and Business Intelligence?
GIS is focused on geographic and location data while Business Intelligence is focused on broader business data such as sales, operations and customer performance. By combining them, organizations gain insight into not only what is happening in the business, but where it is happening, thus enabling more informed decision making.
How does GIS improve Business Intelligence reporting?
GIS maps data to maps and geographic layers, adding a spatial component to traditional BI reports. This allows organizations to find location patterns, regional trends, customer concentrations and operations opportunities that might not be readily apparent in standard charts or tables.
What is Location Intelligence in Business Intelligence?
Location Intelligence is the practice of embedding geographic and spatial data into Business Intelligence processes. This helps organizations to analyse business performance by location which leads to better planning, resource allocation, customer targeting and operational efficiency.
Modern businesses are using GIS for much more than route planning. Typical uses include market analysis, customer segmentation, branch performance tracking, marketing campaign optimization, territory management, and finding business expansion opportunities.
Why is GIS important for marketing analytics?
GIS provides marketers with a look at where their customers live, work and engage with businesses. Combining demographic data with geographic information helps companies to build more targeted campaigns, improve customer acquisition efforts and maximize marketing return on investment.
Can GIS help businesses choose better store or branch locations?
Yeah. GIS can assist in location decisions by analyzing demographic trends, customer behavior, population density, and accessibility factors. It also allows businesses to evaluate how well existing locations are doing on a regular basis and to identify changing market conditions.
What industries benefit most from GIS and Business Intelligence integration?
Many industries benefit from GIS-powered analytics, including retail, banking, telecommunications, logistics, healthcare, government, education, and real estate. Any organization that relies on customer, asset, or operational location data can gain valuable insights from integrated GIS and BI solutions.
How does GIS improve customer and demographic analysis?
Businesses can use GIS to layer customer data over demographic information like income levels, age groups, population growth and consumer behavior. This enables organizations to better understand their target audience and make more effective strategic decisions.
What are the advantages of integrating GIS into enterprise systems?
Integrating GIS into enterprise apps enhances the employee experience by providing location insights within existing workflows. This reduces the need for stand-alone systems, while allowing users to combine operational, financial and geographic data in a single analytical environment.
Why is Location Intelligence becoming more important for businesses?
As organizations collect more data about their customers and operations, the geographical context behind that data becomes increasingly valuable. Location Intelligence helps businesses spot trends, plan better, optimize resources and gain competitive advantage through data driven decisions.
What role does GIS play in business decision-making?
GIS enables decision-makers to view data geographically so they can quickly spot opportunities, risks and trends. Organizations can make faster and more accurate strategic decisions by combining location data with traditional business metrics.
How does GIS support operational efficiency?
GIS assists businesses in analyzing service areas, distribution networks, customer locations, and operational assets. Such insights can be used to optimise routes, allocate resources more effectively, reduce costs and improve overall operational performance.
About Yellowfin
www.yellowfin.bi
Yellowfin is passionate about making Business Intelligence easy. Recently recognised among 25 rising companies that CIO’s must know about, Yellowfin is a leading web-based BI solution can be easily integrated into any third-party application or delivered as a stand-alone enterprise platform. Yellowfin is an innovative and flexible solution for reporting and analytics, providing a full range of data access, presentation and information delivery capabilities.